Skip to content
The title slide and first slides of the Investment Fee Comparison template

Investment Fee Comparison

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
7
Style
Modern
Difficulty
Beginner
Updated
November 16, 2026

Every slide (7)

Overview

Fees are quoted in small percentages that hide their dollar cost. On Funds, list up to three funds with an expense ratio and any other yearly fee, such as an advisor charge. On Fees, set a starting balance, a yearly addition and the return before fees. Yearly then grows the balance with no fees and again for each fund, so the gap between them is the dollar cost of fees.

Cost Over Time shows that cost at the number of years you pick and charts it every five years from 5 to 30. In the sample, a 0.04 percent fund costs about $8,300 over 30 years against about $160,700 for a 0.85 percent fund. Fees are not the only difference between funds, and the return you assume is your own.

Useful for

  • See what a 1 percent fee costs over 30 years
  • Compare an index fund with a managed fund in dollars
  • Show a client or partner why small fees matter

What's included

  • 5 tabs: Funds, Fees, Yearly, Cost Over Time, How to use
  • Funds: a table
  • Fees: a table
  • Yearly: a table
  • Cost Over Time: a dashboard with 4 summary figures
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Funds tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How much do investment fees cost over time?

Fees are taken every year from a balance that would otherwise keep growing, so the cost compounds. Enter your balance, deposits and fees on the Fees tab to see it in dollars.

What is an expense ratio?

It is the yearly percentage a fund charges for running it, taken from the fund assets. It is listed in the fund fact sheet and prospectus.

Is a lower fee always better?

Not always on its own, because funds differ in what they hold and how they behave. Fees are one certain cost, so they deserve a look next to risk and tax effects.

  • #investment-tracker
  • #investment-fee-comparison
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More investment tracker templates

See all 14

Also in Finance

All finance templates
Get this template

Preparing your template…