# Hotel Dashboard

Evaluate hotel operations and investment returns through occupancy, ADR, RevPAR, segment revenue, departmental margins, management fees, NOI, debt service, capex reserves, and exit analysis across scenarios.

- Canonical: https://finamodel.com/excel-dashboard/hotel
- Excel download: https://finamodel.com/templates/hotel.xlsx

## About this dashboard

Hotel Dashboard connects hospitality operating drivers to property-level financial outcomes. It covers room inventory, occupancy, ADR, and room segments such as Transient, Group, and Contract, alongside F&B, spa, parking, resort fees, and events.

The dashboard presents revenue, departmental expenses, labour and variable costs, GOP, NOI, management fee logic, FF&E reserves, capital expenditure planning, debt service, and exit sensitivity. RevPAR makes the occupancy and ADR relationship visible, while seasonal and market-driven assumptions support normalized performance analysis across operating cases. Departmental reporting keeps the property's operating build connected to its investment outputs and return framework clearly.

Use the outputs for hotel acquisition underwriting, development, renovation or repositioning planning, and asset management. The supporting workbook holds operating assumptions, USALI expense schedules, fee rates, reserve inputs, debt terms, and exit parameters; the dashboard reports the resulting property economics and return analysis for each scenario.

## What's included

- Room revenue by Transient, Group, and Contract segments
- Occupancy, ADR, and RevPAR operating drivers
- F&B, spa, parking, resort fee, and event revenue
- Departmental labour and variable expense schedules
- GOP, NOI, management fees, and FF&E reserve outputs
- Debt service, capex planning, and exit sensitivity

## Frequently asked questions

### Which hotel revenue streams are shown?

The dashboard shows segmented room revenue plus ancillary streams including food and beverage, spa, parking, resort fees, and events. These outputs connect occupancy, ADR, and segment mix to the property's total operating revenue.

### How does the model connect occupancy and ADR?

Occupancy and average daily rate drive room revenue and RevPAR. The dashboard lets you examine their relationship across seasonal and market-driven assumptions, then follow the resulting revenue through departmental margins and property-level profitability.

### What profitability outputs are included?

Outputs include departmental expenses, labour and variable costs, gross operating profit, NOI, management fees, and FF&E reserve deductions. Together they show how hotel-specific operating costs affect the property's financial outcome.

### Does the dashboard include financing and exit analysis?

Yes. It includes debt service, capital expenditure planning, and exit sensitivity analysis. The supporting workbook supplies the financing and exit assumptions, while the dashboard displays their effect on property-level underwriting and returns.

### Can I use it for repositioning or conversion analysis?

Yes. Adjust property type, occupancy, ADR, segment mix, and expense assumptions in the supporting workbook to assess renovation, repositioning, conversion, or other operating scenarios. The dashboard then reflects the revised hotel economics.

## Related dashboards

- [Ecommerce Forecast Dashboard](https://finamodel.com/excel-dashboard/ecommerce)
- [Retail Store Dashboard](https://finamodel.com/excel-dashboard/retail-store)
- [Restaurant Dashboard](https://finamodel.com/excel-dashboard/restaurant)
- [Real Estate Dashboard](https://finamodel.com/excel-dashboard/real-estate)