In: Finance
Consider the following scenario analysis:
Rate of Return | |||||
Scenario | Probability | Stocks | Bonds | ||
Recession | 0.2 | -5 | % | 13 | % |
Normal economy | 0.5 | 14 | 9 | ||
Boom | 0.3 | 23 | 4 | ||
Assume a portfolio with weights of 0.60 in stocks and 0.40 in bonds.
a.What is rate of return on the portfolio in each scenario? (Enter your answer as a percent rounded to 1 decimal place.)
Recession rate of return:?%
Normal Economy rate of return:?%
Boom rate of return:?%
b. What are the expected rate of return and standard deviation of the portfolio? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.)
Expected rate of return:?%
Standart deviation:?%
SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE
just written in excel. solved as per book formula only