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.

What does the HMO room analyser cover?

  • 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

Who needs the HMO room analyser?

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

Download your free HMO room-by-room analyser

Get the free HMO room analyser

Download the full Excel HMO room-by-room cashflow analyser. Supports up to 8 rooms, all HMO-specific costs, and net yield summary. Free with a PropertyAlert.uk 7-day trial — no card required.

Get free HMO room analyser →

Free trial · No card required · Instant download

HMO Room Analyser FAQs

PropertyBrain Editorial Team — cost ranges reflect typical UK HMO running costs, not guaranteed figures for any specific property. Last verified: July 2026. This is not financial or legal advice.
How do you calculate HMO cashflow?

HMO cashflow is calculated by totalling annual rent across all rooms (net of void allowance), then deducting all running costs: mortgage or finance payments, insurance, HMO licence fee, gas safety certificate, EICR, maintenance allowance, management fees, council tax for voids, and broadband if bills are included. The resulting net annual cashflow divided by 12 gives monthly cashflow. Positive cashflow above £200–300 per month per property is typically considered the minimum threshold for an investable HMO.

What is a good net yield for an HMO?

A good net yield for an HMO in the UK is typically 8–12%, compared to 4–6% for a standard buy-to-let. HMOs command higher gross rents (room rates being higher than whole-property rents on a per-sqft basis), but also carry higher running costs including HMO licensing fees, higher insurance, more frequent maintenance, and management fees that can reach 12–15% of gross rent for a fully managed property. Net yield of 7%+ is generally considered strong.

Who pays the bills in an HMO?

In most HMO arrangements, the landlord is responsible for communal utilities (gas, electricity, water) and broadband, particularly in fully managed student or professional lets where bills are included in the room rent. However, individual tenants on assured shorthold tenancies in larger HMOs sometimes pay bills proportionally. The bills-included model simplifies tenant management and improves occupancy, but adds meaningful cost — typically £50–150 per room per month depending on property size and usage.

Important note

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.

Related tools