The cost lens
Move the charge. See what it takes from the end value.
The formula
End value = P x (1 + g - c)^n
P is the starting amount, 10,000. g is gross yearly growth, fixed at 5%. c is the yearly charge you set. n is the number of years. The no-charge column uses c = 0.
What the charge means here
The charge is subtracted from the growth rate once a year. It is a simplified model: growth is constant, there are no contributions or withdrawals, no tax, no variation in returns and no other costs. The result is arithmetic, not a forecast, and not the outcome of any product.
A different convention
A fee taken as a percentage of the balance each year after growth gives P x ((1 + g)(1 - c))^n. It removes slightly more, because the charge also applies to that year's growth. Both are shown below so the difference is visible. The cost lens uses the first.
Worked test cases
Computed from the formulas above with P = 10,000 and g = 5%. The interactive chart returns the same figures for the same inputs.
| Charge | Years | No charge | Lens model | Charge on balance after growth |
|---|---|---|---|---|
| 0.00% | 10 | 16,289 | 16,289 | 16,289 |
| 0.00% | 30 | 43,219 | 43,219 | 43,219 |
| 0.60% | 10 | 16,289 | 15,382 | 15,338 |
| 0.60% | 30 | 43,219 | 36,393 | 36,080 |
| 1.00% | 30 | 43,219 | 32,434 | 31,969 |
| 2.00% | 40 | 70,400 | 32,620 | 31,377 |
Cost lens