Separate the insurance and the investment in an illustration

Split a benefit illustration's year-ten figures into what stayed invested and what cover and charges cost, using one spreadsheet formula.

?? An adviser shows you year ten of an illustration: S$36,000 paid in, S$46,000 at 8%. What does that tell you? You'd be S$10,000 ahead by year ten + Not much, until you grow the same premiums at 8% Your money would grow about 28% over the ten years you pay in => The S$46,000 assumes the policy earns 8%, and your S$36,000 would have grown at 8% anyway. A fair comparison is the same premiums grown at 8% with nothing taken out.

---

Open the illustration at year ten

Use one you've been offered, or a sample from an insurer's website.

[[flow Say S$3,600 a year, paid at the start | x 10 years | S$36,000 paid in]]

The rates it shows are assumed returns rather than a forecast of what you'll earn.

---

Tap the three numbers you need

[[doc policy | Policy year 10 | Annual premium S$3,600 | Total premiums paid S$36,000 (1) | Sum assured S$100,000 | Value at 4% S$36,500 (2) | Value at 8% S$46,000 (3) | 1: Paid in by year ten | 2: Value at the lower assumed rate | 3: Same, at the higher rate | find 3]]

---

Grow the same premiums with **no charges**

In a spreadsheet, type =FV(8%, 10, -3600, 0, 1). The final 1 means each premium goes in at the start of the year.

[[big S$56,324 | at 8%, with nothing taken out]]

At 4%, the same premiums grow to S$44,951.

---

Subtract at the same rate

| | At 4% | At 8% | |---|---|---| | No charges | S$44,951 | S$56,324 | | Illustration | S$36,500 | S$46,000 | | Cover and charges | S$8,451 | S$10,324 | | Share of S$36,000 paid | 23.5% | 28.7% |

The gap is bigger at 8% because charges taken early would have grown faster if left invested.

---

About a quarter went on cover and charges

Some of that bought real life cover, so compare it with a term cover quote before calling it expensive.

Your figure is an estimate, so check it against the separate cover, charges and units in your illustration and Product Summary.

---

?= Build your summary of reading an illustration Compare the illustrated value with the same premiums grown at the same rate with no charges | Compare the illustrated value with the premiums you paid in | Read the highest number on the last page Only subtract values that use the same rate | Subtract the 4% value from the 8% value | Average the two rates first, then subtract The illustrated rates are assumptions rather than a forecast | The insurer expects its sub-funds to earn 8% | The value at the lower rate is the least the policy will be worth

Copy the year-ten figures from your own illustration into a spreadsheet, run FV at both rates, and write one line on what share of your premiums went on cover and charges.

Course

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