This bed and breakfast business plan revenue projection is the first step in starting a b&b business plan or an Airbnb business plan. The template provides a quick and easy method to estimate revenue generated by an bed and breakfast business for the next 5 years.
To use the bed and breakfast revenue projection template, input the number of rooms in the bed and breakfast accommodation, followed by the number of days the accommodation is open for each of the high, medium, and low seasons, this will set the maximum number of room nights available for the year.
By entering an occupancy percentage for each of the seasons, the template calculates the chargeable room nights. The chargeable room nights figure is then multiplied by the average room rate for the season to give the total room revenue for the year.
To give a complete revenue projection for the five year period the template provides extra sundry revenue lines. Two of the extra lines use a percentage of room revenue as a base for the calculation. Management information such as the average daily income, occupancy and room rate are also provided.
Bed and Breakfast Business Plan Revenue Projection Download
The bed and breakfast business plan revenue projection template is available for download in Excel format by following the link below.
The revenue forecast from this template is a useful starting point for our Financial Projections Template. The financial projections of course form part of the business plan required to start a bed and breakfast business.
If you do spot a mistake in the bed and breakfast business plan revenue projection template, please let us know and we will try to fix it.
About the Author
Chartered accountant Michael Brown is the founder and CEO of Plan Projections. He has worked as an accountant and consultant for more than 25 years and has built financial models for all types of industries. He has been the CFO or controller of both small and medium sized companies and has run small businesses of his own. He has been a manager and an auditor with Deloitte, a big 4 accountancy firm, and holds a degree from Loughborough University.