Companion files · The Private Markets Career Guides

The Hotel Investor

Hotel Investment, Underwriting and Asset Management: RevPAR, the USALI Statement, PIPs, Valuation and Financing of Select-Service and Full-Service Hotels.

DRM-free PDF edition, $19.99: searchable, printable, instant download.Buy the PDFFree sample

These are the companion files of the book. One workbook rebuilds the Marrowby Hotel, the fictional hotel of the case: 280 keys, upscale and full-service, studied by Quillmoor Hospitality Partners at a price of $48.00 million. It follows the rooms line against a competitive set, the statement from revenue to GOP, the fees and the reserve down to NOI, the PIP and its displacement, the valuation, a bank loan against a CMBS loan with a mezzanine loan, the returns, a downturn and a shock, and a select-service hotel beside it. A toolkit holds the checklists of Appendix B in an editable form.

The workbook, the toolkit and the read-me, in one archive106 KB

The archive holds the workbook, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links. The workbook recalculates in Excel, LibreOffice or Google Sheets.

The files

Three numbers to reproduce first

The rooms line68.0 percent occupancy at an ADR of $189.00: a RevPAR of $128.52 in 2026, and a RevPAR index of 89.2 against the competitive set
The price$48.00 million, $171,429 a key: a going-in cap rate of 6.85 percent on normalized NOI, $59.04 million with transaction costs and the PIP; unlevered IRR 10.32 percent
The PIP yearNOI falls from $3.42 million in 2026 to $2.34 million in 2027 while floors are out of service, then reaches $5.07 million in 2029

The files are provided as they are, without warranty of any kind. The model is illustrative: Quillmoor Hospitality Partners, its fund, the Marrowby Hotel, the Brand, the Operator and the seller are fictional, and rates, costs, fees, prices, cap rates, interest rates and dates are the book’s assumptions, not the terms of any real contract, the quote of any real market or a forecast. Nothing here is legal, tax, accounting or investment advice.

Read next: RevPAR vs GOPPAR: how do you calculate them, and which hotel is doing better?