Free download

Free buy-to-let deal spreadsheet

An Excel file with working formulas. Rules as checked on 10 October 2026.

The short answer. This is a free .xlsx spreadsheet that works out stamp duty, the cash you need, monthly cash flow, yields and whether the rent passes a lender's interest cover test for a buy-to-let. Change the yellow cells to your own figures. In the worked example, £200,000 at £1,100 a month gives £11,500 of stamp duty, a gross yield of 6.6% and cash flow of £118.50 a month.

Download the spreadsheet (.xlsx, 9 KB) No email and no account needed.

What is inside

  • Deal sheet. Three columns: a worked example and two blank columns for your own deals. Input cells are yellow with blue figures. Everything else is a formula.
  • Rules sheet. The stamp duty bands, the surcharges, the lender's stress rate and the interest cover pass marks, each in an editable cell, with the date they were last checked.
  • Read me sheet. How to use it, and what it leaves out.
The worked example, as the spreadsheet and the calculator both work it out
WhatResult
Purchase price£200,000
Monthly rent£1,100
Stamp duty (additional property, England and Northern Ireland)£11,500
Cash needed up front£64,500
Cash flow per month, before tax£118.50
Gross yield6.6%
Net yield4.84%
Cash-on-cash return2.2%
Interest cover at the lender's stress rate160% (145% needed): passes

The assumptions it starts with

These are the figures on the Rules sheet when you download it. They are editable, and they are dated 10 October 2026. England and Northern Ireland only.

Residential stamp duty bands (rules checked 10 October 2026)
Part of the priceStandard rateWith the additional property surcharge
£0 to £125,0000%5%
£125,000 to £250,0002%7%
£250,000 to £925,0005%10%
£925,000 to £1,500,00010%15%
Over £1,500,00012%17%
  • The additional property surcharge is 5%, and a non-UK resident pays a further 2% of the price. Both start at a price of £40,000.
  • The lender's stress rate starts at 5.5% a year, interest only. This is an assumption, not a rule: each lender chooses its own.
  • The interest cover pass mark starts at 125% for a basic-rate taxpayer or a company and 145% for a higher-rate taxpayer. Lenders vary.

What it leaves out

It is a quick deal check, not a full model. It does not work out tax on your profit (including the Section 24 limit on mortgage interest), a repayment mortgage, refurbishment, company purchases that do not run a rental business, or buying six or more homes at once. Scotland and Wales have their own taxes. For those, use the buy-to-let calculator and the Section 24 calculator, which are free to use.

Questions and answers

Is the spreadsheet free?

Yes. Download it and use it as often as you like. You do not need to give an email address or create an account.

Does it work in Excel, Numbers and Google Sheets?

It is a standard .xlsx file with ordinary formulas, so it opens in Excel, Apple Numbers and Google Sheets. It was checked by working every formula in the file and comparing the answers with the Deal Analyser calculator.

How do I change the stamp duty rates?

They are in yellow cells on the Rules sheet, with the date they were last checked (10 October 2026). Change a rate there and every deal on the Deal sheet follows.

What does it leave out?

Tax on your profit, a repayment mortgage, refurbishment costs, company purchases that do not run a rental business, buying six or more homes at once, and Scotland and Wales. The free calculators cover more of these.

How accurate is it?

It is an estimate. It gives the same answers as the Deal Analyser calculator for the same figures, but the figures you enter are your own assumptions, and lenders use their own stress rates and pass marks. It is not financial, tax or legal advice.