Find Every Fee in a Mutual Fund and See What It Costs Over 30 Years

Paste a fund fact sheet and get a full fee table plus a 10, 20 and 30-year dollar comparison against a low-cost index fund benchmark.

You getFee table, total yearly cost vs benchmark and growth table

Prompt

Prompt
Act as a fee-only financial analyst who explains fund costs in plain dollars.

I will paste a fund fact sheet or prospectus excerpt right after this message. Before calculating, ask me in one numbered message:
1. How much I plan to invest up front
2. How much I will add each year, if anything
3. What yearly return to assume before fees (use 6% if I am unsure)
Wait for my answers.

Rules:
- List every fee you find: expense ratio, management fee, 12b-1, front or back load, redemption fee, account fee. Quote the figure from the sheet; mark anything not stated as "Not listed".
- Compare against a low-cost index fund at 0.05% total yearly cost with no loads.
- Compound yearly, deduct loads from every purchase, add contributions at year end, and show the formula once.
- Flag fees that are conditional or temporary, such as fee waivers with an end date or breakpoint discounts.
- Do not tell me to buy or sell.

Output format:
1. Fee table: Fee | Amount | Where on the sheet | Notes
2. Total yearly cost vs benchmark
3. Growth table: Year | This fund | Benchmark | Fee drag in dollars | Drag as % of benchmark balance
4. Three plain-language takeaways
5. Questions to ask the fund provider

End with your assumptions and what the sheet left out. This is educational, not financial advice; talk to a fee-only fiduciary adviser before moving large sums or if selling could trigger taxes.

Example output

At a glanceHarborline fund vs low-cost benchmark over 30 years$25,000 up front, $3,000 yearly, 6% assumed return before fees
ItemThis fundBenchmark
Yearly cost0.98%0.05%
Sales load5.75% per purchaseNo load
Balance at year 10$74,044$84,001
Balance at year 20$156,446$189,190
Balance at year 30$290,945$376,647

Example for: Harborline Growth & Income Fund, Class A shares; $25,000 up front, $3,000 added yearly, 6% assumed return before fees.

1. Fee table
FeeAmountWhere on the sheetNotes
Front-end sales load5.75%Shareholder FeesTaken from every purchase
Management fee0.68%Annual Operating ExpensesIncluded in expense ratio
12b-1 fee0.25%Annual Operating ExpensesMarketing cost, included
Other expenses0.19%Annual Operating ExpensesIncluded
Gross expense ratio1.12%Annual Operating Expenses
Fee waiver-0.14%Footnote 2Expires 30 April next year
Net expense ratio0.98%Annual Operating ExpensesUsed below
Redemption feeNot listed
Account feeNot listedCheck your brokerage
2. Total yearly cost vs benchmark
  • This fund: 0.98% per year + 5.75% on each purchase
  • Benchmark: 0.05% per year, no load
  • First-year load paid: $1,437.50 on the initial deposit, then $172.50 per yearly contribution

Formula: Balance = P(1+r)^n + C × ((1+r)^n − 1) / r, where r = 6% minus yearly cost and P, C are amounts after the load.

3. Growth table
YearThis fundBenchmarkFee drag in dollarsDrag as % of benchmark
10$74,044$84,001$9,95711.9%
20$156,446$189,190$32,74417.3%
30$290,945$376,647$85,70222.8%
4. Takeaways
  1. The load costs you immediately: about $1,438 never gets invested on day one.
  2. The 0.93-point yearly cost gap matters more over time; by year 30 it takes nearly a quarter of the ending balance.
  3. If the waiver ends, the cost rises to 1.12% and the 30-year gap grows further.
5. Questions to ask the fund provider
  • Do I qualify for a breakpoint discount on the load at $25,000 or with family accounts?
  • Is the 0.14% fee waiver likely to be renewed?
  • Is there a no-load share class (such as Class I) available on my platform?
  • What were the fund's trading costs and turnover last year?

Assumptions and gaps: steady 6% return, contributions at year end, no taxes, no account fees. The sheet did not list portfolio turnover or trading costs, which add hidden expense. This is educational, not financial advice; speak with a fee-only fiduciary adviser before switching, especially in a taxable account.

Written by AI from this prompt. Your results will vary.

Tips and common edits

Why this works

  • Requiring a quote and location for each fee, with 'Not listed' for gaps, stops the model from guessing numbers.
  • A fixed 0.05% benchmark and shown formula make the 10, 20 and 30-year dollar drag checkable.
  • Flagging waivers and breakpoints catches the fees that change after you buy.

Use this before buying a fund or when reviewing one you already own. Have the fact sheet or prospectus fee section ready to paste into ChatGPT, Claude or Gemini, plus your planned investment amounts.

Common edits

  • Swap the benchmark to a specific index fund's expense ratio you are considering.
  • Add a column showing results after a 15% tax on gains for a taxable account.

Prompt details

By
Prompts-GPT editors
Published

Did this prompt work?

Keep exploring

More in Personal Finance