Separating hotel room revenue from other departmental revenue for lender review
Hospitality lenders need to see hotel revenue broken into separate departments—rooms, food and beverage, banquet, and other income—because the risk and stability of each stream differ. This guide explains how to prepare a departmental revenue schedule that matches how lenders underwrite hotel loans, including how to handle unallocated and fixed expenses.
Hospitality lenders need to see hotel revenue broken into separate departments—rooms, food and beverage, banquet, and other income—because the risk and stability of each stream differ. This guide explains how to prepare a departmental revenue schedule that matches how lenders underwrite hotel loans, including how to handle unallocated and fixed expenses.
When a lender reviews a hotel loan request, the revenue picture is not just one number. Hotel operations generate income from multiple sources, and each behaves differently. A lender will want to see room revenue separated from food and beverage, banquet, and other departmental income because the risk profile, volatility, and expense structure of each stream are distinct. A single blended revenue figure can hide weakness in one department or mask the true performance of the rooms business.
Why departmental revenue matters to a lender
Full-service hotels derive a significant portion of their income from non-room-related activities such as banquet and food and beverage [1]. A lender reviewing a hotel loan needs to understand which parts of the business are driving income and which are consuming expense. Separating revenue by department allows the lender to apply different underwriting assumptions to each stream, compare departmental performance to industry benchmarks, and identify trends that a combined figure would obscure. Hotel operations can be complex and may have a sizable non-real estate component, which makes departmental analysis useful for a lender to assess the property's true income-generating capacity [1].
What to prepare: a departmental revenue and expense schedule
A suggested first step is to build a schedule that shows the trailing twelve months of revenue and expense broken into three categories: rooms, other operating departments, and undistributed expenses. For each month, record the following:
- Rooms revenue: total room revenue, average daily rate (ADR), occupancy percentage, and revenue per available room (RevPAR). The ADR should be calculated by dividing room revenue by the number of rooms occupied for a given period, excluding complimentary rooms or other occupancies that do not generate revenue [1]. RevPAR is calculated by multiplying ADR by the occupancy rate [1].
- Other operating departments: food and beverage, banquet, telephone, internet, parking, and any other revenue-generating department. Record both revenue and directly attributable expenses for each department.
- Undistributed expenses: management fees, franchise fees, sales and marketing, repairs and maintenance, and any other costs not directly attributable to a single department [1].
- Fixed expenses: real estate taxes and insurance, recorded separately as fixed costs [1].
This schedule should be prepared for the trailing twelve months (T-12) and also as a summary for the most recent fiscal year. The lender will use this to compare the property's performance against industry benchmarks and to test the reasonableness of the operating history [1].
How to show seasonality in departmental revenue
Hotel revenue is often seasonal, and the lender will want to see how each department performs across the year. A suggested way to present this is to include a month-by-month breakdown in your T-12 schedule, with a note identifying peak and off-peak periods for each department. For example, banquet revenue may spike in December, while rooms revenue may peak in summer. Showing this pattern helps the lender understand the property's cash flow cycle and assess whether the debt service coverage is adequate during lower-revenue months.
Reconciling the departmental schedule with other financial statements
The departmental revenue and expense schedule should reconcile to the property's overall profit and loss statement. A suggested way to do this is to prepare a summary reconciliation that shows total revenue from all departments, total direct expenses, total unallocated expenses, total fixed expenses, and net operating income (NOI). This allows the lender to see that the departmental detail matches the aggregate financial statements and that no revenue or expense has been double-counted or omitted. If the property uses a different reporting basis (for example, cash basis for internal management), identify the basis and reconcile any timing differences between the T-12 and the rent roll or other financial reports.
Preparing for lender questions on departmental revenue
A lender reviewing a hotel loan will likely ask about the following, based on industry practice:
- What is the current and historical profitability of each department?
- How does each department's performance compare to industry benchmarks?
- What is the quality and reputation of the management team?
- What is the franchise agreement, including its duration and termination rights?
- What is the age and condition of FF&E, and what are the replacement needs?
- What is the revenue seasonality, and how does it affect cash flow?
- What is the proximity to transportation and demand generators such as office and recreational facilities?
Having the departmental schedule prepared in advance allows you to answer these questions with specific data rather than estimates.
Evidence checklist for a hotel loan request
Use this checklist to confirm you have the key documents and schedules ready before submitting a hotel loan request to a lender:
- [ ] Trailing twelve months (T-12) departmental revenue and expense schedule, with rooms, other operating departments, unallocated expenses, and fixed expenses shown separately
- [ ] Monthly ADR, occupancy, and RevPAR calculations for the T-12 period
- [ ] Summary reconciliation showing total revenue, total expenses, and NOI for each of the trailing twelve months and the most recent fiscal year
- [ ] Franchise agreement with duration and termination rights noted
- [ ] Management agreement, if applicable
- [ ] FF&E schedule with age, condition, and replacement reserve history
- [ ] Property tax and insurance expense records
- [ ] Industry benchmark comparison for key metrics (occupancy, ADR, RevPAR, departmental margins)
- [ ] Seasonality analysis showing peak and off-peak revenue months by department
- [ ] Reconciliation of the departmental schedule to the property's overall financial statements, noting the reporting basis
How this affects the financing discussion
A lender uses the departmental revenue breakdown to assess the stability and risk of the income stream. A property that relies heavily on a single department, such as rooms, may be more vulnerable to market downturns than one with diversified revenue from food, beverage, and banquet operations. Conversely, a property with high non-room revenue may have higher operating expenses and require more specialized management. By preparing a clear departmental schedule, you give the lender the information needed to underwrite the loan accurately and to offer terms that reflect the property's true risk profile.
Do I need to separate revenue by department if my hotel is limited service and has minimal food and beverage?
Yes. Even limited-service hotels should show room revenue separately from any other income, such as vending, parking, or meeting space rentals. Limited-service hotels offer no or limited food service and limited meeting space, but any non-room income should still be reported in a separate department [1].
Should I include complimentary rooms or staff occupancy in the ADR calculation?
No. The ADR calculation should exclude complimentary rooms or other occupancies that do not generate revenue [1]. Only revenue-generating room nights should be counted.
How do I handle franchise and management fees in the departmental schedule?
These should be recorded as unallocated expenses, not assigned to any single department. Typical expenses not directly attributable to a department, such as management, franchise, sales and marketing fees, and repairs and maintenance, are recorded as unallocated expenses [1]. The lender will apply standard underwriting assumptions to these costs.
We prepare the loan request, take it to the lenders suited to the property and the plan, and negotiate the terms through closing. Send us the property, the business plan, and the capital you need, and we will tell you how we would approach it.
Run the numbers on your deal
Try your own NOI, value and lender tests to see which one limits the loan: DSCR, LTV or debt yield.
Talk through your financing
Working on a real property? Send us the deal and a financing advisor will review it and get back to you. It costs nothing to ask and does not commit you to anything.
Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).