Mutual Fund Calculator (lump sum + monthly, with load and expense ratio)

Understanding the mutual fund fee calculator — concept and principle

This calculator projects the value of a mutual fund investment with a front-end sales charge (load) and a yearly expense ratio, and shows how much those charges cost compared with the same plan without them. It is useful for comparing share classes or a fund with a low-cost index alternative.

Paying $58,000 in at 7% before fees ends at $124,850.93; without the load and expense ratio it would be $140,204.12.

How it is calculated

Front-end load: only amount × (1 − load) of each purchase is invested.
Net yearly return = (1 + return) × (1 − expense ratio) − 1.
Monthly rate i = (1 + net return)^(1/12) − 1; value = P(1 + i)^n + C((1 + i)^n − 1) ÷ i, with the monthly investment at the end of each month.
Cost of each charge = value without it − value with it, so it includes the growth the money would have earned.

The principle

A load is taken once from each purchase, so less money starts compounding. The expense ratio is taken every year from the fund's assets, so it reduces the return on the whole balance, year after year. Small percentages compound into large amounts over decades, which is why regulators require funds to disclose fees and their effect on a hypothetical investment.

Worked example

Default inputs: 10,000 USD initial, 200 USD a month, 3% load, 0.6% expense ratio, 7% return before fees, 20 years.

Invested after the load: 9,700 USD and 194 USD a month.
Net return = 1.07 × 0.994 − 1 = 6.36% a year.
Final value ≈ 124,850.93 USD. You paid in 10,000 + 200 × 240 = 58,000.00 USD, a gain of 66,850.93 USD.
Sales charges paid = 3% × 58,000 = 1,740.00 USD.
Lost to the expense ratio = 11,147.06 USD. With no charges at all the plan would reach 140,204.12 USD, so total cost = 15,353.19 USD.

Each point is the calculator re-run with only “Years” changed; the gold point is the default example. Change the inputs above and this chart follows your numbers.

Years	Final value
5	$26,799.63
10	$50,071.84
15	$81,744.79
20	$124,850.93
25	$183,517.42
30	$263,361.15
40	$519,917.89

How to read the result

Compare the total cost with the fees of an alternative fund. Over long horizons the expense ratio usually costs far more than the load, because it applies to the growing balance every year. A difference of half a percentage point a year can mean thousands of dollars over 20 years.

Common mistakes

Looking only at the load and ignoring the expense ratio.
Forgetting breakpoint discounts that lower the load on large purchases.
Assuming the return before fees is guaranteed.
Ignoring taxes on distributions in taxable accounts.

Keep in mind: Returns are assumed constant; taxes and back-end loads are not included. Read the fund prospectus. This is not investment advice.

Frequently asked questions

What is a good expense ratio?

Lower is better for the same strategy. Broad index funds often charge well under 0.2% a year, while active funds usually charge more.

Is a front-end load worth paying?

Only if the fund's expected net performance justifies it. Many no-load funds offer similar exposure.

Where do I find a fund's fees?

In the fee table at the front of the prospectus.

Sources: US SEC Investor.gov, Mutual Fund Fees and Expenses (Investor Bulletin) · FINRA, Fund Analyzer (fee comparison tool)

Checked 9 Nov 2026. Mutual fund loads and annual operating expenses: U.S. SEC, Investor.gov, “Mutual Fund Fees and Expenses” and Investor Bulletin “How Fees and Expenses Affect Your Investment Portfolio” (2014); sales-charge limit: FINRA Rule 2341 (Investment Company Securities).

Your numbers