HMO Analyser Excel Template | Room Income, Voids, Layouts, Setup Costs and Turnover

For landlords and investors looking at HMOs. It works out income room by room, allows for realistic voids and keeps licence dates in view. You can compare room layouts in pounds, budget the cost of converting a house and log tenant turnover. It gives you the numbers before you commit.

What it covers

• Room by room income with voids and licence dates
• Compare layouts, such as six small rooms against five larger ones
• Setup budget for turning a house into an HMO
• Turnover log to measure tenant churn
• Goals and targets with dates
• Weekly review to keep the numbers current

Who it is for

Suits HMO landlords, property investors, letting agents and anyone converting a house to shared accommodation.

What is inside

• How To Use and Quick Start guides, from download to working in ten minutes
• HMO Analyser
• Config Compare
• Setup Budget
• Turnover Log
• Notes and Actions, Log and Diary, Goals and Targets and Weekly Review tabs

How it works

Open the file in Microsoft Excel and read the How To Use tab first, it takes two minutes. White cells are yours to type in and blue tinted cells calculate themselves, so there are no formulas to write. The example rows show every feature working, overtype them with your own figures and the totals and charts update as you go.

What you get

• One editable Excel (.xlsx) workbook with 10 tabs
• Built for Microsoft Excel, no macros and no formulas for you to write
• Example rows included so you can see every feature working
• Commercial licence, use in your own business, not for resale
• Instant digital download, no physical item shipped

Small print

Template only. The names, jobs and figures shown in the product images and in the example rows are examples only, overtype them with your own. A planning and record keeping aid, not professional advice, so check big decisions with the relevant professional.