CPF interest rate is calculated monthly and there is no commission charge.
There is indeed a mistake in the calculation. I did not add the final year interest to the final amount.
But, the above example is using simple yearly calculation. For more accurate calculation, monthly interest rate computation will have to be used.
If monthly interest rate is used,
The first couple ends up with $435789.18
The second couple ends up with 439518.8516
The difference is only $3729.
But, the most accurate scenario is to split the CPF contribution amount into 2, monthly loan amount into 2 and take into account of the 3.5% interest rate for the 1st $20,000.
The first couple will end up with $225240.4628 each or a total of $450480.9256.
The second couple will end up with $222920.4546 or a total of $445840.9091.
So, strangely speaking, if the 3.5% interest rate for 1st $20000 remains, the one who takes the longest loan period will end with more money.
http://www.yousendit.com/download/QlVnck93UzhsamNLSk1UQw?cid=tx-02002207340200000000&s=19102
still wrong. Cell B181 is 1201.02, not 2014.52.
Cell A181 dun need add 814 as well..
