Build a worksheet that splits a monthly salary across your accounts and estimates a year's interest.
Open a blank spreadsheet and log in to cpf.gov.sg. Have your latest CPF balances ready, and find the current tables for contribution rates, allocation rates for your age band, the Ordinary Wage ceiling, interest rates and the extra interest rules. With these you can build a worksheet that estimates how much your Ordinary Account (OA), Special Account (SA) and MediSave will grow in the coming year if you do nothing.
Your CPF statement shows what happened last year, so it doesn't tell you what next year will look like with a new salary. Kelvin, 32, wanted one number before making any CPF decision: how much his accounts would grow this year if he left them alone. When he found the statement only covered last year, he built a small worksheet in about half an hour, and he now updates it every January. Every rate in his sheet is made up, so replace each one with the current figure from cpf.gov.sg before you trust a result.
Put every figure that can change in its own labelled cell at the top of the sheet, so that when the CPF Board revises a rate you change one cell and the whole sheet updates. You need these inputs:
monthly salary age Ordinary Wage ceiling total contribution rate for your age three allocation rates, for the OA, SA and MediSave opening balance for each account interest rate for each account extra interest rules
The total contribution rate is the share of your wages paid into CPF each month, your part and your employer's together. Allocation rates are the share of your CPF contributions going to the OA, SA and MediSave. The CPF allocation table gives each account's share as a ratio of CPF contributions, so copy it in that form. Beside the inputs, note the date you copied the rates, so you know when they need refreshing next.
Kelvin entered a salary of S$5,800 (an example figure) and an age of 32. He used a total contribution rate of 35%, split as 21% to OA, 6% to SA and 8% to MediSave. His opening balances were S$40,000 OA, S$15,000 SA and S$25,000 MediSave, and his interest rates were 3% OA, 5% SA and 5% MediSave, none of which are current CPF rates.
The Ordinary Wage ceiling sets the maximum amount of Ordinary Wages that attracts CPF contributions in a calendar month, so Ordinary Wages above it attract no contributions. Ordinary Wages are the pay you earn for work in a given month, such as your basic monthly salary. Never multiply your full salary by the contribution rate. Add a cell for wages subject to CPF, which is your salary capped at the ceiling, using the formula =MIN(salary, ceiling), and have every contribution line work from that cell.
This step stops the sheet overstating contributions for anyone earning above the ceiling. A colleague of Kelvin's earns well above it, and gets the same contribution on Ordinary Wages as someone earning exactly the ceiling. Kelvin earns below the ceiling, so his full S$5,800 counts.
Bonuses are treated separately as additional wages, with their own yearly ceiling, the Additional Wage ceiling. If you get a regular bonus, add it as a separate row and look up how the Additional Wage ceiling applies to it.
Now multiply wages subject to CPF by each rate. For Kelvin, the monthly total is S$5,800 x 35% = S$2,030. Split by account, that is S$1,218 OA, S$348 SA and S$464 MediSave. Check that the three accounts add to the total: S$1,218 + S$348 + S$464 = S$2,030.
Multiply each monthly figure by 12 for the year. Kelvin's yearly contributions come to S$14,616 OA, S$4,176 SA and S$5,568 MediSave, a total of S$24,360.
The Basic Healthcare Sum is the cap on how much your MediSave can hold. If your MediSave balance is close to the Basic Healthcare Sum, cap the MediSave line at the room left and move the rest to the account it overflows to, using the overflow rules explained in Lesson 1.3.
Interest has three parts, and each gets its own row for each account: interest on the opening balance, interest on new contributions, and extra interest. Extra interest is an additional rate CPF pays on the first part of your combined balances.
The first row is the opening balance multiplied by the interest rate. For Kelvin, that gives S$1,200 OA, S$750 SA and S$1,250 MediSave.
The second row covers the money paid in during the year. As Lesson 1.2 explained, each month's contribution starts earning interest the month after it arrives. With a contribution arriving every month from January to December, the months earning interest add up to 66. The formula is monthly contribution x 66 x rate / 12, which for Kelvin comes to about S$200.97 OA, S$95.70 SA and S$127.60 MediSave.
For the third row, work out how much of your combined balance qualifies for extra interest under the current rules, then multiply that by the extra rate. Only part of the OA can count. Kelvin's made-up rule paid an extra 0.5% on the first S$50,000, with no more than S$15,000 of OA counted. His qualifying balance was S$15,000 OA + S$15,000 SA + S$25,000 MediSave = S$55,000, capped at S$50,000, which gave him S$250 of extra interest.
Add the rows to get the year's total. Kelvin's estimated interest for the year is S$3,874.27. Because the inputs are estimates, round the final figure when you write it down, as Kelvin did when he recorded S$3,870 for the year.
The estimate can overstate your growth. A pay cut, months without work, or OA savings used for a home all mean less goes into your accounts and less earns interest.
An untested worksheet is a guess. Copy the sheet to a second tab and enter last year's opening balances, last year's salary and last year's rates. Then compare the interest it predicts with the interest credited on last year's statement.
Kelvin's test tab predicted S$3,640, and his statement showed S$3,580, a gap of under 2%. He could explain it: one month's contribution arrived late after a payroll change, and a course fee was paid from his OA in March.
A gap of a few percent between predicted and actual interest is fine. A large gap usually comes from a wrong rate, a missed withdrawal, or extra interest counted on more of the OA than the rules allow.
Your worksheet is finished when it has labelled input cells holding this year's CPF Board figures, a wage line that applies the ceiling, and monthly and yearly contributions per account that add to the total. It also needs three interest rows per account, a test tab that lands within a few percent of last year's statement, and the date you copied the rates noted beside the inputs.
Build yours now with your own salary, age and balances, and keep last year's statement open next to the sheet for the comparison.
Build the worksheet with your own salary and age, then compare its interest estimate with the interest shown on last year's CPF statement.
Junxiong-WFG Organisation is an authorised representative of AIA Financial Advisers Private Limited (Reg. No. 201715016G).