Need help with excel formatting for #5. Use the weights from the above table

% Weight of Investment 60% 40% 60% 40% 8.40% 8.40% 25 26 Funds $ Investments 27 Stock Fund $ 60,000.00 28 Bond Fund $ 40,000.00 29 $ 100,000.00 30 31 Portfolio Expected Rate of Return 32 33 5. Please Calculate Portfolio Standard Deviation using portfolio weights in #4 34 Let's Compute portfolio return each state 35 Stock Fund 36 Scenario Probability Rate of Return 37 Recession 0.3 -0.11 38 Normal 0.4 0.13 39 Boom 0.3 0.27 40 Bond Fund Rate of Return 0.16 Portfolio Return 0.06 -0.04 41 42 43 Portfolio Standard Deviation 5.9174% 44 % Weight of Investment 60% 40% 60% 40% 8.40% 8.40% 25 26 Funds $ Investments 27 Stock Fund $ 60,000.00 28 Bond Fund $ 40,000.00 29 $ 100,000.00 30 31 Portfolio Expected Rate of Return 32 33 5. Please Calculate Portfolio Standard Deviation using portfolio weights in #4 34 Let's Compute portfolio return each state 35 Stock Fund 36 Scenario Probability Rate of Return 37 Recession 0.3 -0.11 38 Normal 0.4 0.13 39 Boom 0.3 0.27 40 Bond Fund Rate of Return 0.16 Portfolio Return 0.06 -0.04 41 42 43 Portfolio Standard Deviation 5.9174% 44