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.)...
Your grandmother gave you $390 for your birthday, which you invested in a mutual fund on...
Your grandmother gave you $390 for your birthday, which you invested in a mutual fund on January 1, 2012. On June 1, 2012, she gave you $720 for your high school graduation, which you immediately deposited into your mutual fund. On January 1, 2013, found that your dollar-weighted rate of return for the previous year was 8%. On April 1, 2013 your fund balance was $1700, and you then deposited $X, which your grandmother gave you for college. On January...
Question 1,2,3 are based on the following information Consider a fund that starts with $10 M...
Question 1,2,3 are based on the following information Consider a fund that starts with $10 M under management. The fund’s yearly returns and net inflows from fund investors are reported as below. 1st Year 2nd Year 3rd Year Holding-period return (%) 20% 8% -5% Net inflow ($ million) 3 5 0 The arithmetic average return is ___________ Group of answer choices 7.67% 8% 9.2% 7.18% Flag this Question The geometric average return is ___________ Group of answer choices 7.67% 8%...
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?
A mutual fund has earned annual returns of 11%, -5% and 21% over the past three...
A mutual fund has earned annual returns of 11%, -5% and 21% 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) 0.47 b) 0.51 c) 0.53 d) 0.56 e) 0.58
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? a) 0.47 b) 0.51 c) 0.53 d) 0.56 e) 0.58
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT