Hotel Renovation ROI Calculator
Estimates the first-year ROI on a hotel renovation by projecting incremental room revenue against total project cost plus an 8% annual financing charge. Use it when evaluating capital improvement proposals or comparing renovation scenarios.
About this calculator
The calculator measures how much additional annual room revenue a renovation generates relative to its cost. It first computes the incremental revenue per room per day: (newADR × newOccupancy%) − (currentADR × currentOccupancy%). Multiplying that by totalRooms × 365 gives the full-year revenue lift. An 8% financing cost (renovationCost × 0.08) is then subtracted as the annual cost of capital. The resulting net benefit is divided by renovationCost and multiplied by 100 to express ROI as a percentage: ROI = [(totalRooms × 365 × (newADR × newOcc% − currentADR × currentOcc%)) − renovationCost × 0.08] / renovationCost × 100. A positive result means the renovation pays for its financing cost within the first year on incremental revenue alone.
How to use
Suppose a 100-room hotel has a current ADR of $120 and 65% occupancy. After a $500,000 renovation, management projects a 15% ADR increase and a 5-point occupancy gain. New ADR = $120 × 1.15 = $138; new occupancy = 70%. Daily revenue lift per room = $138 × 0.70 − $120 × 0.65 = $96.60 − $78.00 = $18.60. Annual lift = 100 × 365 × $18.60 = $679,200. Financing cost = $500,000 × 0.08 = $40,000. Net benefit = $679,200 − $40,000 = $639,200. ROI = ($639,200 / $500,000) × 100 = 127.8%.
Frequently asked questions
What does a positive hotel renovation ROI percentage actually mean?
A positive ROI means the incremental room revenue the renovation generates exceeds its annualized financing cost within the first year. For example, a 50% ROI means the project returns $0.50 in net benefit for every $1 invested. The higher the percentage, the faster the project recovers its capital outlay through improved rates and occupancy. Most hotel owners target a first-year ROI above 20–30% to justify the disruption of a renovation.
Why does the formula subtract 8% of the renovation cost?
The 8% deduction represents the annual cost of capital—what the hotel pays (or forgoes) to finance the project, whether through a loan or equity. It ensures the ROI reflects a real economic hurdle, not just raw revenue uplift. Without this adjustment, the calculation would overstate returns by ignoring the time value of money. The 8% is a common proxy for a mid-market blended cost of capital; for projects with higher-interest financing, you would want to adjust that rate accordingly.
How should I estimate projected ADR increase and occupancy gain for my renovation?
The best starting point is competitive benchmarking: identify hotels in your market that recently completed similar renovations and compare their pre- and post-renovation STR (Smith Travel Research) data. Brand standards documents often publish expected rate premiums for specific product tiers. As a sanity check, keep ADR increases below 25% and occupancy gains below 10 percentage points for a standard soft-goods renovation; larger structural upgrades may justify higher assumptions. Sensitivity analysis—running the calculator with optimistic, base, and conservative inputs—is strongly recommended before committing capital.