How this instrument works
An expense ratio is quoted as a small yearly percentage, and a small percentage reads as a small cost. This instrument tests that impression directly by running the same starting balance through two identical compounding formulas that differ in exactly one place: one raises Initial investment, $ by Gross annual return, % every year, the other raises it by that same return with Annual expense ratio/fee, % subtracted first. Everything else — the principal, the horizon, the compounding — stays identical between the two runs, so whatever separates them at the end is the fee and nothing else.
Treating the fee as a subtraction from the growth rate, rather than a one-time charge on the principal, is what makes the cost so much larger than intuition predicts. A fund does not bill an expense ratio as a flat withdrawal; it shaves a sliver off the fund's assets continuously, which is arithmetically close to letting the balance compound at (return − fee) instead of return every single year. That means the money the fee removes in year one would itself have kept compounding for every year that followed — the fee doesn't just cost you the fee, it costs you the fee plus everything the fee would have earned.
The gap between Final value, no fees at all and Final value, net of fees is not a forecast; both figures use the identical fixed Gross annual return, % you supplied, so neither claims to know what markets will actually do. What the instrument isolates is the arithmetic fact of the drag itself — holding return constant, how much of the terminal balance a given expense ratio consumes over a given stretch of years. Trading costs inside the fund, sales loads, taxes, and any change in return or fee over time all sit outside this calculation.
- Enter Initial investment, $ — the lump sum you are comparing, not a stream of future contributions.
- Set Gross annual return, % to the return the investment earns before any fee is deducted.
- Enter Annual expense ratio/fee, % — the fund's yearly cost as a percentage of assets, taken from its published fee table.
- Set Investment horizon, years to how long the money stays invested.
- Compare Final value, net of fees against Final value, no fees at all; Total cost of fees over the horizon is the difference between them.
Worked example — a 1% fee over thirty years
Set Initial investment, $ to 100,000, Gross annual return, % to 7, Annual expense ratio/fee, % to 1, and Investment horizon, years to 30. The fee-free run compounds at the full 7 percent: 100,000 times 1.07 raised to the 30th power gives Final value, no fees at all of $761,225.50. The fee-bearing run compounds at 7 minus 1, or 6 percent instead: 100,000 times 1.06 raised to the 30th power gives Final value, net of fees of $574,349.12.
Total cost of fees over the horizon reads $186,876.39 — the two projections subtracted, nothing more. A single percentage point of annual fee, run for three decades against otherwise identical numbers, consumes just under a quarter of what the fee-free balance reached. Anyone estimating that cost as principal times fee times years — 100,000 times 1 percent times 30, or $30,000 — is off by more than six times, because that shortcut ignores every year the missing fee dollars would otherwise have kept compounding.
Questions
Why is the fee cost so much bigger than 1% times the years?
Because a fee taken every year doesn't just remove that year's slice — it removes the growth that slice would have earned in every year after it, too. Multiplying fee by years by principal treats the cost as flat and additive, when the underlying arithmetic is compounding and multiplicative. Over three decades at these defaults, that shortcut understates the true cost by more than six times.
Does a fund actually deduct its expense ratio this way?
Close to it. Funds accrue their operating costs daily against assets, which behaves very similarly to compounding at a reduced rate year over year rather than billing a flat annual fee. This sheet's return-minus-fee model is the standard simplified way of showing that effect over a multi-year horizon; it will not match a fund's daily accrual to the penny, but the scale of the drag it shows is realistic.
How is this different from an expense-ratio calculator?
An expense-ratio calculator works backward from a fund's raw dollar expenses and assets to compute the percentage itself. This instrument starts from an already-known percentage and works forward, projecting what that percentage costs in real dollars by the end of a stated horizon — a different question with a different formula.
Does raising the expense ratio always cost proportionally more?
No — the relationship is not linear. Doubling Annual expense ratio/fee, % from 1 to 2 percent on the default sheet does not double Total cost of fees over the horizon, because a bigger fee also lowers the base the remaining growth compounds on. Change the field and compare; the cost rises faster than the fee does, especially over longer horizons.
Does this account for contributions made after the initial investment?
No. This sheet tracks one lump sum left untouched for the whole horizon, isolating the fee's effect from any other variable. Money added later, or an employer match layered on top, belongs to a different projection built around a recurring contribution, since each later deposit only compounds for however many years remain.
Why does the fee-free figure matter if I can never actually avoid all fees?
It is not a promise of an achievable balance — it is the baseline the fee-bearing run is measured against. The two projections share every input except the fee, so the gap between them isolates exactly what the fee alone costs, holding the same assumed return constant in both scenarios.
References
- SEC Investor.gov — How Fees and Expenses Affect Your Investment Portfolio
- CFPB — Planning for retirement and long-term saving
Read this first: This instrument shows arithmetic, not advice. Real offers add fees, taxes and terms that vary by lender and place — verify the figures against your actual paperwork before deciding anything.