Free Excel templates

A free compound interest and investment fees calculator in Excel

Two classic illustrations made into numbers: an early investor against a late one, and a low-cost fund against a higher-cost one, year by year to age 65, then adjusted for inflation, with a sheet for your own case.

Invest 3,600 a year from 25 to 35 and stop: at 65 you have 405,132. Start at 35 and keep going to 65: 363,863, despite paying in three times as much. A one point higher yearly fee costs 23.1% of the final pot.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.

Compound_Interest_and_Fees_Calculator.xlsx (32 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this model

This model goes with Stock Market Investing for Beginners, which explains the method behind it, chapter by chapter.

Get the book on Amazon →

Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada.

Want every model at once?

The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).

Get the Library, $79 →

This free file stays free. Secure checkout by Stripe.

Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

What is in the file

6 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.

Your Numbers
Every assumption. Change these first.
Early vs Late
Chapter 4's illustration, year by year
The Cost of a Fee
Chapter 8's illustration, year by year
In Today's Money
What the totals are actually worth
Your Own Case
The same arithmetic on your numbers, not the book's
Checks
Every figure in Appendix F, recomputed and compared, and the tests that hold for any inputs

What the worked case returns

MeasureValue
Early investor: total contributed36,000
Early investor: value at 65405,132
Late investor: total contributed108,000
Late investor: value at 65363,863
Low-cost investor: value at 65738,846
Higher-cost investor: value at 65567,961
What the fee difference costs170,885
Extra fees actually paid70,317
Wealth lost per 1 of extra fee2.43
Low-cost pot in today's money275,169
Return after inflation4.39%

The higher-cost investor hands over 70,317 more in fees, but ends 170,885 poorer: each extra unit of fee costs 2.43 units of wealth, because the fee is taken from money that would have compounded.

How to use it on your own case

  1. Enter the yearly contribution, return, inflation and the two fee levels on Your Numbers.
  2. Read Early vs Late and The Cost of a Fee year by year.
  3. Read the totals in today's money.
  4. Enter your own monthly saving, age, return and costs on Your Own Case.

Questions people ask about it

Is it better to start investing early?

On the same return, money invested earlier has longer to compound. In the file, ten years of saving from 25 beat thirty years from 35.

How much does a 1% fee cost?

Over forty years, a one point higher annual cost takes a large share of the final pot, much more than the fees themselves, because the money taken in fees stops compounding.

Is this investment advice?

No. The return, costs and inflation are illustrative inputs, not a forecast. All investing carries the risk of loss.

Is this template really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

The free workbooks of Stock Market Investing for Beginners go further: the full companion set, blank models and the worked cases of the book.

See the book and its free files →

Other free templates

This template goes with Stock Market Investing for Beginners. The book is on Amazon.

If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The template stays free either way.