Question: Please show how to do in Excel with formulas! Don't need to know the long form. Suppose you have $10,000 to invest and you have
Please show how to do in Excel with formulas! Don't need to know the long form.
Suppose you have $10,000 to invest and you have purchased the following securities.
| Stock A | Stock B | |
| $ Amount | $4,000 | $6,000 |
| Mean return | 19.65% | 8.96% |
| Standard deviation (sample) | 40% | 20% |
| Correlation coefficient | +0.25 | |
Calculate the following statistics: (1/100 of one percent without % sign, e.g. 12.671, if a negative percentage, -9.56):
1) Expected portfolio return: _____
2) Expected portfolio standard deviation: _____
Please show how to do in Excel with screenshot!
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
