Free reward · Google Sheets

Singapore Home Buyers Toolkit

A Google Sheets template that works out stamp duty, grants, cash and CPF, loan limits, rent vs buy and selling costs for a Singapore home. Free when friends join the Propwise newsletter through your link.


Work out what a Singapore home really costs, in one spreadsheet.

Buying a home means many sums: stamp duty, grants, fees, the loan limits, and how much CPF and cash you will use. This toolkit puts them in one Google Sheet. You fill in the yellow cells. The rest is worked out for you.

It comes with an example filled in, a couple buying a S$600,000 resale 4-room flat. Replace it with your own numbers.

How to get it
The Your details tab of the toolkit, with yellow input cells for the home, the buyers, the loan, fees and grants, and an At a glance summary
Your details. Fill in the yellow cells. The summary on the right updates as you type.

What is inside

  1. 01
    Your detailsOne page for the home, the buyers, the loan and the fees. Yellow cells are yours to change.
  2. 02
    Upfront costsBuyer's Stamp Duty, ABSD, legal fees, HDB grants, and the cash and CPF you need on completion.
  3. 03
    Loan checkThe largest loan the TDSR, MSR and LTV rules allow, the monthly instalment, and a Pass or Fail on each test.
  4. 04
    Rent vs buyA 15-year comparison of buying and renting, with the year buying comes out ahead and a chart.
  5. 05
    Sell and upgradeSeller's Stamp Duty, the CPF refund and the cash left after you sell, before the next purchase.
  6. 06
    RulesEvery rate in one place, each with its source link and the date it was checked.

Why use it

  • See the whole cost, not just the priceStamp duty, fees and renovation sit next to the down payment, so the cash you need is not a surprise.
  • Split cash and CPFThe sheet shows how much CPF can pay and how much must be cash, and how much cash is left after the fit-out.
  • Test the loan before the bank doesIt applies the TDSR, MSR and LTV limits at the stress-test rate and says which limit binds.
  • Change one number, see everything moveEvery figure is a formula. Try a higher price, a longer tenure or a second income and read the result at once.
  • Know where each rate comes fromThe Rules tab links every rate to IRAS, MAS, HDB or CPF, with the date we checked it.
  • Keep your numbers privateYou get your own copy in your own Google account. We cannot see what you type into it.

A look at the tabs

All figures below are the example in the sheet: a couple aged 30 and 28, on S$4,500 and S$4,000 a month, buying a S$600,000 resale 4-room flat with an HDB loan.

The Upfront costs tab: Buyer's Stamp Duty by band, ABSD, fees, HDB grants, the total needed on completion and the cash and CPF split
Upfront costsBSD by band, grants, fees, and how much CPF and cash cover the total.
The Loan check tab: income the lender counts, loan limits, the largest loan allowed, the monthly instalment and Pass results for the MSR and LTV tests
Loan checkThe limit that binds, the instalment at the stress-test rate, and a Pass or Fail on each test.
The Rent vs buy tab: assumptions, the result, a year-by-year table for 15 years and a line chart of net worth if you buy or rent
Rent vs buyA model built on the assumptions you set, not a forecast. Change the rent, price growth or years of stay and the chart moves.

How to get it

  1. Join the newsletter. Confirm your email and you get a personal link at the foot of every daily email.
  2. Share your link. Send it to friends who are thinking of buying, selling or renting.
  3. We send the toolkit. When 3 friends sign up through your link and confirm their email, we email you Singapore Home Buyers Toolkit, free.

Each friend gets the daily email and the free beginner's guide. Read the full terms on the newsletter page.

Start with the daily email

Join free. Your personal link arrives in the first email you receive after you confirm.

Free: the guide, then one email a day. We email a link to confirm first. Unsubscribe in one click. Privacy policy

General information, not financial, legal or tax advice. Rules change, so check the current position with the agency before you decide.