Hotel Acquisition Pro Forma Model
The complete real estate financial model for hotel acquisitions. Model full-service, limited-service, boutique, resort, and more.
Complete Hotel Acquisition Model
Designed for seasoned hotel investors and operators, this comprehensive Excel model tackles every aspect of your acquisition analysis.
Why Choose TILT?
Built for real estate professionals who need depth, flexibility, and a model they can trust.
Depth & Professional Outputs
One model with the depth and functionality to handle your entire deal. Smart input features and a hyperlinked table of contents keep everything organized on a single input page, driving 50+ polished output sheets ready to present to investors, lenders, and partners.
Proven & Refined for Over a Decade
The same model, continuously enhanced and improved for 10+ years. Vetted and validated by hundreds of clients across every deal type. A model you can trust.
Not Cloud-Based, No Per-User Fees
No subscriptions, no per-seat licensing. Everyone at your company can use the model. Work offline, keep your data local, and TILT can customize it to fit your specific needs.
Free Technical Support
Get help with model questions directly from the person who built it. Fast response times and client feedback actively incorporated into model improvements.
Acquisition Pro Forma Features & Functionality
Built on proven institutional methodology with advanced Excel functionality that eliminates circular references and maximizes flexibility.
Base Functionality
Inputs & Smart Features
Inputs All on One Page
No hunting through tabs: all inputs displayed, categorized, and hyperlinked.
Show Only Rows with Data
One-click toggle to display only non-zero rows for clean, focused output.
Show/Hide Output Sheets
Easy toggle to display only the sheets you need for each presentation.
Print Selected Reports from TOC
Select and print multiple output reports as a packet directly from the table of contents.
Smart Uses and Sources
Unlike traditional models, ours understands timing and availability each month.
Auto Loan Interest Calculation
Accurately calculates loan interest without circular references or iterative calculations.
Input Error Check
Automatically detects common errors with clearly labeled warnings.
Flexible Input Methods
Enter values as $/SF, $/unit, $/month, or $total, whatever fits your workflow.
Hyperlinked Table of Contents
Navigate 50+ sheets instantly with a clickable, organized TOC.
Right-Click Sheet Reordering
Reorganize output sheets with a simple right-click menu, no dragging required.
Auto-Updating Sheet Names
Rename any sheet and the TOC updates automatically, no manual fixes.
Underwriting & Rent Roll
Commercial Tenant-by-Tenant Rent Roll
Input detailed lease terms for each commercial tenant with individual rent schedules, escalations, and expiration dates.
Vacancies, Concessions & Bad Debt
Factor in occupancy losses year by year for realistic revenue projections.
Commercial Rent Step-ups & Lease Structure
Model NNN, NN leases, rent abatements, TI's, and management and leasing assumptions for commercial tenants.
20 Different Unit Types per Property Segment
No limit on units of each type: scale your analysis to any property size.
Capital Stack & Partnership
Equity Recognition for Non-Cash Contributions
Acknowledge equity for land contributions or other non-cash assets contributed to the partnership.
Capacity for 6 Individual LPs and 3 Individual GPs
Detailed partnership structuring for complex joint ventures with up to 6 limited partners and 3 general partners.
Multiple Equity Distribution Methods
IRR waterfall, GP catch-up, fixed percentage, and other distribution methods for flexible profit-sharing structures.
Mezz Debt and Grants
Utilize multiple sources of financing alongside the acquisition loan.
Investment Returns & Exit
Flexible Exit Valuation
Set exit valuation based on cap rate or $ input for standard sales or specialized scenarios like land sales.
Comprehensive Sensitivity Analysis
Automatic "what-if" analysis on input assumptions for revenues, expenses, interest rates, and more.
Phased Renovations with Automatic Rent Increases
Schedule unit renovations over time with rent bumps that automatically apply when each phase completes.
Optional Additional Functionality
Any Property Combination
Support any mix of residential, commercial, and/or hotel in one model.
Multi-Date Exit
Sell different units at different dates over the project lifecycle.
Ready to Elevate Your Acquisition Analysis?
Get started with the industry's most comprehensive real estate acquisition model.
Frequently Asked Questions
A hotel acquisition pro forma model is the financial model used to underwrite the purchase of an existing hotel property. It forecasts ADR, RevPAR, occupancy, department-level expenses, renovation premium, franchise fees, and exit returns. The TILT hotel acquisition model handles full-service, limited-service, extended-stay, and boutique hotels with brand-specific reporting.
Yes. ADR, RevPAR, occupancy, and department-level expenses (rooms, F&B, banquet, telecom, other) are all standard. Full-service, limited-service, extended-stay, and boutique can all be modeled. Two hotel sections can run in parallel if you are modeling a campus or a brand mix.
TILT can upgrade the model to the mixed-use version. The same engine handles hotel plus residential plus commercial acquisitions in any combination.
Yes. Renovation premium on ADR or occupancy, phased ramp-up, RevPAR uplift assumptions, and refinancing for cash-out or LTV-target events are all standard. The model handles seasonality, stabilized year separately from ramp-up, and exit valuation on cap rate or NOI multiple.
Yes. Franchise fees as a percent of revenue or a fixed amount, management fees, base plus incentive fee structures, and brand-specific reporting all work. Hotel-specific operating expense logic is built into the model.
TILT can customize the model. Specific franchise structures, brand reporting, or hotel acquisition logic the standard build does not cover get added by Justin for an hourly fee.
Most clients have their first acquisition running within an hour. Every TILT model purchase includes 1 hour of complimentary setup help with Justin.
Schedule a Free Call
Ready to elevate your real estate acquisition analysis? Fill out the form and our team will get back to you within one business day.
Why Choose TILT Analytics?
- 50+ professional output sheets
- Institutional-grade methodology
- Expert technical support
- Customization options available
Know a colleague who could use TILT? Refer them and you'll both get 10% off.