Transparent method
The formula
Worked example
Example inputs
How to interpret the result
An ETF's expense ratio compounds against the balance every year it's held, so a seemingly small percentage difference between two similar funds tracking the identical index can remove a meaningfully different dollar amount from the ending balance over a long holding period, even though both funds start from the identical initial investment.
Before you rely on it
What to check
Compare the compounded dollar fee drag over your actual expected holding period, not just the headline expense-ratio percentage difference between funds.
The common error
Where people go wrong with ETF fee calculator
Dismissing a small expense-ratio difference between two similar funds as immaterial. Compounded over a long holding period, even a modest percentage gap removes a real, sometimes substantial dollar amount from the ending balance.
Sensitivity evidence
How annual gross return changes the estimated after-tax ending value
| Annual gross return | Estimated after-tax ending value | Estimated tax on gain | After-tax annualized return |
|---|---|---|---|
| 4.0% | $67,450 | $3,079 | 3.0% |
| 6.0% | $80,096 | $5,311 | 4.8% |
| 8.0%worked example | $95,094 | $7,958 | 6.6% |
| 10.0% | $112,825 | $11,087 | 8.5% |
| 12.0% | $133,723 | $14,775 | 10.3% |
Every input, tested
Which input moves the estimated after-tax ending value most
| Input | Tested from | To | Estimated after-tax ending value at each end | Swing |
|---|---|---|---|---|
| Holding period | 7.0 years | 13.0 years | $78,010 to $116,318 | $38,308 (40%) |
| Annual gross return | 6.0% | 10.0% | $80,096 to $112,825 | $32,729 (34%) |
| Starting investment | $45,000 | $55,000 | $85,584 to $104,603 | $19,019 (20%) |
| Annual investment fee | 0.250% | 0.750% | $97,152 to $93,078 | $4,074 (4.3%) |
| Tax rate on modeled gain | 13.0% | 17.0% | $96,155 to $94,033 | $2,122 (2.2%) |
Two variables at once
Estimated after-tax ending value by annual gross return and starting investment
| Annual gross return \ Starting investment | $40,000 | $50,000 | $60,000 |
|---|---|---|---|
| 4.0% | $53,960 | $67,450 | $80,941 |
| 6.0% | $64,077 | $80,096 | $96,115 |
| 8.0% | $76,075 | $95,094 | $114,113 |
| 10.0% | $90,260 | $112,825 | $135,390 |
| 12.0% | $106,978 | $133,723 | $160,467 |
Step by step
The worked example, input by input
| Input | Value used |
|---|---|
| Starting investment | $50,000 |
| Annual gross return | 8.0% |
| Holding period | 10.0 years |
| Annual investment fee | 0.500% |
| Tax rate on modeled gain | 15.0% |
| Estimated after-tax ending value | $95,094 |
| Estimated tax on gain | $7,958 |
| After-tax annualized return | 6.6% |
Where the inputs come from
Starting investment is the amount you hold in the ETF, gross return is the return of the index before costs, and the annual fee is the ETF's expense ratio. Look the ratio up on the fund provider's page. The holding period and tax rate complete the model. ETFs also have trading costs, such as the bid-ask spread, that do not appear in the ratio, so add a small allowance if you trade often.
Using the estimated after-tax ending value in a real decision
Use the number to decide whether a narrow theme is worth paying several times more than a broad-market fund for the same kind of exposure.
When the result stops applying
The expense ratio is deducted inside the fund, so it never appears on your statement, while trading commissions and spreads are extra. ETFs are usually more tax-efficient than mutual funds because of how shares are created and redeemed, which this model does not capture. Very small or new ETFs may have wide spreads and low volume.
What to compare it with
Compare with the expense ratio calculator and the investment fee drag calculator for the compounded cost, and with the after-tax return page for tax effects. When choosing among ETFs that track the same index, pick the one with the lowest total cost and enough trading volume.
People also ask
Frequently asked questions
Are ETFs cheaper than mutual funds?
Often, particularly for broad index funds, though many index mutual funds now charge similar low fees. The difference is larger for actively managed products.
What is the bid-ask spread?
It is the gap between the price buyers will pay and sellers will accept, an implicit cost each time you trade. Large, heavily traded ETFs have very narrow spreads.
Do ETFs have any tax advantages?
Yes. Their creation and redemption process typically avoids the capital gains distributions that mutual funds pay, so they tend to generate fewer taxable events.