Calculate your own hurdle rate

You will be able to calculate the hurdle rate for your own CPF and decide whether investing it makes sense for you.

Before you open a spreadsheet, go to cpf.gov.sg and write down the current interest rates for your Ordinary Account (OA) and Special Account (SA). Then find the yearly cost figure you worked out in lesson 4.3, and settle on the amount of CPF money you are thinking of investing. Those three things are all you need for this exercise, which takes about twenty-five minutes.

You already have a hurdle rate from lesson 4.2 and a cost list from lesson 4.3. Neither gives you a dollar picture of the decision over the years you would actually hold the investment. The sheet you build here does that. It shows how investing compares with leaving the money in CPF, year by year, and where the break-even return sits. It ends with a written decision.

Kelvin, the course's running example, was in the same position. He had his hurdle rate and his costs but no figures for what the choice meant in dollars over time.

Setting up the inputs

At the top of the sheet, make labelled cells for the amount, the source account (OA or SA), that account's CPF interest rate, your total yearly investment cost, the number of years, and three gross return levels: low, middle and high. Gross return is the return before costs.

Choose return levels you can defend with a source. If you pick them to make the idea look good, the sheet will only confirm what you hoped. A sensible set is one at or slightly below the CPF rate, one in the middle, and one that would be a good result for the type of product you would buy. Next to each input, note where the figure came from.

Kelvin's inputs are S$15,000 of OA money, an OA rate of 3%, yearly costs of 0.8%, ten years, and gross returns of 3%, 5% and 7%. These are invented example figures, and 3% is not the current OA rate.

Calculating the CPF path and three investment paths

Make a year column running from 0 to 10. Beside it, add a CPF column. Year 0 is your amount, and each later year is the previous year's value times (1 + CPF rate). Then add three investment columns, one for each return level. They compound the same way, but their yearly growth rate is the gross return minus the yearly cost.

Below the table, add a difference row, which shows each investment path's value minus the CPF path's value.

Kelvin's S$15,000 left in the OA reaches about S$20,158.75 after ten years. At 3% gross, his money grows at 2.2% after costs and reaches about S$18,646.62. At 5% gross, or 4.2% after costs, it reaches about S$22,634.37. At 7% gross, or 6.2% after costs, it reaches about S$27,373.88. His difference row reads about minus S$1,512.13, plus S$2,475.62 and plus S$7,215.13. His low case grew every year and still finished behind the CPF path, because 2.2% after costs is less than the 3% the OA pays.

Finding the break-even and charting the paths

Add a cell for the break-even gross return, which is the CPF rate plus the yearly cost. It is the gross return at which investing finishes level with leaving the money in CPF. For Kelvin it is 3% + 0.8% = 3.8%.

Check the figure by entering it as a return level. At 3.8% gross, Kelvin's after-cost growth is 3%, the same as the OA, and the path finishes at S$20,158.75, exactly level with the CPF path. If your break-even path doesn't match your CPF ending value, look for a mistake in your formulas.

Chart all four paths as lines over the ten years, with the CPF line in a different colour from the others. Anything above the CPF line is the reward for taking risk. Anything below it is the cost of being wrong.

If the money would come from your SA, rerun the sheet with the SA rate. The break-even rises sharply, and the low and middle cases usually fall below the CPF line.

Writing the decision and its conditions

Under the chart, write two or three sentences stating your decision, then list the conditions that would change it. The choice is wider than invest or don't. You could invest a smaller amount, invest later, or invest cash instead. CPF money is meant for retirement, while gains made with cash are free to use.

Work through these questions as you write. Will you need this money for a home, an instalment reserve or education within the ten years? If education is part of the plan, note that OA money used for a student's fees goes out under the CPF Education Loan Scheme as a loan. The student repays it in cash to the lender's OA, starting one year after they graduate or leave the course, and cannot use their own CPF savings to repay it. Check the CPF Board's website for the current rules. How confident are you in the middle return, and what does the low case cost you in dollars? Since the money is for retirement, would you hold through a fall of a third without selling? Could you take the same risk with cash?

Kelvin decided not to invest now. His OA is going toward his flat purchase over the next two years, so investing it would put money he needs on a fixed date at market risk. His middle case beats the OA by about S$2,476 over ten years, and he judged that this does not justify the risk while his OA reserve for instalments is thin. He will revisit the decision once the flat is bought, his OA holds six months of instalments above the CPFIS threshold, and he can leave the money invested for at least ten years. In the meantime he will take his investing risk with cash.

Your sheet is complete when it has:

labelled inputs, with today's CPF rate and your full cost figure a ten-year table with one CPF column and three investment columns a difference row a break-even cell that checks out a chart with the CPF line clearly marked a written decision plus the conditions that would change it

Build the sheet with your own amount, account and costs. Keep it with your top-up plan from lesson 3.5, because the two decisions compete for the same savings.

Build the hurdle rate sheet, chart the results, then write down whether you will invest your CPF and why.

Course

Junxiong-WFG Organisation is an authorised representative of AIA Financial Advisers Private Limited (Reg. No. 201715016G).