CPF Calculator

[doody_]

http://s000.tinyupload.com/index.php?file_id=08472886294492285480

Uploaded again

 

[stealth0128]

Bookmarked. Thanks doody.

Sent from Google PIXEL 2 XL using GAGT

 

[blackfyre]

Uploaded again

Hi doody_, can you upload the file again? Appreciate much.

 

[Perisher]

Up this TS calculator, jsk.

 

[zoneguard]

A modern version: https://geek.sg/tools/cpf-forecast/

It handles projected FRS and BHS growth unlike doody's spreadsheet.

 

[item2sell]

Is it correct?

It says I hit ers already

 

[Atrina_Boy]

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

power la TS !!

 

[1982-1994]

A modern version: https://geek.sg/tools/cpf-forecast/

It handles projected FRS and BHS growth unlike doody's spreadsheet.

But like not zhun
You try put the retirement age as a year later and see how

 

[zoneguard]

You try put the retirement age as a year later and see how

1 year later? How does that work? I don't know your age.

Anyway the calculator would have made some assumptions and if you break those assumptions, of course it won't work for you. You can feedback to the creator and see if he wants to fix it - or not.

Assumptions:

• CPF SA top up and transfers are made only in January.
• Bonus for the year is credited only in December.
• CPF FRS will inflate at a constant rate of 3% per year.
• CPF BHS will inflate at a constant rate of 4.95% per year.

Finally, there are few known limitations to the product:

• Simplified calculation of age by using birth year instead of full birth date
• Missing accrued interest for months prior to current month

If you noticed any inaccuracies or errors, please contact me.

 

[kangzhengxing]

anyone can share the spreadsheet?

 

[tyongchi]

Based on the latest CPF Life estimator, the $$ pay out per month per $1000 at age of withdrawal is as shown below. The % increase seems to be around 1.7%

Age​	Basic Plan​	% Increase​	Standard Plan​	% Increase​
65​	$ 4.89​		$ 5.37​
66​	$ 4.98​	1.74%​	$ 5.47​	1.71%​
67​	$ 5.04​	1.36%​	$ 5.56​	1.65%​
68​	$ 5.13​	1.65%​	$ 5.64​	1.49%​
69​	$ 5.22​	1.89%​	$ 5.73​	1.71%​
70​	$ 5.32​	1.83%​	$ 5.84​	1.84%​
	Average​	1.69%​		1.68%​

 

[YouHeypiCanLiao]

@doody_ bro can re-upload XLS kym?

 

[Shion]

Does anyone have the spreadsheet ? Able to share ?

 

[gold_eagle36]

Anyone updated it to reflect 2025 SA changes?