70.2K

Verified Solution

Link Copied!

need help with these

Q 2.2: We saw that the stock return is equal to (P1P0)/P0 when there are no dividends. a) What was the return of Microsoft stock from January 31 to February 282023 ? 0.006497 b) What was the (arithmetic) average monthly return of Microsoft from January 2013 to December 2022? .021929 c) What was the total return for Microsoft from January 2013 to December 2022 ? The systematic risk of a stock is measured by its Beta. We get beta through a regressionlof the stock's return in excess of the risk free rate (ri - f ) onto the market's return in excess of the risk free rate (rmrf). a) What is the Beta (5Y Monthly) for MSFT in Yahoo Finance? 93 b) Calculate Beta yourself in Excel by regressing the MSFT excess returns onto the market's excess returns using monthly data spanning January 2013 to December 2022. You can get the market returns and the risk free rate each month from Kenneth French's website: https://mba.tuck.dartmouth.edw/pages/faculty/ken.french/ftp/FF_Research_data Factors CSV.zip Note that you have to divide returns by 100 to get them into decimal form. Also note that since all you need is Beta, a shortcut is to use Excel's slope function. If you had MSFT returns minus rf in column A and ( mrf) in column B, you could get the beta with the function "=Slope(A1:A120,B1:B120)" c) Are these numbers different? If so, why? d) Is Microsoft more or less risky than an average stock on the market? Q 2.2: We saw that the stock return is equal to (P1P0)/P0 when there are no dividends. a) What was the return of Microsoft stock from January 31 to February 282023 ? 0.006497 b) What was the (arithmetic) average monthly return of Microsoft from January 2013 to December 2022? .021929 c) What was the total return for Microsoft from January 2013 to December 2022 ? The systematic risk of a stock is measured by its Beta. We get beta through a regressionlof the stock's return in excess of the risk free rate (ri - f ) onto the market's return in excess of the risk free rate (rmrf). a) What is the Beta (5Y Monthly) for MSFT in Yahoo Finance? 93 b) Calculate Beta yourself in Excel by regressing the MSFT excess returns onto the market's excess returns using monthly data spanning January 2013 to December 2022. You can get the market returns and the risk free rate each month from Kenneth French's website: https://mba.tuck.dartmouth.edw/pages/faculty/ken.french/ftp/FF_Research_data Factors CSV.zip Note that you have to divide returns by 100 to get them into decimal form. Also note that since all you need is Beta, a shortcut is to use Excel's slope function. If you had MSFT returns minus rf in column A and ( mrf) in column B, you could get the beta with the function "=Slope(A1:A120,B1:B120)" c) Are these numbers different? If so, why? d) Is Microsoft more or less risky than an average stock on the market

Answer & Explanation Solved by verified expert

See Answer