UK Buy-to-Let Yield Calculator 2026/27

Know whether a UK buy-to-let deal stands up before you make an offer. Type the price, rent and mortgage, and see yield, monthly cashflow, purchase tax and an after-tax illustration on one dashboard.

Who it's for

UK landlords and first-time investors comparing properties in England, Northern Ireland, Scotland or Wales.

What you get

• Excel workbook: a blank copy for your own deals and a filled copy with two fictional worked examples.
• A copy prepared for Google Sheets.
• A branded Quick Start guide (PDF). You will be up and running in about ten minutes.

Features

• Gross yield, net yield, cash-on-cash return and break-even rent on one dashboard.
• 2026/27 purchase tax worked out for you, including higher rates for additional homes: Stamp Duty, LBTT with the Additional Dwelling Supplement, and LTT.
• Interest-rate and void stress tests, with a cashflow chart.
• After-tax cashflow illustration, including the Section 24 finance cost restriction.
• Own name versus limited company comparison, as an illustration with no recommendation.
• Every rate shows its official source and the date it was checked.

Good to know

• A planning tool, not financial, tax or legal advice. Figures checked against official sources on 11 November 2026. Confirm with the cited source or an adviser before you act.
• Current 2026-27 rules are the default. Announced changes are shown as optional illustrations only.
• Microsoft Excel (.xlsx, no macros). Google Sheets: import the .xlsx; most features work. Apple Numbers is not supported.
• Free updates for the 2026-27 tax year. If a file doesn't work as described, tell us within 14 days and we'll fix it or refund you.
• Questions: hello@ashlarledger.co.uk. Save £3.98 with the Landlord Starter Kit bundle (£36.99).

Shane Stanford trading as Ashlar Ledger.