PLAN60191 Chap.5 Mortgage Cash Flows and Underwriting
Mortgage Cash Flows and Underwriting
Mortgage Cash Flows and Underwriting separates the payment from its interest and principal components. A constant-payment amortising loan keeps the payment level while interest falls and principal repayment rises as the balance declines. An interest-only loan keeps principal outstanding until maturity, creating a different terminal and refinancing exposure.
Monthly payments require a monthly rate and payment count, and the annual pro forma must reconcile to that schedule. Equity analysis subtracts debt service and the terminal balance; lender analysis tests property income coverage and collateral value through ratios such as DSCR and LTV.
The chapter uses base and downside cases because coverage and collateral can weaken simultaneously even when the contractual payment is unchanged.
What this chapter covers
- 01
Payment timing
- 02
Amortisation
- 03
Interest-only loans
- 04
Debt service
- 05
DSCR and debt yield
- 06
LTV and refinancing
Worked example · free
Build the first mortgage period
- 2Monthly rate is 0.5% and the schedule contains 240 payments.
- 3Monthly payment is £25,791.52 and annual debt service is £309,498.22.
- 3Month 1 interest is £18,000, principal is £7,791.52 and closing balance is £3,592,208.48.
Key terms
- Amortisation
- The scheduled repayment of loan principal over the loan term.
- Debt service
- The contractual interest and principal cash payment due in a period.
- Coverage ratio
- A comparison of qualifying property income with scheduled debt service.
Mortgage Cash Flows and Underwriting FAQ
Why does the interest share fall over time?
Interest is calculated on the opening loan balance. Amortisation reduces that balance, so the next period's interest is lower and more of a constant payment repays principal. The payment can stay unchanged while its composition shifts.
What does DSCR show?
DSCR compares qualifying property income with scheduled debt service for the same period. A value above one means the stated income exceeds the scheduled payment under that convention. It does not guarantee repayment if income falls or refinancing fails.
Why test LTV and DSCR together?
DSCR addresses cash coverage, while LTV addresses collateral leverage. Income and value can deteriorate together. A loan may remain just covered while collateral protection becomes weak, so lender analysis needs both dimensions and a clear downside scenario.
Assessment move
Start with the contract terms: principal, rate convention, payment frequency, amortisation term, maturity and payment timing. Convert rate and period consistently before using a payment function. Build the first two schedule rows manually, then check the spreadsheet formula. Aggregate monthly payments to annual debt service and carry the correct outstanding balance into the exit year.
Compare the same principal under amortising and interest-only structures to see how annual cash flow and terminal debt differ. For lender analysis, define NOI and debt service before calculating DSCR, then calculate LTV from the current or stressed value stated. Apply a compound downside to both income and value. Connect the ratios to refinancing and covenant exposure, and connect the same structure to equity IRR.
Review errors under payment period, opening balance, principal sign, terminal balance and ratio denominator. Finish with one sentence explaining who benefits and who bears the risk created by the loan structure. Create a full monthly schedule with opening balance, interest, contractual payment, principal reduction and closing balance, then sum it to annual rows used by the property model.
Reconcile the closing balance independently with the remaining-term formula. Model interest-only, partially amortising and fully amortising loans on identical property cash flows so their timing effects are clear. Add fees, reserves and prepayment terms when comparing lender offers instead of comparing coupon rates alone.
For underwriting, construct a covenant table showing definition, threshold, base result, stressed result and cure mechanism. Stress NOI and property value separately before combining them, because DSCR and LTV respond through different channels. At maturity, test refinance proceeds using a new interest rate, amortisation period, lender DSCR and lender LTV; use the lower debt capacity.
Compare that capacity with the balloon balance to expose any equity funding gap. In the report, explain not only whether ratios pass today but also which assumption erodes the first layer of protection and what action remains available to borrower or lender. Build a separate loan-term checklist and verify that every model input matches the offer or facility document.
Reperform the first payment, the balance at maturity and one covenant ratio without spreadsheet functions. Where lender and borrower definitions differ, show both rather than silently choosing the more favourable result. Reconcile interest expense, cash debt service and principal outstanding.
Working through Mortgage Cash Flows and Underwriting in PLAN60191? Sia is AskSia’s AI Finance tutor — ask any PLAN60191 Mortgage Cash Flows and Underwriting question and get a clear, step-by-step explanation grounded in how PLAN60191 is taught and assessed. Read this chapter free, then take your hardest questions to Sia.