Hospitality financial analysis by property

Hospitality financial analysis compares room demand, property contribution and cash needs in the same reporting period. Start with room-night records and departmental ledger exports, then explain why the operating result did or did not become cash. A high room rate alone cannot show whether a property is performing well.

Match the operating and finance exports

Use one property ID across the room-night report, revenue ledger, departmental expenses and cash schedule. Keep service dates separate from payment dates. A group event deposit received this month may relate to a later stay, while a completed stay can remain unpaid after checkout.

Bring available room nights, sold room nights, room revenue and revenue by other department. Match payroll, supplies and other costs to the same period. Keep undistributed property costs separate from departmental costs so a restaurant result does not change merely because a corporate allocation moved.

The room measures have distinct denominators:

Occupancy = Sold room nights / Available room nights

ADR = Room revenue / Sold room nights

RevPAR = Room revenue / Available room nights = Occupancy × ADR

These definitions appear in Hilton's published operating measure explanations. Apply one consistent policy for rooms removed from available inventory, and disclose renovations or closures when comparing properties.

Calculate two properties from the same rows

The example is a US hotel group reviewing one 30-day month. No rooms are removed from inventory. Put the following layout on a sheet named Operating: labels in column A, Harbor in B and Mesa in C. The header occupies row 1.

Enter these Excel formulas in column B and copy across to C:

B4 = B2*B3
B11 = SUM(B6:B7)
B12 = B11-SUM(B8:B9)
B13 = B12-B10
B14 = B5/B4
B15 = B6/B5
B16 = B6/B4

Microsoft's formula overview describes cell references, operators and copying relative references. Covirage is not affiliated with Microsoft.

Harbor sells more of its available room nights. Mesa achieves a higher ADR, but its lower occupancy leaves RevPAR slightly below Harbor's. The identity checks both: 70.0% × 150.00 = 105.00 and 65.0% × 160.00 = 104.00.

Total property revenue is $714,600, and property contribution is $242,600. These are the sums of the property amounts. For group occupancy, divide combined sold room nights by combined available room nights; never take an unweighted average of property percentages. The broader financial analysis method uses the same rule: compare totals on matching bases.

Bridge contribution to cash

Property contribution here excludes depreciation, income taxes and interest. The expense rows use accrued period expenses; working capital adjustments convert those expenses and earned revenue to cash. The example has no tax or interest payments and no other operating balance movements. Capital spending is paid in the month; debt payments below are principal only. A real cash schedule needs additional rows whenever those assumptions do not hold.

Create a sheet named Cash with the same property columns:

Use these formulas in B, copied across:

B3 = Operating!B13
B7 = B3-B4-B5+B6
B10 = B7-B8-B9
B11 = B2+B10

Mesa's negative payable movement means it paid down supplier balances, which uses cash. Its bridge is 99,600 - 18,000 - 2,000 - 3,000 - 25,000 - 14,000 = $37,600. Harbor's bridge is 143,000 - 12,000 - 3,000 + 5,000 - 35,000 - 18,000 = $80,000.

The group proof is opening cash of $140,000 plus net movement of $117,600 equals closing cash of $257,600. Tie closing cash to the relevant cash accounts. The SEC's financial statement guide explains why operating profit and cash differ, including adjustments for noncash items and operating balances.

Amounts in these tables are whole dollars except room-rate measures, which show cents; occupancy shows one decimal place. Calculations use the underlying values before display rounding.

Turn the comparison into operating questions

Ask the property manager whether Mesa's lower occupancy reflects fewer bookings, unavailable rooms or deliberate pricing choices. Ask the departmental leaders whether their staffing and supply costs match the business served. Ask finance to explain receivable growth and the timing of capital payments before changing cash plans.

Keep the discussion at whole-property level. Detailed cost allocation deserves its own review. A property can improve room pricing while its restaurant contribution or cash collection weakens, so a single revenue measure cannot replace the combined view. The working capital guide explains the balances behind the cash bridge; hospitality analytics provides the wider operating context.

Where it goes wrong

• Including restaurant revenue in ADR. Room-rate measures use room revenue; other departments need separate lines.
• Changing available inventory silently. Renovation and closure policies can move occupancy without changing bookings.
• Mixing deposits with earned revenue. Payment timing and the date of the stay answer different questions.
• Calling contribution cash. Receivables, supplier payments, capital work and debt principal can change liquidity after the operating result.

Compare your property workbook in Covirage

Bring your room-night report, property finance workbook and cash schedule; Covirage maps the columns, and its tools compute and check the figures. The external AI model explains property differences with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See Covirage for hospitality for the supporting industry workflow.