Skip to content

Lesson 05 · 15 min read

Underwriting and Valuing a Hotel

Build a hotel pro forma from room nights, occupancy, and ADR through NOI after reserve, then value it by income capitalization, price per key, and replacement cost, with the PIP deducted from price.

Underwriting a hotel means rebuilding its operating statement line by line, in your own assumptions, and then asking what a buyer should pay for the result. The seller's numbers are a starting point. Your pro forma is the answer.

This lesson builds a full pro forma for a hypothetical 110-key select-service hotel in Kissimmee: rooms revenue from available room nights, occupancy, and ADR, then other revenue, departmental and undistributed expenses, Florida property tax and windstorm insurance, the management fee, and the FF&E reserve. It then values the hotel three ways and shows why the PIP belongs in the price. The structure follows Hotel Metrics and the Hotel Operating Statement, and the general method follows Pro Forma vs. Actuals.

Education, not tax or investment advice. Every number in this lesson is illustrative. Confirm property tax treatment with a property tax consultant or CPA, and current market pricing with an appraiser and lenders.

Start with the T-12, then normalize

Ask for the trailing twelve months (T-12) and the prior two or three years, all by month and by department. Then adjust for items that will not continue under your ownership:

  • Self-management. If the seller manages the hotel and shows no management fee, add a market fee. A buyer who hires a manager pays one, and a buyer who self-manages is still giving up time worth paying for
  • Owner compensation and perks. Remove the seller's personal expenses, and add the cost of a general manager if the seller filled that role unpaid
  • Deferred maintenance. If repairs and maintenance look low, check whether work was skipped. Add it back to expense or to capital needs
  • Insurance. Get a current quote for your coverage, not the seller's renewal from last year
  • Property taxes. Reprice them to your purchase price (see below)
  • One-time revenue. Remove insurance proceeds, one-time group business, or a storm recovery bump
  • Franchise fees. Use the new franchise agreement the buyer will sign, not the seller's older terms

The T-12 and Normalized NOI covers this process for other property types. The difference with hotels is that every line moves with operations, so normalizing takes more judgment.

Build rooms revenue from the ground up

Rooms revenue is the largest number in the pro forma and the one most worth questioning.

Set your occupancy and ADR assumptions from evidence:

  • The hotel's own monthly history, by segment
  • The STR comp set trend for the same months
  • Known changes in demand, such as new attractions or the loss of a contract
  • New supply opening nearby
  • The effect of the PIP or a brand change

Do not assume the hotel will immediately jump to the top of its comp set because you plan to run it better. If you expect improvement, model it as a ramp over two or three years and show a case where it does not happen.

Other revenue, then expenses

Other revenue in a select-service hotel is usually small: a market or pantry, parking, meeting rooms, vending, and miscellaneous fees. Base it on history, not on percentages from another hotel.

Departmental expenses. Rooms department expense is mostly labor (housekeeping, front desk), plus laundry, guest supplies, and travel agent and online booking commissions. Model labor from a staffing plan if you can: how many housekeepers per occupied room, how many front desk shifts, at local wage rates. Labor markets in tourism-heavy Central Florida can be tight, so check current wages with the manager.

Undistributed expenses. Model administrative and general, technology, sales and marketing, franchise fees, maintenance, and utilities. Utilities in Florida are driven by air conditioning, so older PTAC units can make this line higher than in newer hotels.

Management fee. Use the base fee in the management agreement you will sign, as a percentage of total revenue.

Florida property tax

Florida counties assess real property, and hotels also file a tangible personal property return for furniture and equipment. Two points to underwrite:

  • Reassessment after a sale. Florida caps annual assessment increases on non-homestead property, but the cap generally resets after a change of ownership. The property appraiser can look at your purchase price. Underwrite taxes on what you are paying, not on the seller's assessed value
  • Business value. Part of a hotel's price reflects the going business and personal property. Valuation for tax purposes can be contested, which is a question for a property tax consultant or attorney

Insurance, including windstorm

Insurance is often the most volatile fixed charge for a Florida hotel. Get a real quote early covering property (including named storm or windstorm), flood if the site is in or near a flood zone, general liability, liquor liability if alcohol is served, and business interruption. Named-storm deductibles are often stated as a percentage of insured value, which can mean a large out-of-pocket cost in a storm. Lenders set minimum coverage, so share the quote with your lender.

FF&E reserve

Deduct a reserve for replacement of furniture, fixtures, and equipment, as a percentage of total revenue. Use the percentage your loan, franchise, or management agreement requires, or a reasonable market assumption if none applies. A reserve is not optional just because the seller did not fund one.

Worked example: a 110-key select-service in Kissimmee

Illustrative numbers. Not market data. These figures show the method, not what any hotel in Kissimmee earns or sells for.

Rooms revenue

  • Keys: 110
  • Available room nights: 110 × 365 = 40,150
  • Occupancy: 72%, so rooms sold = 40,150 × 0.72 = 28,908
  • ADR: $135, so rooms revenue = 28,908 × $135 = $3,902,580
  • RevPAR: 0.72 × $135 = $97.20 (check: $3,902,580 ÷ 40,150 = $97.20)

Stabilized pro forma

LineAmountBasis
Rooms revenue$3,902,580Above
Other revenue$150,000Market, parking, fees
Total revenue$4,052,580
Rooms department expense$975,64525% of rooms revenue
Other departmental expense$75,000
Departmental profit$3,001,935
Franchise fees$390,25810% of rooms revenue, new agreement
Administrative and general$360,000
Information and telecom$80,000
Sales and marketing$160,000Excluding franchise fees
Property operation and maintenance$190,000
Utilities$200,000
Total undistributed$1,380,258
Gross operating profit$1,621,67740.0% margin
Base management fee$121,5773% of total revenue
Property and TPP taxes$170,000Repriced to purchase price
Insurance, including windstorm$240,000Current quote
EBITDA$1,090,100
FF&E reserve$162,1034% of total revenue
NOI after reserve$927,997

Check the subtotals: $4,052,580 − $1,050,645 = $3,001,935. Then $3,001,935 − $1,380,258 = $1,621,677. Then $1,621,677 − $121,577 − $170,000 − $240,000 = $1,090,100. Then $1,090,100 − $162,103 = $927,997.

Method 1: income capitalization

Divide NOI after reserve by a capitalization rate.

The cap rate must come from current sales of comparable hotels: similar service level, brand quality, age, and location, analyzed on the same NOI-after-reserve basis. Hotel cap rates are typically higher than those on net lease property because of the risks in Lesson 1, and they move with interest rates and lending conditions. For a discussion of how local hotel cap rates are evaluated, read How to Evaluate Hotel Cap Rates in Orlando and Hotel and Motel Cap Rates in Central Florida. Then confirm current levels with an appraiser and recent closed sales.

Illustrative: at an 8.0% cap rate, $927,997 ÷ 0.08 = about $11,600,000, or about $105,455 per key.

Because the rate is uncertain, show a range:

Illustrative cap rateValue before PIPLess PIP and disruptionNet value
7.5%$12,373,293$1,904,000$10,469,293
8.0%$11,599,963$1,904,000$9,695,963
8.5%$10,917,612$1,904,000$9,013,612

A half-point change in the cap rate moves value by well over half a million dollars here. That is why the cap rate assumption must be supported by real comparables.

Put the PIP in the price

The brand's change-of-ownership PIP in this example is priced at $16,000 per key, or $1,760,000. The renovation will also take rooms out of service.

Estimating disruption. Suppose the room renovation runs 150 days with an average of 18 rooms out of service:

  • Room nights out of service: 150 × 18 = 2,700
  • Room nights that would have sold at 72% occupancy: 2,700 × 0.72 = 1,944
  • Lost rooms revenue: 1,944 × $135 = $262,440
  • Lost profit, assuming 55% flow-through (the hotel saves housekeeping and supplies on rooms it cannot sell): about $144,000

Total PIP-related deduction: $1,760,000 + $144,000 = $1,904,000.

At the 8.0% illustrative cap rate, the stabilized value is $11,600,000 (rounded), but a buyer who must also fund the PIP should pay no more than about $9,696,000. Rounded, the maximum offer is $9,700,000, or about $88,182 per key. The total investment after the PIP is $11,460,000, or about $104,182 per key.

Ramp-up after the PIP

A fresh renovation can lift ADR and occupancy, but often not right away. Brand inspections, online reviews, and booking patterns take time to catch up. Model the post-PIP improvement as a ramp and treat it as upside. A price that only works if the renovation produces a large RevPAR gain is a price that depends on a forecast.

Method 2: price per key

Price per key is the sale price divided by the number of rooms. It is the hotel industry's quick comparison metric, similar to price per square foot in other property types.

Use it as a check, not as the main method:

  • Compare only with hotels of similar service level, brand tier, age, and location
  • Note whether the comparable sold before or after a PIP
  • Remember that two hotels at the same price per key can have very different profits

In the example, $9,700,000 ÷ 110 = about $88,182 per key as-is, or about $104,182 per key after the PIP. If recent local select-service sales of similar age and brand sit far above or below those figures, find out why before you decide which number is wrong.

Method 3: replacement cost

Replacement cost asks what it would take to build a comparable new hotel today: land, construction, FF&E, soft costs, financing, and the time and risk to open and ramp up. Developers, appraisers, and contractors can estimate it.

Illustrative: if building a comparable new select-service hotel nearby would cost $185,000 per key all in, then an all-in basis of about $104,182 per key is well below new construction. That does not prove the hotel is a good buy. It does suggest that new competitors would need much higher rates to justify building, which offers some protection against new supply.

If your basis is close to or above replacement cost, ask why you would not build new instead, and expect that someone else might.

Why revenue multiples mislead

Some sellers price hotels as a multiple of revenue, such as "three times revenue." It sounds simple. It ignores the expense structure.

Illustrative: two hotels each earn $4,052,580. One runs a 40% GOP margin and the other a 30% margin, because of higher labor, older systems, and higher insurance. At three times revenue, both would be priced near $12,160,000. Yet the second hotel produces about $405,000 less GOP a year (10% of revenue). Revenue multiples treat a well-run hotel and a poorly run hotel as equal. Value comes from NOI after reserve.

Sensitivity and stress tests

Before you finalize a price, change one assumption at a time and watch the value:

  • Occupancy down 5 points
  • ADR down 5% to 10%
  • Insurance up sharply at renewal
  • Labor costs up
  • PIP over budget, or longer disruption
  • Exit cap rate higher than entry

If a modest change wipes out your return, the deal is tighter than it looks. Lesson 6 runs the same hotel through a lender's sizing tests.

Common underwriting mistakes

  1. Capitalizing EBITDA instead of NOI after reserve
  2. Leaving property taxes at the seller's assessed value
  3. Using last year's insurance premium
  4. Ignoring the PIP or counting it as optional
  5. Underwriting a ramp-up as if it were certain
  6. Comparing price per key across different service levels
  7. Accepting a revenue multiple as a valuation

What to take away

  • Normalize the T-12: add a management fee, reprice taxes and insurance, remove one-time items
  • Rooms revenue = available room nights × occupancy × ADR
  • Model expenses by department and support labor assumptions with a staffing plan
  • Florida's non-homestead assessment cap generally resets after a sale, so underwrite taxes on your price
  • Get a real windstorm and property insurance quote early
  • Deduct an FF&E reserve before capitalizing
  • Value = NOI after reserve ÷ a cap rate supported by current comparable sales
  • Deduct the PIP and renovation disruption from stabilized value
  • Use price per key and replacement cost as checks, not as the main method
  • Revenue multiples ignore margins and mislead

Next lesson: Financing Hotels in Florida.

Get Market Insights Delivered

Weekly Central Florida CRE updates — cap rates, new listings, market trends, and investment opportunities. No spam, unsubscribe anytime.