Question: Please, show the calculation and if possible how to do it on Excel Question 1 Calculate the expected return and standard deviation for this asset

 Please, show the calculation and if possible how to do it

Please, show the calculation and if possible how to do it on Excel

Question 1 Calculate the expected return and standard deviation for this asset using the forecasted scenarios below: Scenario 1 Scenario2 Scenario 3 Scenario 4 Probability 5% 30% 50% 15% of scenario Return -15% -3% 7% 20% forecast Expected return: 9%; Standard deviation: 14.09% Expected return: 4.85%; Standard deviation: 3.6% Expected return: 4.85%; Standard deviation: 8.66% Expected return: 0.0485; Standard deviation: 0.0036

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!