← Hospitality Deal Screening & Price Discovery · Engine
| Hotel Name | |
| Location | |
| Segment | |
| Operating Structure |
| Ask Price ($) | - |
| Number of Keys (Rooms) | |
| Year Built / Renovated | |
| Years Since Last PIP |
| Comp Set ADR ($) | |
| Comp Set Occupancy (%) | |
| RevPAR Index (fair share = 100) |
| ADR ($) | |
| Occupancy (%) | |
| RevPAR (calc) | - |
| ADR Growth (%/yr) | |
| Occupancy Ramp (pts/yr, first 2 yrs) |
| F&B Revenue ($/occupied room) | |
| Other Revenue ($/occupied room) | |
| Rooms Departmental Cost (% of rooms rev) | |
| F&B + Other Dept Cost (% of that rev) | |
| Undistributed Expenses (% of total rev) |
| Rooms Revenue (Yr 1) | - |
| F&B + Other Revenue (Yr 1) | - |
| Total Revenue (Yr 1) | - |
| Gross Operating Profit (GOP) | - |
| GOP Margin | - |
| Base Management Fee (% of total rev) | |
| Incentive Mgmt Fee (% of GOP) | |
| Franchise / Royalty Fee (% of rooms rev) |
| Property Taxes ($/Yr) | |
| Insurance ($/Yr) | |
| FF&E Reserve (% of total rev) |
| Total Management & Franchise Fees | - |
| Fixed Charges (Tax + Ins) | - |
| FF&E Reserve | - |
| Net Operating Income (after reserve, Yr 1) | - |
| NOI per Key | - |
| Line Item | $/Key | Total |
|---|---|---|
| Guestroom Renovation | - | |
| Lobby / Public Space | - | |
| F&B Outlets | - | |
| Building Systems / MEP | - | |
| Contingency (% of hard) | - | |
| TOTAL PIP / CAPEX | - |
| Ask Price | - |
| Acquisition Closing Costs (%) | |
| PIP / CapEx | - |
| Working Capital / Pre-Opening | |
| TOTAL ALL-IN BASIS | - |
| All-In Basis per Key | - |
| Loan-to-Cost (%) | |
| Interest Rate (%) | |
| Amortization (yrs) |
| Interest-Only Period (yrs) | |
| Loan Fee (%) | |
| Hold Period (yrs) |
| Exit Cap Rate (%) | |
| Going-In Cap Rate (calc) | - |
| Cost of Sale (%) | |
| Market Cap Rate for YoC (%) |
Annual projection across the hold (NOI after FF&E reserve). Key return metrics sit in the Decision Summary.
Each row shows return metrics at a different ask price. Highlighted row = current price. Green rows meet both IRR and DSCR targets.
| Ask Price ($) | Price/Key | All-In Basis | Loan | Equity | Levered IRR | DSCR | Debt Yield |
|---|