Question

In: Finance

********* Section C only. Please show your excel formula************** In addition to risk-free securities, you are...

********* 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.)

Solutions

Expert Solution

a)sharpe ratio=(expected return-risk free)/standard deviaiton of stock
=(11%-4%)/24%
=0.29
b) Now we invest 50% in venture fund and 50% in the tanglewood fund
expected return of portfolio=16.50%
std=44%
sharpe ratio=(16.5%-4%)/44%
=0.28
c)optimal share ratio occurs at below
expected return of portfolio=12.85%
std=26.22
sharpe ratio=(12.85%-4%)/26.22%
=0.34



Related Solutions

Please explain your answers and use Excel to show the excel formula you used to get...
Please explain your answers and use Excel to show the excel formula you used to get your solution. 6. A manufacturing process produces connecting rods whose diameter is normally distributed with mean 1.495 cm and standard deviation .05 cm. In what range will the “middle 80%” of the diameters lie? What about the “middle 98%”?
Please show your work and formula on excel sheet. Thank you. Assume you borrow $8,000,000 with...
Please show your work and formula on excel sheet. Thank you. Assume you borrow $8,000,000 with a coupon rate of 8% from a bank as a mortgage against your newly renovated plant. The loan is paid off in 7 years. You will pay an equal amount every year until the loan is fully paid off. What are the interest and principal payments for each year of the loan.
please show your work and formula on excel You are now 25 years old. You would...
please show your work and formula on excel You are now 25 years old. You would like to retire when you are 65 years old. You want to receive starting at 65 an annual income of $150,000 per year until you are 95. How much money must you have in your retirement account when you are 65? Assume you can earn 4% per annum.
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...
please show your work and formula on excel You can afford to pay $375 monthly car...
please show your work and formula on excel You can afford to pay $375 monthly car payments. Assume an annual interest rate of 6%, and assume 60 monthly payments. You can afford to put down $3,000. Can you afford to buy a car that costs $30,000?
Please do this in C++ only. Please Show your code and your output too. Would you...
Please do this in C++ only. Please Show your code and your output too. Would you focus on number 2 in the Required functions:? Please use all the variables in the program. The assignment problem: You are asked to develop an application that prints a bank’s customers' names, IDs, and accounts balances in different ways. In this program, you need to read a file of customer’s data into different arrays, pass these arrays to functions as (array parameter), calculate the...
7) There are only two securities (A and B, no risk free asset) in the market....
7) There are only two securities (A and B, no risk free asset) in the market. Expected returns and standard deviations are as follows: Security Expected return standard Deviation Stock A 25% 20% Stock B 15% 25% The correlation between stocks A and B is 0.8. Compute the expected return and standard deviation of a portfolio that has 0% of A, 10% of A, 20% of A, etc, until 100% of A. Plot the portfolio frontier formed by these portfolios...
Show formula A. Spot is $60 for a stock. The risk free rate at time of...
Show formula A. Spot is $60 for a stock. The risk free rate at time of spot is 4%. And there is no convenience yield or carrying cost. What is the 18-month Forward price for the stock? B. A barrel of oil  is trading in at $304. If the convenience yield is 12% and the bowing rate (risk free) is 4%, then what is the 6-month Futures price for this asset? C.Using the information above, is this asset said to be...
Please use Excel and show the formula you used. Thank you :) A manufacturing process produces...
Please use Excel and show the formula you used. Thank you :) A manufacturing process produces connecting rods whose diameter is normally distributed with mean 1.495 cm and standard deviation .05 cm. In what range will the “middle 80%” of the diameters lie? What about the “middle 98%”?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT