I need to double check my answers. Here is an empty template, wondering what you come up with. Thank you! Below 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?
Paper#4095 | Written in 18-Jul-2015Price : $25