Index Fund Fees: How to Calculate Your Lifetime Savings

Michael Chen

Michael Chen writes about personal finance fundamentals. Bay Area-based · finance enthusiast for 15 years.

Visual representation of the voice · not a photographic portrait

Quick answer: Multiply your balance by the expense ratio to see the yearly cost: $10,000 in a 0.03% fund costs about $3 a year, in a 1.00% fund about $100. For the lifetime cost, run the same plan twice with each fund's net return and subtract the ending balances.↗ Share on X

To estimate how much a low expense ratio saves you over a lifetime, run the same investment plan twice — once with each fund's fee — and subtract the two ending balances. The quick version: multiply your balance by the expense ratio to see this year's cost (a $10,000 balance in a 0.03% fund costs about $3 a year; in a 1.00% fund, about $100). The long version, shown below with a worked example, matters more, because the fee is charged every year on a growing balance, and every dollar paid in fees also stops growing for you.

This article explains the math in plain steps. It is general education, not personal financial advice. Your real results depend on market returns nobody can predict, so treat every number here as an illustration.

What is an expense ratio, in plain words?

READ ALSOHow Much to Save for Retirement: A 4-Step Paper Method →Your Real Retirement Savings Rate, Employer Match Included →Early Retirement Savings Rate: Find Your Number in 4 Steps →

An index fund pools money from many people and buys the stocks or bonds in an index, such as a list of the 500 largest U.S. companies. Running the fund costs money. The expense ratio is the yearly fee for that, shown as a percentage of what you have invested.

You never get a bill. The fee comes out of the fund's value a little at a time, so your balance is simply smaller than it would be. That is why it is easy to ignore.

Two quick conversions help:

• 0.10% = $1 per year for every $1,000 invested
• 1.00% = $10 per year for every $1,000 invested

You can find a fund's expense ratio on its fact sheet, its page on your broker's website, or in its prospectus (the official document every fund publishes).

How do you calculate the cost for one year?

Use this formula:

Yearly fee ≈ your balance × expense ratio

Write the expense ratio as a decimal. To do that, divide the percentage by 100. So 0.03% becomes 0.0003, and 0.50% becomes 0.005.

Examples for a $10,000 balance:

A $47 difference per year between 0.03% and 0.50% does not look like much. The problem is what happens over decades.

Why does a small fee become a big number over time?

READ ALSOIndex Funds vs. Mutual Funds: How a Beginner Can Choose →How to Calculate Your Personal Savings Rate for Retirement →Rebalance Index Funds Without a Surprise Tax Bill: 5 Ways →

Two things stack up:

1. The balance grows, so the fee grows. A 0.50% fee on $10,000 is $50. The same fee on $300,000 is $1,500 a year.

2. Money paid in fees cannot compound. Compounding means your gains earn their own gains. Every dollar that leaves as a fee also takes away all the future growth that dollar would have produced.

So the real lifetime cost is not "yearly fee × number of years." It is larger, because you also lose the growth on those fees.

How do you calculate lifetime savings step by step?

You can do this in any spreadsheet or with a free online compound interest calculator. Here is the method.

1. Write down your plan: starting balance, monthly contribution, and number of years until you plan to stop investing.

2. Pick an assumed yearly return before fees. This is a guess, not a promise. Many people test a few different numbers, such as 5%, 6% and 7%, to see a range.

3. Subtract each fund's expense ratio from that return. If you assume 7% and the fund charges 0.50%, use 6.5%. If it charges 0.03%, use 6.97%.

4. Run the calculator twice, once with each net return, using the same contribution and time.

5. Subtract the two ending balances. The difference is your rough lifetime savings from choosing the cheaper fund.

This is a simplified estimate. Real funds charge fees daily, returns change every year, and taxes are not included. But for comparing two funds side by side, it shows the size of the gap clearly.

How do you set this up in a spreadsheet?

Google Sheets and Excel both have a built-in function called FV (future value). You only need one line per fund.

1. In cell A1, type your net yearly return as a decimal. For 7% minus 0.03%, type 0.0697.

2. In cell B1, type: =FV(A1/12, 360, -500, -10000)

3. In cell A2, type the net return for the second fund. For 7% minus 1.00%, type 0.06.

4. In cell B2, type: =FV(A2/12, 360, -500, -10000)

5. In cell B3, type: =B1-B2. That is your estimated lifetime difference.

What the parts mean: A1/12 turns the yearly return into a monthly one. 360 is the number of months (30 years × 12). -500 is the monthly deposit and -10000 is the starting balance; the minus signs just tell the function that money is going in. Change these numbers to match your own plan.

What does the math look like with real numbers?

Here is an illustration. The plan: start with $10,000, add $500 per month, keep going for 30 years, and assume a 7% yearly return before fees, compounded monthly. The 7% is only an assumption for the example — actual returns can be much higher or lower, and some years are negative.

In this example, the person put in $190,000 of their own money ($10,000 plus $500 × 360 months). Choosing a 1.00% fund instead of a 0.03% fund would leave roughly $124,000 less at the end — more than half of everything they contributed.

Shorter time frames shrink the gap but do not erase it. Over 20 years with the same plan, the 0.03% fund ends near $300,000, and the 1.00% fund ends near $264,000, a difference of about $36,000.

Which costs should you include besides the expense ratio?

The expense ratio is the main ongoing cost of an index fund, but it is not always the only one. Check for:

• Sales loads: a one-time charge when you buy or sell some mutual funds. Many index funds have none.
• Account or advisory fees: some brokers or advisers charge a yearly percentage on top of fund fees. A 1% advisory fee works the same way as a 1% expense ratio in the math above.
• Trading commissions: many large brokers now charge zero for stock and ETF trades, but confirm on your own account.
• Fees inside workplace plans: a 401(k) can have plan administration fees. Your plan's annual fee disclosure lists them.

Add all yearly percentage costs together and subtract the total from your assumed return in step 3.

Is the cheapest fund always the best choice?

Not automatically. Before switching, compare:

1. What the fund holds. Two funds that both say "total market" can track different indexes. Compare like with like.

2. Taxes on switching. Selling a fund in a regular taxable account can trigger capital gains tax. Inside an IRA or 401(k), switching usually does not create a tax bill, but rules vary — check before you move money.

3. Your plan's menu. In a 401(k), you can only pick from the funds offered. Pick the lowest-cost option that fits your goals, and use an IRA for other choices if that makes sense for you.

4. Small differences. The gap between 0.03% and 0.05% is tiny. The gap between 0.05% and 1.00% is not. Focus on the big gaps first.

If you are unsure about taxes, account types, or how to rebalance, talk to a fee-only fiduciary financial planner (someone legally required to act in your interest and paid directly by you, not by commissions) or a tax professional before making changes.

What should you do next?

Take 20 minutes this week:

1. Log in to every investment account you have: 401(k), IRA, brokerage.

2. List each fund and its expense ratio in a simple table.

3. Add any account or advisory fee as a separate line.

4. Run the two-scenario calculation above for your highest-cost fund versus a lower-cost fund that holds similar investments.

5. If the gap is large, check the tax impact of switching, and get professional advice if the move is in a taxable account or involves a large balance.

FAQ

What is a good expense ratio for an index fund?

Many broad-market index funds charge well under 0.20% a year, and some charge 0.05% or less. Compare funds that track the same type of index, and treat anything near 1% as expensive for a plain index fund.

How do I convert an expense ratio into dollars?

Divide the percentage by 100 and multiply by your balance. For example, 0.20% on $25,000 is 0.002 × 25,000 = about $50 a year.

Should I sell my expensive fund right away?

Not before checking taxes. Selling in a taxable account can trigger capital gains tax. Inside retirement accounts it is usually simpler. If the amount is large, talk to a fee-only financial planner or tax professional first.

Does a lower expense ratio mean higher returns?

Not by itself. Returns depend on the market and what the fund holds. A lower fee only means less is taken from whatever the fund earns.

Educational content, not personalized financial advice. Sources cited where applicable.