Companion files · The Private Markets Career Guides
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 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.
Chapters 2 to 4, 6, 8, 10, 11, 13 and 14, and Appendix A
An Inputs sheet holds every assumption of the case, and one sheet follows each step of the book: Rooms, P&L, Fees, PIP, Valuation, Debt, Returns, Downside, Select-Service. A Checks sheet puts the figures printed in the book beside the cells that compute them, and the 15 exercises of Appendix A run on it.
Download the workbook68 KBAppendix B
Reading the trailing statements and the benchmark report; Management agreement review on a purchase; Franchise agreement and change of ownership; Property condition and the PIP estimate; Labor, taxes, insurance and licenses; Building the projection and the valuation; Loan term sheet review; The first 100 days after closing.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me3 KB| The rooms line | 68.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 year | NOI 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?