What is this?
It's an Excel spreadsheet to project your CPF account balances into the future.
Can use this do what?
Estimate how much CPF you have at age 55, project impact of additional CPF contributions, etc.
How to use?
You enter your birth year on top in the box highlighted in yellow. The age and category will be auto updated. CPF not very clear so I made some assumptions about when the age category changes. The data table is on the right from Column V onwards.
After that, you enter your CPF contribution for each month. It will show the split into the 3 accounts, and the balance for that month. Interest is calculated every month and added at the end of the year.
Some other stuff
It's supposed to roll over MA to SA once MA exceeds BHS, and to roll over to OA once SA exceeds FRS. I checked the figures and it looks good, but let me know if something goes wrong with the rolling .
I didn't include in the extra 1% interest paid on first 60k of balances, still need to think about the best way to fit it in.
Where to get?
Download link here: http://s000.tinyupload.com/index.php?file_id=00281808830695621173 (No macros required!)
Any suggestions? Problems? Complaints? Let me know
Maybe should pm TS.
Sorry ah, need to find the file again...
Thanks for the spreadsheet...
LOL, did a calculation with the following assumptions:
-BHS increasing @4.7% yearly till I reach 65yo
-FHS increasing @3% yearly till I reach 55 yo
-salary increasing @4% yearly till hitting $6k, no bonus
-MA is untouched as I will pay cash for ISP and any medical bills
-no transferring of OA to SA as it will be used for housing
MA will hit the projected BHS @ the age of 55
SA will hit the projected FRS @ the age of 59...
jin jialat, must pray to stay employed till 60yo.
Only comment is that it definitely not right or reasonable to hold MA constant at 52k in the projection and let the excess flow into SA/OA. MA will keep increasing till one reaches 65.
So optimistic that every year is 5 months bonus?
Sample data only la...
Are you referring to BHS increasing over the years? Will need to follow the changes over the years to ensure it's correct.
I appreciate and laud your effort and time spent on table. But it would be reasonable to assume BHS would certainly increase. A guess of 3% to 5% would prevent too much overflowing to other accounts over the years giving a distorted view.
Yep that's a good point. You guys can make the formula change yourself hor?
I check the excel he got the extra 1%.The SA difference is ~52k but the OA difference is ~29k. In total the difference is ~23k.
There's a simple calculation you can do yourself in Excel or Google Docs to calculate the difference. Enter the formula: =FV(0.04, 26, 0, -30000) - FV(0.025, 26, 0, -30000). You will get the result $26,165
Not sure why that TS's calculator calculates it different, will need to audit the formulas to check, which I don't really have time to.
I think I know why the CPF's calculator projects more though: It takes into account the extra 1% interest you get for the first $60k in your CPF (capped at $20k for OA). So on Jan 2019 you are only getting the 1% bonus interest on $20k + $14032.75, and if you transfer $30k into your SA you will get the capped bonus interest on $60k.
Yep that's a good point. You guys can make the formula change yourself hor?