166 Endowment Plan of a friend 朋友的储蓄保单

 166 Endowment Plan of a friend 朋友的储蓄保单

Last week, my friend said his son's endowment plan (bought by his wife) is going to mature, and they are going to get a sum of money. So, he is curious about the interest (rate of return).

The payment period period for that endowment plan is 12 years, each payment was RM1,585. The maturity value is RM34,019.

And I asked him, after paying for 12 years, how many years did they waited till maturity? He is not sure, he thought they can get the maturity value on the 13th year. I am a bit skeptical, so I asked him to check with his wife again. Till now, he has not reply to me.

OK, we can do some simulation to see the rate of return using different maturity period. I use a spreadsheet, key in 12 lines of -1585 (payment, duit keluar) plus a line of 34019 (receiving, duit masuk). The maturity value (34019), I placed in different different years. Then I use IRR function to calculate the internal rate of return. As below.

We can see the IRR is between 3.34%~8.67.

* * * * * SEPARATOR 分割线 * * * * *

上个星期，朋友说他的太太为孩子买的储蓄保单到期了，有得拿一笔钱了。那他很想知道这份储蓄保单的利息（回抽率）到底有多少。

他说该储蓄保单一共要还12年，每期RM1,585。到期可以拿到RM34,019。

那我问他还了12年后，等了多少年才到期呢？他也不知道，还以为第13年就到期领钱了。我有点儿质疑，要他跟他太太询问清楚。这是因为第几年到期就决定了回抽率。只是到今天他还没有给我答案啦。

那好，我们可以做几个推算，依不同的到期年来看看回酬率多寡。我用 spreadsheet ，输入 12 行的 -1585 （还款，钱飞出去）再加一行的 34019 （收到钱，钱飞进来）。到期日的数目 (34019)，我把它放在不同的年份借此试算出内部回酬率 (internal rate of return)。看下图。

所以回酬率介于3.34%~8.67%之间。