doody_
Supremacy Member
- Joined
- Nov 27, 2006
- Messages
- 7,508
- Reaction score
- 5
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? (updated Feb 2018)
Download link here: http://s000.tinyupload.com/index.php?file_id=56966513491273753715 (No macros required!)
Any suggestions? Problems? Complaints? Let me know
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? (updated Feb 2018)
Download link here: http://s000.tinyupload.com/index.php?file_id=56966513491273753715 (No macros required!)
Any suggestions? Problems? Complaints? Let me know
Last edited: