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.
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).
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
Measure
Value
RevPAR, year 1
126.00
Total revenue, year 1
8,968,050
GOP margin
42.4%
Base and incentive management fees, year 1
269,042 and 353,203
NOI, year 1
1,920,107
NOI per key
12,801
Going-in cap rate
8.0%
Unlevered and levered IRR
13.1% and 20.6%
Management fees, share of GOP over the hold
16.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
Enter keys, occupancy, ADR and their growth on Inputs.
Enter departmental and undistributed expense ratios.
Enter the management agreement's base and incentive fees and the FF&E reserve.
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.
LCR and NSFR calculatorLiquidity coverage and net stable funding built line by line, with encumbrance and six defensible readings.
Risk-weighted assets (RWA) calculatorStandardised against internal-model RWA, the mortgage loan split, CET1 ratios and the year the output floor binds.
Credit scorecard modelA points scorecard built from counts: bins, weight of evidence, information value and the leaking variable.
Price waterfall analysisList price to pocket price for one account and a whole company: nine leakages, ranked and added up.
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.