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,000 | LTV 0.90 | loan 450,000 | ||
| net income 6,000/month | existing debt 800/month | |||
| rate | years | instalment | total interest | DSR |
| 0.035 | 25 | 2,252.81 | 225,842 | 0.5088 |
| 0.035 | 30 | 2,020.70 | 277,452 | 0.4701 |
| 0.035 | 35 | 1,859.81 | 331,119 | 0.4433 |
| 0.040 | 25 | 2,375.27 | 262,580 | 0.5292 |
| 0.040 | 30 | 2,148.37 | 323,413 | 0.4914 |
| 0.040 | 35 | 1,992.49 | 386,844 | 0.4654 |
| 0.045 | 25 | 2,501.25 | 300,374 | 0.5502 |
| 0.045 | 30 | 2,280.08 | 370,830 | 0.5133 |
| 0.045 | 35 | 2,129.66 | 444,455 | 0.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
- Chapter 1 · The Information Value of Three Questions: Question Count, Completion and the Stopping Point
- Chapter 3 · The Cash Threshold: Stamp Duty Bands, Transaction Costs and a Combined Three-Question Score
- Chapter 4 · The Same-Day Viewing: Routes under Time Windows, the Weight of the Anchor and How Many Units to See
- Chapter 5 · Bounding the Decoy Effect: an Effect that May Be Positive or Negative, Choice Overload and Compliant Progress to a Close
- Chapter 6 · Exclusive Mandates: Agent Effort, the Owner's Net Price and Bargaining for an Owner in a Hurry
- Chapter 7 · Classical Sources East and West: the Market-Certificate Office of the Rites of Zhou and Cicero on the Seller's Disclosure
- Chapter 8 · The Empirical Loop and the Pricing and Closing Tool Specification: Ledger, Rhythm, Comparator and Pre-Registered Tests