US & UK Buy-and-Hold Spreadsheet + Guide.

Find out in minutes whether a rental property is worth buying, in the US or the UK. Enter a property’s price, rent and costs. The Stonefold Rental Deal Analyzer shows how much cash you need, what the property earns, whether a lender is likely to lend, and how the deal holds up if things go wrong. One switch changes the whole sheet between US and UK terms, taxes and lending rules. What you get A Google Sheet with five tabs: Start Here, Deal Analyzer, Projection, Assumptions and Examples. A 21-page PDF guide explaining every input and result. A full US example and a full UK example to load and explore. What the sheet does Calculates total cash needed, including UK Stamp Duty (additional-property rates) or US closing costs. Shows cash flow, yields, return on cash invested and break-even occupancy. Applies the lender test that fits your market: DSCR in the US, rental cover in the UK. Gives a simplified income-tax estimate, including the UK Section 24 rules and US depreciation. Projects 10 years of rent growth, loan paydown and sale proceeds, with IRR and equity multiple. Gives a green, amber or red verdict against the return you set. How it works Make your own copy of the sheet. Enter your deal, or load an example. Read the verdict, then stress it. The guide shows how to test higher interest rates, lower rent and more vacancy. Who it’s for Landlords and investors in the US or UK who are weighing a buy-and-hold residential rental. Who it isn’t for Flippers, wholesalers, short-let operators, or anyone buying multi-unit or commercial property. What it does not cover The Stamp Duty calculation covers England and Northern Ireland only, not Scotland or Wales. It does not model the higher flat rate for companies buying expensive homes, US state and local taxes, capital gains tax, or depreciation recapture. It is built for single buy-and-hold residential rentals, not flips, short lets, refinancing, multi-unit buildings or commercial property. Tax estimates are simplified. Please note This is an educational calculation tool, not financial, tax, investment or legal advice. Results depend on the numbers you enter. Tax rates on the Assumptions tab are starting values that change over time, so check them against official sources before relying on a result. The worked examples use invented figures. Requirements A free Google account.