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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!