# The Hotel Investor: companion files

Julian R. Sterling

## What is here

- **Hotel_Investor_Model.xlsx**: the workbook that rebuilds the Marrowby case and reproduces the figures of the book with live formulas. Sheets: Inputs, Rooms, P&L, Fees, PIP, Valuation, Debt, Returns, Downside, Select-Service, Checks.
- **Hotel_Investor_Toolkit.docx**: the 8 checklists of Appendix 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), in editable form.

## Which sheet answers which chapter

- Chapter 2: Rooms (occupancy, ADR and RevPAR from 2026 to 2032, the competitive set and the MPI, ARI and RGI indexes: RGI 89.2 in 2026)
- Chapter 3: P&L (the statement in the USALI order, from departmental revenue to GOP: $6.85 million in 2026)
- Chapter 4: Fees (base, incentive and franchise fees, property tax, insurance, the FF&E reserve, NOI: $3.42 million in 2026)
- Chapter 10: PIP ($10.08 million, the displacement of 2027 and the repositioning)
- Chapter 11: Valuation (price, cap rates, exit, DCF value of $61.04 million, walk-away price of $49.96 million)
- Chapter 13: Debt (bank loan of $34.50 million against a CMBS loan of $28.50 million and a mezzanine loan of $4.50 million)
- Chapter 14: Returns (unlevered IRR 10.32 percent, 14.23 percent with the bank loan, 14.02 percent with the CMBS structure)
- Chapter 8: Downside (a downturn and a 2020-style shock, with both loans)
- Chapter 6: Select-Service (a 140-key select-service hotel beside the Marrowby, and whether to build it)
- Appendix A: 15 exercises, with the answers the workbook returns

## Two inputs to change first

1. On Inputs, lower the 2028 ADR growth from 9.0 percent to 5.0 percent: the repositioning is worth less, and every year after it and the exit fall with it.
2. On Inputs, raise SOFR by one point: watch the bank loan's interest, its coverage in the PIP year and the levered IRR on the Debt and Returns sheets. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light blue background is an input, black type a formula, green type a link to another sheet. Every input is on the Inputs sheet. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

A few lines round a half cent exactly as the book's model does (on the value the computer stores), so the workbook prints the same cents as the book; their formulas are longer for that reason only.

Quillmoor Hospitality Partners, its fund, the Marrowby Hotel, the Brand, the Operator and the seller are fictional; rates, occupancies, costs, fees, prices, cap rates, interest rates and dates are teaching assumptions, not the terms of any real contract, the quote of any real market or a forecast. Provided as is, without warranty. Not legal, tax, accounting or investment advice.
