Explanation and the calculation should be clearly hand written or typed in word doc. Please avoid writing in Excel sheet.

Minicase:

A Job at Deck Out My Yacht, Part 2

You are discussing your retirement plan with Alvin Jones when he mentions that Maureen Buffett, a representative from Marshall & McLaren Financial Services, is visiting Deck Out My Yacht today. You decide that you should meet with Maureen, so Alvin sets up an appointment for you later in the day. When you sit down with Maureen, she discusses the various investment options available in the company's retirement plan. You mention to Maureen that you researched Deck Out My Yacht before you accepted your new job. You are confident in management's ability to lead the company.

Analysis of the company has led to your belief that the company is growing and will achieve a greater market share in the future. You also feel you should support your employer. Given these considerations, along with the fact that you are a conservative investor, you are leaning toward investing 100 percent of your retirement amount in Deck Out My Yacht.

Assume the risk-free rate is the historical average risk-free rate (Chapter 10 Risk & Return). The correlation between the M&M Large-Cap Stock Fund and the M&M Bond Fund is 0.15. Note that the spreadsheet graphing and "solver" functions may assist you in answering the following questions.

1. Considering the effects of diversification, how should Maureen respond to the suggestion that you invest 100 percent of your retirement savings in Deck Out My Yacht stock?

2. Maureen's response to investing your retirement savings entirely in Deck Out My Yacht stock has convinced you that this may not be the best alternative. Because you are a conservative investor, you tell Maureen that a 100 percent investment in the bond fund may be the best alternative. Is it?

3. Using the average returns and standard deviations for the M&M Large-Cap Stock Fund and the M&M Bond Fund, graph the opportunity set of feasible portfolios.

4. After examining the opportunity set, you notice that you can invest in a portfolio consisting of the bond fund and the large-cap stock fund that will have exactly the same standard deviation as the bond fund. This portfolio will also have a greater expected return. What are the portfolio weights and expected return of this portfolio?

5. Examining the opportunity set, notice there is a portfolio that has the lowest standard deviation. This is the minimum variance portfolio. What are the portfolio weights, expected return, and standard deviation of this portfolio? Why is the minimum variance portfolio important?

6. An often-used measure of risk-adjusted performance is the Sharpe ratio. The Sharpe ratio is calculated as the risk premium of an asset divided by its standard deviation. The portfolio with the highest possible Sharpe ratio on the opportunity set is called the Sharpe optimal portfolio. What are the portfolio weights, expected return, and standard deviation of the Sharpe optimal portfolio? How does the Sharpe ratio of this portfolio compare to the Sharpe ratios of the bond fund and the large-cap stock fund? Do you see a connection between the Sharpe optimal portfolio and the CAPM? What is the connection?