Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3. Open the worksheet called Testing CAPM. Calculate the beta using excess returns between each asset and the market (e.g. S&P500). Then calculate the expected
3. Open the worksheet called "Testing CAPM". Calculate the beta using excess returns between each asset and the market (e.g. S&P500). Then calculate the expected return using historical data (remember the columns are "excess" meaning r-rf). Finally calculate the CAPM implied return and the average historical alpha for each asset class. As you fill in these numbers, you will notice that the chart populates with data points. This may be useful in answering the below. a. Report beta, historical return, capm return and alpha for corporate bonds. b. For this time period, how do the predictions of CAPM line up with the data.- i. They are consistent because we have a positive relationship between beta and return which is all that we need to confirm CAPM ii. They are consistent because we have positive alphas They are inconsistent because we have a positive relationship between beta and return but the slope is too flate They are inconsistent because we have a positive relationship between beta and return but the slope is too steepe This exercise provides mixed evidence: it shows that alphas are O but the slope of the SML is incorrect. iv. v. 3. Open the worksheet called "Testing CAPM". Calculate the beta using excess returns between each asset and the market (e.g. S&P500). Then calculate the expected return using historical data (remember the columns are "excess" meaning r-rf). Finally calculate the CAPM implied return and the average historical alpha for each asset class. As you fill in these numbers, you will notice that the chart populates with data points. This may be useful in answering the below. a. Report beta, historical return, capm return and alpha for corporate bonds. b. For this time period, how do the predictions of CAPM line up with the data.- i. They are consistent because we have a positive relationship between beta and return which is all that we need to confirm CAPM ii. They are consistent because we have positive alphas They are inconsistent because we have a positive relationship between beta and return but the slope is too flate They are inconsistent because we have a positive relationship between beta and return but the slope is too steepe This exercise provides mixed evidence: it shows that alphas are O but the slope of the SML is incorrect. iv. v
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started