Buy to Let ROI Calculator Google Sheets, Rental Yield & Cash Flow Spreadsheet with Stress Test, Deal Comparison & Cash-on-Cash Return

🏘️ Gross yield is the number everyone quotes and the one that tells you least. It ignores your mortgage, your fees and the cash you actually put in — two properties on the same yield can return 3% and 9% on your money. This works out the number that ranks deals: cash-on-cash ROI. Type the price, the deposit and the expected rent; it handles buying costs, agent fees, maintenance, voids, insurance and mortgage interest, then gives a BUY or REVIEW verdict against your own target. Then it stress-tests it. Rate up two points, voids up to eight weeks — the deals still standing are the real ones. 📊 WHAT'S INSIDE (5 tabs) • Dashboard — best ROI, average gross yield, total cash in, monthly cash flow, deals passing, stress survivors, annual profit and health gauges • Deal Calculator — twelve properties side by side: cash in, gross yield, running costs, mortgage interest, monthly cash flow, ROI and verdict • Stress Test — same deals at a higher rate and longer voids, with a survives YES/NO and the cash-flow swing • Assumptions — rate, buying costs, agent fee, maintenance, void weeks, insurance and your target ROI • Start Here — set up in five minutes ⚙️ HOW IT WORKS 1. Open your link and click "Make a copy" 2. Set your assumptions once — rate, fees, voids, target ROI 3. Type each property: price, deposit %, refurb, expected monthly rent 4. Read ROI and the verdict, then check the stress test before you offer 🏷️ PERFECT FOR • First-time buy-to-let buyers working out if the numbers stack up • Landlords comparing several properties before making an offer • Anyone who has been quoted a yield and wants the real return • Pairs with our Landlord Rental Property Tracker — this one decides, that one records 💻 FORMAT & ACCESS • Made for Google Sheets — works on phone, tablet & desktop • Nothing to install, no software fees — just a free Google account • Delivered as a private "Make a Copy" link — one click and it's yours • Your copy is 100% private and fully editable, forever ⚡ INSTANT ACCESS — Your template link is available immediately after purchase. No physical item will be shipped. 📌 A modelling and organisation tool only — not financial, mortgage, tax or investment advice. All figures are estimates based on the assumptions you enter. Always take professional advice before buying. This is a digital product; all sales are final.