What this calculator does
The calculator shows you what your starting capital and your monthly savings turn into in an ETF. It calculates twice, once with the ongoing fund costs and once without. The difference between the two final values appears as a separate line in the result, in dollars instead of percent.
If your target amount is already fixed, ask the question the other way round. With the savings rate calculator, you work out the required monthly amount from the target sum, starting capital and term. You can enter any target amount of your own there. Here you then check how different ongoing costs change the final capital.
How I calculate it
I use the values preset in the calculator: $5,000 starting capital, $250 monthly savings, a 7% expected annual return, a 25-year term and a TER of 0.20%.
Step 1: Deduct the TER from the return. TER stands for total expense ratio, the ongoing costs of the fund per year. The fund company takes them from the fund’s assets. No booking for this appears in your account, the share price is simply a little lower. A 7% gross return and 0.20% TER therefore become a 6.80% net return.
Step 2: Convert the annual return into a monthly rate. 6.80% a year is not 0.5667% a month. Because of compounding, twelve months at 0.5667% each give 7.02% a year, which is more than you entered. That is why I convert geometrically. 6.80% a year becomes 0.5497% a month, and twelve such months give exactly 6.80% again.
Step 3: Apply the return to the capital, then add the monthly savings. In the first month, the $5,000 grows by 0.5497%. That is $27.49. At the end of the month, $250 is added. You are at $5,277.49.
Step 4: Repeat 300 times. In the second month, the return is earned on the new balance, no longer on the original starting capital. That is exactly what compound interest is. After 25 years, that is 300 months, you are at around $215,960. Of that, you paid in $80,000, namely $5,000 at the start plus 300 times $250.
Step 5: Run the same calculation again without costs. In parallel, the same process runs with the full 7%. The result is around $222,900. The difference of around $6,940 is what the TER of 0.20% has cost you over 25 years.
What 0.60 percentage points add up to over 25 years
A broadly diversified world ETF today often has a TER of 0.20%. For an actively managed fund in the same category, 0.80% is not unusual. Enter both values one after the other and leave everything else the same.
At 0.20% TER, around $215,960 is in your account after 25 years. At 0.80% it is around $196,560. The gap is around $19,400. That is almost a quarter of everything you paid in over these 25 years.
Over 30 years the gap grows considerably. Around $317,790 at 0.20% becomes around $282,990 at 0.80%. The difference is then around $34,800. Five more years of term therefore raise the cost difference by around 79%, even though the percentage stayed the same.
Why the cost effect is larger than the fee
The TER is not charged on your monthly savings. It is charged every year on your entire fund assets. At the start these assets are small, at the end they are large. Most of the costs therefore arise in the last years, exactly when your portfolio is worth the most.
There is a second effect. Every dollar the fund company takes out is permanently missing from your portfolio afterwards. It no longer earns a return, and later the compound interest on this missing return is missing as well. At 0.80% TER, the cost of the TER adds up to around $47,440 over 30 years. You paid in $95,000 during this time. So the costs eat around half of what you transferred yourself. Measured against the final capital without costs, it is a good 14%.
At 0.20% TER, the cost of the TER over the same 30 years stays at around $12,630, just under 4% of the final capital without costs. You can find the same compound interest mechanism without the cost line in the compound interest calculator.
What is often overlooked
The TER is not the whole cost block. It contains the fund’s management fee, but neither the transaction costs inside the fund nor your broker’s order fees nor the spread when you buy, the gap between the buying price and the selling price on the exchange. How far an ETF really lags behind its index in the end is shown by the tracking difference. It can turn out smaller than the TER, for example if the fund earns income from securities lending or reclaims withholding taxes.
Taxes are missing from this calculation. The figures are before taxes. How fund income and price gains are taxed depends on the country you live in. Depending on the rules, tax can be due every year, even on an accumulating ETF that pays out nothing, or only when you sell. Check the rules where you live, or ask a tax advisor.
The return is an assumption, the TER is a fact. Nobody knows in advance whether your ETF will return 4% or 8% a year on average. In the example above, the final capital is around $136,430 at 4% and around $253,220 at 8%. This range is much larger than any cost difference. The TER, by contrast, is stated in the key information document and applies from the first day.
Purchasing power is something different from your account balance. The calculator delivers nominal amounts. If you want to think in today’s purchasing power, subtract the expected inflation from the return assumption and use the difference.
An existing mortgage changes the comparison. Then it is no longer just ETF against doing nothing. It is an uncertain market return against loan interest saved with certainty. The overpay-mortgage-or-invest calculator compares both paths with the same available amount and the same period.
How to use the calculator sensibly
Calculate three versions instead of one. With $5,000 start, $250 a month, 0.20% TER and 25 years, you get around $136,430 at 4%, around $184,710 at 6% and around $253,220 at 8%. This range shows you how strongly the result depends on an assumption nobody knows.
Then turn the two levers that really belong to you. At 0.80% TER and $250 a month, you end up with around $196,560 after 25 years. If you raise the monthly savings to $300, it is around $231,370, so around $34,810 more. Switching to an ETF with 0.20% TER brings around $19,400 at the same monthly savings. Both work, but in this example the monthly savings carry more weight.
Both together have the strongest effect, and both are in your hands. The return, on the other hand, is delivered by the market. When your portfolio reaches a fixed target amount is shown by the millionaire calculator. If you want to know how long your capital will last later, continue in the retirement withdrawal calculator. The guide Live off your investments connects your savings goal and withdrawals with your complete spending, taxes, insurance contributions and later income.