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?

Using a spreadsheet, compute the average return and standard deviation of each

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 Accounting Questions!