The University of Manchester · FACULTY OF FINANCE

PLAN60191 Chap.5 Mortgage Cash Flows and Underwriting

- one subject, every graph, every model, every mark
6 Chapters3-page Bible
Our own words - no uploaded lecturer files
Updated for this semester
Chapter 5 of 10 · PLAN60191

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.

In this chapter

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

Q [8 marks]. A £3.6 million loan charges 6% nominal interest, amortises over 20 years and pays monthly in arrears. Find payment and Month 1 balance. The marks shown are for checking the method and are not an official University marking scheme.
The solid curve shows principal declining through amortisation, while the dashed interest-only balance remains unchanged until the maturity payment creates a laThe solid curve shows principal declining through amortisation, while the dashed interest-only balance remains unchanged until the maturity payment creates a larger refinancing requirement. loan balanceloan termamortisinginterest-onlystartmaturity
The solid curve shows principal declining through amortisation, while the dashed interest-only balance remains unchanged until the maturity payment creates a larger refinancing requirement.
  • 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.
The first payment is £25,791.52 and the first closing balance is £3,592,208.48. Practice marks are original.
Sia tip — Calculate each period's interest from the opening balance, not the original loan.
Glossary

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.
FAQ

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.

Study strategy

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.

A+Everything unlocked
Unlocks this Bible + all 41 of your subjects at The University of Manchester, plus 1,000+ more Bibles across the AskSia library.
Sia - your PLAN60191 tutor, unlimited, worked the way the exam marks it
The full 3-page Bible + practice bank with worked solutions
Chrome extension - sync your LMS so Sia knows your deadlines
Bilingual EN / Chinese on every Bible and every Sia answer
$0.99 Trial
30-day money-back · cancel in one tap · how it works