Hotel Financial Model Template for Excel and Google Sheets

A pre-built Excel and Google Sheets hotel model with 5-year projections, cash flow, P&L, startup costs, and dashboard charts. It gives you a cleaner way to plan, present, and compare your numbers without starting from scratch.
Hotel Financial Model - overview header showing the model’s main dashboard and navigation, summarizing key KPIs, runway/cash and performance at a glance for investor-ready presentations and clearer cash-flow visibility.
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Hotel Financial Model - overview header showing the model’s main dashboard and navigation, summarizing key KPIs, runway/cash and performance at a glance for investor-ready presentations and clearer cash-flow visibility.
Industry Benchmarks
Projected balance sheet
Capital expenditure plan
Capitalization table
Cash flow forecast
Financial charts
COGS & Operating expense forecast
Financial model dashboard
DuPont analysis
Projected income statement
Payroll forecast
Financial ratio analysis
Return on invested capital analysis
Revenue forecast
Financial scenario analysis
Sources and uses of funds
Financial model summary
Top expense analysis
Top revenue streams
Business valuation analysis
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Hotel Bundle
See included products:
Financial Model iHotel Bundle Financial Model template included in this product.
$149 $109
ADD TO YOUR ORDER
Business Plan iHotel Bundle Business Plan template included in this product.
$79 $59
Pitch Deck iHotel Bundle Pitch Deck template included in this product.
$49 $29
YOU SAVE $0 TODAY
30-Day Money-Back Guarantee
Created by a Former CFO
Updated for 2026
One-Time Purchase
Description

The Hotel Financial Model is a five-year Excel template for planning room revenue, operating costs, and staffing for a 40-room independent select-service hotel. It converts available room nights, occupancy, seasonality, room mix, and realized nightly prices into financial projections.

The illustrated case uses a leased, existing suburban US property with complimentary continental breakfast. Forecasts cover 2026–2030, with a January 31, 2026 launch date and sales starting in the launch month; all selected inputs are estimates, and no specific property is selected.

Room inventory
40available rooms
Room categories
5shared sold-night pool
Forecast
5years
WORKBOOK CONTENTS

Edit Hotel Assumptions and Review Linked Reports

The workbook connects hotel operating inputs with monthly calculations, financial statements, and management reports.

Revenue & Calc

Edit room inventory, occupancy, seasonality, category mix, nightly prices, and launch timing to build the monthly revenue forecast.

Costs, Payroll & CAPEX

Plan revenue-linked costs, lease expenses, role-based staffing, and property improvements separately so operating costs and investment spending remain distinguishable.

Dashboard & Scenarios

Select Low, Base, or High multipliers for revenue, COGS, variable expenses, fixed expenses, and payroll; compare their effects on margins and EBITDA.

Statements & Funding

Use IS, CF, BS, and Summary to review linked financial statements; CapTable, Debt, and Sources & Uses organize equity, financing schedules, and cash allocation.

REVENUE FORECAST

Room Capacity and Occupancy Drive Revenue

Available rooms multiplied by calendar days, occupancy, and the seasonal factor determine the shared monthly pool of sold room nights.

Room inventory stays at 40; annual occupancy assumptions are 52%, 58%, 62%, 64%, and 65% for 2026 through 2030, respectively. Repeating seasonal factors include 0.8 in January and 1.2 in July.

The model allocates sold nights across five categories, then applies each category’s realized nightly price. Accessibility spans these categories rather than forming a separate commercial price class.

Revenue Forecast

The Revenue Forecast connects room capacity, projected sold nights, category mix, and nightly prices to sales. Adjust these inputs to compare occupancy and pricing plans without counting the same room-night pool more than once.

hotel financial model revenue fml30
Estimated 2026 room mix and realized nightly prices
Room category Sold-night mix Nightly price
Standard King 35% $130
Standard Queen 20% $125
Double Queen 25% $145
Deluxe King 10% $155
Junior Suite 10% $185

Prices are per sold room night; category shares total 100%.

July 2026 capacity illustration

40 rooms × 31 days × 52% occupancy × 1.2 seasonal factor = 773.76 projected sold room nights.

The 2026 mix produces a weighted nightly price of $140.75, giving approximately $108,907 in July room revenue. Fractional room nights represent planning averages; staffing supports operations without independently generating sales.

OPERATING COSTS

Separate Revenue-Linked Costs from Lease and Payroll

Revenue-linked expenses change with sales, while lease commitments and staffing plans determine much of the operating cost base.

COGS total 11% of revenue: supplies and cleaning materials at 3.5%, breakfast materials at 3.5%, and outsourced laundry at 4%. Variable expenses total 11.4%: commissions at 6%, processing at 3.2%, marketing at 2%, and credit losses at 0.2%.

COGS and Operating Expenses

The COGS & Operating Expense Forecast separates direct, variable, and fixed expenses. Monthly property lease and charges rise from $20,000 in 2026 to approximately $22,510 in 2030; fixed costs also include utilities, insurance, repairs, software, professional services, and other operating overhead.

hotel financial model cogs opex fml30

Front desk and night audit remain at 4.5 annual-average FTE, while housekeeping increases from 2.8 to 3.4 FTE. The plan also includes a manager, breakfast attendant, and maintenance technician; these staffing measures are not employee headcounts.

Payroll Forecast by Staff Role

The Payroll Forecast calculates personnel costs from roles, compensation, hiring dates, and FTE assumptions. Illustrated annual payroll rises from $363,800 in 2026 to $383,000 in 2030; outsourced laundry remains a separate cost, and employer taxes, benefits, and personal taxes are excluded from this case.

hotel financial model payroll fml30
STARTUP AND FUNDING

Budget Refurbishment and Startup Cash Separately

This leased-property case budgets improvements and equipment rather than purchasing or developing a hotel.

Startup asset inputs total $455,000: improvements of $160,000, furniture, beds, and electronics of $240,000, breakfast and housekeeping equipment of $30,000, and access, security, and front-desk hardware of $25,000.

Capital Expenditure Plan

The Capital Expenditure Plan schedules asset spending and depreciation from budgets, dates, and depreciability settings. Use it to distinguish refurbishment purchases from recurring lease payments and operating expenses.

hotel financial model capex fml30

Deposits, setup, launch marketing, and preopening costs are separate startup cash items. Initial owner funding is approximately $811,335 from the source startup budget; this input does not establish a tested financing requirement.

Sources and Uses of Funds

Sources and Uses of Funds reconciles cash receipts, funding, payments, and retained cash over selected forecast months. Dashboard debt controls support four facilities with repayment schedules, allowing financing assumptions to be entered without treating borrowings as room revenue.

hotel financial model sources uses fml30
ILLUSTRATIVE FINANCIAL PROJECTIONS

The Illustrated Case Shows Positive EBITDA

The selected hotel scenario produces positive EBITDA throughout 2026–2030; the supplied numerical results stop at this operating earnings measure.

Illustrative annual hotel forecast, nominal US dollars
Year Revenue Operating Expenses EBITDA
2026 $1,069,599 $999,390 $70,209
2027 $1,228,804 $1,053,332 $175,472
2028 $1,356,111 $1,100,485 $255,626
2029 $1,438,485 $1,134,741 $303,745
2030 $1,504,819 $1,165,781 $339,038

Illustrative projections, rounded independently to whole dollars; displayed totals may differ by $1.

Higher occupancy and nightly prices increase projected revenue while lease and staffing costs continue to absorb cash. Positive EBITDA does not establish net profit, positive cash flow, or investment recovery.

Cash Flow Forecast

The Cash Flow Forecast tracks operating, investing, and financing cash movements and reconciles opening to closing cash. Receivable days of 3, payable days of 10, and inventory days of 13 affect working-capital timing; they are separate from annual expense inputs.

hotel financial model cf fml30
BREAK-EVEN AND RETURNS

Evaluate Break-Even, Payback, and Annual ROIC

Returns reports help assess operating thresholds and capital recovery using the workbook’s linked calculations.

Break-Even, Payback and ROIC

The Return on Invested Capital Analysis combines sales break-even, cash break-even timing, investment payback, and annual ROIC. These functions support investment review, but the supplied case does not establish numerical return results.

hotel financial model returns fml30

Sales break-even tests the revenue needed to cover modeled operating costs; cash break-even addresses cash timing. Investment payback tracks recovery of invested funds through project cash flow, while annual ROIC measures annual operating returns relative to invested capital.

MODEL FIT

Designed for an Existing Select-Service Hotel

The template suits owners and advisers evaluating a leased hotel with room-led sales and limited amenities.

The case excludes a restaurant, bar, pool, and meeting business. Replace the estimated rates, occupancy, lease, staffing, and startup inputs with property-specific assumptions before using the financial projections for a decision.

FREQUENTLY ASKED QUESTIONS

Questions About the Hotel Financial Model

These answers clarify the template’s scope and how to interpret the illustrated case.

Can I change occupancy and room prices?

Yes; the Revenue inputs include room capacity, occupancy, seasonal factors, category mix, and annual nightly prices that feed monthly revenue calculations.

Does the model include complimentary breakfast?

Yes; the case includes breakfast materials and a breakfast attendant, with no separate breakfast revenue stream.

Does this case include buying the hotel?

No; it assumes a leased existing property, with refurbishment, equipment, deposits, and other startup cash items.

Are these figures actual hotel results?

No; they are illustrative projections based on estimated inputs, with no selected city or property.

Does positive EBITDA confirm investment payback?

No; payback depends on project cash flows and invested funds, and no payback result is supplied for this case.

Can I compare downside and upside cases?

Yes; Dashboard scenario controls apply Low, Base, and High multipliers to revenue and major expense groups, with comparisons of margins and EBITDA.

What Does the Hotel Financial Model Contain?

hotel financial model dashboard fml30

Financial Dashboard

KPIs, forecasts, and cash flow at a glance.

hotel financial model revenue fml30

Revenue Engine

Key assumptions and calculations driving revenue forecasts.

hotel financial model sources uses fml30

Sources & Uses

Funding sources, spending, and closing cash.

hotel financial model returns fml30

Returns & Break-Even

Cash break-even, payback, and ROIC.

hotel financial model valuation fml30

Business Valuation

DCF valuation and sensitivity analysis.

hotel financial model top expenses fml30

Expense Breakdown

Largest costs and spending trends.

hotel financial model summary fml30

Financial Summary

Annual and monthly financial performance.

hotel financial model benchmarks fml30

KPI Benchmarks

Compare margins and returns to benchmarks.

Trusted by 25,000+ startup founders, investors and CPAs

Clear Runway Visibility

Megan Hart, CA

4 star rating

The cash flow forecast made it easy to see our runway and likely shortfalls months ahead, which saved us from guessing. We cut a half-day planning meeting down to 30 minutes because the assumptions were finally in one place.

Investor-Ready Structure

Daniel Reed, NY

4 star rating

I wasn’t sure what investors wanted to see, but this template gave me the right layout and outputs right away. It saved me about 8 hours of rework before our first fundraising call.

Everything In One Place

Lauren Bishop, FL

4 star rating

Our statements and charts were spread across too many files, and this cleaned it up fast. I pulled the monthly report together in under an hour instead of chasing tabs all afternoon.