Active vs passive investing calculator

By MoneyBees

Put the same money into an index fund and an actively managed fund, with your own returns and fees, and see what each is worth, what the fees take and how much the active manager must beat the index by just to keep up.

Calculator

Your money and the two funds

S$
S$
%

Your assumption.

%

How far it trails the index a year, TER included. See the factsheet.

%
%
%

Your assumption. Use a negative number if it lags.

Index fund after costs

$293,042

costs take $7,809

Active fund after costs

$244,063

costs take $56,787

Needed to break even

1.42% a year

active return above the index, before fees

You put in $130,000 over 20 years. At 7% a year the index itself would grow it to $300,851. The index fund trails by 0.2% a year and ends at $293,042.

The active fund takes 1.5% of each amount you put in and 1.5% a year from the fund, and you assumed it beats the index by 0% before fees. It ends at $244,063, so the index fund is $48,979 ahead.

To end level with the index fund, the active fund has to beat the index by 1.42% a year before fees, every year for 20 years.

Save my results

Leave your email and we'll save this scenario so a MoneyBees adviser can follow up.

Or book a free chat if you'd rather talk it through.

Typical fund costs in Singapore, from MoneySense

CostTypical rangeWho pays it
Initial sales charge1.5% to 5% of what you investYou, when you buy, to the distributor
Redemption charge1% to 5%You, when you sell, if charged
Management fee, active1.0% to 2.0% a yearTaken from the fund
Management fee, passiveUsually below 1% a yearTaken from the fund
TER, unit trustsUsually 1.0% to 2.5% a yearTaken from the fund
TER, ETFs on the same indexFrom 0.03% to over 0.5% a yearTaken from the fund

Distributors that charge a sales charge do not usually charge a redemption fee. 20% to 60% of the management fee may go to the distributor as a trailer fee.

Worked example

You start with S$10,000 and add S$500 a month for 20 years: S$130,000 in all. If the index returns 7% a year, an index fund that trails it by 0.2% ends at S$293,042. An active fund with a 1.5% TER and a 1.5% sales charge that only matches the index before fees ends at S$244,063, about S$48,979 less. To catch up it has to beat the index by 1.42% a year, every year.

What to compare on a factsheet

For an index fund, look at the tracking difference: it already includes the TER and shows how well the fund follows its index. MoneySense suggests weighing an active fund's TER and track record against a passive fund on the same market before you invest, and comparing the cost of the same fund through different channels.

Frequently asked questions

What is the difference between active and passive investing?

A passive fund, such as an index ETF, tries to match an index and charges little to do it. An active fund pays a manager to pick investments and try to beat the index, and charges more for that. MoneySense puts active management fees at 1.0% to 2.0% a year, and passive fees usually below 1%.

How much do fees matter over the long run?

A lot, because they come off every year and compound. On S$10,000 plus S$500 a month for 20 years at 7%, an index fund trailing by 0.2% ends about S$49,000 ahead of an active fund with a 1.5% TER and a 1.5% sales charge that only matches the index before fees.

What is a TER?

The total expense ratio is the yearly cost of running a fund as a percentage of its assets, taken from the fund itself. MoneySense says unit trust TERs are usually 1.0% to 2.5%, while ETFs on the same index range from 0.03% to over 0.5%.

What is tracking difference?

The gap between an index fund's return and its index's return over a period. It includes the TER and shows how efficiently the fund copies the index. It is the better number to enter for the index fund here.

How much does an active fund need to beat the index by?

Roughly its extra costs: with no sales charge, its TER less the index fund's tracking difference. A sales charge raises the bar further, more so over shorter periods. The calculator works out the exact figure for your inputs.

Do active funds beat the index?

Some do in some years. This calculator does not assume they will or will not: you enter the outperformance you expect. MoneySense suggests checking an active fund's track record against a passive fund on the same market before you invest.

What sales charge do unit trusts have in Singapore?

MoneySense puts the initial sales charge at 1.5% to 5% of what you invest, paid to the distributor. Some distributors charge a redemption fee of 1% to 5% when you sell instead.

Keep exploring

These calculators provide general estimates for educational purposes only and are not personalised financial advice. Results may rely on rates and rules that change over time, so verify against official sources (IRAS, CPF Board, HDB, MAS) or consult a licensed financial adviser before making decisions.

Junxiong-WFG Organisation is an authorised representative of AIA Financial Advisers Private Limited (Reg. No. 201715016G).