View the step-by-step solution to:

Portfolio Theory, CAPM Homework Year 1 2 3 4 5 Asset A 20.00% -11.00% 10.00% -9.00% 21.00% Rate of Return Asset B 19.00% 22.00% -6.00% -14.00% 28.00%...

basic finance homework

Portfolio Theory, CAPM Homework Rate of Return Year Asset A Asset B Market 1 20.00% 19.00% 9.00% 2 -11.00% 22.00% 12.00% 3 10.00% -6.00% 6.00% 4 -9.00% -14.00% -4.00% 5 21.00% 28.00% 17.00% For this exercise, you might want to copy and paste the table above into Excel and then do all your calculations on that spreadsheet. 1) Calculate the expected returns for Asset A, Asset B and the Market (use Average function in Excel) Asset A = Asset B = Market = 2) Calculate the standard deviation of returns, ϭ , for each asset (use STDEVP function) Asset A = Asset B = Market = 3) Calculate the correlation, ρ, between Asset A and Asset B (use CORREL function in Excel) ρ = 4) Calculate the expected returns from the following portfolios: Use the following formula to calculate the portfolio standard deviation ϭ P =√ (w A ϭ A) 2 + (w B ϭ B) 2 +(2 w A w B ϭ A ϭ B ρ (A,B) ) =(((w A * ϭ A) ^ 2) + ((w B * ϭ B) ^2)+(2 *w A * w B * ϭ A * ϭ B (A,B) )))^.5 Where w A and w B are the % of assets in Asset A and B respectively ϭ A and ϭ B are the respective standard deviations of return and ρ (A,B) ).is the correlation of returns between asset A and B Portfolio Expected Return Portfolio Std Dev. % Asset A % Asset B 0% 100%
Background image of page 1
25% 75% 50% 50% 75% 25% 100% 0% 5) Using Portfolio Expected Returns on the Y axis and Portfolio Standard Deviation in the X axis, draw the efficient frontier for possible portfolio combinations of Asset A and B. (include 100% A and 100% B as two possibilities). Hint: Use the Excel Chart Wizard and select the XY(scatter) plot option) 6) Calculate Beta for Asset A (relative to the Market) and Asset B relative to the Market) (use SLOPE function) Beta for Asset A = Beta for Asset B = 7) Assume that for next year the Risk Free Rate is expected to be 2% and that the overall Market will realize a return of 12%. Using the CAPM / SML methodology, calculate the required returns for Asset A and Asset B. Required Return for Asset A = Required Return for Asset B = Equity Pricing Exercise
Background image of page 2
Show entire document
Sign up to view the entire interaction

Top Answer

Dear Student,... View the full answer

8407858.xlsx

Year
1
2
3
4
5 Rate of Return
Asset B
19.00%
22.00%
-6.00%
-14.00%
28.00% Asset A
20.00%
-11.00%
10.00%
-9.00%
21.00% Market
9.00%
12.00%
6.00%
-4.00%
17.00% 1) Calculate the expected returns for...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online