Advertisement

Expense ratio calculator

See the effect of a constant expense ratio on an investment balance over whole model years.

Calculator

A model year is 365.25 days; a month is one twelfth of that year.

Future value after fees
$30,483.67
Future value without fees
$31,089.27
Modelled fees paid
$484.42
Total wealth reduction from fees
$605.60
Growth forgone on fees
$121.17
Annual return after expense ratio
5.7350%
Future value of initial investment
$17,465.77
Future value of contributions
$13,017.90
Initial investment
$10,000.00
Yearly contribution
$1,000.00
Gross annual return
6.0000%
Annual expense ratio
0.2500%
Whole model years
10.0000
Annual fee projection
YearFee ($)Year-end contribution ($)Ending balance ($)
1.000026.50001,000.000011,573.5000
2.000030.66981,000.000013,237.2402
3.000035.07871,000.000014,996.3960
4.000039.74041,000.000016,856.4393
5.000044.66961,000.000018,823.1561
6.000049.88141,000.000020,902.6641
7.000055.39211,000.000023,101.4318
8.000061.21881,000.000025,426.2989
9.000067.37971,000.000027,884.4972
10.000073.89391,000.000030,483.6731

Advertisement

How this calculator works

The model grows each year's opening balance at the supplied pre-fee return, deducts an expense-ratio charge from that grown balance, then adds the year-end contribution. It compares this path with a fee-free investment receiving the same contributions. Actual funds generally accrue expenses throughout the year, so this annual convention is an estimate. The difference in final wealth includes both paid fees and their subsequent investment growth. Reverse modes recover the missing investment, contribution, fee or gross-return assumption. Time-to-target returns the first whole model year at or above the target.

Formula

Net yearly factor = (1+r)(1-f). Balance_next = balance × net factor + contribution. Wealth reduction = fee-free ending value - after-fee ending value; lost growth = wealth reduction - fees paid.

Worked example

$1,000 earning 10% before a 1% annual expense charge becomes $1,089 after one year, versus $1,100 without the charge. After two years with no contributions, it becomes $1,185.921 and the cumulative cash charges are $22.979.

Advertisement

Frequently asked questions

Is fee drag the same as fees paid?

No. Fee drag includes what those deducted amounts would have earned after deduction.

Should I subtract the expense ratio from a published fund return?

Check the return basis first. Published fund performance often already reflects operating expenses; subtracting them again double-counts costs.

Why enter whole years?

Fees and contributions occur once each model year in this projection, so fractional-year fee timing is not assumed.

Sources

Advertisement