Question: Please formulas in excel Based on the following information, calculate the expected return and standard deviation for two stocks: State of the Economy Recession Normal

 Please formulas in excel Based on the following information, calculate theexpected return and standard deviation for two stocks: State of the Economy

Please formulas in excel

Based on the following information, calculate the expected return and standard deviation for two stocks: State of the Economy Recession Normal Boom Probability Rate of Return Stock A .25 .05 .06 Rate of Return Stock B -.19 .14 .34 .50 .25 .10 Fill in the value in the spreadsheet. Input area: Stock A 0.05 State Recession Normal Boom Probability 0.25 0.50 0.25 Stock B (0.19) 0.14 0.34 0.06 0.10 Output area: Return Deviation Squared Deviation Probability Return Product Product Stock A Recession Normal Boom 0.0000 Variance = E(R) = 0 Standard Deviation C .00% Return Deviation Squared Deviation Probability Return Product Product Stock B 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!