Combine one-off sales charges and yearly costs in a single FV model that also handles monthly top-ups.
[[chat Friend: Bank fund or robo? S$10,000 to start, then S$300 a month for 20 years. | Friend: The bank takes 2% off every buy and 1.75% a year. The robo is 0.78% a year, nothing upfront. | Friend: The 2% hurts most, right? | You: Put both in one model first.]]
---
[[flow S$300 top-up | 2% sales charge, S$6 | S$294 buys units]]
The charge applies to every buy, so your first S$10,000 also goes in as S$9,800. If a fund charges on your first sum alone, reduce just that amount.
---
Your total yearly cost is the fund's expense ratio plus any platform, wrap or advisory fee.
[[sum A fund earns 6% a year before costs and charges 1.75% a year in total. What monthly rate goes into FV, in %? | 0.354% within 0.001 | 4.25% => That's still a yearly rate. FV counts in months, so divide by 12. | 0.5% => That's 6% / 12, before the costs come off. | => (6% - 1.75%) / 12 = 0.354% a month.]]
---
| | Bank fund | Robo | No costs | |---|---|---|---| | Starts with | S$9,800 | S$10,000 | S$10,000 | | Each month | S$294 | S$300 | S$300 | | Rate a year | 4.25% | 5.22% | 6% |
The 6% is an assumption that nobody can promise. Using it for every option leaves cost as the only difference.
---
``` =FV((6%-1.75%)/12, 240, -300*0.98, -10000*0.98) ```
That formula gives the bank fund S$133,809.15. Money you pay in is entered as a negative.
The robo, at 5.22%, ends at S$154,833.21, and both have S$82,000 paid in. These are worked examples rather than forecasts.
---
[[drawit The robo ends S$21,024 ahead. Draw how that gap builds over the 20 years. | years | 20 | points 0 200, 4 1326, 8 3515, 12 7160, 16 12775, 20 21024]]
---
[[bridge No costs 171714 | 2% off every buy -3434 | 1.75% a year -34471 | Bank fund 133809 =]]
No option reaches the no-cost line. By year 20, the 2% charge cost S$3,434 and the 1.75% yearly charge cost ten times that.
---
?? Another fund takes 3% off your first S$10,000 but charges nothing on S$300 top-ups, and its yearly cost is 1.2%. With 6% before costs, which FV is right? =FV((6%-1.2%)/12, 240, -300*0.97, -9700) + =FV((6%-1.2%)/12, 240, -300, -9700) =FV(6%/12, 240, -300, -9700) => The 3% applies only to the first sum, so S$9,700 goes in and every top-up is the full S$300. The 1.2% still comes off the rate before you divide by 12.
---
?= Build your cost model A charge on every buy reduces the first sum and each top-up | A sales charge only applies to your first sum Yearly costs come off the rate, then you divide by 12 | Yearly costs come off the final balance, once Every option gets the same return before costs | Each option gets the return its factsheet shows The no-cost line minus an option is what it costs you | The no-cost line is what you can expect to end with
In a spreadsheet, give each option you're weighing a starting sum, a monthly top-up, a sales charge and a yearly cost, then run FV for each at the net monthly rate.
Junxiong-WFG Organisation is an authorised representative of AIA Financial Advisers Private Limited (Reg. No. 201715016G).