Banking And Finance Mathematics | Mortgage, Housing Loan and Property Finance Mathematics

Mortgage and property-finance mathematics turns one large purchase into a system of downpayments, loan-to-value limits, monthly-rest interest, amortisation, total debt servicing, cash-flow affordability, refinancing, prepayment, property yield, cap rates, leverage, equity build-up and credit risk. The mathematics matters because a property can be affordable at purchase yet stressful later if interest rates rise, income falls, refinancing changes, maintenance costs increase or the borrower underestimates the true cost of debt.

For readers searching for mortgage mathematics, home loan formula, housing loan Singapore, monthly rest mortgage, loan-to-value LTV, total debt servicing ratio TDSR, mortgage servicing ratio MSR, mortgage amortisation, refinancing, mortgage prepayment, property finance, rental yield, cap rate, property leverage or real estate finance mathematics, the central object is the cash-flow timeline. Property price is only the beginning. The real model includes upfront equity, financing, taxes and fees, monthly instalments, interest/principal split, maintenance, insurance, rent, vacancies, sale proceeds and debt redemption.

Singapore’s MoneySense guidance updated in July 2026 emphasises affordability across upfront costs, ongoing expenses, TDSR, MSR and LTV constraints; its home-loan guide explains monthly-rest interest and how rate changes affect instalments. This flagship article builds those household-facing mechanics and then extends them into bank-side mortgage economics, rental-property cash flows, cap rates, debt-service coverage and refinancing. It is educational mathematics, not mortgage, legal, property or investment advice.

50-Second Router

• Property price: purchase price is not the same as cash required upfront or total lifetime cost.
• LTV: loan amount divided by property value under the applicable definition.
• Downpayment: equity contribution plus applicable cash/CPF/legal/tax requirements.
• Monthly rest: interest calculated on the declining outstanding mortgage balance each month.
• Instalment: level-payment mortgage amount determined by principal, periodic rate and remaining term.
• Interest/principal split: early payments contain more interest because balance is larger.
• TDSR: debt-service constraint comparing total monthly debt obligations with income under prevailing rules.
• MSR: mortgage-specific debt-service limit applicable to specified housing contexts in Singapore.
• Refinancing: replace existing mortgage with new terms; savings must be compared after penalties, fees and remaining tenure.
• Prepayment: reducing principal early lowers future interest but can trigger charges or liquidity trade-offs.
• Rental yield: annual rent relative to property price; net yield must deduct vacancies and costs.
• Cap rate: net operating income divided by property value, generally before financing costs.
• DSCR: property/business cash flow relative to debt service.
• Verification: reconstruct every monthly cash flow and check the final balance reaches zero at maturity.

The Central Proposition: Property Finance Is a Balance-Sheet and Cash-Flow Problem

A buyer who focuses only on property price sees one number. A lender sees collateral value, borrower income, leverage, monthly debt service, interest-rate sensitivity and recovery risk. An investor sees rent, operating costs, vacancy, financing, capital expenditure, taxes and eventual sale value. All three perspectives can be modelled from the same dated cash flows.

Mortgage mathematics is therefore not only a payment formula. It is a system linking household affordability, bank credit exposure and asset valuation. The same S$1 million property can be low-risk for a borrower with a large downpayment and high stable income, or highly leveraged for another borrower with minimal equity and tight monthly cash flow.

Adrian’s rule is to split the problem into three boxes: property value, loan cash flows, and borrower/investor cash flows. Confusion begins when these boxes are merged.

1. Purchase price

Purchase price is agreed transaction price for the property. It anchors financing and many costs but is not total economic cost. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. PropertyCost begins with purchase price plus transaction/setup costs. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. A lower sticker price can still carry higher renovation, maintenance or financing costs. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into affordability. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

2. Market value

Market value is estimated current market price of property. It may differ from transaction price and lender valuation. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. LTV denominator can depend on accepted valuation rules. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Assuming purchase price always equals bank valuation can overstate allowable loan. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into LTV. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

3. Bank valuation

Bank valuation is lender-approved property valuation for credit purposes. It can cap recognised collateral value. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Loan eligibility may use lower of price/value under applicable rules. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Borrower’s own valuation is not binding on lender. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into mortgage underwriting. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

4. Downpayment

Downpayment is buyer equity contributed at purchase. It reduces debt and LTV. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Downpayment=Price−Loan, before detailed fee treatment. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Downpayment does not include every upfront cost. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into property purchase. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

5. Loan-to-value ratio

Loan-to-value ratio is loan principal relative to recognised property value. It measures leverage against collateral. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. LTV=Loan/PropertyValue. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. LTV can rise even without borrowing more if property value falls. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into credit risk. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

6. Equity in property

Equity in property is property value minus outstanding mortgage and other secured claims. It is borrower residual ownership value. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Equity=MarketValue−MortgageBalance−OtherLiens. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Book/purchase equity can differ from current market equity. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into wealth. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

7. Negative equity

Negative equity is condition where outstanding secured debt exceeds property market value. It increases refinancing and default stress. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. NegativeEquity if Debt>PropertyValue. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. A borrower can continue paying despite negative equity; it is not automatic default. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into credit risk. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

8. Monthly-rest interest

Monthly-rest interest is interest calculated on outstanding principal each month. It is common in Singapore mortgage explanations. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Interest_t=Balance_{t-1}×monthly rate. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Applying interest to original principal every month would be flat-rate arithmetic, not monthly rest. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into mortgages. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

9. Periodic mortgage rate

Periodic mortgage rate is effective/nominal rate per payment period. It must match instalment frequency. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. i=j/12 for nominal annual rate convertible monthly in simple setup. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Dividing an effective annual rate by 12 is not generally exact. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into payment formula. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

10. Level-payment mortgage

Level-payment mortgage is mortgage with scheduled instalment held constant over a rate period. Principal/interest mix changes through time. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Payment=P i/(1−(1+i)^−n). Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. If rate resets, payment may change even with remaining balance schedule. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into amortisation. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

11. Amortisation

Amortisation is scheduled reduction of principal through repayments. It builds borrower equity as debt declines. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Balance recursion: B_t=B_{t-1}(1+i)−Payment. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Fees and prepayments alter schedule. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into mortgages. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

12. Interest component

Interest component is portion of payment compensating lender for outstanding balance. It declines in a fixed-rate level-payment loan as balance falls. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Interest_t=i×B_{t-1}. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Interest is not simply annual rate×original principal after amortisation. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into payment. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

13. Principal component

Principal component is portion of instalment reducing outstanding balance. It rises over time in standard fixed-rate level-payment loan. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Principal_t=Payment−Interest_t. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Principal repayment is not an expense in the same sense as interest for asset-return analysis. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into cash flow. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

14. Outstanding balance

Outstanding balance is remaining principal after scheduled/prepayments. It determines future interest and redemption amount. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. B_k=P(1+i)^k−Payment[(1+i)^k−1]/i. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Using original loan amount in refinancing comparison overstates payoff. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into loan balance. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

15. Remaining tenure

Remaining tenure is number of periods left until scheduled maturity. It influences payment and refinancing economics. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. n_remaining=maturity periods−elapsed periods. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Extending tenure lowers payment but usually raises total interest. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into affordability. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

16. Loan tenure

Loan tenure is contractual period over which mortgage is repaid. It trades monthly affordability against cumulative interest. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Longer n lowers payment at same rate/principal. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Long tenure can extend debt into retirement years. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into household finance. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

17. Effective interest rate

Effective interest rate is annualised cash-flow-equivalent borrowing cost. It improves comparison across fee/rate structures. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Solve IRR from net loan proceeds and repayments. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Advertised mortgage rate may not include all costs or promotional step changes. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into comparison. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

18. Promotional mortgage rate

Promotional mortgage rate is temporary introductory rate. It lowers initial payments but may reset upward later. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Model payment schedule period by period. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Comparing only promotional instalment understates later burden. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into mortgage packages. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

19. Fixed-rate mortgage

Fixed-rate mortgage is rate fixed for stated period. It provides payment certainty but may carry refinancing/prepayment trade-offs. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Payment fixed until reset/end of lock period. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Fixed for two years is not fixed for the entire 25-year mortgage. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into rate risk. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

20. Floating-rate mortgage

Floating-rate mortgage is rate linked to reference rate or bank-administered rate. Payments can rise/fall over time. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Rate_t=Reference_t+Spread under contract. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Borrower affordability should be stress-tested at higher rates. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into rate risk. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

21. SORA-linked mortgage

SORA-linked mortgage is mortgage linked to SORA or SORA-based reference plus spread. It transmits SGD market rate changes into payments according to contract. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Rate=Compounded/averaged SORA convention+spread. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Today’s SORA is not the whole future mortgage cost. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into Singapore mortgages. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

22. Board-rate mortgage

Board-rate mortgage is mortgage linked to lender-administered rate. It can reprice under contractual terms Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Customer rate=BoardReference+spread. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Reference-setting discretion requires reading terms carefully. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into mortgages. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

23. Lock-in period

Lock-in period is period during which refinancing/prepayment may trigger charges. It affects option value to borrower. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Prepayment cost depends on contract. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Low headline rate can be less flexible during lock-in. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into refinancing. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

24. Prepayment

Prepayment is extra principal repayment before scheduled maturity. It reduces future interest and debt duration. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. New balance=Old balance−Prepayment. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Opportunity cost of using cash/CPF and penalties should be considered. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into mortgages. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

25. Partial prepayment

Partial prepayment is lump-sum reduction without fully redeeming loan. It can lower instalment, shorten tenure or both depending on lender treatment. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Re-amortise remaining balance. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Savings depend on timing; earlier prepayment usually saves more interest. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into mortgages. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

26. Full redemption

Full redemption is complete repayment of mortgage. It ends contractual debt subject to fees/notice. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Payoff amount may include accrued interest/fees. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Outstanding balance is not always identical to settlement payoff quote. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into refinancing. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

27. Refinancing

Refinancing is replacing existing mortgage with a new loan. It can reduce rate or alter tenure/features. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. NPV savings compare new vs old cash flows net of fees/penalties. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Lower new rate can be uneconomic if remaining balance/tenure is small and fees high. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into mortgage strategy. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

28. Repricing

Repricing is changing package with same lender without full external refinancing. It can reduce transaction friction. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Compare all-in costs and terms. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Same bank does not guarantee zero fees or best economics. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into mortgages. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

29. Break-even refinancing horizon

Break-even refinancing horizon is time needed for monthly savings to recover upfront switching costs. It is a quick screening metric. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. BreakEvenMonths≈SwitchingCosts/MonthlySavings. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Payment savings can change after promotional period, so NPV is better. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into refinancing. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

30. Mortgage NPV comparison

Mortgage NPV comparison is present value comparison of remaining old-loan versus new-loan cash flows. It handles fees, rate paths and timing rigorously. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Choose discount framework and compare borrower cash flows. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Using only first-year savings can mis-rank packages. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into refinancing. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

31. Interest-rate stress

Interest-rate stress is higher-rate scenario used to test affordability. It reveals payment sensitivity. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Recalculate payment at stressed rate with remaining principal/term. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. A borrower comfortable at current rate may fail at reset rate. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into TDSR. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

32. Payment shock

Payment shock is increase in instalment when rate resets or promotion ends. It is borrower liquidity risk. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Shock=(NewPayment−OldPayment)/OldPayment. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Percentage rate change and percentage payment change are not the same. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into household risk. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

33. Debt service

Debt service is required loan repayments over a period. It links debt to income/cash flow. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. MonthlyDebtService=sum monthly obligations. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Debt principal and interest both matter for household affordability. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into TDSR. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

34. TDSR

TDSR is Total Debt Servicing Ratio used in Singapore affordability rules. It compares total monthly debt obligations with monthly income under prevailing regulatory definitions. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. TDSR=TotalMonthlyDebtObligations/GrossMonthlyIncome under simplified representation. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Actual regulatory rules include income haircuts/stress assumptions and should be checked currently. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into Singapore housing. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

35. MSR

MSR is Mortgage Servicing Ratio applying to specified housing loans. It focuses on housing instalment relative to income. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. MSR=MonthlyMortgagePayment/GrossMonthlyIncome under simplified lens. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. MSR applicability depends on property/loan type. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into Singapore housing. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

36. LTV limit

LTV limit is maximum loan relative to property value under applicable lending rules. It constrains leverage at origination/refinancing. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Loan≤LTV_limit×recognised value. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Limits vary by borrower loan count, tenure and policy; current rules govern. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into Singapore housing. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

37. Mortgage affordability

Mortgage affordability is capacity to meet upfront and recurring housing costs without undue strain. It goes beyond loan eligibility. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. CashFlowAfterHousing=Income−DebtService−PropertyCosts−LivingCosts. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Maximum eligible loan is not necessarily prudent personal loan size. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into household finance. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

38. Upfront property costs

Upfront property costs is downpayment, option/booking amounts, stamp duties, legal/valuation and other acquisition costs. They determine initial cash requirement. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. InitialCash=Downpayment+Taxes+Fees+Renovation less allowed financing sources. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Ignoring non-loan costs causes liquidity shortfall at completion. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into property buying. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

39. Stamp duty

Stamp duty is transaction tax on property purchase and, where applicable, additional buyer circumstances. It increases acquisition cost. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Duty follows statutory bands/rules. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Rates and additional duties are policy-specific and can change. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into Singapore property. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

40. Legal fee

Legal fee is conveyancing and mortgage documentation cost. It enters purchase/refinancing economics. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Include in initial/ refinancing NPV. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Small relative to property price can still affect refinancing break-even. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into property finance. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

41. Valuation fee

Valuation fee is cost of lender/property valuation. It can be required in financing. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Include in setup costs. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Fee may be waived/promotional but should not be assumed. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into mortgages. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

42. Renovation cost

Renovation cost is capital expenditure to prepare property for use. It is separate from property purchase price and loan economics. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Total invested equity includes renovation. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Renovation may not be recoverable in resale value. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into property investment. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

43. Maintenance fee

Maintenance fee is recurring property cost such as condominium maintenance. It reduces owner/investor cash flow. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. NetPropertyCashFlow=Rent−maintenance−tax−other costs−debt service. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Gross rental yield ignores these costs. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into property investment. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

44. Property tax

Property tax is recurring tax based on applicable property rules. It reduces net yield. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Net operating income subtracts tax under chosen definition. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Owner-occupied and non-owner rules can differ. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into Singapore property. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

45. Insurance

Insurance is property/mortgage insurance costs. It reduces net cash flow but protects specified risks. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Include premium in annual housing cost. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Insurance cover is not a substitute for affordability buffer. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into property risk. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

46. Vacancy

Vacancy is period without rental income. It reduces effective gross rent. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. EffectiveRent=ScheduledRent×OccupancyRate. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Assuming 100% occupancy overstates yield. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into rental property. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

47. Gross rental yield

Gross rental yield is annual gross rent divided by property value/purchase price. It is a simple income yield. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. GrossYield=AnnualRent/PropertyPrice. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. It ignores vacancy, expenses and financing. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into property investing. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

48. Net rental yield

Net rental yield is net property income after specified operating costs divided by property value/equity basis. It is more informative than gross yield. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. NetYield=NOI/PropertyValue under property-level definition. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Definitions vary on taxes/capex/management; state them. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into property investing. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

49. Net operating income

Net operating income is property income minus operating expenses before financing and income tax under common real-estate convention. It is the numerator of cap rate. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. NOI=EffectiveGrossIncome−OperatingExpenses. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Mortgage interest is usually excluded from NOI for cap-rate analysis. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into real estate. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

50. Capitalisation rate

Capitalisation rate is NOI divided by property value. It is a property-level yield independent of financing in standard form. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. CapRate=NOI/Value. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Cap rate is not mortgage interest rate or expected total return. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into property valuation. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

51. Value from cap rate

Value from cap rate is property value inferred from stabilised NOI and cap rate. It is a simple income-capitalisation model. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Value=NOI/CapRate. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Small cap-rate changes create large value changes; NOI sustainability matters. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into real estate valuation. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

52. Cap-rate compression

Cap-rate compression is decline in market cap rate. It raises value for unchanged NOI. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. V rises when cap rate falls. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Falling cap rate is not automatically improving cash flow. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into property markets. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

53. Cap-rate expansion

Cap-rate expansion is increase in cap rate. It lowers value for unchanged NOI. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. V falls as cap rate rises. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Higher rent growth can partly offset cap-rate expansion. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into property risk. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

54. Debt service coverage ratio

Debt service coverage ratio is NOI or defined cash flow divided by debt service. It measures property/business ability to service debt. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. DSCR=NOI/DebtService. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. For household mortgages TDSR/MSR are different concepts. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into commercial property. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

55. Interest coverage

Interest coverage is earnings/cash flow relative to interest expense. It isolates interest burden. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. ICR=NOI or EBIT/Interest depending context. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Principal amortisation still consumes cash even if ICR is high. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into property companies. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

56. Debt yield

Debt yield is NOI divided by loan balance. It measures property cash flow relative to lender exposure independent of interest rate. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. DebtYield=NOI/LoanAmount. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Debt yield is not borrower return. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into commercial real estate. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

57. Mortgage constant

Mortgage constant is annual debt service divided by original/current loan amount under a defined period. It converts debt into annual service burden. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Constant=AnnualDebtService/LoanAmount. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. It depends on rate and amortisation term. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into property finance. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

58. Balloon payment

Balloon payment is large principal amount due at maturity. It reduces interim debt service but creates refinancing risk. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. FinalPayment includes remaining principal. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. A property can be cash-flow positive yet face maturity default if refinancing unavailable. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into commercial property. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

59. Interest-only loan

Interest-only loan is loan paying interest without scheduled principal for a period. It lowers near-term debt service but leaves principal outstanding. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Payment≈P×rate during IO period. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Refinancing and final principal risk remain. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into property finance. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

60. Amortising loan

Amortising loan is loan reducing principal over time. It builds equity and lowers EAD. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Scheduled payment includes principal. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Higher amortisation increases near-term cash burden. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into mortgages. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

61. Refinancing risk

Refinancing risk is risk that borrower cannot obtain replacement financing at maturity/reset. It is especially important for balloons/commercial debt. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Stress new rate, LTV and lender appetite. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Strong property value today does not guarantee future refinancing. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into property credit. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

62. Property leverage

Property leverage is use of mortgage debt to increase exposure relative to equity. It magnifies equity return and loss. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. EquityReturn depends on property return relative to borrowing cost and leverage. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Leverage can create negative equity after modest property decline. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into investment. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

63. Levered equity return

Levered equity return is return to owner after debt costs. It can exceed property return when asset return exceeds debt cost. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. ROE_property=(NetCashFlow+ΔEquityValue)/InitialEquity. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Leverage magnifies downside too. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into property investing. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

64. Unlevered return

Unlevered return is property return before financing structure. It allows comparison independent of debt. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. UnleveredReturn=(NOI+ValueChange)/PropertyValue. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Mixing leveraged and unleveraged returns is misleading. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into real estate. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

65. Equity multiple

Equity multiple is total cash distributions/proceeds to equity divided by invested equity. It summarises cumulative return without time value. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. EquityMultiple=TotalEquityCashReceived/EquityInvested. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. It ignores timing; use IRR/NPV too. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into real estate. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

66. Property IRR

Property IRR is internal rate of return on equity cash flows. It accounts for timing of rent, capex, debt and sale proceeds. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Solve NPV=0 for equity cash flows. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. IRR can be distorted by leverage and multiple sign changes. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into real estate. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

67. Property NPV

Property NPV is present value of equity or unlevered property cash flows minus investment. It measures value relative to chosen discount rate. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. NPV=ΣCF_t/(1+r)^t−InitialOutlay. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Choice of discount rate and terminal value dominates long-horizon result. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into real estate. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

68. Terminal value

Terminal value is estimated sale value at end of forecast. It often dominates property DCF. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. TerminalValue=NOI_{t+1}/ExitCapRate in simple income model. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Small exit-cap assumptions can create huge value changes. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into property valuation. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

69. Exit cap rate

Exit cap rate is cap rate assumed at sale horizon. It converts future NOI into terminal value. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. TV=NOI_next/ExitCap. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Assuming exit cap equal entry cap without stress can be optimistic. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into real estate. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

70. Rent growth

Rent growth is growth in contractual/market rental income. It drives future NOI. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Rent_t=Rent_0(1+g)^t in simple model. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Rent growth can be negative and subject to vacancy/lease resets. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into property cash flow. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

71. Expense growth

Expense growth is growth in maintenance, tax, management and other costs. It determines NOI margin. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Expense_t=Expense_0(1+g_e)^t. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Assuming rent rises while costs stay fixed overstates NOI. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into property DCF. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

72. Capital expenditure

Capital expenditure is major spending to maintain/improve property. It can be lumpy and not included in NOI convention. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. FCF subtracts capex after NOI. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Ignoring capex overstates distributable cash flow. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into property investing. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

73. Tenant improvements

Tenant improvements is landlord spending to secure/retain tenants. It reduces net cash generation. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Deduct TI in leasing cash-flow model. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. High headline rent can require costly incentives. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into commercial property. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

74. Leasing commissions

Leasing commissions is fees paid to agents/brokers for leases. They reduce effective rent economics. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Deduct from cash flow. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. NOI may not include these depending convention. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into commercial property. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

75. Occupancy rate

Occupancy rate is leased/occupied area relative to available area. It drives effective rent. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. EffectiveGrossIncome≈PotentialRent×Occupancy adjusted for concessions. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Physical and economic occupancy can differ. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into property operations. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

76. Rental arrears

Rental arrears is rent due but unpaid. It creates credit risk in property income. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Cash rent differs from accrued rent. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. High occupancy with poor collections can still produce weak cash flow. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into property credit. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

77. Tenant concentration

Tenant concentration is dependence on a few tenants. It raises income volatility and lease-renewal risk. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. HHI of rent shares is one simple measure. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. 100% occupancy is not diversified if one tenant pays most rent. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into commercial property. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

78. Lease expiry profile

Lease expiry profile is schedule of rent contracts ending through time. It creates repricing/vacancy risk. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Rent roll by expiry year. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Average lease term can hide one-year expiry cliffs. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into commercial property. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

79. Weighted average lease expiry

Weighted average lease expiry is average remaining lease term weighted by rent/area. It measures income duration. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. WALE=Σw_iT_i. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Long WALE can mean stability but may lock below-market rent. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into commercial property. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

80. Property duration intuition

Property duration intuition is sensitivity of property value to discount/cap rates and cash-flow timing. Long-duration property cash flows can be rate-sensitive. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. DCF derivative with respect to discount rate. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Cap-rate and discount-rate changes interact with rent expectations. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into real estate risk. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

81. Mortgage duration

Mortgage duration is interest-rate sensitivity of mortgage cash flows. Prepayment creates negative convexity in many mortgage systems. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Effective duration from shocked prepayment/discount models. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Contractual maturity overstates duration when prepayment is likely. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into bank mortgage book. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

82. Prepayment incentive

Prepayment incentive is borrower benefit from refinancing when market rates fall. It changes lender cash-flow timing. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Incentive≈CurrentRate−MarketRefiRate adjusted for costs. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Borrowers differ in responsiveness and constraints. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into mortgage modelling. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

83. Prepayment hazard

Prepayment hazard is conditional probability of prepayment over a period. It produces expected mortgage cash flows. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Survival/CPR/SMM frameworks are common. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Constant prepayment assumptions can fail around rate shocks. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into mortgage modelling. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

84. Default hazard

Default hazard is conditional probability mortgage defaults. It depends on affordability, equity and macro conditions. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Default probability varies by borrower/property state. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Prepayment and default are competing risks. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into mortgage credit. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

85. Competing risks

Competing risks is multiple ways a mortgage can terminate, such as prepayment or default. They affect expected cash flows jointly. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Cause-specific hazards combine to survival. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Modelling prepayment independently of default can double count exits. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into mortgage analytics. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

86. Mortgage servicing

Mortgage servicing is collection/admin of payments, escrow and borrower support. It produces servicing fees/costs. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Servicing value depends on outstanding balance and loan life. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. High prepayment shortens servicing income. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into mortgage banking. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

87. Mortgage servicing right

Mortgage servicing right is asset representing expected future servicing cash flows. It often gains value when rates rise/prepayment slows. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. MSR value=PV(servicing fees−costs) over expected loan life. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. It can hedge some mortgage negative convexity but has its own model risk. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into mortgage banking. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

88. Securitisation

Securitisation is pooling mortgages and issuing securities backed by cash flows. It transforms mortgage funding and risk distribution. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Pool cash flows allocated through security structure. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Borrower loan math remains underneath securitisation. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into structured finance. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

89. Mortgage-backed security

Mortgage-backed security is security receiving mortgage pool principal/interest cash flows. It inherits prepayment/default timing risk. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Cash flow depends on pool factors and prepayments. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Yield-to-maturity alone can be misleading due to uncertain cash flows. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into fixed income. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

90. CPR

CPR is annualised conditional prepayment rate convention. It summarises mortgage prepayment speed. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. SMM=1−(1−CPR)^(1/12). Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. CPR is a convention/model input, not guaranteed borrower behaviour. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into MBS. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

91. SMM

SMM is single monthly mortality/prepayment rate. It converts CPR into monthly prepayment fraction. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. SMM=1−(1−CPR)^(1/12). Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Applying CPR directly monthly massively overstates prepayment. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into MBS. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

92. Loan payoff quote

Loan payoff quote is amount needed to fully discharge loan on a specified date. It includes principal plus accrued interest/fees and adjustments. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Payoff=OutstandingPrincipal+per-diem interest+fees−credits. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Statement balance may not equal payoff amount. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into mortgage operations. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

93. Per-diem interest

Per-diem interest is daily interest accrual between statement/payment dates. It affects payoff settlement. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. DailyInterest≈Balance×annual rate/day-count. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Day-count convention matters. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into loan payoff. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

94. Escrow

Escrow is account for taxes/insurance payments in some mortgage systems. It affects monthly payment but is not principal/interest. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Total payment=P&I+escrow. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Singapore mortgage structures may differ from US-style escrow arrangements. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into mortgage comparison. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

95. Debt-to-income

Debt-to-income is borrower debt service relative to income in general lending analysis. It is related to but not identical to Singapore TDSR/MSR rules. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. DTI=DebtPayments/Income. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Use jurisdiction-specific regulatory definitions where applicable. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into underwriting. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

96. Income stress

Income stress is scenario reducing borrower income. It increases debt-service ratio without changing loan rate. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. TDSR_stress=DebtService/LowerIncome. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Affordability should be robust to income shocks as well as rate shocks. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into household risk. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

97. Property-price stress

Property-price stress is scenario reducing collateral value. It raises LTV and LGD risk. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. StressedLTV=LoanBalance/StressedValue. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Payment capacity can remain intact while collateral buffer disappears. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into credit risk. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

98. Combined stress

Combined stress is higher mortgage rate plus lower income plus lower property value. It captures joint household/credit pressure. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Recalculate payment, TDSR and LTV simultaneously. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Single-factor stress understates correlation in downturns. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into stress testing. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

99. Liquidity reserve

Liquidity reserve is cash buffer held by homeowner/investor for instalments and expenses. It reduces forced-sale/refinancing risk. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. MonthsOfHousingCosts=LiquidSavings/MonthlyHousingOutflow. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. All spare cash used for downpayment can leave household fragile. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into personal finance. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

100. Opportunity cost of downpayment

Opportunity cost of downpayment is return/liquidity foregone by committing equity to property. It affects total economic decision. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Compare alternative use of funds at appropriate risk. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Larger downpayment reduces interest but ties up capital. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into household finance. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

101. CPF usage

CPF usage is use of Singapore CPF savings for eligible housing payments under prevailing rules. It changes cash source and retirement accumulation considerations. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Housing cash flow can be split between CPF and cash. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. CPF rules, accrued interest and limits should be checked currently. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into Singapore housing. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

102. Refinancing option value

Refinancing option value is borrower’s ability to refinance when rates fall. It is economically valuable to borrower and costly to lender. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Option value rises with rate volatility and prepayment freedom. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Lock-in/penalties reduce option value. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into mortgage pricing. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

103. Rate cap

Rate cap is contractual maximum on floating mortgage rate if present. It limits borrower rate risk. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Rate=min(reference+spread,cap). Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Caps have option value and may increase initial pricing. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into mortgages. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

104. Rate floor

Rate floor is minimum lender rate if present. It limits bank downside from falling reference rates. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Rate=max(reference+spread,floor). Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Floor can make ‘floating’ rate asymmetric. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into mortgages. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

105. Mortgage spread

Mortgage spread is customer rate above funding/reference curve. It covers bank funding, credit, liquidity, costs and capital. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Spread=MortgageRate−FTP/reference. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Spread is not pure profit. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into bank pricing. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

106. Mortgage RAROC

Mortgage RAROC is risk-adjusted return on capital for mortgage exposure. It evaluates profit relative to capital consumption. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. RAROC=(Revenue−Funding−Costs−EL)/Capital. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Low PD/LGD and collateral can reduce capital cost but not eliminate rate/prepayment risk. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into bank mortgage economics. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

107. Property cycle

Property cycle is multi-year movement in prices, rents, supply and credit. It affects LTV, default and valuation assumptions. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Scenario analysis links price/rent paths to cash flows. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Extrapolating recent appreciation indefinitely is dangerous. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into real estate risk. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

108. Affordability margin

Affordability margin is income/cash buffer after housing costs. It is a household resilience metric beyond regulatory eligibility. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. Margin=Income−DebtService−EssentialCosts. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. A loan can pass TDSR yet leave little discretionary cash. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into household resilience. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

109. Break-even rent

Break-even rent is rent needed for rental property cash inflows to cover operating and financing costs. It links occupancy and debt burden. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. BreakEvenRent=(OperatingCosts+DebtService−other income)/occupied months. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. Cash-flow break-even is not same as economic return break-even. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into property investing. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

110. Cash-on-cash return

Cash-on-cash return is annual pre-tax cash flow divided by actual equity invested. It measures current leveraged income yield. Property-finance mathematics becomes clearer when property value, loan balance and household/investor cash flow are kept as separate ledgers.

Mathematics. CoC=AnnualEquityCashFlow/EquityInvested. Match rate period to payment period, use the actual outstanding balance for interest, and distinguish regulatory affordability ratios from personal cash-flow affordability.

Failure mode. It ignores appreciation and time value. Jo’s diagnostic is to identify whether the error belongs to property value, debt mechanics, operating cash flow or policy constraint.

Connection. This feeds directly into property investing. Ryan would stress either rates, property value, rent or income and recalculate the whole system rather than changing one headline ratio in isolation.

Worked Example 1: Monthly Mortgage Payment

Borrow S$800,000 for 25 years at a nominal annual rate of 4.0% with monthly payments. Monthly rate i=0.04/12 and n=300. Payment=P i/[1−(1+i)^−n].

The formula produces the level instalment under a fixed-rate monthly-rest model. The first month’s interest is opening balance×i; principal reduction is payment minus interest. Repeat recursively.

Verification: after 300 payments, balance should be approximately zero subject to rounding.

Worked Example 2: Rate Shock

Keep outstanding balance and remaining tenure fixed but raise mortgage rate from 3% to 5%. Recalculate payment. The payment percentage change is not simply 2% because the annuity formula is nonlinear.

MoneySense’s 2026 home-loan guidance makes the same practical point: even modest rate changes can materially affect monthly instalments over large, long loans.

Affordability should therefore be tested at stressed rates, not only current promotional rates.

Worked Example 3: Prepayment

A borrower owes S$800,000 with 25 years remaining. A S$80,000 lump-sum prepayment immediately cuts principal to S$720,000. If rate and remaining term are unchanged, new payment can be recalculated from the lower balance.

Alternatively, the borrower may keep roughly the old payment and shorten tenure, usually saving more total interest. Exact lender treatment and penalties must be checked.

The value of prepayment is highest when made early because it removes principal from many future interest periods.

Worked Example 4: LTV Stress

Property value S$1.2m, mortgage S$840,000: LTV=70%. Property falls 20% to S$960,000 while balance is S$820,000 after some amortisation. Stressed LTV=85.42%.

Borrower equity shrinks from S$360,000 initially to S$140,000 despite principal repayment. Leverage magnifies the property-price loss on equity.

This is why collateral risk matters even when instalments are current.

Worked Example 5: Rental Yield and Cap Rate

Property value S$1.5m, annual gross rent S$72,000: gross yield=4.8%. Assume vacancy and operating expenses reduce NOI to S$54,000. Cap rate=54,000/1,500,000=3.6%.

If market cap rate expands to 4.5% with unchanged NOI, income-capitalisation value falls to 54,000/0.045=S$1.2m.

A 90bp cap-rate change reduces value by S$300,000 in this simple model, illustrating long-duration property sensitivity.

Worked Example 6: DSCR

NOI S$180,000; annual mortgage debt service S$150,000. DSCR=1.20×. If rents fall 10% and expenses remain fixed such that NOI falls to S$155,000, DSCR becomes 1.033×.

A small additional shock can push cash flow below debt service even though property remains valuable.

Lenders therefore stress both income and debt cost.

Worked Example 7: Refinancing Break-Even

Existing mortgage payment S$4,500/month; new package S$4,250/month; switching cost S$6,000. Simple break-even=6,000/250=24 months.

If new low rate lasts only one year before resetting, the simple break-even is misleading. Full NPV over expected holding period is better.

Refinancing should compare remaining cash flows, not original loan rates.

Worked Example 8: Leveraged Equity Return

Buy S$1m property with S$300,000 equity and S$700,000 debt. Property rises 5% to S$1.05m before transaction costs and principal changes. Equity value increases from S$300,000 to S$350,000, a 16.67% gross equity gain before interest/costs.

If property falls 5%, equity drops to S$250,000, a 16.67% loss. Leverage magnifies both directions.

Financing costs and amortisation alter realised equity return.

Worked Example 9: Property IRR

Initial equity outflow S$300,000. Annual after-debt cash flows S$10,000 for four years and final year cash flow S$360,000 including sale net equity. IRR solves NPV=0.

Compare IRR with an appropriate required return, but inspect the actual cash flows too. A high IRR can be created by leverage, optimistic terminal value or short holding period.

NPV remains the direct measure of value added at a chosen discount rate.

Worked Example 10: Combined Household Stress

Household gross monthly income S$16,000; total debts S$7,000 including mortgage S$5,000. If mortgage resets to S$6,000 and income falls to S$14,000, total debt service becomes S$8,000 and simple debt-service ratio rises from 43.75% to 57.14%.

At the same time a property-value decline can raise LTV. Cash-flow stress and collateral stress can reinforce one another.

This is why robust underwriting and household planning examine joint scenarios.

Mortgage Mathematics and Property Valuation Are Connected but Different

Mortgage mathematics values the debt cash flows: principal, interest, prepayment and refinancing. Property valuation estimates the asset value from comparable sales, income, replacement cost or DCF. The two interact through LTV and collateral but should not be confused.

A property can appreciate while a badly structured mortgage creates cash-flow stress. A mortgage can be comfortably affordable while property value falls. Lender risk depends on both payment capacity and collateral recovery.

Mira’s check is to ask whether the conclusion comes from the asset, the financing or the borrower. Each can move independently.

A Professional Property-Finance Workflow

1. Map purchase price, valuation and upfront costs.
2. Determine equity/downpayment and loan amount under applicable limits.
3. Convert quoted mortgage rate into monthly cash-flow convention.
4. Build complete amortisation schedule.
5. Stress payment under higher rates and lower income.
6. Track LTV as both debt balance and property value change.
7. For rental property, forecast rent, vacancy, operating costs and capex.
8. Separate NOI from financing cash flows.
9. Calculate DSCR, cap rate, cash-on-cash return, NPV and IRR with stated definitions.
10. Model prepayment/refinancing/balloon risks explicitly.
11. Stress exit cap rate and terminal value.
12. Reconcile household affordability, property economics and lender credit risk separately.

Common Failure Modes

1. Property price treated as total cost

Upfront taxes, fees, renovation and financing matter. The repair is to rebuild the property, debt and owner cash flows separately and reconnect them only through explicit equations.

2. Promotional mortgage rate treated as lifetime rate

Reset terms can dominate later payments. The repair is to rebuild the property, debt and owner cash flows separately and reconnect them only through explicit equations.

3. Monthly-rest and flat-rate arithmetic mixed

Outstanding balance differs from original principal. The repair is to rebuild the property, debt and owner cash flows separately and reconnect them only through explicit equations.

4. Maximum eligible loan treated as affordable loan

Regulatory eligibility is not personal cash-flow comfort. The repair is to rebuild the property, debt and owner cash flows separately and reconnect them only through explicit equations.

5. LTV treated as fixed

Property value and mortgage balance both change. The repair is to rebuild the property, debt and owner cash flows separately and reconnect them only through explicit equations.

6. Gross rental yield treated as return

Vacancy, costs, capex and financing reduce cash flow. The repair is to rebuild the property, debt and owner cash flows separately and reconnect them only through explicit equations.

7. Cap rate includes mortgage interest

Standard property NOI/cap-rate analysis is before financing. The repair is to rebuild the property, debt and owner cash flows separately and reconnect them only through explicit equations.

8. Refinancing judged by rate difference only

Fees, penalties, tenure and remaining balance matter. The repair is to rebuild the property, debt and owner cash flows separately and reconnect them only through explicit equations.

9. Prepayment always assumed optimal

Liquidity needs and alternative returns matter. The repair is to rebuild the property, debt and owner cash flows separately and reconnect them only through explicit equations.

10. Terminal value assumed precise

Exit cap rate and future NOI dominate DCF uncertainty. The repair is to rebuild the property, debt and owner cash flows separately and reconnect them only through explicit equations.

11. Contractual mortgage maturity used as expected life

Prepayment/refinancing can shorten life. The repair is to rebuild the property, debt and owner cash flows separately and reconnect them only through explicit equations.

12. Property appreciation assumed to offset debt risk

Price and cash-flow stress can occur simultaneously. The repair is to rebuild the property, debt and owner cash flows separately and reconnect them only through explicit equations.

Formula Map

Concept	Simplified formula	Meaning
Mortgage payment	P i/[1−(1+i)^−n]	Level monthly-rest instalment.
Interest	Opening balance×periodic rate	Period financing cost.
Principal repayment	Payment−Interest	Debt reduction.
LTV	Loan/Property value	Collateral leverage.
Gross rental yield	Annual rent/Property price	Pre-cost income yield.
Cap rate	NOI/Property value	Unlevered property income yield.
DSCR	NOI/Debt service	Cash-flow coverage of debt service.
Terminal value	Next-period NOI/Exit cap rate	Simple income-capitalisation exit value.

Authoritative Singapore Reference Map

• MoneySense — How Home Loans Work
• MoneySense — Buying a Property: How Much Can You Afford? (updated 1 July 2026)
• MoneySense — Costs of Borrowing: Flat Rate, Monthly Rest and EIR
• Monetary Authority of Singapore — current housing-loan and macroprudential rules

Connected Banking And Finance Mathematics Route

• Complete Banking And Finance Mathematics System
• Loans, Amortisation, Mortgages, Flat Rates and Effective Borrowing Cost
• Deposits and Loan Pricing Mathematics
• Credit Risk Mathematics
• Mortgage Prepayment Algorithms
• Finance & Banking Algorithms

Applied Case Study 1: First-home affordability

Situation. Household compares a smaller flat with a larger private property. The task is to distinguish property economics from debt mechanics and household cash flow.

Method. Build full upfront/ongoing cash-flow budget, then stress mortgage rate and income. Adrian maps purchase and loan cash flows, Jo checks rate convention and policy constraints, Aisha stresses income/property value, and Ryan compares NPV/affordability outcomes.

Boundary. Eligibility does not equal comfortable affordability. Mira then identifies which conclusion changes if property prices, rates or holding period move differently from the base case.

Applied Case Study 2: HDB versus bank-loan structure

Situation. Buyer compares different rate/reference and downpayment structures. The task is to distinguish property economics from debt mechanics and household cash flow.

Method. Normalise rate conventions, upfront equity and payment paths. Adrian maps purchase and loan cash flows, Jo checks rate convention and policy constraints, Aisha stresses income/property value, and Ryan compares NPV/affordability outcomes.

Boundary. Policy terms change; use current official rules. Mira then identifies which conclusion changes if property prices, rates or holding period move differently from the base case.

Applied Case Study 3: Fixed versus floating mortgage

Situation. Borrower chooses payment certainty versus rate sensitivity. The task is to distinguish property economics from debt mechanics and household cash flow.

Method. Model several future rate paths and refinancing/prepayment options. Adrian maps purchase and loan cash flows, Jo checks rate convention and policy constraints, Aisha stresses income/property value, and Ryan compares NPV/affordability outcomes.

Boundary. No one structure dominates for every borrower. Mira then identifies which conclusion changes if property prices, rates or holding period move differently from the base case.

Applied Case Study 4: Refinancing after lock-in

Situation. Borrower sees lower advertised rate. The task is to distinguish property economics from debt mechanics and household cash flow.

Method. Compare NPV of old/new remaining cash flows after fees and penalties. Adrian maps purchase and loan cash flows, Jo checks rate convention and policy constraints, Aisha stresses income/property value, and Ryan compares NPV/affordability outcomes.

Boundary. Headline spread saving can be too small to recover switching costs. Mira then identifies which conclusion changes if property prices, rates or holding period move differently from the base case.

Applied Case Study 5: Rental condominium

Situation. Investor forecasts rent and mortgage payments. The task is to distinguish property economics from debt mechanics and household cash flow.

Method. Build NOI, DSCR, after-debt cash flow and exit value. Adrian maps purchase and loan cash flows, Jo checks rate convention and policy constraints, Aisha stresses income/property value, and Ryan compares NPV/affordability outcomes.

Boundary. Gross yield alone hides vacancy, maintenance and leverage. Mira then identifies which conclusion changes if property prices, rates or holding period move differently from the base case.

Applied Case Study 6: Commercial property balloon loan

Situation. Property has stable NOI but large maturity payment. The task is to distinguish property economics from debt mechanics and household cash flow.

Method. Stress refinance rate/LTV and calculate DSCR plus balloon coverage. Adrian maps purchase and loan cash flows, Jo checks rate convention and policy constraints, Aisha stresses income/property value, and Ryan compares NPV/affordability outcomes.

Boundary. Cash-flow positive operations can still face maturity default. Mira then identifies which conclusion changes if property prices, rates or holding period move differently from the base case.

Applied Case Study 7: Property-price downturn

Situation. Value falls 25% while borrower keeps paying. The task is to distinguish property economics from debt mechanics and household cash flow.

Method. Track LTV and equity separately from affordability. Adrian maps purchase and loan cash flows, Jo checks rate convention and policy constraints, Aisha stresses income/property value, and Ryan compares NPV/affordability outcomes.

Boundary. Collateral stress can rise without payment delinquency. Mira then identifies which conclusion changes if property prices, rates or holding period move differently from the base case.

Applied Case Study 8: Income shock

Situation. Household income falls 20%. The task is to distinguish property economics from debt mechanics and household cash flow.

Method. Recompute debt-service ratio and liquidity runway. Adrian maps purchase and loan cash flows, Jo checks rate convention and policy constraints, Aisha stresses income/property value, and Ryan compares NPV/affordability outcomes.

Boundary. Loan rate need not move for affordability to deteriorate. Mira then identifies which conclusion changes if property prices, rates or holding period move differently from the base case.

Applied Case Study 9: Prepayment decision

Situation. Borrower has spare S$100,000. The task is to distinguish property economics from debt mechanics and household cash flow.

Method. Compare interest savings with liquidity/alternative-return opportunity cost. Adrian maps purchase and loan cash flows, Jo checks rate convention and policy constraints, Aisha stresses income/property value, and Ryan compares NPV/affordability outcomes.

Boundary. Prepayment is a capital-allocation choice, not automatically optimal. Mira then identifies which conclusion changes if property prices, rates or holding period move differently from the base case.

Applied Case Study 10: Interest-only investment loan

Situation. Low initial debt service supports cash flow. The task is to distinguish property economics from debt mechanics and household cash flow.

Method. Model unchanged principal and refinancing/balloon risk. Adrian maps purchase and loan cash flows, Jo checks rate convention and policy constraints, Aisha stresses income/property value, and Ryan compares NPV/affordability outcomes.

Boundary. Near-term cash flow can conceal future leverage risk. Mira then identifies which conclusion changes if property prices, rates or holding period move differently from the base case.

Applied Case Study 11: Mortgage bank portfolio

Situation. Bank owns many fixed-rate mortgages. The task is to distinguish property economics from debt mechanics and household cash flow.

Method. Model prepayment/default as competing risks and calculate duration/LGD. Adrian maps purchase and loan cash flows, Jo checks rate convention and policy constraints, Aisha stresses income/property value, and Ryan compares NPV/affordability outcomes.

Boundary. Borrower refinancing option creates lender negative convexity. Mira then identifies which conclusion changes if property prices, rates or holding period move differently from the base case.

Applied Case Study 12: MSR/TDSR policy stress

Situation. Borrower is near regulatory serviceability limits. The task is to distinguish property economics from debt mechanics and household cash flow.

Method. Recompute under prescribed/current stress rate and income definitions. Adrian maps purchase and loan cash flows, Jo checks rate convention and policy constraints, Aisha stresses income/property value, and Ryan compares NPV/affordability outcomes.

Boundary. Regulatory formulas must use current official implementation, not memory. Mira then identifies which conclusion changes if property prices, rates or holding period move differently from the base case.

Final Principle

Property finance is leverage applied to a long-lived, illiquid asset. The mortgage can make ownership affordable, but it also turns interest rates, income stability and property value into one connected household balance-sheet system.

The strongest analysis builds the mortgage from monthly cash flows, tests affordability at stressed rates, tracks LTV as debt and property value evolve, and evaluates property returns before and after financing separately.

For owner-occupiers, resilience matters more than maximising leverage. For investors, gross yield is only the starting point; NOI, debt service, capex, vacancy, terminal value and equity cash flows determine the real economics.

This page closes the mortgage/property-finance owner without replacing the existing detailed amortisation and bank mortgage-algorithm lanes.

Deep Practice Lab 1: Build a 30-year amortisation model

Create month-by-month opening balance, interest, payment, principal and closing balance. Verify final balance, then shock the rate after year 2 and re-amortise.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 2: Stress household affordability

Use base income, debts and mortgage. Apply rate +200bp, income −15%, and combined scenario. Recalculate monthly surplus and debt-service ratios.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 3: Compare refinancing packages

Model remaining old mortgage versus two new packages including legal fees, cashback clawback/penalties, promotional rates and later reset. Compare NPV over expected holding horizon.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 4: Build rental-property DCF

Forecast rent, vacancy, operating expenses, capex, debt service and sale proceeds. Calculate unlevered and levered IRR/NPV, then stress exit cap rate.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 5: Track LTV through a downturn

Project mortgage amortisation and three property-price paths. Calculate LTV and equity each year. Identify when leverage improves from debt paydown versus deteriorates from price decline.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 6: Build a 30-year amortisation model

Create month-by-month opening balance, interest, payment, principal and closing balance. Verify final balance, then shock the rate after year 2 and re-amortise.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 7: Stress household affordability

Use base income, debts and mortgage. Apply rate +200bp, income −15%, and combined scenario. Recalculate monthly surplus and debt-service ratios.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 8: Compare refinancing packages

Model remaining old mortgage versus two new packages including legal fees, cashback clawback/penalties, promotional rates and later reset. Compare NPV over expected holding horizon.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 9: Build rental-property DCF

Forecast rent, vacancy, operating expenses, capex, debt service and sale proceeds. Calculate unlevered and levered IRR/NPV, then stress exit cap rate.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 10: Track LTV through a downturn

Project mortgage amortisation and three property-price paths. Calculate LTV and equity each year. Identify when leverage improves from debt paydown versus deteriorates from price decline.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 11: Build a 30-year amortisation model

Create month-by-month opening balance, interest, payment, principal and closing balance. Verify final balance, then shock the rate after year 2 and re-amortise.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 12: Stress household affordability

Use base income, debts and mortgage. Apply rate +200bp, income −15%, and combined scenario. Recalculate monthly surplus and debt-service ratios.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 13: Compare refinancing packages

Model remaining old mortgage versus two new packages including legal fees, cashback clawback/penalties, promotional rates and later reset. Compare NPV over expected holding horizon.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 14: Build rental-property DCF

Forecast rent, vacancy, operating expenses, capex, debt service and sale proceeds. Calculate unlevered and levered IRR/NPV, then stress exit cap rate.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 15: Track LTV through a downturn

Project mortgage amortisation and three property-price paths. Calculate LTV and equity each year. Identify when leverage improves from debt paydown versus deteriorates from price decline.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 16: Build a 30-year amortisation model

Create month-by-month opening balance, interest, payment, principal and closing balance. Verify final balance, then shock the rate after year 2 and re-amortise.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 17: Stress household affordability

Use base income, debts and mortgage. Apply rate +200bp, income −15%, and combined scenario. Recalculate monthly surplus and debt-service ratios.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 18: Compare refinancing packages

Model remaining old mortgage versus two new packages including legal fees, cashback clawback/penalties, promotional rates and later reset. Compare NPV over expected holding horizon.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 19: Build rental-property DCF

Forecast rent, vacancy, operating expenses, capex, debt service and sale proceeds. Calculate unlevered and levered IRR/NPV, then stress exit cap rate.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 20: Track LTV through a downturn

Project mortgage amortisation and three property-price paths. Calculate LTV and equity each year. Identify when leverage improves from debt paydown versus deteriorates from price decline.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 21: Build a 30-year amortisation model

Create month-by-month opening balance, interest, payment, principal and closing balance. Verify final balance, then shock the rate after year 2 and re-amortise.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 22: Stress household affordability

Use base income, debts and mortgage. Apply rate +200bp, income −15%, and combined scenario. Recalculate monthly surplus and debt-service ratios.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 23: Compare refinancing packages

Model remaining old mortgage versus two new packages including legal fees, cashback clawback/penalties, promotional rates and later reset. Compare NPV over expected holding horizon.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 24: Build rental-property DCF

Forecast rent, vacancy, operating expenses, capex, debt service and sale proceeds. Calculate unlevered and levered IRR/NPV, then stress exit cap rate.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 25: Track LTV through a downturn

Project mortgage amortisation and three property-price paths. Calculate LTV and equity each year. Identify when leverage improves from debt paydown versus deteriorates from price decline.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 26: Build a 30-year amortisation model

Create month-by-month opening balance, interest, payment, principal and closing balance. Verify final balance, then shock the rate after year 2 and re-amortise.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 27: Stress household affordability

Use base income, debts and mortgage. Apply rate +200bp, income −15%, and combined scenario. Recalculate monthly surplus and debt-service ratios.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 28: Compare refinancing packages

Model remaining old mortgage versus two new packages including legal fees, cashback clawback/penalties, promotional rates and later reset. Compare NPV over expected holding horizon.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 29: Build rental-property DCF

Forecast rent, vacancy, operating expenses, capex, debt service and sale proceeds. Calculate unlevered and levered IRR/NPV, then stress exit cap rate.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 30: Track LTV through a downturn

Project mortgage amortisation and three property-price paths. Calculate LTV and equity each year. Identify when leverage improves from debt paydown versus deteriorates from price decline.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 31: Build a 30-year amortisation model

Create month-by-month opening balance, interest, payment, principal and closing balance. Verify final balance, then shock the rate after year 2 and re-amortise.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 32: Stress household affordability

Use base income, debts and mortgage. Apply rate +200bp, income −15%, and combined scenario. Recalculate monthly surplus and debt-service ratios.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 33: Compare refinancing packages

Model remaining old mortgage versus two new packages including legal fees, cashback clawback/penalties, promotional rates and later reset. Compare NPV over expected holding horizon.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 34: Build rental-property DCF

Forecast rent, vacancy, operating expenses, capex, debt service and sale proceeds. Calculate unlevered and levered IRR/NPV, then stress exit cap rate.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 35: Track LTV through a downturn

Project mortgage amortisation and three property-price paths. Calculate LTV and equity each year. Identify when leverage improves from debt paydown versus deteriorates from price decline.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 36: Build a 30-year amortisation model

Create month-by-month opening balance, interest, payment, principal and closing balance. Verify final balance, then shock the rate after year 2 and re-amortise.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 37: Stress household affordability

Use base income, debts and mortgage. Apply rate +200bp, income −15%, and combined scenario. Recalculate monthly surplus and debt-service ratios.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 38: Compare refinancing packages

Model remaining old mortgage versus two new packages including legal fees, cashback clawback/penalties, promotional rates and later reset. Compare NPV over expected holding horizon.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 39: Build rental-property DCF

Forecast rent, vacancy, operating expenses, capex, debt service and sale proceeds. Calculate unlevered and levered IRR/NPV, then stress exit cap rate.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 40: Track LTV through a downturn

Project mortgage amortisation and three property-price paths. Calculate LTV and equity each year. Identify when leverage improves from debt paydown versus deteriorates from price decline.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 41: Build a 30-year amortisation model

Create month-by-month opening balance, interest, payment, principal and closing balance. Verify final balance, then shock the rate after year 2 and re-amortise.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 42: Stress household affordability

Use base income, debts and mortgage. Apply rate +200bp, income −15%, and combined scenario. Recalculate monthly surplus and debt-service ratios.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 43: Compare refinancing packages

Model remaining old mortgage versus two new packages including legal fees, cashback clawback/penalties, promotional rates and later reset. Compare NPV over expected holding horizon.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 44: Build rental-property DCF

Forecast rent, vacancy, operating expenses, capex, debt service and sale proceeds. Calculate unlevered and levered IRR/NPV, then stress exit cap rate.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 45: Track LTV through a downturn

Project mortgage amortisation and three property-price paths. Calculate LTV and equity each year. Identify when leverage improves from debt paydown versus deteriorates from price decline.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 46: Build a 30-year amortisation model

Create month-by-month opening balance, interest, payment, principal and closing balance. Verify final balance, then shock the rate after year 2 and re-amortise.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 47: Stress household affordability

Use base income, debts and mortgage. Apply rate +200bp, income −15%, and combined scenario. Recalculate monthly surplus and debt-service ratios.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 48: Compare refinancing packages

Model remaining old mortgage versus two new packages including legal fees, cashback clawback/penalties, promotional rates and later reset. Compare NPV over expected holding horizon.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 49: Build rental-property DCF

Forecast rent, vacancy, operating expenses, capex, debt service and sale proceeds. Calculate unlevered and levered IRR/NPV, then stress exit cap rate.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 50: Track LTV through a downturn

Project mortgage amortisation and three property-price paths. Calculate LTV and equity each year. Identify when leverage improves from debt paydown versus deteriorates from price decline.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 51: Build a 30-year amortisation model

Create month-by-month opening balance, interest, payment, principal and closing balance. Verify final balance, then shock the rate after year 2 and re-amortise.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 52: Stress household affordability

Use base income, debts and mortgage. Apply rate +200bp, income −15%, and combined scenario. Recalculate monthly surplus and debt-service ratios.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 53: Compare refinancing packages

Model remaining old mortgage versus two new packages including legal fees, cashback clawback/penalties, promotional rates and later reset. Compare NPV over expected holding horizon.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 54: Build rental-property DCF

Forecast rent, vacancy, operating expenses, capex, debt service and sale proceeds. Calculate unlevered and levered IRR/NPV, then stress exit cap rate.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 55: Track LTV through a downturn

Project mortgage amortisation and three property-price paths. Calculate LTV and equity each year. Identify when leverage improves from debt paydown versus deteriorates from price decline.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 56: Build a 30-year amortisation model

Create month-by-month opening balance, interest, payment, principal and closing balance. Verify final balance, then shock the rate after year 2 and re-amortise.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.

Deep Practice Lab 57: Stress household affordability

Use base income, debts and mortgage. Apply rate +200bp, income −15%, and combined scenario. Recalculate monthly surplus and debt-service ratios.

Complete the lab with separate columns for property value, loan balance and owner equity. Ben should reconcile principal, Clara should record rate/policy assumptions, and Ethan should identify the scenario in which the borrower remains solvent but becomes cash-flow stressed.

Then change only one dimension—rate, income, rent, property value or exit cap—and record which ratio moves. This prevents a model from attributing every outcome to property price alone.