Short Let Income Forecast Spreadsheet
This short let income forecast turns editable assumptions into a transparent twelve month view of revenue, operating costs and owner cash flow. It includes conservative, base and strong scenarios so a promising figure can be tested rather than simply believed.
Free to download. Add your own details and branding, then check it against the way your property or business actually works.
Who it is for
Property owners, investors, companies and managers assessing whether a short let could work before they commit to a plan.
What is inside
- Editable monthly occupancy and nightly rate assumptions
- Platform fees, cleaning, management, maintenance and fixed costs
- A twelve month revenue and owner cash flow forecast
- Conservative, base and strong scenario comparison
- A summary dashboard and monthly trend chart
- Formula checks for the selected scenario and key totals
When to use it
- You are comparing a short let with another letting strategy
- A company or investor needs a clear income forecast with visible assumptions
- You want to test the effect of occupancy, pricing and costs before making a decision
Frequently asked questions
How do I forecast Airbnb or short let income?
Estimate available nights, monthly occupancy and average nightly rate, then add cleaning income and subtract platform fees, cleaning, management, maintenance and fixed property costs. The workbook keeps every assumption visible.
What occupancy and nightly rate should I use?
Use evidence for the property and the relevant months, not an annual market headline. Replace every blue example input and test the conservative scenario before relying on the result.
Can I use the spreadsheet in a company forecast or business plan?
Yes. Add the property and cost assumptions that apply to the company, then save the scenario and supporting evidence with the forecast. The workbook is editable and does not hide any calculation.
Does the spreadsheet guarantee the income shown?
No. It is a planning model, not a valuation or income guarantee. The result changes with the assumptions and excludes VAT, tax and capital expenditure unless you add them.
Download the Short Let Income Forecast Spreadsheet
Enter your details once and every template in the library unlocks.