Question: Using a spreadsheet, compute the average return and standard deviation of each of the three asset classes. Compute the annual return of a portfolio consisting
Using a spreadsheet, compute the average return and standard deviation of each of the three asset classes.
Compute the annual return of a portfolio consisting of 50% stocks, 40% real estate, and 10% gold. What is the average return and standard deviation of this portfolio? Also compute the average return and standard deviation of the following portfolios: 75%, 20%, and 5%; and 80%, 5%, and 15%. How do these portfolios perform compared to owning just stocks?
Choose and independent stock from the S&P 500, one that looks promising for you. What is its average return and standard deviation? Look up its Beta, and considering a market premium of 5.6% and a risk-free rate of 3.8%, what is its expected return? Use CAPM
Is this individual stock that you chose better that any of the portfolios from above? What other asset you could have picked to minimize risk? What are your conclusions on this?

Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
