SmartHelping / Hotel Development & Acquisition / Excel
Hotel Financial Models
Evaluate a hotel acquisition or development with room revenue, project costs, debt, cash flow, and investor returns in one forecast. Choose the original model or the advanced Hotel Investment Model.
Original Hotel Model
Room bookings, project costs, debt, three financial statements, and two equity-structure options.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
Advanced Hotel Investment Model
Adds residence sales, food and beverage, events, and expanded project funding tools. View advanced model details.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
Each model is a separate purchase. The detailed features and walkthrough below describe the original $45 model.
See the original model in action
Walk through the hotel plan, financing, and return analysis.
Follow the original $45 model’s walkthrough to see how project costs, room assumptions, operating expenses, and equity terms connect to the forecast.
Original model / Acquisition and development costs
Build the initial project costs on a monthly schedule.
Six initial cost sections
Use one section or combine up to six. Each section has 22 input slots for purchase price, closing costs, construction, development, and other hard or soft costs.
Monthly cost timing
Schedule initial costs by month so the forecast reflects when acquisition or development spending occurs.
Financing choices by cost row
Set a yes/no financing selector and the financed percentage for each cost row. Sponsor or management fees are excluded from the financed project-cost calculation.
Sponsor fees and depreciation
Define optional fees as a percentage of the applicable initial costs, such as acquisition or renovation-management fees. Enter depreciation drivers for each initial cost section.
Original model / Debt and refinancing
Choose how the project is financed.
Connect the eligible project costs to the financing structure that fits the acquisition or development plan.
Interest-only debt
Use an interest-only loan for the initial costs when that matches the financing plan.
Principal and interest
Fund initial costs through a regular principal-and-interest loan, or use the financing assumptions to evaluate the debt structure alongside project cash flow.
All-equity funding
Choose equity funding for costs that will not be financed. The resulting cash-flow requirements feed the equity analysis.
Future refinancing
Set a future refinancing month and define the relevant loan terms and prepayment fees.
Original model / Booking revenue
Build room revenue from the room mix, rates, and occupancy.
Use the room schedule to connect supply, seasonal pricing, and expected occupancy with the operating forecast.
Up to 20 room types
Enter each room type, its room count, and its base nightly booking rate.
Annual room-rate growth
Define the annual increase in the base booking rate.
Monthly price seasonality
Set the percentage variance from the base room rate for each month of the year to reflect seasonality.
Monthly occupancy and annual improvement
Enter occupancy assumptions for each month of the year and an annual occupancy-improvement percentage.
Original model / Operating expenses
Plan staffing and fixed expenses separately.
Staffing schedule
Define staff type, headcount, monthly cost, annual cost growth, and payroll taxes and benefits.
Fixed expense schedule
Enter each fixed expense, its monthly amount, its start month, and its annual growth rate.
Original model / Equity structure
Choose a simple ownership split or an IRR-hurdle waterfall.
Acquisition and management fees are expenses to the deal and income to the GP. For a separate waterfall tool, explore the IRR-hurdle template with a GP catch-up option.
Simple LP / GP cap table
Define the equity contributed by the limited partner and general partner, then set the percentage of distributions each receives. The model solves for the minimum equity required from the negative cash flows.
Monthly IRR-hurdle waterfall
Set contribution rates and distribution splits that vary with the return achieved by the LP. Review monthly-cash-flow-based IRR and equity multiple for both sides of the joint venture.
Original model / Reporting and investment analysis
Follow hotel operations through the financial statements and returns.
Monthly and annual operating detail
Review operating results and cash-flow detail throughout the forecast.
Three connected financial statements
Review monthly and annual income statements, balance sheets, and cash-flow statements.
DCF and return analysis
Evaluate discounted cash flow and IRR for the project as a whole, the investor, and the sponsor.
Annual executive summary
Review the main financial results at the deal level.
Operating visualizations
Use the charts to review the operating forecast and communicate the results.
Sponsor and investor income reports
Review contributions and income sources for the sponsor and investor, including the relevant fee and distribution streams.
Original model / Forecast length and sale assumptions
Set the holding period and decide whether to model a sale.
For separate tools, explore IRR sensitivity to occupancy, leverage, and interest rates or browse the industry-specific financial model collection.
Up to 10 years with a dynamic end month
Select the end month for the forecast rather than using the full 10 years for every analysis.
Optional sale at the end of the forecast
Choose whether the hotel is sold when the forecast ends.
Exit value from NOI and cap rate
Calculate the exit value using trailing 12-month net operating income and the exit capitalization rate you define.
Going-in cap rate
Review the going-in capitalization rate alongside the operating and investment outputs.
Original model / Debt and fixed-cost improvements
See the debt and fixed-cost logic upgrades.
This update video accompanies the original model and explains the changes to its debt and fixed-cost assumptions.
Choose the scope that fits the hotel project
Original hotel model or advanced investment model?
The advanced model has its own detailed product page and purchase option. Review its features before selecting the version for your project.
Original Hotel Model — $45
Focus on room bookings, six initial cost sections, debt and refinancing, staffing, fixed costs, monthly and annual financial statements, and the choice of a simple cap table or monthly IRR-hurdle waterfall.
Advanced Hotel Investment Model — $75
Model four revenue streams: rooms, residence sales, food and beverage, and events. The advanced version also includes three construction phases, expanded construction and acquisition financing, monthly equity timing, distribution controls, sources and uses, hotel KPIs, and acquisition sensitivity analysis.
Explore the Advanced Hotel ModelHow to use the original model
Move from a hotel project plan to an investment analysis.
Set the project costs and timing
Choose the initial cost sections, enter monthly spending, and define sponsor fees and depreciation assumptions.
Configure financing and the equity structure
Set financed costs, debt terms, and any future refinance. Choose a simple LP / GP distribution split or the monthly IRR-hurdle waterfall.
Build the operating forecast
Enter room types, room counts, booking rates, seasonality, occupancy, staffing, and fixed expenses.
Review the investment and exit
Choose the end month and optional sale assumptions. Review the statements, cash flow, minimum equity requirement, partner reports, and return metrics.
Also available in these bundles
Need more real estate and hospitality templates?
Both hotel models are included in the Real Estate and Hospitality bundles. The Super Smart Bundle includes the complete public collection.
Real Estate Model Bundle
Explore models for property acquisitions, development, financing, operating forecasts, and investment returns.
View the Real Estate bundleHospitality Model Bundle
Find financial models for hotels and other hospitality businesses.
View the Hospitality bundleSuper Smart Bundle
Get the complete public SmartHelping financial model collection across industries and financial-analysis needs.
View the Super Smart BundleQuestions before you choose
A few useful details.
What are the two purchase options?
The original Hotel Development / Acquisition Model is $45. The Advanced Hotel Investment Model is $75 and has its own detailed product page. Each button purchases the named model separately.
What does the original model cover?
It connects initial acquisition or development costs, room bookings, staffing, fixed expenses, debt, optional refinancing, and the equity structure to monthly and annual financial outputs.
How many room types and initial cost sections are available?
The original model supports up to 20 room types and six initial cost sections, with 22 input slots in each section.
Can I choose whether individual costs are financed?
Yes. The initial cost schedule includes a yes/no financing selector and financed percentage for each cost row. Sponsor or management fees are excluded from the financed project-cost calculation.
What equity structures does the original model include?
Choose a simple cap table with defined contribution and distribution percentages, or a monthly IRR-hurdle waterfall in which distribution splits vary with the return achieved by the LP.
How is the exit value calculated?
If you choose to model a sale, the original model uses trailing 12-month NOI and the defined exit cap rate. You can choose the forecast end month and whether the hotel is sold at that point.
Which additional revenue streams are in the advanced model?
Alongside room bookings, the advanced version includes residence sales, food and beverage, and events. Review the linked advanced product page for its full operating, financing, and funding features.
How is the template delivered?
Each version is a one-time purchase with immediate access to the Excel download after purchase.
Put the hotel plan and investment returns together
Choose the hotel model that fits your project.
Original Hotel Model: $45. Advanced Hotel Investment Model: $75.
