Outcome
The hotel rent-roll step contains a complete room inventory with reconciled ADR, RevPAR, and room revenue.
Navigation path
Document wizard > Rent Roll > Room Inventory
Access
A Hospitality document with Rent Roll included
On this page
Before you start
Data, sources, and access to prepare
- A Hospitality property type
- Room type and count schedule
- Current ADR and occupancy assumptions
Understand the hotel calculation
Room revenue calculation
Room count, ADR, and occupancy combine into room revenue.
Room count
Keys in the category
ADR
Average daily rate
Occupancy
Occupied room percentage
RevPAR
ADR x occupancy
Annual room revenue
RevPAR x 365 x rooms
- ADRRevPAR
- OccupancyRevPAR
- RevPARAnnual room revenue
- Room countAnnual room revenue
Complete hotel-specific fields
| Field | Requirement | What it means | Format | Units | Save behavior | Downstream effect |
|---|---|---|---|---|---|---|
| Room Type | Required | The inventory category, such as Standard, Deluxe, or Suite. | Plain-text category name | Not applicable | Saved with the Room Inventory rows when Continue succeeds. | Labels the category in Room Inventory and hotel financial output. |
| Room Count | Required | Keys represented by the category. | Positive whole number | Rooms or keys | Saved with the Room Inventory rows when Continue succeeds. | Adds to Total Rooms and multiplies category RevPAR into annual room revenue. |
| Average SF | Optional | Typical room area. | Positive number | Square feet per room | Saved with the Room Inventory rows when Continue succeeds. | Provides room-size context in inventory output; it does not replace the subject property area. |
| ADR | Required | Average Daily Rate for one occupied room. | Positive currency amount | Currency per occupied room per day | Saved with the Room Inventory rows when Continue succeeds. | Recalculates weighted ADR, RevPAR, and annual room revenue. |
| Occupancy | Recommended | Global occupied-room percentage applied to inventory. | Percentage | Percent of available rooms | Saved with the Room Inventory rows when Continue succeeds. | Applies to room categories when calculating RevPAR and annual room revenue. |
| ADR Growth | Optional | Annual growth used by the cash-flow projection. | Percentage | Percent per projected year | Saved with the Room Inventory rows when Continue succeeds. | Compounds room rates in projected cash-flow years. |
| RevPAR | Calculated | ADR multiplied by occupancy. | Read-only calculated currency | Currency per available room per day | No direct entry. Recalculates automatically from saved ADR and occupancy inputs. | Feeds annual room revenue and the hotel analysis summary. |
Required means the field is needed to complete or support this workflow. Some screens allow a draft to save before every required item is complete. The steps and troubleshooting call out controls the product actively blocks.
Hotel uses a dedicated cash-flow editor
The Room Inventory screen saves a hotel-specific unit-mix cash-flow structure. It does not offer the standard hotel pro-forma editor.
Enter and save room inventory
On a phone, select Edit room type to open all fields for that category in a full-width sheet. Done returns to the inventory; Continue retains the existing required-row checks and saves the inventory. RevPAR and revenue are calculated values, so correct their count, ADR or occupancy inputs instead of typing over totals.
Hotel inventory steps
- 1
Set occupancy and growth
Room Inventory summary controls
Enter the current occupancy percentage and annual ADR growth assumption.
Expected result: Weighted ADR, RevPAR, and projected revenue update.
If this does not happen: If the values look wrong, confirm occupancy is a percentage and ADR is a daily amount.
- 2
Review starter categories
Room Inventory rows
Rename, edit, or remove Standard, Deluxe, and Suite starter rows to match the source inventory.
Expected result: Only relevant room categories remain.
If this does not happen: Do not leave unused starter rows with positive counts or ADR.
- 3
Enter every category
Room Inventory rows
For each room type, enter name, count, optional average SF, and ADR.
Expected result: Each valid row displays calculated revenue.
If this does not happen: Rows need a name, room count above zero, and ADR above zero to satisfy Continue.
- 4
Reconcile the summary
Room Inventory totals
Compare total keys, weighted ADR, RevPAR, and annual room revenue with the source underwriting.
Expected result: Displayed metrics reconcile or documented differences are understood.
If this does not happen: Correct category counts, occupancy, or ADR one at a time to isolate the mismatch.
- 5
Continue and persist rows
Bottom of Room Inventory
Select Continue after every required row is complete.
Expected result: Hotel rows save and the wizard advances.
If this does not happen: If nothing happens, inspect each row for a missing name, zero count, or zero ADR.
Resolve hotel inventory problems
Continue does not advance and no message appears
Likely cause: At least one row lacks a name, positive room count, or positive ADR.
- Inspect each row.
- Complete or remove invalid rows.
- Retry Continue.
Revenue is too high
Likely cause: ADR may have been entered as monthly revenue, occupancy may be overstated, or room counts may be duplicated.
- Confirm ADR is per occupied room per day.
- Confirm occupancy percent.
- Reconcile the sum of room counts.
Pro forma is not offered
Likely cause: The dedicated hotel inventory currently forces its cash-flow format.
- Use ADR Growth for the annual projection.
- Use the Income & Expenses and valuation steps for the remaining hotel analysis.
Hotel inventory complete
- Total keys reconcile
- Every category has positive ADR
- Occupancy matches the analysis
- RevPAR is reasonable
- Annual room revenue reconciles
Related guides
Build a Hospitality document
Use room inventory, ADR, occupancy, RevPAR, room revenue, hotel rate comps, and hotel-specific reserve labels.
Open guideEnter income and operating expenses
Build the non-rental income and operating expense statement used to calculate effective gross income and NOI.
Open guideRead and verify the cash-flow projection
Trace rent, vacancy, reimbursements, additional income, expenses, reserves, debt, and exit value through the annual projection.
Open guide