Short Term Rental Portfolio 5 Year Financial Model: Dashboard, 3 Statements, Per Unit Drivers

Description
A fully linked five year financial model for a short term rental operator running up to three units, whether the units are owned or held on rental arbitrage. It answers the three questions an operator asks before signing anything: whether the next unit is worth it, how long the furnishing takes to pay back, and what a soft season does to cash. Revenue is built one line per unit, so each property carries its own nights booked per month, monthly growth, a nights ceiling that is really the occupancy limit, the nightly rate, and a direct cost percentage holding platform fees and per stay consumables. Cleaning fees collected sit on a fourth line with the cleaning cost as their direct cost, so the fee passes through honestly instead of flattering the margin. Because every unit is separate, a weak third unit is visible rather than hidden inside a portfolio average. Fifteen linked worksheets: Start Here, Dashboard, Inputs, Revenue, COGS, Payroll, Opex, CapEx, P&L, Cash Flow, Balance Sheet, Break even, Scenarios, Funding and Checks. Monthly across 60 months with annual summaries. Furnishing per unit as capital expenditure with a go live month and straight line depreciation. A cleaner, cohost and maintenance roster with start months. Rent, utilities, insurance, supplies and licences as real expense lines. A soft season stress test on a single scenario switch. Benchmarks beside your own numbers. A Checks tab proves the balance sheet balances every month. Excel 2016 or later and Google Sheets, no macros. Includes a one page quick start guide with a Google Sheets copy link.