Explore BrainMass

Explore BrainMass

    Scenario & Portfolio Analysis for a Return on Stocks and Bonds

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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?

    © BrainMass Inc. brainmass.com June 3, 2020, 5:36 pm ad1c9bdddf
    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.

    $2.19

    ADVERTISEMENT