Mutual Fund Return Calculator

What Is a Mutual Fund?

A mutual fund pools money from many investors and invests it in a portfolio of stocks, bonds, or other securities. A professional fund manager selects and manages the investments. When you invest in a mutual fund, you buy shares and your returns reflect the fund’s performance minus fees.

Expense Ratios, The Hidden Cost

The expense ratio is an annual fee charged by the fund as a percentage of your assets under management. It covers fund management, administration, and marketing (12b-1 fees, named after the SEC rule that permits them). A 1% expense ratio on $100,000 costs you $1,000 in the first year, which sounds survivable. The damage is what that missing $1,000 would have earned, every year, for as long as you hold the fund.

Put $100,000 into a fund returning 8% before fees and leave it for 30 years. At a 0.05% expense ratio you finish with about $1,077,000. At 1.00% you finish with about $812,000. The fee took roughly a quarter of your money, 24.7% of it, and you never wrote a cheque for any of it. Both figures come straight out of the calculator above.

If you are also contributing monthly the percentage looks smaller, around 19% on the same assumptions, only because your later contributions have not been exposed to the drag for as long. The dollars lost are still enormous. This is the arithmetic behind Warren Buffett’s and John Bogle’s insistence on minimizing fund costs.

Typical expense ratios:

• Index funds (passive): 0.03% – 0.20%
• Actively managed funds: 0.50% – 1.50%
• High-cost funds: 2.00%+

Load Fees

A load fee is a sales commission paid when you buy (front-end load) or sell (a back-end load, also called a Contingent Deferred Sales Charge or CDSC) fund shares.

• Front-end load: Deducted from your initial investment. A 5% front-end load on a $10,000 investment means only $9,500 is actually invested. The 5% is not just gone, it also never compounds.
• Back-end load (CDSC): Applied to the value when you sell. It steps down roughly one percentage point a year and reaches zero, usually after five to seven years. The calculator models it that way, so a 5% charge on a fund held five years or more comes out at nothing.
• No-load funds: No sales commission at all, so the entire investment goes to work immediately. Most index funds and direct-purchase funds are no-load.

The Power of Low-Cost Index Investing

Over long periods, most actively managed funds underperform their benchmark index after fees. That single finding is what built the index fund business: a fund that passively tracks a market index such as the S&P 500 has almost no turnover and almost no expense ratio to overcome. The S&P 500 has returned roughly 10% a year historically before inflation, or about 7% after it.

Notice what the two sections above imply together. An active fund charging 1% with a 5% front-end load has to beat the index by well over a point a year, every year, just to draw level with a no-load index fund. Some managers do. Picking them in advance is the part nobody has reliably solved.

Future Value Formula

Future value is standard compound interest with regular additions, run monthly:

FV = PV × (1 + r)^n + PMT × [((1 + r)^n − 1) / r]

Where r is the monthly rate and n the number of months. The rate used is the net one: effective return = gross return − expense ratio. A fund quoted at 8% with a 0.50% expense ratio compounds at 7.50%, not 8%.