Free Excel templates

A free hotel acquisition model in Excel, from RevPAR to levered IRR

Occupancy, ADR and RevPAR, rooms and other revenue, departmental and undistributed expenses, GOP, base and incentive management fees, FF&E reserve, fixed charges and NOI, then the purchase, debt, sale and returns: four sheets, no macros.

The file buys a fictional 150-key select-service hotel for 24 million, 160,000 a key. In year one it runs at 70% occupancy and an ADR of 180: a RevPAR of 126 and 8.97 million of total revenue. After departmental and undistributed costs the GOP margin is 42.4%; the operator's base and incentive fees, the FF&E reserve and fixed charges then take NOI down to 1.92 million, an 8.0% going-in cap rate. Held five years with 60% debt and sold at the same cap rate, it returns 13.1% unlevered and 20.6% levered.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.

Hotel_Acquisition_Model.xlsx (16 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this model

This model goes with How to Read a Hotel Management Agreement, which explains the method behind it, chapter by chapter.

Get the book on Apple Books → Or on Google Play

Want every model at once?

The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).

Get the Library, $79 →

This free file stays free. Secure checkout by Stripe.

Not on Amazon: 36 paperbacks by Julian R. Sterling on how to read the documents, printed on demand and shipped worldwide. Browse the bookshop →

What is in the file

Four sheets. Inputs are blue cells on a pale blue fill on the Inputs sheet.

Read me
What the file does and its conventions.
Inputs
Keys, occupancy path, ADR and growth, other revenue, departmental and undistributed expenses, base and incentive fees, FF&E reserve, fixed charges, price, costs, debt, exit cap rate and selling costs.
Operations
Six years of occupancy, ADR, RevPAR, revenue, expenses, GOP and its margin, management fees, FF&E reserve, fixed charges, NOI and NOI per key.
Returns and Checks
Purchase, NOI, sale and debt to unlevered and levered cash flows, IRR, multiple, DSCR, debt yield and management fees as a share of GOP; then the checks: all OK.

What the worked case returns

MeasureValue
RevPAR, year 1126.00
Total revenue, year 18,968,050
GOP margin42.4%
Base and incentive management fees, year 1269,042 and 353,203
NOI, year 11,920,107
NOI per key12,801
Going-in cap rate8.0%
Unlevered and levered IRR13.1% and 20.6%
Management fees, share of GOP over the hold16.4%

The management agreement takes a sixth of the hotel's operating profit before the owner sees any of it. The incentive fee, here larger than the base fee, is the term that most deserves negotiation, and its definition decides how much of every extra point of GOP margin reaches the owner.

How to use it on your own hotel

  1. Enter keys, occupancy, ADR and their growth on Inputs.
  2. Enter departmental and undistributed expense ratios.
  3. Enter the management agreement's base and incentive fees and the FF&E reserve.
  4. Enter price, debt and exit cap rate and read the returns.

Questions people ask about it

Is this template really free?

Yes. The file costs nothing: you enter an email address, the download opens at once, and you can leave the reader list in one click.

Does it use macros or circular references?

No macros and no circular reference.

What is the difference between GOP and NOI for a hotel?

GOP is revenue less departmental and undistributed operating costs. NOI then deducts the management fees, the FF&E reserve and fixed charges such as property tax and insurance. Here GOP is 3.80 million and NOI 1.92 million.

Can I use it for a real hotel?

You can reuse the structure. The hotel is fictional and simplified, and nothing here is investment advice.

Go further

For the agreement that sets the management fees in this model, clause by clause, How to Read a Hotel Management Agreement goes further.

See the book and its free files →

Other free templates

This template goes with How to Read a Hotel Management Agreement. The book is on Apple Books and Google Play.

If this book helped, or didn’t, a rating where you bought it is worth more than it looks: it is what the next reader goes on. The template stays free either way.