Built for your next decision. Editable Excel models. Free calculators & guides.Models from €49 incl. VAT
FREE HOTELS CALCULATOR

RevPAR Calculator

Calculate room revenue per available room from ADR and occupancy.

Your assumptions

INDICATIVE RESULT
€126
Annual room revenue per available room€45,990

Calculated directly from the assumptions shown.

Continue in the full model.

Move from this screening result to the complete Hotel Acquisition Model.

Get the model · €69 incl. VAT
FORMULA

How the RevPAR calculation works

RevPAR = ADR × occupancy.

Example calculation

€180 ADR at 70% occupancy produces €126 RevPAR.

INVESTMENT USE

How professionals use the result

Use RevPAR to compare room-revenue productivity. It excludes F&B, other revenue and operating costs.

Common mistakes

  • Entering occupancy as 70 rather than 70% in a spreadsheet formula
  • Comparing net and gross ADR
  • Ignoring rooms out of service
  • Treating RevPAR as profit
FREE EMBED

Embed this calculator on your website.

FormulaPlanet branding and a source link remain visible.

<iframe src="https://formulaplanet.nielsen1983.chatgpt.site/calculators/revpar-calculator?embed=1" title="RevPAR Calculator" width="100%" height="720"></iframe>
CLEAR ANSWERS

RevPAR Calculator FAQs

What does the RevPAR calculator measure?

Calculate room revenue per available room from ADR and occupancy.

What formula does the RevPAR calculator use?

RevPAR = ADR × occupancy.

Is the result suitable for a final investment decision?

Use it as a transparent screening calculation. Validate deal-specific tax, timing, financing and legal assumptions in a complete underwriting model before making a decision.

Do I need an account?

No. The calculator is free and runs in your browser. FormulaPlanet does not store your projects, inputs or results.

Is any input sent publicly?

No calculation is public by default. A shareable link is only created when you explicitly choose to copy one; that link contains the assumptions shown in its URL.

Why might my spreadsheet give a different answer?

Differences usually come from timing, compounding, sign conventions, fees or a different definition of the numerator or denominator. Match every period and definition before comparing.

What should I review alongside this result?

Use RevPAR to compare room-revenue productivity. It excludes F&B, other revenue and operating costs.

Which mistakes are most common?

Entering occupancy as 70 rather than 70% in a spreadsheet formula; Comparing net and gross ADR; Ignoring rooms out of service; Treating RevPAR as profit.

STAY ONE STEP AHEAD

New models. Useful insights.
Offers worth opening.

Get FormulaPlanet news, new releases and promotions in your inbox.