Compare two homes over ten years

Compare two homes over ten years by cash paid out, net cost and the first year each one can be sold.

Say a S$450,000 BTO, keys in four years, or a S$620,000 resale, keys in three months. 25-year HDB loan at 2.6%, S$2,400 rent while you wait.

?^ Ten years in: which is bigger? BTO downpayment | 112500 | 25% x S$450,000 Rent while you wait for BTO keys | 115200 | S$2,400 x 48 months Stamp duty on the resale | 13200 | 1% of S$180,000 + 2% of S$180,000 + 3% of S$260,000 Resale downpayment | 162500 | 25% x S$610,000 valuation + S$10,000 cash over valuation BTO instalments, years 5 to 10 | 110242 | S$1,531.13 x 72 months Resale instalments | 242838 | S$2,075.54 x 117 months Rent while the resale completes | 7200 | S$2,400 x 3 months BTO loan still owed at year 10 | 275246 | S$337,500 after 72 of 300 payments at 2.6%

---

The two homes, row by row

| | BTO | Resale | |---|---|---| | Price | S$450,000 | S$620,000 | | Loan, 75% | S$337,500 | S$457,500 | | Downpayment | S$112,500 | S$162,500 | | Stamp duty | S$8,100 | S$13,200 | | Monthly instalment | S$1,531 | S$2,076 |

Example figures: HDB loan, 25 years at 2.6%. Resale valued at S$610,000, the S$10,000 over in cash.

BTO instalment: =PMT(2.6%/12, 300, -337500).

---

What you paid, **minus what you own**

| Ten years, flat prices | BTO | Resale | |---|---|---| | Paid out | S$346,042 | S$425,738 | | Owned, year 10 | S$174,754 | S$306,714 | | Net cost | S$171,288 | S$119,024 |

Paid out: downpayment, stamp duty, rent, instalments. Owned: price minus loan left, =FV(2.6%/12, 72, 1531.13, -337500) for the BTO.

---

Prices won't stay flat. **Test the gap.**

[[big S$52,264 | how far the resale's year-ten value must fall, about 8%, before the BTO wins]]

Nobody knows year-ten prices. HDB sets BTO prices below nearby resale flats, so try a higher BTO value as well.

---

?? A valuer reckons the resale will be worth S$580,000 in year ten. At flat prices it was S$52,264 cheaper. Which home wins? The BTO, by S$40,000 + The resale, still cheaper by S$12,264 Neither, S$40,000 is too close to call => A S$40,000 drop is smaller than the S$52,264 gap. The resale's net cost rises to S$159,024, which is still under the BTO's S$171,288.

---

When can each one be sold?

[[flow BTO keys, end of year 4 | 5-year MOP from keys | Free to sell in year 10]]

Resale keys come in month 3, so it's free to sell from year 6. A Plus or Prime BTO: 10-year MOP.

---

Write one line under it

Write down which one you'd pick today and the number that would change your mind.

For example: the resale, unless it's valued well under the asking price.

For two homes you're weighing, work out each one's ten-year net cost in a spreadsheet: everything paid, minus the price less the loan left. Then write which you'd pick today.

Calculators for this lesson

Course

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