Hotel Development Financial Model

It is a financial model for a ground-up hotel project. It forecasts room revenue, operating expenses, construction costs, ramp-up, financing, and returns from land purchase through stabilization or sale.

A development model covers a project you are building, including land, construction costs, loan draws, lease-up or ramp-up, and stabilization. An acquisition model starts with an existing property and its current rent roll or operating results.

Yes. It is a macro-enabled .xlsb Excel workbook that you download and run on your computer. Nothing runs in the cloud, and your files stay local. The license covers your company rather than individual users.

Yes. It handles full-service, limited-service, extended-stay, and boutique hotels. You can also run two hotel sections in one project.

Yes. ADR and occupancy are inputs, and the model calculates RevPAR. It itemizes rooms, food and beverage, banquet, telecom, and other department expenses. You can model ramp-up, seasonality, and the stabilized year separately.

Up to 20 phases, in series or in parallel. Phase timing controls cost spending, loan draws, and revenue start dates.

Free templates are usually built for simple deals. The TILT model supports hotel operations, phased development, construction financing, optional financing add-ons, and partnership waterfalls. It also includes setup help and technical support.

Yes. The model tracks monthly draws, interest accrual, and payoff timing without circular references. You can size the loan by LTC, a dollar amount, stabilized DSCR, or percent of stabilized value.

LTC sizes the loan as a percentage of total project cost. DSCR sizes it based on the debt service the stabilized property can support. The model supports both methods.

Yes. Optional paid add-ons include C-PACE, TIF, LIHTC, mezzanine debt, and multi-date exit. The model also supports grants and separate land and construction loans.

Yes. You can model up to 6 LP investors and 6 GP sponsors with preferred returns, IRR hurdles, and promote splits. The results flow to the deal summary and investor cash flow sheets.

Pricing includes a base model and any optional features your project needs. The license covers your company rather than individual users. Use the form below to request a quote.

Yes. TILT can enter your cost budget and other project inputs on an hourly basis. Your project information stays confidential.

You can upgrade to the mixed-use version and add residential or commercial uses when you need them.

The model is updated throughout the year. A full annual renewal includes features added during the year. Contact TILT for current renewal options.

TILT can add a financing structure, output sheet, or waterfall for an hourly fee.

Yes. RE Analyst services can help enter project data, review underwriting, prepare offering memorandums and investor decks, and build custom models. Work is available by the hour or on retainer.

Each model includes up to one hour with Justin. You can use 15 to 30 minutes before buying to review your deal structure. That time counts toward the hour, and you can use the rest to set up your first project. Ongoing technical support is free. Project input and analysis are available by the hour.

You need the 64-bit Microsoft 365 desktop version of Excel on Windows or Mac, with macros enabled. Do not use Excel for the web because its macro support is limited.

Use the form below to describe your project. Justin will confirm the model fits and provide a quote. You can also book a free 15 to 30 minute screen-share before you buy.