Scenario & Portfolio Analysis for a Return on Stocks and Bonds
1) SCENARIO ANALYSIS: Consider the following scenario-analysis
RATE OF RETURN
Scenerio Probability Stocks Bonds
recession .20 -5% +14%
normal economy .60 +15 + 8%
boom .20 +25 + 4%
a. Is it reasonable to assume that Treasury Bonds will provide higher returns in recessions than in booms?
b. How do I calculate the
expected rate of return and standard deviation for each investment?
c. And which investments would you prefer?
2) PORTFOLIO ANALYSIS: Using the data in the above problem and considering a portfolio with weights of .60 in stocks and .40 in bonds.
a. What is the rate of return on the portfolio in each scenario?
b. What is the expected rate of return and standard deviation of the portfolio?
c. Would you prefer to invest in the portfolio, in stocks only, or in bonds only?
https://brainmass.com/business/bond-valuation/scenario-portfolio-analysis-for-a-return-on-stocks-and-bonds-32581
Solution Summary
The expected rate of return and standard deviation for investment in bonds and stocks is calculated, given the probability distribution of return. Also, the expected rate of return and standard deviation for investment in a portfolio of bonds and stocks is calculated. This solution is provided in an attached Excel file.