Hotel & Boutique Hotel Financial Model Excel – 5-Year Forecast, Occupancy, ADR, RevPAR, Cash Flow & Investor Deck

Financial Model, Hospitality, Hotel

5-year Financial Projections, Break-Even, Budget, Budgeting, Cash Flow Analysis, Cash Flow Projections, Dashboard, Debt Schedule, Excel, Financial Modeling, Financial Planning, Financial Projections, Financial Reporting, Forecast, Forecasting, Investor Cash Flows, Investor Presentations, Real Estate Valuation, Three Statement Model | Three Financial Statements

Integrated Hotel Financial Forecasting, Three-Statement Planning and Investment Analysis

Plan the financial performance of an independent hotel, boutique hotel or new hospitality project with a comprehensive, editable Excel financial model.

The Hotel & Boutique Hotel 5-Year Three-Statement Financial Model by SheetworksStudio connects property-specific operating assumptions with projected profitability, liquidity, capital investment and financing requirements.

Designed for hotel owners, operators, developers, financial analysts, consultants and management teams, this system supports structured business planning, investment discussions and ongoing financial reviews.

Instead of managing disconnected room revenue, staffing and operating expense spreadsheets, users can develop a coordinated financial forecast driven by occupancy, ADR, available room nights, guest services, departmental costs and funding assumptions.

1. Complete Product Package

The download includes three professional files:

Excel Hotel Financial Model – 26 Worksheets

A comprehensive hotel planning workbook with editable operating assumptions, linked calculations, financial statements, executive reporting and supporting analysis.

Investor / Management PowerPoint – 15 Slides

An editable presentation designed to communicate hotel operating assumptions, forecast performance, funding requirements and major financial risks.

How-to-Use PDF Guide – 24 Pages

A detailed guide explaining model setup, operating inputs, financial forecasts, dashboards, scenarios and troubleshooting.

2. Room Inventory and Capacity Planning

Develop forecasts using hotel-specific room inventory and capacity assumptions.

Plan room types, available rooms, changes in room inventory, out-of-service nights and total available room nights.

These inputs provide the foundation for estimating room sales potential and operational capacity.

3. Occupancy, ADR and RevPAR

Forecast three fundamental hotel performance indicators:

• Occupancy Rate
• Average Daily Rate (ADR)
• Revenue per Available Room (RevPAR)

The model also supports monthly seasonality assumptions, allowing users to reflect variations in expected demand and room pricing across the year.

Users supply their own assumptions rather than relying on automatically imposed market benchmarks.

4. Hotel Revenue Forecasting

Plan revenue across multiple operating departments, including:

• Rooms
• Food and Beverage
• Events
• Spa
• Parking
• Other Guest Services

This structure accommodates hotels with different service offerings and revenue mixes.

5. Staffing and Operating Expenses

Develop staffing and operating cost assumptions for major hotel functions, including front desk, housekeeping, management, maintenance, food and beverage, and sales and marketing.

Operating expense planning covers relevant categories such as laundry, utilities, booking and distribution fees, housekeeping supplies, maintenance, insurance, marketing, software and property-related expenses.

This helps users evaluate how operating costs influence EBITDA and cash generation.

6. Capital Expenditure, Depreciation and Debt

Model major investment and financing requirements, including:

• Room renovations
• Furniture and equipment
• Building improvements
• Technology investment
• Replacement reserves
• Depreciation
• Debt financing and repayments

These schedules connect investment planning with projected financial performance and liquidity.

7. Integrated Three-Statement Financial Forecast

The workbook includes linked projections for:

Income Statement: Revenue, expenses and profitability.

Balance Sheet: Assets, liabilities and equity.

Cash Flow Statement: Cash movements, investment and financing activities.

The model is structured to support a coordinated financial outlook rather than a standalone revenue projection.

8. Monthly and Five-Year Forecasts

A detailed Monthly Forecast Year 1 provides a closer view of the initial planning period.

The Annual Forecast Years 1–5 extends the analysis across a five-year horizon.

Illustrative data is provided for 2029–2033 and can be replaced with the user’s own assumptions and planning periods.

9. Executive Hotel Dashboard

The executive dashboard presents important financial and operating indicators, including:

• Occupancy
• ADR
• RevPAR
• Total Revenue
• Rooms Revenue
• Food and Beverage Revenue
• EBITDA
• EBITDA Margin
• Ending Cash
• Break-Even Occupancy
• Funding Required

Four embedded Excel chart objects support visual analysis and management reporting.

10. Break-Even and Scenario Analysis

Evaluate the occupancy level required to support financial break-even under the model’s assumptions.

Compare Downside, Base and Upside scenarios to understand how alternative operating conditions may influence profitability and liquidity.

The sensitivity analysis examines the relationship between Occupancy and ADR, helping users assess the financial implications of changes in demand and room pricing.

11. Funding Requirements and Investment Planning

Review potential financing needs arising from operating losses, capital expenditure, debt servicing and cash flow timing.

The funding requirement analysis provides a structured planning reference for internal management discussions and preparation for lender or investor conversations.

It is not a financing approval, investment recommendation or independent property valuation.

12. Investor and Management Presentation

The included 15-slide PowerPoint supports communication of:

• Hotel concept and operating assumptions
• Room inventory
• Occupancy and ADR forecasts
• RevPAR and revenue mix
• Staffing and cost structure
• Capital expenditure
• Five-year financial outlook
• EBITDA development
• Cash flow and funding
• Break-even analysis
• Scenarios and financial risks

The presentation is editable and should be updated with the user’s own property data before external distribution.

13. Practical User Guide

The 24-page PDF explains workbook navigation, editable inputs, operating schedules, financial statement logic, dashboard interpretation, scenario analysis, funding calculations and common troubleshooting considerations.

14. Technical Specifications

Excel Workbook: 26 worksheets

Forecast Horizon: Five years, with detailed first-year monthly planning

Sample Period: 2029–2033

Financial Statements: Income Statement, Balance Sheet and Cash Flow Statement

Presentation: 15-slide PowerPoint

Documentation: 24-page PDF

File Formats: XLSX, PPTX and PDF

Macros: None

External Data Connections: None required

Google Sheets: Excel workbook import is possible, although spreadsheet formatting, chart rendering and compatibility should be checked after import.

Ideal For

Independent hotel owners, boutique hotel operators, hospitality entrepreneurs, hotel development teams, financial analysts, business consultants, hospitality management teams and professionals preparing financial plans for hotel projects.

Important Information and Disclaimer

This product is a financial planning template, not a source of verified hotel market benchmarks or property-specific valuations.

All example figures are illustrative. Forecasts and calculations depend on the assumptions and information supplied by the user.

The product does not constitute financial, investment, accounting, tax, legal, valuation or financing advice. Users should independently review all calculations and consult qualified professionals before making material business or investment decisions.

Independently developed by SheetworksStudio. No external certification, endorsement or affiliation is implied.

© SheetworksStudio. For personal or internal business use only. Unauthorized resale, redistribution and sharing are prohibited.