Question: Please show formulas on excel. Based on the following information, calculate the expected return and standard deviation: .15 State of the Economy Probability Rate of


Please show formulas on excel.
Based on the following information, calculate the expected return and standard deviation: .15 State of the Economy Probability Rate of Return Depression -.107 Recession .20 .069 Normal .40 .135 Boom 25 215 Fill in the values in the spreadsheet. Input area: State Depression Recession Normal Boom Probability 0.15 0.20 0.40 0.25 Stock A -0.107 0.069 0.135 0.215 Output area: Return Deviation Probability Squared Deviation Return Return Product Stock A Product Probability Product Deviation Product Deviation Stock A Depression Recession Normal Boom E(R) = 0.0000 Variance = Standard Deviation 0.00%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
