HMO Room-by-Room Analyser UK — Free Excel Download

HMO (House in Multiple Occupation) property investment offers some of the strongest cashflow returns available in UK property — but only when the numbers are modelled correctly. A whole-property gross yield figure tells you very little about whether an HMO will actually generate positive cashflow after all costs are accounted for. The room-by-room analyser breaks down the income and costs at the level that actually matters: individual room rents, room-specific void allowances, and the full list of HMO-specific running costs.

This spreadsheet supports up to eight rooms, each with its own monthly rent and void allowance. On the cost side, it covers all HMO-specific expenses: the annual HMO licence fee, gas safety certificate, EICR, fire alarm service, public liability and buildings insurance, a maintenance and repair allowance, management fees, broadband (if bills-included), and mortgage payments. The result is a true net cashflow figure — not the optimistic gross yield that is often used to market HMO investments.

Compatible with Microsoft Excel 2016+ and Google Sheets. All calculations are automatic — enter your room rents and costs, and the summary sheet shows your net yield, monthly cashflow, and cash-on-cash return instantly.

• Up to 8 individual rooms — each with monthly rent, room type (ensuite / shared bathroom), and void allowance in weeks per year
• Gross annual rent — total of all rooms across 52 weeks, less void allowance
• HMO licence fee — annual cost (typically £500–£1,500 for a 5-year licence amortised) — varies by council
• Gas Safety Certificate (CP12) — annual renewal cost from a Gas Safe registered engineer
• Electrical Installation Condition Report (EICR) — amortised annual cost of 5-yearly inspection
• Fire alarm servicing — annual maintenance contract for interlinked Grade D or LD1/LD2 system
• Buildings and contents insurance — HMO-specific policy (typically 20–50% more than standard BTL)
• Management fees — percentage of gross rent if using a letting agent (typically 10–15% for HMO)
• Maintenance allowance — percentage of gross rent (typically 8–12% for HMO, higher than standard BTL)
• Broadband and utilities — monthly cost if bills are included in room rent
• Mortgage or finance cost — monthly mortgage payment or bridging/development finance cost
• Net cashflow and net yield summary — monthly and annual cashflow, net yield on purchase price, cash-on-cash return on deposit

This tool is designed for any investor considering an HMO acquisition or conversion — whether you are buying a licensed HMO, converting a standard house, or reviewing your existing HMO portfolio's performance:

• Investors evaluating HMO acquisitions — model the specific room configuration and local rental rates for any target property before committing to a purchase price
• Investors converting standard BTL properties to HMO — compare projected HMO cashflow against the current BTL cashflow to assess whether the conversion costs and licensing burden are worthwhile
• Rent-to-rent HMO operators — model the room-by-room income against your guaranteed rent obligation to the landlord and all running costs, to verify the R2R deal is viable
• Deal sourcers packaging HMO deals — provide a clear, credible cashflow analysis to investor buyers as part of the deal package

HMO licensing requirements and fees vary significantly by local authority. Before investing in an HMO, check your specific council's licensing requirements, fees, and any Article 4 directions that may restrict the creation of new HMOs in your target area. This tool is for financial modelling purposes only and does not constitute legal or regulatory advice. PropertyAlert (Eightfinity Ltd) accepts no liability for any errors in your financial projections arising from use of this spreadsheet.

• HMO Yield Calculator — quick gross and net yield calculation for HMO properties
• Buy-to-Let Calculator — compare HMO returns against a standard single-let strategy