ETF vs Mutual Fund Calculator

Where the Cost Difference Comes From

An ETF and a mutual fund can hold the same underlying assets and still end at different values, because they charge in different ways. Both carry an annual expense ratio taken out of returns. A mutual fund may also carry a sales load, a one-off percentage removed from the money before any of it is invested. Exchange-traded funds are bought and sold on an exchange instead, so a bid-ask spread applies on the way in and out. This calculator isolates the fee effect: it takes a gross return and an expense ratio for each, plus any load on the mutual fund, compounds both over the horizon you set, and reports the gap between the two final values.

How Each Charge Reaches the Result

The expense ratio is subtracted from the gross return before compounding, so a fund charging 1% against an 8% gross return compounds at 7%. That subtraction repeats every year, which is how a gap of a fraction of a percentage point turns into a large difference across decades. A load works differently. It comes out once, from the capital, so it shrinks the base that everything else compounds on.

Neither charge belongs to one structure by definition. Index-tracking mutual fund share classes exist with expense ratios in the same range as broad-market ETFs, and load-free share classes are widely available. What the comparison turns on is the figures attached to two specific funds rather than the format either one comes in.

What a Load Does to the Capital Base

A 5% front-load on 10,000 leaves 9,500 invested and 500 not. The 500 does not only cost 500, it costs whatever it would have compounded into: at 7% over 30 years, about 3,806. Because the deduction happens before the first year of growth rather than each year, its effect scales with the horizon in the same way the invested capital does.

Worked Example

The sample figures used on this page are 50,000 over 20 years, both gross returns at 8%, an ETF expense ratio of 0.1%, a mutual fund expense ratio of 1%, and a 3% load. The ETF ends at 228,769.91 against the mutual fund's 187,679.70, a gap of 41,090.21.

Holding everything else and moving the load to 0% isolates the expense-ratio effect. The mutual fund then ends at 193,484.22 and the gap narrows to 35,285.69, which is about 71% of the amount originally invested. The 5,804.53 difference between those two gaps is what the 3% load accounts for, 14.13% of the total at these sample figures.

Raising the load to 5% instead, with the expense ratios unchanged, takes the mutual fund down to 183,810.01 and widens the gap to 44,959.90.

Where the Gap Narrows

The gap narrows as the two expense ratios converge, and shorter horizons compress it further, since fewer years of compounding act on the fee difference. It does not reach zero while a load is in play. With both expense ratios set to 0.1% and the 3% load left in place, the difference settles at 13.73% of the amount entered, which is exactly the 3% the load removed compounded at the 7.9% net rate for twenty years. Some workplace pension and retirement schemes offer share classes at pricing not available to individual buyers, which can reverse the comparison for money held inside them. Entering the actual figures for the specific funds available is what makes the output mean anything.

When the Mutual Fund Ends Ahead

The annual charge and the one-off load pull the same way only when the same fund carries both. That is the case at the sample figures on this page, where the ETF has the lower expense ratio and no load, so it leads at every horizon and there is no crossover to find. For the two to draw level there, the mutual fund expense ratio would have to reach roughly -0.06%, or the load roughly -18%, and neither is an accepted value.

Reversing the charges makes the two effects oppose each other. Where the mutual fund is the cheaper one to hold each year but carries a load, the load costs it capital at the outset while the lower annual charge earns that back over time, so the ETF leads early and the mutual fund leads later. The switch happens at the horizon where the compounding advantage of the lower annual charge has repaid the capital the load removed. With both gross returns at 8%, an ETF expense ratio of 1%, a mutual fund expense ratio of 0.05% and a 3% load, that lands at 3.45 years: at three years the ETF is ahead by 0.48% of the amount entered, at four the mutual fund is ahead by 0.64%, and by twenty it is ahead by 60.98%. Narrowing the annual gap pushes the crossover out, to 7.29 years at an ETF expense ratio of 0.5% and to 65.75 years at 0.1%, which is past the 60-year maximum the horizon input accepts.

What the Model Does Not Capture

Tax treatment is excluded, and it varies by jurisdiction and by the type of account a fund is held in. In some markets the two structures differ in how realised gains reach the holder, which can move the after-tax outcome in either direction relative to the fee-only figure shown here. Trading costs are excluded as well: the bid-ask spread on exchange-traded purchases, and any commission either structure attracts.

Both gross returns are held constant for the whole horizon, with no contributions or withdrawals along the way. Real returns vary year to year, and two funds tracking the same index will not post identical gross figures. Ongoing marketing or distribution charges applied by some share classes, and charges levied on sale rather than on purchase, sit outside the calculation as well, since only a front-end load is modelled. Minimum investment sizes, scheduled contribution facilities and rebalancing arrangements also differ between the two formats and are not inputs here.