Hotel & Boutique Hotel 5-Year Financial Model Excel | Occupancy, ADR, RevPAR, Break-Even, Cash Flow & Investor Deck

✨ HOTEL & BOUTIQUE HOTEL 5-YEAR THREE-STATEMENT FINANCIAL MODEL

A professional financial planning system for independent hotels, boutique hotels, new hotel projects, operators, consultants, finance professionals, and management teams.

The model connects the main operating drivers of a hotel directly with a fully integrated 5-year financial forecast, helping users understand how room capacity, Occupancy, ADR, RevPAR, F&B activity, staffing, operating costs, CapEx, debt, and financing assumptions may influence profitability, liquidity, and funding requirements.

The package includes a 26-worksheet Excel Financial Model, a professional 15-slide Investor / Management PowerPoint Deck, and a detailed 24-page How-to-Use PDF Guide.

The included 2029–2033 sample period and data are illustrative and can be replaced with property-specific assumptions and planning periods.

🛏️ ROOM INVENTORY & OPERATING CAPACITY

Model room types, starting inventory, annual room additions, out-of-service nights, total room capacity, available room nights, and net available room nights.

📈 OCCUPANCY, ADR & REVPAR

The model combines annual occupancy assumptions, ADR development, and editable monthly seasonality factors to calculate occupied room nights, room revenue, RevPAR, and other operating metrics.

💰 REVENUE PLANNING

Revenue planning covers:

✅ Rooms Revenue ✅ Food & Beverage ✅ Events ✅ Spa ✅ Parking ✅ Other Guest Services ✅ Additional editable ancillary revenue streams

Optional categories can be adjusted, reduced to zero, or adapted to the individual hotel concept.

👥 STAFFING, DEPARTMENT COSTS & OPEX

Plan management, front desk, housekeeping, maintenance, F&B, sales and marketing, administration, and additional staffing categories using editable FTE, salary, and wage-growth assumptions.

Cost planning includes department costs and operating expenses such as housekeeping supplies, laundry, utilities, booking and distribution fees, F&B COGS, maintenance, insurance, marketing, software, property-related costs, and other OPEX.

🏗️ CAPEX, DEPRECIATION & DEBT

Create a structured capital plan for renovations, furniture, equipment, building improvements, IT, replacement reserves, and other projects.

CapEx timing and useful-life assumptions feed into the depreciation schedule, while the Debt Schedule tracks debt balances, planned draws, repayments, and interest expense.

🧾 FULL THREE-STATEMENT MODEL

The workbook includes fully linked:

✅ Income Statement ✅ Balance Sheet ✅ Cash Flow Statement

A Balance Check provides an additional model-control mechanism and should remain at zero throughout the forecast.

📅 MONTHLY + 5-YEAR FORECAST

Review a detailed monthly forecast for Year 1 together with an annual management view covering 2029–2033.

The five-year forecast consolidates room capacity, Occupancy, ADR, RevPAR, Rooms Revenue, F&B Revenue, Other Revenue, total revenue, costs, EBITDA, net income, ending cash, and cumulative funding requirements.

📊 EXECUTIVE DASHBOARD & KPI ANALYSIS

The Executive Dashboard provides a concise management overview of key financial and operating outputs, including:

✨ Revenue ✨ EBITDA ✨ EBITDA Margin ✨ Occupancy ✨ ADR ✨ RevPAR ✨ Ending Cash ✨ 5-Year Funding Requirement

Four integrated dashboard charts provide additional visual analysis.

The dedicated KPI Analysis expands the review with metrics including Rooms Revenue, F&B Revenue, Revenue per Available Room, Payroll %, Break-Even Occupancy, Funding Required, Debt / EBITDA, and Net Income Margin.

🎯 BREAK-EVEN, SCENARIOS & SENSITIVITY

Analyze the occupancy level required for EBITDA break-even and test how changes in operating assumptions may affect performance.

Included:

📉 Break-Even Occupancy 🔵 Downside Scenario ⚪ Base Scenario 🟢 Upside Scenario 📊 Occupancy × ADR Sensitivity 💵 Funding Requirement

Scenario assumptions can flex:

✅ Occupancy ✅ ADR ✅ F&B Spend ✅ Payroll ✅ OPEX

The Sensitivity Analysis evaluates the effect of different Occupancy × ADR combinations on estimated 2029 EBITDA.

💵 FUNDING REQUIREMENT

The dedicated Funding Requirement section calculates annual external funding needs after operating cash flow, CapEx, planned debt activity, and the minimum cash reserve.

Users can review both annual funding requirements and cumulative funding requirements across the forecast period.

🎤 15-SLIDE INVESTOR / MANAGEMENT POWERPOINT

The included professional PowerPoint Deck covers:

🏨 Room Inventory 📈 Occupancy Forecast 💵 ADR & RevPAR 🍽️ Revenue Mix 🧾 Cost Structure 🏗️ CapEx Plan 📊 5-Year Forecast 💎 EBITDA Development 💰 Cash Forecast 🎯 Break-Even 🏦 Funding Requirement 🔄 Scenario Analysis ⚠️ Risks & Model Limits ⭐ Executive Summary

The deck is designed for internal management reviews, consulting engagements, planning discussions, and preparation for 

funding or investor conversations.

📘 24-PAGE HOW-TO-USE GUIDE

The detailed PDF guide explains the model workflow step by step, including:

✅ Quick Start ✅ Workbook Architecture ✅ Input Color System ✅ Navigation ✅ Assumptions ✅ Seasonality, Occupancy & ADR ✅ Room Inventory ✅ Rooms Revenue & ADR Index ✅ Food & Beverage and Other Revenue ✅ Department Costs ✅ Staffing & Operating Expenses ✅ CapEx, Depreciation & Debt ✅ Three-Statement Model ✅ Monthly & Annual Forecasts ✅ Dashboard & KPI Analysis ✅ Break-Even Analysis ✅ Scenario Analysis ✅ Sensitivity Analysis ✅ Funding Requirement ✅ QA & Troubleshooting ✅ Google Sheets Compatibility ✅ Final Review Before Use

💻 TECHNICAL COMPATIBILITY

✅ Microsoft Excel (.xlsx) ✅ Microsoft PowerPoint (.pptx) ✅ PDF Guide ✅ Import into Google Sheets possible ✅ No macros ✅ No APIs ✅ No live data feeds ✅ No external Excel connections ✅ No automatically assumed regional hotel prices or industry benchmarks

📌 When imported into Google Sheets, formatting or chart appearance may vary. Excel remains the primary environment for the original workbook design.

⚖️ IMPORTANT DISCLAIMER

This product is an editable planning and informational template and does not constitute financial, investment, tax, legal, accounting, valuation, funding, hospitality, or business advice.

All sample figures and assumptions are illustrative only. The model does not provide guaranteed market values, regional hotel pricing, automatic industry benchmarks, or guaranteed business outcomes.

All assumptions and outputs should be independently reviewed and replaced with property-specific information before being used for real-world business, investment, financing, or management decisions.

✨ SheetworksStudio — Professional Planning. Clear Numbers. Better Decisions.