Question 1

What's included in this hotel business plan template?

Accepted Answer

The template includes 5 worksheets: an Executive Summary with property details, occupancy and ADR assumptions, RevPAR, and total investment; a Startup Costs & Funding sheet breaking down construction, FF&E, pre-opening costs, and working capital; a 12-month Revenue Forecast built from occupancy %, ADR, seasonality, and ancillary revenue with a ramp-up schedule; a 3-Year Projected P&L showing room revenue, F&B, labor by department, GOP margin, EBITDA, and net income; and a Dashboard with RevPAR, GOP margin, occupancy and ADR trends, DSCR, and profitability trajectory. All formulas are pre-built.

Question 2

What's RevPAR and why do lenders focus on it?

Accepted Answer

RevPAR (Revenue Per Available Room) is total room revenue divided by total available room nights. It's a single metric that combines both occupancy rate and average daily rate, so it's hard to game. A hotel with 100 rooms and 73% occupancy at $150 ADR has RevPAR of $109.50. RevPAR is the key metric lenders use to compare your property against competitive sets and to project cash flow. A hotel with $12,000 annual RevPAR is generally stronger than one with $8,000 RevPAR, regardless of occupancy mix (whether it got there with high occupancy at lower ADR or lower occupancy at higher ADR).

Question 3

How do I estimate occupancy and ADR for my hotel?

Accepted Answer

Research comparable hotels in your market using hotel data services (Smith Travel Research, Revinate, etc.) to find occupancy %, ADR, and RevPAR for similar properties. Occupancy varies by property type: urban business hotels typically run 75–85%, resort properties 70–85% (with significant seasonality), and budget properties 80–90%. ADR varies by market and property class. Use actual comparable data from your market as your baseline, then adjust for your property's competitive position. New hotels typically open at 5–15% below comparable properties due to lack of brand recognition, so plan conservatively.

Question 4

What should I include in startup costs for a hotel?

Accepted Answer

For a new hotel: land acquisition, construction, FF&E (furnishings, fixtures, equipment—typically $20,000–$50,000 per room), PMS and technology systems, pre-opening labor and training, initial marketing, licenses and permits, and working capital. For a renovation: all hard costs, all FF&E, rebranding, pre-opening marketing, and working capital. Most hotels cost $100,000–$300,000 per room in hard costs plus $20,000–$50,000 per room in FF&E. A 100-room hotel might have $10–$20 million in total startup costs. Work with your architect and equipment suppliers to build detailed cost estimates.

Question 5

What's gross operating profit (GOP) margin and what's a healthy target?

Accepted Answer

GOP is total revenue minus all departmental labor and COGS (mainly F&B costs). GOP margin is GOP divided by total revenue. Healthy hotel GOP margins are 35–50% depending on property type: luxury hotels often hit 45–50%, mid-scale hotels hit 38–42%, and budget properties hit 35–40%. If your GOP margin is below 35%, you either have too much labor, too high F&B costs, or your ADR is too low. The template shows GOP margin so you can see whether your labor staffing levels and F&B operations are efficient.

Question 6

How long should I model the ramp-up period for a new hotel?

Accepted Answer

Model a 12–18 month ramp-up where occupancy starts at 50–60% in month one and reaches 80–90% by month 12–18, depending on the market and your property type. ADR typically ramps faster than occupancy—you can achieve near-target ADR in months 2–3 but occupancy takes longer as you build market awareness and establish distribution channels. Seasonal properties take longer to ramp because you need multiple peak seasons to fill the customer pipeline. The Revenue Forecast sheet includes adjustable ramp-up percentages—model conservatively and let the property outperform rather than disappointing lenders with a slower ramp.

Question 7

What's debt service coverage ratio and why do lenders require 1.25x?

Accepted Answer

Debt service coverage ratio (DSCR) is EBITDA divided by annual debt service (principal + interest). A DSCR of 1.25x means your EBITDA is 25% higher than your debt payments, giving the lender a 25% margin of safety if actual performance is lower than projected. Most construction and permanent hotel lenders require DSCR of 1.25x or higher. If your business plan shows DSCR of 1.10x, the lender won't fund because there's insufficient cushion for underperformance. Calculate DSCR in the Dashboard and ensure it's 1.25x or higher before approaching lenders.

Question 8

Should I include pre-opening expenses in startup costs?

Accepted Answer

Yes, include all pre-opening costs: staff hiring and training, initial marketing and grand opening event, management fees during construction, insurance, and working capital for the first few months of operations. Pre-opening costs typically run $500,000–$2,000,000 depending on property size and market. These are typically capitalized and depreciated over several years, not expensed immediately, so they should be included in your total investment figure. The Startup Costs sheet has a specific line for pre-opening expenses.

Question 9

How do I model labor costs for a hotel by department?

Accepted Answer

Break labor into departments: front office (reservations, check-in/check-out, concierge), housekeeping (the largest labor cost), maintenance, and management. Housekeeping typically costs $15–$25 per room per day in wages and benefits depending on your market and labor costs. Front office might be 3–5 staff plus management. Total hotel labor is typically 25–35% of revenue, with housekeeping being 10–15%. Build your staffing plan from room count and occupancy assumptions: a 100-room hotel at 75% occupancy needs roughly 25–30 housekeeping staff, 4–6 front office staff, and 4–6 management/support staff.

Question 10

Does this work in Google Sheets?

Accepted Answer

Yes. The template is built in Excel (.xlsx) but is fully compatible with Google Sheets. Upload the file to Google Drive, open it with Google Sheets, and all formulas, formatting, and charts will work without modification. You can share it with your lender, accountant, or hotel management company directly from Google Drive.

Hotel Business Plan Template

What's Inside This Hotel Business Plan Template

Executive Summary

Startup Costs & Funding

Revenue Forecast

Projected P&L

Dashboard

Hotel Business Plan Template Features

How to Use This Hotel Business Plan Spreadsheet

Why Hotels Need a Solid Business Plan

Hotel Industry at a Glance

Revenue Drivers

Key Cost Categories

Typical Margins

Seasonality

Key Performance Indicators

Hotel Business Plan Template FAQ

More Hotel Templates

More Business Plan Templates