What does Lead Triage, Viewings and Mandates conclude, in numbers, about “The Arithmetic of the Debt Service Ratio: Annuity Instalments, Stress Tests and the Affordable Price”?

Answer: The instalment follows from the annuity formula, and the debt service ratio is all monthly repayments divided by monthly net income. The illustrative household has a ratio of 0.4654 at a rate of 0.040 over 35 years; mistaking gross income for the denominator understates it at 0.3723. The stress test shows that a higher income is not the same as safety: H4 crosses 0.70 after a rise of only 0.0023. When the calculation is inverted to find an affordable price, both the loan side and the cash side must be checked, and for many households the binding constraint is cash.

Scope of the numbers: The third needs boundaries: an exclusive mandate serves the owner only up to a commission rate of 0.0287 and a best term of 45 days in the illustrative model. Parameters are illustrative and every number comes from the book's programs.

中文版

Data table

The numbers below are printed verbatim by the chapter's Python program and can be reproduced by running it. standard-library Python onlyprinted values that match the answer: 0.040, 0.3723, 0.4654, 35

price 500,000LTV 0.90loan 450,000
net income 6,000/monthexisting debt 800/month
rateyearsinstalmenttotal interestDSR
0.035252,252.81225,8420.5088
0.035302,020.70277,4520.4701
0.035351,859.81331,1190.4433
0.040252,375.27262,5800.5292
0.040302,148.37323,4130.4914
0.040351,992.49386,8440.4654
0.045252,501.25300,3740.5502
0.045302,280.08370,8300.5133
0.045352,129.66444,4550.4883
35 vs 25 years at 0.040: instalment -382.78/month, interest +124,265
same debts on gross income 7,500: DSR 0.3723 (understated)
Show the full program
# Chapter 2. p21: the monthly instalment and the debt service ratio.
# Level-payment loan: M = L * r / (1 - (1 + r) ** -n), r = annual rate
# / 12, n = months. DSR = (all monthly debt payments) / (monthly net
# income). Every figure is an illustrative parameter: price, income,
# rates and tenures are not quotes from any bank, and each bank applies
# its own internal DSR ceiling and income recognition rules.
import math


def instalment(loan, annual_rate, years):
    r, n = annual_rate / 12.0, years * 12
    if r == 0:
        return loan / n
    return loan * r / (1.0 - (1.0 + r) ** (-n))


def dsr(new_payment, existing, net_income):
    return math.fsum([new_payment, existing]) / net_income


PRICE = 500000.0
LTV = 0.90
NET_INCOME = 6000.0      # monthly net income, after statutory deductions
EXISTING = 800.0         # car loan and card minimums per month

if __name__ == "__main__":
    loan = PRICE * LTV
    print("price {:,.0f}  LTV {:.2f}  loan {:,.0f}".format(
        PRICE, LTV, loan))
    print("net income {:,.0f}/month  existing debt {:,.0f}/month".format(
        NET_INCOME, EXISTING))
    print(" rate  years  instalment  total interest     DSR")
    for rate in (0.035, 0.040, 0.045):
        for years in (25, 30, 35):
            m = instalment(loan, rate, years)
            tot = m * years * 12 - loan
            print("{:5.3f}  {:5d}  {:10,.2f}  {:14,.0f}  {:6.4f}".format(
                rate, years, m, tot, dsr(m, EXISTING, NET_INCOME)))
    m35 = instalment(loan, 0.040, 35)
    m25 = instalment(loan, 0.040, 25)
    print("35 vs 25 years at 0.040: instalment -{:,.2f}/month, interest"
          " +{:,.0f}".format(m25 - m35,
                             (m35 * 420 - loan) - (m25 * 300 - loan)))
    gross = 7500.0
    print("same debts on gross income {:,.0f}: DSR {:.4f} (understated)"
          .format(gross, dsr(m35, EXISTING, gross)))

Single source and citation

Fan, Y. (2026). Three-Question Property Lead Qualification, Same-Day Multi-Viewing Closing Kinetics and Exclusive Landlord Mandates (Version 1.0.0), Chapter 2: The Arithmetic of the Debt Service Ratio: Annuity Instalments, Stress Tests and the Affordable Price. 5D Library. DOI pending

DOI pending · monograph page goes live after publication · 5DL-B-355 · v1.0.0 · CC-BY-NC-ND-4.0

BibTeX
@book{fan2026355,
  author    = {Fan, Yafu},
  title     = {Three-Question Property Lead Qualification, Same-Day Multi-Viewing Closing Kinetics and Exclusive Landlord Mandates},
  year      = {2026},
  publisher = {5D Library},
  edition   = {1.0.0},
  note      = {DOI pending}
}

Other chapter answers in this book