calculate-loan

01 Loan payments

HDB Loan Calculation Formula: Monthly Repayment

Calculator No. 01-21618 · Updated · Formula and assumptions shown below

The calculator on this page is switched off while it is checked. The formula is below, and the worked example shows how to do the sum by hand.

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

The HDB loan calculation formula determines your monthly repayment for a Housing Development Board (HDB) flat in Singapore. You enter the loan amount, interest rate (currently 2.6% for HDB loans), and loan tenure, and the formula returns your fixed monthly payment and total interest paid over the loan’s life.

Formula

The formula used is the standard amortizing loan payment formula:

M = P × [r(1 + r)^n] / [(1 + r)^n – 1]

Where:

  • M = monthly payment (in dollars)
  • P = principal loan amount (in dollars)
  • r = monthly interest rate = annual interest rate / 12 (as a decimal, e.g., 2.6% / 12 = 0.2167% per month)
  • n = total number of monthly payments = loan term in years × 12

This formula assumes a fixed interest rate over the entire loan tenure and equal monthly payments throughout. It is the same formula used for most mortgages and car loans worldwide.

Worked Example

Using the default values from the calculator above:

  • Loan amount (P) = $20,000
  • Annual interest rate = 2.6%
  • Loan term = 5 years

Step 1: Convert annual rate to monthly rate: r = 2.6 / 100 / 12 = 0.0021667

Step 2: Calculate total number of payments: n = 5 × 12 = 60

Step 3: Plug into the formula:

M = 20000 × [0.0021667 × (1.0021667)^60] / [(1.0021667)^60 – 1]

First compute (1.0021667)^60 ≈ 1.1387 (using a calculator).

Then M = 20000 × [0.0021667 × 1.1387] / [1.1387 – 1] = 20000 × [0.002467] / [0.1387] = 20000 × 0.01779 = 355.80

So the monthly payment is $355.80 (rounded to the nearest cent).

Total interest = (monthly payment × number of payments) – principal = (355.80 × 60) – 20000 = 21348 – 20000 = $1,348.

Assumptions

  • Fixed interest rate for the entire loan tenure (HDB loans currently have a fixed rate, but the calculator uses the input rate).
  • Monthly payments are made at the end of each month.
  • Interest is compounded monthly at the annual rate divided by 12.
  • The calculation does not include any administrative fees, late payment charges, or insurance premiums.
  • The loan amount is the actual amount borrowed from HDB, not the full flat price (which may include a downpayment).

When to Use This Formula

This formula is used whenever you want to estimate the monthly repayment for a new HDB loan, or for refinancing calculations if you are comparing a bank loan (which uses the same formula but with a different interest rate). It is also useful for planning your budget: you can input different loan amounts and tenures to see how your monthly payment changes.

HDB loans are available for purchasing new or resale flats, and the loan amount is typically up to 90% of the flat’s purchase price (or valuation, whichever is lower). The maximum loan tenure is 25 years for HDB loans, but the calculator allows up to 50 years for general use.

How to Choose Your Loan Amount and Tenure

When you apply for an HDB loan, you choose the loan amount and tenure. The longer the tenure, the lower your monthly payment, but the more total interest you pay over time. Conversely, a shorter tenure means higher monthly payments but less interest overall.

For example, on a $300,000 loan at 2.6% interest:

  • 25-year tenure: monthly payment ≈ $1,366, total interest ≈ $109,800
  • 15-year tenure: monthly payment ≈ $2,006, total interest ≈ $61,080

You can use the calculator above to try different tenures and see the trade-off. The choice depends on your monthly budget and how long you plan to stay in the flat. There is no universally “best” option—it depends on your personal financial situation.

Common Mistakes and Misconceptions

One common mistake is using the annual interest rate directly in the formula without dividing by 12. The formula requires the monthly rate, so always divide by 12.

Another mistake is forgetting to convert the loan term into months. If you enter 25 years directly as ‘n’, you will get a wildly incorrect result. Always multiply years by 12.

A common misconception is that the HDB interest rate is fixed forever. In reality, HDB loans have a fixed rate at the time of the loan, but that rate can be revised by HDB (though it has remained at 2.6% for many years). The formula assumes a constant rate for the entire tenure, which is true for the initial loan but may change if HDB revises its rate.

Also, note that the formula gives the payment for a fully amortizing loan—meaning the loan is fully paid off at the end of the tenure. It does not account for any lump-sum payments or early repayment, which would reduce the total interest.

Limitations of the Formula

This formula is accurate for fixed-rate, fully amortizing loans. It does not apply to loans with variable rates (like some bank loans) or interest-only loans. For HDB loans, the rate is fixed at the start, so the formula works well for the initial loan period.

The formula also assumes that payments are made on time and that there are no additional fees. In reality, HDB may charge a late payment fee if you miss a payment, and there may be administrative fees when taking the loan. These are not included in the calculation.

Finally, the formula does not take into account any grants or subsidies you might receive from the government, which could reduce your loan amount. Always use the actual loan amount after grants are applied.

Frequently Asked Questions

What is the current HDB interest rate?

The HDB concessionary interest rate is 2.6% per annum, and it has been so for many years. However, this rate is not guaranteed forever—HDB can revise it, so always check the latest rate on the HDB website or with HDB directly.

Can I use this formula for a bank loan?

Yes, the formula is the same for any fixed-rate amortizing loan, including bank housing loans. Just enter the bank’s interest rate (which may be variable, so the formula gives an estimate based on the current rate) and the loan amount and tenure.

How long can my HDB loan tenure be?

For HDB loans, the maximum tenure is 25 years. However, the actual tenure you can get depends on your age and the remaining lease of the flat. For example, if you are 40 years old, the maximum tenure is typically 25 years, but it may be shorter if the flat’s lease ends before you turn 65.

Does the HDB loan amount include the downpayment?

No, the loan amount is the amount you borrow from HDB, which can be up to 90% of the purchase price (or valuation, whichever is lower). You pay the remaining 10% as a downpayment, which can be paid using CPF savings or cash.

What happens if I make extra payments?

If you make a lump-sum payment or increase your monthly payment, you will pay off the loan faster and reduce the total interest. The formula above does not account for extra payments, but you can use a separate calculator that includes extra payments to see the impact.

Is the HDB loan better than a bank loan?

That depends on your personal circumstances. HDB loans have a fixed rate and are generally more flexible (e.g., you can make partial repayments without penalty), but bank loans may offer lower rates in certain market conditions. You should compare the rates, fees, and terms before deciding. This page does not recommend one over the other.

Remember, this calculation is an estimate. For the exact figures, refer to the loan disclosure provided by HDB or your bank.

Related

Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 2.6 | 0.01 | 100
in yrs | Loan term | years | 5 | 0.0833 | 50
out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.

More in this section

The whole Loan payments section →