← Hospitality Deal Screening & Price Discovery · Engine

Development Name - Location

Hospitality · Deal Screening System & Price Discovery System · Reverse Price Engine

Input (adjust) Calculated Key Output Return Metric
Vertical: Hospitality

Project Details

Hotel Name
Location
Segment
Operating Structure

Saved Projects

Sign-in and saved projects use the same account system as the multifamily engine. Your work autosaves to your account while signed in.

Ask Price

Ask Price ($)-

Section 1 - Hotel Summary

Number of Keys (Rooms)
Year Built / Renovated
Years Since Last PIP
Comp Set ADR ($)
Comp Set Occupancy (%)
RevPAR Index (fair share = 100)

Section 2 - Operating Performance (Stabilized, Yr 1)

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-

Section 3 - Fees, Fixed Charges & FF&E Reserve

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-

Section 4 - PIP / CapEx Budget

Line Item$/KeyTotal
Guestroom Renovation-
Lobby / Public Space-
F&B Outlets-
Building Systems / MEP-
Contingency (% of hard)-
TOTAL PIP / CAPEX-

Section 5 - Total All-In Basis

Ask Price-
Acquisition Closing Costs (%)
PIP / CapEx-
Working Capital / Pre-Opening
TOTAL ALL-IN BASIS-
All-In Basis per Key-

Section 6 - Financing Assumptions

Loan-to-Cost (%)
Interest Rate (%)
Amortization (yrs)
Interest-Only Period (yrs)
Loan Fee (%)
Hold Period (yrs)

Section 7 - Exit Assumptions

Exit Cap Rate (%)
Going-In Cap Rate (calc)-
Cost of Sale (%)
Market Cap Rate for YoC (%)

Cash Flows

Annual projection across the hold (NOI after FF&E reserve). Key return metrics sit in the Decision Summary.

Ask Price Sensitivity

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/KeyAll-In BasisLoanEquityLevered IRRDSCRDebt Yield