Question

You are operating a mutual fund which today has $100mil in assets. Your returns and fund...

You are operating a mutual fund which today has $100mil in assets. Your returns and fund flows into/out of the fund are listed below

Time =

Return

Fund Flow $Mil

1

20.00%

5

2

10.00%

3

3

-30.00%

-10

4

10.00%

4

5

-5.00%

-2

Question 1: What is the arithmetic average (mean) of the returns?

Answer is 1%

Question 2: What is the geometric average (mean) of the returns?

Answer is -0.698%

Question 3: What is the dollar-weighted average (mean) of the returns?

Answer question 3

In this question, time means first time, second time..... It's not how many times. Think about the formula of dollar weight average.

I think you need to use IRR.

Homework Answers

Answer #1
R F A B=A*R C=A+B+F D=1+R
Time Return Fund Flow Beginning Balance Dollar Return Ending Balance 1+Return
1 20.00% 5 100 20 125              1.20
2 10.00% 3 125 12.5 140.5              1.10
3 -30.00% -10 140.5 -42.15 88.35              0.70
4 10.00% 4 88.35 8.835 101.185              1.10
5 -5.00% -2 101.185 -5.05925 94.12575              0.95
SUM 5.00%
Q1 Arithmetic average (Mean) Return 1% (5/5) Average =SUM/(Number of readings)
Q2 Geometric Average of Return=G
(1+G)^5=1.2*1.1*0.7*1.1*0.95
((1.2*1.1*0.7*1.1+0.95)^(1/5))-1     (0.00698)
Geometric Average of Return=G -0.6981%
Q3 Time Cash Flow
0 -100
1 -5
2 -3
3 10
4 -4
5 94.12575
Dollar Weighted Average Return -1.58% (Using IRR function of excel over cash flow)
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You are the manager of the Mighty Fine mutual fund. The following table reflects the activity...
You are the manager of the Mighty Fine mutual fund. The following table reflects the activity of the fund during the last quarter. The fund started the quarter on January 1 with a balance of $80 million. Mighty Fine Mutual Fund Monthly Data (measured at end of month) January February March Net inflows ($ million) 6.7 -4.3 0 HPR (%) -0.30 6.80 6.80 a. Calculate the quarterly arithmetic average return on the fund. (Round your answer to 2 decimal places.)...
You are the manager of the Mighty Fine mutual fund. The following table reflects the activity...
You are the manager of the Mighty Fine mutual fund. The following table reflects the activity of the fund during the last quarter. The fund started the quarter on January 1 with a balance of $120 million. Mighty Fine Mutual Fund Monthly Data (measured at end of month) January February March Net inflows ($ million) 7.9 -3.3 0 HPR (%) -2.70 7.40 3.80 a. Calculate the quarterly arithmetic average return on the fund. (Round your answer to 2 decimal places.)...
You are the manager of the Mighty Fine mutual fund. The following table reflects the activity...
You are the manager of the Mighty Fine mutual fund. The following table reflects the activity of the fund during the last quarter. The fund started the quarter on January 1 with a balance of $140 million. Mighty Fine Mutual Fund Monthly Data (measured at end of month) January February March Net inflows ($ million) 6.1 -4.8 0 HPR (%) -1.10 6.50 5.80 a. Calculate the quarterly arithmetic average return on the fund. (Round your answer to 2 decimal places.)...
A mutual fund has earned annual returns of 11%, -5% and 33% over the past three...
A mutual fund has earned annual returns of 11%, -5% and 33% over the past three years. If the average risk-free rate during that time was 2% per year, what was this fund's Sharpe Ratio during that time period?
A mutual fund has earned annual returns of 11%, -5% and 15% over the past three...
A mutual fund has earned annual returns of 11%, -5% and 15% over the past three years. If the average risk-free rate during that time was 2% per year, what was this fund's Sharpe Ratio during that time period?
A mutual fund has earned annual returns of 11%, -5% and 27% over the past three...
A mutual fund has earned annual returns of 11%, -5% and 27% over the past three years. If the average risk-free rate during that time was 2% per year, what was this fund's Sharpe Ratio during that time period?
Assume a mutual fund has $800 million of assets under management. The weekly rate of return...
Assume a mutual fund has $800 million of assets under management. The weekly rate of return on the fund is 1.6% and the standard deviation of returns is 3%. Assuming normal distribution, calculate the dollar Value at Risk (VaR) per week at 5% probability.
A mutual fund has earned an annual average return of 15% over the last 5 years....
A mutual fund has earned an annual average return of 15% over the last 5 years. During that time, the average risk-free rate was 2% and the average market return was 12% per year. The correlation coefficient between the mutual fund’s and market’s returns was 0.7. The standard deviation of returns was 45% for the mutual fund and 22% for the market. What was the fund’s CAPM alpha?
A mutual fund has earned an annual average return of 15% over the last 5 years....
A mutual fund has earned an annual average return of 15% over the last 5 years. During that time, the average risk-free rate was 2% and the average market return was 12% per year. The correlation coefficient between the mutual fund’s and market’s returns was 0.7. The standard deviation of returns was 45% for the mutual fund and 22% for the market. What was the fund’s CAPM alpha?
A mutual fund has earned an annual average return of 15% over the last 5 years....
A mutual fund has earned an annual average return of 15% over the last 5 years. During that time, the average risk-free rate was 2% and the average market return was 12% per year. The correlation coefficient between the mutual fund’s and market’s returns was 0.7. The standard deviation of returns was 30% for the mutual fund and 22% for the market. What was the fund’s CAPM alpha?
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT