Free download
Free buy-to-let deal spreadsheet
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.
| What | Result |
|---|---|
| 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 yield | 6.6% |
| Net yield | 4.84% |
| Cash-on-cash return | 2.2% |
| Interest cover at the lender's stress rate | 160% (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.
| Part of the price | Standard rate | With the additional property surcharge |
|---|---|---|
| £0 to £125,000 | 0% | 5% |
| £125,000 to £250,000 | 2% | 7% |
| £250,000 to £925,000 | 5% | 10% |
| £925,000 to £1,500,000 | 10% | 15% |
| Over £1,500,000 | 12% | 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.