Question: ********* Section C only. Please show your excel formula************** In addition to risk-free securities, you are currently invested in the Tanglewood Fund, a broad-based fund

********* Section C only. Please show your excel formula**************

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 11% and a volatility of 24%. 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 22%, a volatility of 80%, and a correlation of 0.2 with the Tanglewood Fund. Assume you follow your broker's advice and put 50% of your money in the venture fund:

a. What is the Sharpe ratio of the Tanglewood Fund? (The Sharpe ratio of the Tanglewood Fund is 0.29. )

b. What is the Sharpe ratio of your new portfolio? (The Sharpe ratio of your new portfolio is 0.28.)

c. What is the optimal Sharpe ratio you can obtain by investing in the venture fund? (Hint: Use Excel and round your answer to two decimal places.)

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