Mortgage Affordability Calculator
How much mortgage can you afford? Bring income, household spending, savings and purchase costs into one calculation.
Prepared and reviewed by the MMDAI Editorial Team on 16 October 2026 against FCA affordability guidance, HMRC SDLT guidance, Revenue Scotland LBTT guidance and Welsh LTT guidance. Educational estimates only; not personalised financial, legal or tax advice.
Household and purchase
Income screen = annual gross income × entered multiple
The monthly budget deducts living costs, continuing debts and owner costs from take-home pay. The model uses a capital-and-interest repayment mortgage; the multiple and rate uplift are editable assumptions.
At zero interest: payment = L ÷ n
L is the mortgage, i the annual rate divided by 1,200, and n the term in months. The higher-rate payment uses the same starting balance and full term, not a later refinance balance.
Required cash = deposit + purchase tax + entered upfront costs
The price ceiling satisfies both borrowing and cash limits at exactly the entered deposit percentage. A penny-down search respects jumps in purchase-tax relief. The model does not optimise how much of your savings to use as deposit.
Scotland: LBTT + ADS where applicable
Wales: LTT main or higher residential rates
First-time relief, additional-property treatment and SDLT non-residence use the selected facts. Eligibility, linked purchases, mixed use, trusts, companies, lease-rent NPV and unusual transactions require separate advice. Model price range: £1,000–£10,000,000.
Your mortgage budget
Check the highlighted inputs. Details below refer to the last valid scenario.
—
Property calculators in Excel
Explore MMDAI workbooks for property purchase costs, comparisons and investments.
Browse Excel calculatorsWhat limits your mortgage?
Income, monthly spending and purchase cash all need to work together.
Gross annual income sets the multiple screen. Monthly take-home pay sets the spending budget. Enter both; the calculator does not estimate your tax code or deductions.
Include regular living costs, debts and owner costs. A payment can fit an income multiple while leaving too little to live on.
Savings must cover more than the deposit. Purchase tax, legal fees, surveys and immediate works use cash too; the reserve stays outside the purchase.
The rate uplift is a planning choice. It tests the same loan and term at a higher rate, without pretending to reproduce every lender’s affordability policy.
The tax calculation follows the purchase nation and buyer treatment. Scotland and Wales have their own systems, not the England and Northern Ireland SDLT bands.
The ceiling uses exactly your deposit percentage and entered costs. Lender income acceptance, credit history, age, valuation and product availability can reduce real borrowing.