
Explanation:
To calculate the money-weighted return (MWR), we need to find the internal rate of return (IRR) that equates the present value of cash flows to zero.
Year 1:
$2,500 (cash outflow from investor's perspective)$2,500 × (1 - 0.20) = $2,000$0$0Year 2:
$1,500 (additional cash outflow)$2,000 + $1,500 = $3,500$3,500 × (1 + 0.65) = $5,775$500 (cash inflow to investor)$500 (inflow)Year 3:
$1,000 (additional cash outflow)$5,775 - $500 + $1,000 = $6,275$6,275 × (1 - 0.25) = $4,706.25$500 (cash inflow to investor)$500 (inflow)Year 4:
$0$4,706.25 - $500 = $4,206.25$4,206.25 × (1 + 0.10) = $4,626.875$0$4,626.875 (cash inflow at end of Year 4)From investor's perspective:
$2,500$1,500$500$1,000$500$4,626.875Combining cash flows at same time points:
$2,500$1,500$500$1,000 + $500 = -$500$4,626.875We need to find r such that:
-2,500 + (-1,500)/(1+r) + 500/(1+r)² + (-500)/(1+r)³ + 4,626.875/(1+r)⁴ = 0
Testing the options:
Option A (2.15%):
NPV = -2,500 - 1,500/1.0215 + 500/1.0215² - 500/1.0215³ + 4,626.875/1.0215⁴ ≈ -$2,500 - $1,468.43 + $479.08 - $469.02 + $4,253.15 ≈ $294.78
Option B (3.96%):
NPV = -2,500 - 1,500/1.0396 + 500/1.0396² - 500/1.0396³ + 4,626.875/1.0396⁴ ≈ -$2,500 - $1,442.86 + $462.38 - $444.74 + $3,985.22 ≈ $61.00
Option C (7.50%):
NPV = -2,500 - 1,500/1.075 + 500/1.075² - 500/1.075³ + 4,626.875/1.075⁴ ≈ -$2,500 - $1,395.35 + $432.90 - $402.70 + $3,472.43 ≈ -$392.72
The IRR is the rate that makes NPV = 0. At 3.96%, NPV is closest to zero ($61), while at 2.15% it's $294.78 and at 7.50% it's -$392.72.
Using financial calculator or Excel: CF0 = -2500 CF1 = -1500 CF2 = 500 CF3 = -500 CF4 = 4626.875 IRR ≈ 3.96%
Therefore, the money-weighted return is closest to 3.96%.
Ultimate access to all questions.
No comments yet.
An investor's transactions in a mutual fund and the fund's returns over a 4-year period are provided in the following table:
| Year | 1 | 2 | 3 | 4 |
|---|---|---|---|---|
| New investment at the beginning of the year (USD) | 2,500 | 1,500 | 1,000 | 0 |
| Investment return for the year | -20% | 65% | -25% | 10% |
| Withdrawal by investor at the end of the year (USD) | 0 | -500 | -500 | 0 |
Based on this data, the money-weighted return (or internal rate of return) for the investor is closest to:
A
2.15%
B
3.96%
C
7.50%