Question: Log in to Connect and link to the material for Chapter 18, where you will find five years of monthly returns for two mutual funds,

Log in to Connect and link to the material for Chapter 18, where you will find five years of monthly returns for two mutual funds, Vanguard's U.S. Growth Fund and U.S. Value Fund, as well as corresponding returns for the S&P 500 and the Treasury-bill rate.
a. Set up a spreadsheet to calculate each fund's excess rate of return over T-bills in each month.
b. Calculate the standard deviation of each fund over the five-year period.
c. What was the beta of each fund over the five-year period? (You may wish to review the spreadsheets from Chapters 5 and 6 on the Index model.)
d. What were the Sharpe, Jensen, and Treynor measures for each fund?

Step by Step Solution

★★★★★

3.44 Rating (173 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The spreadsheet below displays the monthly returns and excess returns for the Vanguard US Growth Fund the Vanguard US Value Fund and the SP 500 a The ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

1376-B-A-I(8993).docx

120 KBs Word File

Students Have Also Explored These Related Accounting Questions!

Log in to Connect and link to the material for Chapter 6, where you will find a spreadsheet containing monthly rates of return for Ford, the S&P 500, and T-bills over a recent five-year period. Set...

Go to www.mhhe.com/bkm and link to the material for Chapter 12, where you will find 5 years of weekly returns for the S&P 500. a. Set up a spreadsheet to calculate the 26-week moving average of the...

Go to www.mhhe.com/bkm and link to the material for Chapter 12, where you will find 5 years of weekly returns for the S&P 500 and Fidelitys Select Banking Fund (ticker FSRBX). a. Set up a spreadsheet...

Go to www.mhhe.com/bkm and link to the material for Chapter 18, where you will find five years of monthly returns for two mutual funds, Vanguards U.S. Growth Fund and U.S. Value Fund, as well as...

Choose a mutual fund family such as Vanguard, American Funds, T. Rowe Price, and so forth. Identify one mutual fund from that family for each of the following categories: Actively managed common...

Froms this Answer this question. By late 2016, Larry J. Puglia had been managing the $33 billion T. Rowe Price Blue Chip Growth Fund (Blue Chip Growth Fund) for more than 23 years. One of the fund's...

Find five years of monthly returns for two mutual funds, Vanguard's U.S. Growth Fund and U.S. Value Fund, as well as corresponding returns for the S8 and the Treasury-bill rate. (Use Spreadsheet.xls)...

here is the file Investment Portfolio Optimization Using Mean-Variance Analysis Question 1. Let's first consider investment portfolios that include only two risky assets: VINIX (a Vanguard...

1. Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method. 2. What do you estimate the company?s WACC? Please...

The case is attached with the supplemental data that you will need for your analysis. After you finish reading the case, answer the following questions. i ) Estimate and compare the returns and...

This question adds some complexity to the models we've discussed, in order to help build intuition. (a) Suppose that we run the Chandrasekhar, Larreguy, and Xandri (2018) experiment, but we allow...

How often should formal performance evaluations take place? Informal ones? How often do they take place?

FIN 3 5 0 : Financial Principles Homework # 5 Chapter 7 : Stocks Total Points: 5 2 = 1 0 Jack, linc. Required return to stockholders = 1 2 . 0 % Just paid a Dividend of $ 2 . 0 0 Growth rate of...

Determine the labour market status of each of the following people. If they are unemployed, can they be considered long-term unemployed? a. Demetrius is a voice-over actor. He has a gig this week,...

Return to Problem 36. Value the call option using the risk-neutral shortcut described in the box on page 736. Confirm that your answer matches the value you get using the two-state approach Problem...

It is now January. The current interest rate is 2%. The June futures price for gold is $1,500, whereas the December futures price is $1,510. Is there an arbitrage opportunity here? If so, how would...

The S&P portfolio pays a dividend yield of 1% annually. Its current value is 1,500. The T-bill rate is 4%. Suppose the S&P futures price for delivery in 1 year is 1,550. Construct an arbitrage...

Calculate the value of a six-month futures contract on a Treasury bond. You have the following information: (Do not round intermediate calculations. Round your answer to 3 decimal places.) 0 ....

A stock has a beta of .6 and an expected return of 10 percent. A risk-free asset currently earns 4.1 percent. a. What is the expected return on a portfolio that is equally invested in the two assets?...

Solve by hand not by excel Galvanized Products is considering purchasing a new computer system for their enterprise data management system. The vendor has quoted a purchase price of $80,000....