From Metrics to Models
Understanding individual metrics is necessary but not sufficient. A robust investment decision requires a financial model that combines all relevant inputs — purchase costs, financing, rental income, operating expenses, and eventual exit — into a single view of expected returns. Building even a simple property model forces precision: you cannot model what you have not defined.
The Basic Cash Flow Model
A rental property model starts with gross rental income and works down to net cash flow:
Gross Rental Income £14,400/yr (£1,200/month)
Less: Void allowance (8%) − £1,152
Less: Management fees (10%) − £1,344
Less: Maintenance reserve − £2,000
Less: Landlord insurance − £300
Less: Ground rent/service − £500 (if leasehold)
─────────────────────────────────────────
Net Operating Income (NOI) £9,104
Less: Mortgage interest − £6,500
─────────────────────────────────────────
Pre-tax net cash flow £2,604/yr (£217/month)
This model, built before purchase, reveals whether the investment generates positive cash flow and how sensitive that position is to changes in key assumptions.
Sensitivity Analysis
A well-built model tests sensitivity to key variables:
- What if voids increase to 15%? Net operating income falls by ~£1,000
- What if interest rates rise 1%? Mortgage cost increases by £1,500 on a £150,000 balance
- What if rents fall 10%? Gross income falls by £1,440
Sensitivity analysis reveals which variables matter most. In highly leveraged investments, interest rate sensitivity is often the most significant risk — a 2% rate increase can turn a cash-flow-positive position negative.
Modelling the Exit
Most property investment returns are generated on exit (sale), not just from annual cash flow. A full model includes an exit analysis over the intended holding period:
Projected sale proceeds = Purchase price × (1 + annual growth rate)^years Less: Selling costs (agent fees ~1–1.5%, legal costs, capital gains tax) Plus: Equity built through mortgage repayment Plus: Accumulated net cash flow
The resulting total return and IRR (Internal Rate of Return) provide a complete picture. IRR is particularly useful because it accounts for the time value of money — returns received earlier are more valuable than equivalent returns received later.
Common Modelling Errors
Omitting void allowances: assuming 100% occupancy consistently overstates income by 5–10%. Using gross yield as a proxy for returns: ignores financing costs, taxes, and capital expenditure timing. Underestimating transaction costs: stamp duty, legal fees, surveys, and mortgage arrangement fees can total 4–7% of purchase price and significantly affect early-year returns. Ignoring the mortgage repayment component: on a repayment mortgage, the equity build-up through principal reduction is part of total return and should be modelled explicitly.