Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Analysis For Financial Management

Authors: Robert Higgins

7th Edition

0072863641, 9780072863642

More Books

Students also viewed these Finance questions