The second tab in the excel file has past five years of monthly data for Microsoft, Google, the market, and the risk fre

[answerhappygod]

The Second Tab In The Excel File Has Past Five Years Of Monthly Data For Microsoft Google The Market And The Risk Fre 1 (91.22 KiB) Viewed 21 times

The second tab in the excel file has past five years of monthly data for Microsoft, Google, the market, and the risk free rate. Based on this data, compute the following (5 points): a. For each asset (Microsoft, Google, and the Market) compute the following: (1 point): i. Sharpe ratio. (0.25 points) ii. The beta (0.25 points) iii. The rsquared (0.25 points) iv. The alpha (0.25 points) v. The required rate of return (0.5 points) b. Which asset (Microsoft, Google, and Market) contains the most systematic risk? Which contains the least systematic risk? Why? (1 point) c. Evaluate the following arguments. In particular, state whether you agree or disagree with the argument and briefly explain why. (Roughly 2 sentences for each question) (1 points) i. MSFT has been a better investment than Google because it has a higher Sharpe Ratio. (0.25 points) ii. MSFT has been a worse investment than Google because it has higher systematic risk. (0.25 points) iii. MSFT has been a better investment than Google because it has a higher alpha. (0.25 points) iv. MSFT has been a better investment than Google because it has a higher required rate of return (0.25 points) d. What are the equations of the capital market line and security market line? Use the specific numbers from this example to fill in the equation. (1points). e. Compute to the predicted excess return according to the CML for Google? Is this greater than or less than Google's expected return. Does this difference make sense? (0.5 point). f. List one important difference and one important similarity between the CML and the SML? (Note - this is a purely conceptual question). (0.5 points)