Calculate the risk-free rate, CAPM and expected return on Excel. Assignment 3, Part-1

Beta, the risk-free rate, and CAPM. Calculate the expected return of security on Excel.
Use Excel, Yahoo Finance, and 90 Day T-bill data from the US Federal Reserve to calculate the expected return of a security.

[sabbirahmed]

You can download treasury data rate from here...

[sae]

The data you have collected it's monthly based, right? Then how have you calculated market return (daily) by doing average taking monthly market return data?

[JIAHUICHEW]

are this the calculation of future risk free rate and market return?

[kimnhunguyent]

Thanks for your video. May I ask you that we still use 365 in formula but there are some days when we do not trade?

[betrayal]

Hey Sabbir, how is is it that the average of the 90 days T-Bills are already yearly? Sorry if it's obvious.

[navaneevenu]

could u pls tell me how to calculate daily risk-free return from annual return. For ex. 7.56% p.a to daily return

[sophiewan]

Hi Sir, is there a reason why the arithmetic average is used instead of the geometric average when finding the mean market rate and treasury bill rate?

[auliariskipratama]

hi sir, can you explain about APT on excel like this video?

[ThanhHoang-cxvz]

Why this risk free rate is already yearly ?? why not daily 😢

[nurulizzani]

hi sir can i know if i use weekly stock price, for the yearly still need to use 365 days or 51 weeks?

[ashwinvenkatesh]

If i calculate monthly return what would be the formula? Kindly help me