Question: Please complete in excel and show formulas Given the performance of 4 mutual funds and S&P500 over the past 15 years in table below: And

Please complete in excel and show formulas

Please complete in excel and show formulas Given the performance of 4

Given the performance of 4 mutual funds and S\&P500 over the past 15 years in table below: And assuming that current and average of past 15 years risk free rate is 6.96%, and using a market risk premium of 9.39% (16.35 -6.96) for the 15 -year period, estimate: 1. Sharpe ratios of all 3 funds and S\&P 500. Which fund has the highest risk adjusted performance according to Sharpe measure? Which of the above funds have beaten the market according to Sharpe measure? 2. Treynor of all 3 funds and S\&P 500 . Which fund has the highest risk adjusted performance according to Treynor measure? Which of the above funds have beaten the market according to Treynor measures? 3. Jensen's alpha for fund 1 4. Which fund is exposed to most nonsystematic or unique risk

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!

Given the performance of 4 mutual funds and S&P500 over the past 15 years in table below: Return and Risk data for 4 equity mutual funds and the market over the past 15 years Mutual Fund Average R...

Given the performance of 4 mutual funds and S&P500 over the past 15 years in table below: Return and Risk data for 5 equity mutual funds, 15-year period Mutual Fund Average Return % Standard...

Given the performance of 4 mutual funds and S\&P500 over the past 15 years in table below: Return and Risk data for 5 equity mutual funds, 15-year period And assuming that current and average of past...

Given the performance of 4 mutual funds and S&P500 over the past 15 years in table below: Sharpe ratios of all 3 funds and S&P 500. Which fund has the highest risk adjusted performance according to...

Given the performance of 3 mutual funds and S&P500 over the past 15 years in table below: R 2 .64 Return and Risk data for 3 equity mutual funds and SPY, 15-year period Mutual Fund Average Return %...

Given the performance of 3 mutual funds and S&P500 over the past 15 years in table below: Beta Return and Risk data for 4 equity mutual funds, 15 year period Mutual Fund Average Return % Standard...

Given the performance of 3 mutual funds and S&P500 over the past 15 years in table below: Return and Risk data for 4 equity mutual funds, 15 year period Mutual Fund Average Return % Standard...

Given the performance of 3 mutual funds and S&P500 over the past 15 years in table below: Return and Risk data for 5 equity mutual funds, 15 year period Mutual Fund Average Return % Standard...

Given the performance of 3 mutual funds and S&P500 over the past 15 years in table below: Return and Risk data for 3 equity mutual funds and SPY, 15-year period Mutual Fund Average Return % Standard...

The Katy Company has two bond issues outstanding. Both bonds pay $100 annual interest plus $1,000 at maturity. Bond L has a maturity of 15 years, and Bond S has a maturity of 1 year. 1. What will be...

After German reunification and the disintegration of Communist rule in Eastern Europe, several countries sought to join the European Union (EU) and later the Economic and Monetary Union (EMU). Why do...

Determine the tension in the cord and the horizontal and vertical components of reaction at support A of the beam in Prob. 54.

In recent years. Haverhil Corporation has averaged net income of $ 1 0 miltion per year on net sales of $ 1 0 0 milion per year. It currently has no long - term debt, but is considering a debt issue...

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...