All-in-One R2R SA & HMO Financial Toolkit | Excel + Google Sheets | Accountant Approved

🚀 The Ultimate Toolkit for Rent-to-Rent Investors

Stop guessing — start analysing every deal with total confidence.

Built by an active R2R investor and specialist property accountant, this all-in-one toolkit gives you complete financial clarity on every Serviced Accommodation (SA) and House in Multiple Occupation (HMO) deal — before you sign a single lease or spend a penny.

Whether you are just starting out or already scaling a portfolio, this spreadsheet works for every level of experience. It is fully formatted, colour-coded, and packed with industry benchmarks, tips, and compliance guidance to ensure you make profitable, safe decisions every time.

✅ Instant Digital Download — Get access immediately after purchase

✅ Works in Microsoft Excel & Google Sheets — Use on desktop, tablet, or mobile

✅ Accountant Approved — Built on real market data and tested in live operations

✅ Updated: June 2026 — Includes latest regulations, thresholds, and best practices

📊 WHAT’S INSIDE (10 Essential Sheets)

1️⃣ START HERE — Onboarding Guide

• Simple colour key: 🟡 Gold = Enter data | ⚪ Grey = Auto-calculated | 🟢 Green = Good | 🔴 Red = Caution | 🔵 Blue = Expert tips
• 4-step quick start guide to get you analysing deals in 5 minutes
• Clear navigation to help you find exactly what you need

2️⃣ SA DEAL ANALYSER — Serviced Accommodation Model

• Full financial underwriting for R2SA deals
• 3 Scenario Modelling: Conservative | Base Case | Optimistic
• Calculate: ADR, Occupancy, RevPAR, Net Revenue, Operating Costs, Cash Flow, Annual Profit, ROI, Break-Even Occupancy
• Built-in benchmarks (e.g. aim for >£500/month cash flow, >50% ROI)
• Automatic DEAL VERDICT: PROCEED / CAUTION / DO NOT PROCEED

3️⃣ HMO DEAL ANALYSER — House in Multiple Occupation Model

• Room-by-room income breakdown with void rate calculations
• Full operating cost tracker including utilities, council tax, licencing, maintenance
• Key metrics: Gross Yield, Average Room Rent, Cash Flow, ROI
• Target-based verdict system to ensure every deal meets your profit goals

4️⃣ DEAL SCORECARD — Compare Multiple Investments

• Rate and compare up to 5 different deals side-by-side
• 8 weighted criteria including: Cash Flow, ROI, Location, Risk, Competition, Compliance
• Automatic weighted scoring & recommendation
• Perfect for choosing which property to pursue first

5️⃣ 12-MONTH CASH FLOW FORECAST

• Rolling monthly forecast for your entire portfolio
• Track income and costs month-by-month to spot seasonal dips or surpluses
• See cumulative balance to plan your finances confidently
• Essential for managing cash reserves and scaling

6️⃣ SETUP COST PLANNER

• 30+ line items covering every upfront cost: Deposits, legal fees, furniture, compliance, marketing, and more
• Separate budgets for SA vs HMO
• Auto-calculated 10% contingency buffer included
• Know exactly how much cash you need to start before you begin

7️⃣ PORTFOLIO TRACKER

• Central dashboard for all your active and pipeline properties
• Compare ROI, cash flow, and setup costs across every unit
• See total portfolio income, costs, and profit at a glance
• Add notes, status tags, and track performance over time

8️⃣ FORMULA GLOSSARY

• Plain English definitions of every single financial term used
• Learn exactly what each metric means, how it is calculated, and why it matters
• Includes benchmarks so you know what “good” looks like
• Perfect for beginners — read this first!

9️⃣ FREQUENTLY ASKED QUESTIONS

• Real answers to the most common R2R questions, written by an expert
• Covers: Occupancy targets, seasonality, VAT rules, 90-day rule, HMO licensing, tenant risks, tax, legal leases, and more
• Saves you hours of research and costly mistakes

🔟 DISCLAIMER & RESOURCES

• Full legal disclaimer & usage terms
• Direct links to official GOV.UK resources: Licensing, fire safety, tax, electrical safety, business rates, and more
• Compliance checklists to keep you operating legally

🎯 WHO IS THIS FOR?

✅ Beginners — Step-by-step guidance removes the confusion; start analysing deals today✅ Active Investors — Speed up your analysis and standardise your process✅ Portfolio Landlords — Track performance, forecast cash flow, and scale with confidence✅ SA / HMO Operators — Ensure every property meets strict profit and compliance standards

Built exclusively for UK Rent-to-Rent investors — all rules, benchmarks, and regulations are UK-specific.

💡 WHY CHOOSE THIS TOOLKIT?

Unlike generic spreadsheets, this was built by someone who actually does this and is a qualified specialist accountant.

• ❌ No guesswork
• ❌ No missing formulas
• ❌ No generic data
• ✅ Real-world tested
• ✅ Accountant-approved calculations
• ✅ Built-in safety margins and risk warnings

📥 WHAT YOU GET

• 1 x Complete All-in-One Toolkit File (Excel .xlsx format)
• Fully compatible with Google Sheets (just upload to Google Drive)
• Unlocked cells (only calculation areas are protected)
• All example data included so you know exactly how to use it

🛡️ LICENSE & GUARANTEE

License: Single-user license for personal/business use by the original purchaser only. Resale, sharing, or distribution is strictly prohibited.

Satisfaction: This toolkit is packed with value and built to work. While digital products are non-refundable, if you have any questions or need help getting started, message us directly — we are here to support you.

📌 READY TO START?

Stop wasting time on spreadsheets that don’t add up. Get the professional toolkit used by successful R2R investors today — and make sure every deal you sign is a profitable one.