Question

In: Finance

You are currently only invested in the Natasha Fund (aside from risk­free securities). It has an...

You are currently only invested in the Natasha Fund (aside from risk­free securities). It has an expected return of 14% with a volatility of 20%. Currently, the risk­free rate of interest is 3.5%. Your broker suggests that you add Hannah Corporation to your portfolio. Hannah Corporation has an expected return of 20%, a volatility of 60%, and a correlation of 0 (zero) with the Natasha Fund. You follow your broker's advice and make a substantial investment in Hannah stock so that, considering only your risky investments, 40.0% is invested in Hannah stock and the rest is invested in the Natasha Fund.

Your finance professor suggests that you should calculate the optimal amount of Hannah stock in the portfolio assuming a risk­free rate of 2%. (Hint: use Excel's solver, the portfolio's Sharpe ratio shall be maximized. Consider the risk­free rate in the Sharpe ratio formula.)

1.The optimal weight of Hannah stock in the portfolio is? %. (Round to one decimal place.) 2.This optimal portfolio has a Sharpe ratio of

just need some steps to show how to do with excel solver, thank you.

Solutions

Expert Solution

Solution:

You now have two assets in risky portfolio:

Natasha Fund with return of 14% and standard deviation of 20%

Hannah Stock with return of 20% and standard deviation of 60%

For the Risky portoflio, let w1 and w2 be the weights of funds invested in the Natasha Fund and Hannah Stock.

w2 = 1- w1

Portfolio return = w1 * 14% + w2 * 20%

Portfolio variance = w1^2 * 20%^2 + w2^2 * 60%^2 ...........Note correlation between then is zero

Portfolio Standard deviaton = square root of protfolio variance.

Risk free rate = 2%

Sharpe ratio of the portfolio = (Portfolio return - Risk free rate)/Standard deviation of the portfolio

We have to maximise the Sharpe ratio.

See the solution and the solver condition below.

Optimal weight of the Hannah stock in the portfolio is .14.

Maximum sharpe ratio is 0.67

-x-


Related Solutions

You are currently only invested in the K Fund (aside from risk-free securities). The expected return...
You are currently only invested in the K Fund (aside from risk-free securities). The expected return for the K Fund is 13.50% with a volatility of 17.10%. Your broker suggests that you add Murni Berhad (MURNI) to your portfolio. With the volatility of 54%, MURNI has an expected return of 18.00%. There is a zero correlation between MURNI and K Fund. Currently, the Treasury Bill yields approximately 3.20%. a) Show your working to prove whether your broker is right. b)...
in addition to risk-free securities, you are currently invested in the Tanglewood Fund, a broad-based fund...
in addition to risk-free securities, you are currently invested in the Tanglewood Fund, a broad-based fund of stocks and other securities with an expected return of 12 %and a volatility of 25 % Currently, the risk-free rate of interest is 4 %Your broker suggests that you add a venture capital fund to your current portfolio. The venture capital fund has an expected return of 20%, volatility of 80 %, and a correlation of 0.2 with the Tanglewood Fund. Assume you...
In addition to risk-free securities, you are currently invested in the Tanglewood Fund, a broad-based fund...
In addition to risk-free securities, you are currently invested in the Tanglewood Fund, a broad-based fund of stocks and other securities with an expected return of 10% and a volatility of 26%. Currently, the risk-free rate of interest is 5%. Your broker suggests that you add a venture capital fund to your current portfolio. The venture capital fund has an expected return of 22%, a volatility of 82%, and a correlation of 0.2 with the Tanglewood Fund. Assume you follow...
You are examining a mutual fund.  You see that it is heavily invested in securities that have...
You are examining a mutual fund.  You see that it is heavily invested in securities that have low price-earnings and price-book ratios relative to the market.  At the same time, its dividend yield exceeds the market yield.  You would conclude that the manager is a… sector rotator. value investor. top-down growth investor. bottom-up growth investor.
Sinclair Fund has invested in securities of five corporations. The market value of each of the...
Sinclair Fund has invested in securities of five corporations. The market value of each of the investments and the beta of the corporations is as follows: Stock               Investment                   Beta 1                      $6 million                    0.50 2                      $5 million                    0.80 3                      $4 million                    1.00 4                      $3 million                    1.40     5                      $2 million                    2.00 The risk free rate is 7 percent and the return on the market portfolio is 12 percent a)What is the portfolio’s beta coefficient? b)What is the fund’s required rate of return?
You are the Chief Investment Officer of a large Australian investment fund which is currently invested...
You are the Chief Investment Officer of a large Australian investment fund which is currently invested in a broadly diversified portfolio of Australian bonds (40 per cent) and Australian shares (60 per cent). You believe that further diversification through the addition of other asset classes would both reduce portfolio risk and increase portfolio return. Analysis presented to you shows that depressed conditions in Australian real estate markets are offering opportunities for property acquisitions at levels of expected return that are...
You are a conservative investor.  You hold only a total market index mutual fund and Treasury-bills.  Currently the...
You are a conservative investor.  You hold only a total market index mutual fund and Treasury-bills.  Currently the market index has an expected return of 10% and a standard deviation of 24% and the T-bills promise a 3% return.  You are evaluating the desirability of three different portfolios, 100% in the market index, 75% in the index and 25% in T-bills, and 50% in each. What is the expected return and standard deviation of each of the three portfolios? What is the beta...
A small construction company has $100,000 set aside in a capital improvement fund to purchase new...
A small construction company has $100,000 set aside in a capital improvement fund to purchase new equipment. If $30,000 is invested at 30%, $20,000 at 25%, and the remaining $50,000 at 20% per year, what is the overall rate of return on the entire $100,000? using spreadsheet
You want to start saving for retirement. You currently have $7,000 set aside for retirement in...
You want to start saving for retirement. You currently have $7,000 set aside for retirement in an IRA. You want to contribute an additional $300 per month for the next 5 years (10%). Then, you believe that you can invest $1,000 per month for the next 45 years (10%). How much would you have at retirement if you would do this?
You are a  conservative investor.  You hold only a total market index mutual fund and Treasury-bills.  Currently the market...
You are a  conservative investor.  You hold only a total market index mutual fund and Treasury-bills.  Currently the market index has an expected return of 10% and a standard deviation of 24% and the T-bills promise a 3% return.  You are evaluating the desirability of three different portfolios, 100% in the market index, 75% in the index and 25% in T-bills, and 50% in each. What is the expected return and standard deviation of each of the three portfolios? What is the beta of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT