Free Excel
HMO Room-by-Room Analyser
Individual room rents, voids, and portfolio cashflow — Excel
Analyse an HMO property room by room. Enter each room's rent, whether bills are included, and void allowance. Includes a running costs sheet and summary with net yield and monthly cashflow.
What's included
- ✓Room-by-room rent, bills, and void inputs
- ✓Annual gross and net income per room
- ✓Full annual running costs sheet (mortgage, licence, EICR, management)
- ✓Portfolio summary: net cashflow and yield
- ✓Up to 8 rooms (extensible)
- ✓Compatible with Excel 2016+ and Google Sheets
Download free with a 7-day trial
Create a free account to download this spreadsheet instantly. No card required — you also get full access to our SA deals, investment analysis, and R2SA deal feed.
Start free trial & download →Already have an account? Sign in to download