Build an active spread sheet that calculates the return and risk of individual securities as well as a portfolio representing a combination of both funds All colored cells should be populated with a formula question Portfolio with Ws weght of stocks and Wb weight of bonds Rate of Return Stock Fund Rate of Return -25 -11 14 40 2 Bond Fund Rate of Return 15 10 Scenario Probability Severe recession 0.25 Mild recession 0.25 Normal growth 0.25 Boom 0.25 Beta Expected or Mean Return: Standard Deviation of returns coefficient of variation Covariance of returns of Stocks and Bonds 3 5 Create a datatable that calculates the return and risk of the portfolio by varying the weight of the stock Fund in the portfolio weight of stock Fund Return Risk 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% Build an active spread sheet that calculates the return and risk of individual securities as well as a portfolio representing a combination of both funds All colored cells should be populated with a formula question Portfolio with Ws weght of stocks and Wb weight of bonds Rate of Return Stock Fund Rate of Return -25 -11 14 40 2 Bond Fund Rate of Return 15 10 Scenario Probability Severe recession 0.25 Mild recession 0.25 Normal growth 0.25 Boom 0.25 Beta Expected or Mean Return: Standard Deviation of returns coefficient of variation Covariance of returns of Stocks and Bonds 3 5 Create a datatable that calculates the return and risk of the portfolio by varying the weight of the stock Fund in the portfolio weight of stock Fund Return Risk 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100%