Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Data since 1977 of the monthly return to investors that have invested their money in fund X, labeled variable RX. Size of the fund,

   

Data since 1977 of the monthly return to investors that have invested their money in fund X, labeled variable RX. Size of the fund, that is the amount of capital that investors have jointly put in the fund, expressed in millions of USD, also called the Assets-Under-Management or AUM. 2. In the tab labeled Fund X Expense Ratio Annual expense ratio that the fund has charged to investors expressed as an annual percentage. The return to investors (or net performance) has already taken into account the fact that the expense ratio is taken out. So, to evaluate the gross performance of the fund you need to add back the expense ratio to the returns. 3. In the tab labeled Benchmark Data Vanguard SP500 Information about the benchmark, which in this case is the S&P500 index fund of Vanguard, which is labeled RVG. Information about the risk-free interest rate, which is labeled Rf questions Question 1 1 pts In your spreadsheet, start by computing the monthly returns of both Fund X as well as the Vanguard S&P 500 index in excess of the risk-free interest rate. These returns are called 'excess returns'. a) What is the Excess return of Fund X for November 1978? Enter value to 4 decimal places. Activate Windows. Question 2 1 pts In your spreadsheet, start by computing the monthly returns of both Fund X as well as the Vanguard S&P 500 index in excess of the risk-free interest rate. These returns are called 'excess returns'. b) What is the Excess return of the S&P 500 for November 1978? Enter value to 4 decimal places. Question 3 1 pts Compute the so-called (which is a measure of risk exposure) of Fund X by regressing the excess returns of Fund X on the excess returns of the Vanguard index fund. You can this in Excel by using the "slope" function, where the first input of that function is the column of excess returns on Fund X and the second input is the column of excess returns on the index. Enter value to 4 decimal places. Activate Windows

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Answer To compute the excess returns of Fund X and the Vanguard SP 500 index in November 1... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Document Format ( 2 attachments)

PDF file Icon
66427cd0660f1_979868.pdf

180 KBs PDF File

Word file Icon
66427cd0660f1_979868.docx

120 KBs Word File

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials of Investments

Authors: Zvi Bodie, Alex Kane, Alan J. Marcus

10th edition

77835425, 978-0077835422

More Books

Students also viewed these Finance questions

Question

Why is change so difficult for people?

Answered: 1 week ago

Question

If X has distribution function F(t) = 0, t Answered: 1 week ago

Answered: 1 week ago

Question

What are the principal alloying elements in SAE 4340 steel?

Answered: 1 week ago