Hotel Break-Even Analysis for Investors: Month 42 Turnaround

Break-Even Metric Cards

Fixed costs $25.0K/mo Base overhead

Contribution margin 94.5%-97.5% After variable costs

Break-even revenue $26.5K/mo Monthly target

Break-even timing Month 42 Plan turn

Break-Even Calculator

Break-even calculator

Test whether monthly revenue covers variable deal costs and fixed overhead.

Lean Base Full

Monthly revenue Revenue must cover variable costs first, then fixed overhead. $ Lower sales Higher sales Variable expenses Include due diligence and investor marketing tied to deal flow. $ Lower costs Higher costs

Money available to cover fixed costs $172,800 $180,000 revenue - $7,200 variable expenses

Margin ratio

96%

Covers fixed costs

Yes

Fixed monthly costs This is the monthly overhead margin has to absorb. $ Lean overhead Higher overhead

Break-even chart Revenue Total costs

Which hotel investment expenses are fixed, and which move with sales?

Cost classification

For this hotel investment model, break-even is only reliable if fixed overhead, revenue-linked fees, and payroll steps stay separate. Blending them can hide why cash bottoms at -$130.575 million in Month 41 before break-even in Month 42.

Expense	Cost	Break-Even Treatment	Common Mistake
Office Rent	Fixed	Use $12,000 per month from Month 1 through Month 60.	Tying rent to hotel sales instead of treating it as base overhead.
Technology & Data Subscriptions	Fixed	Use $4,500 per month as recurring operating overhead.	Scaling subscriptions with revenue without a usage driver in the model.
Legal & Compliance Retainer	Fixed	Use $3,000 per month while the retainer is active.	Mixing recurring legal retainers with one-time entity setup fees.
Transaction Due Diligence Costs	Variable	Apply the revenue-linked rate, falling from 3.5% in the first year to 1.5% in Year 5.	Modeling due diligence as flat overhead when it moves with transaction activity.
Investor Relations & Marketing	Variable	Apply the revenue-linked rate, falling from 2.0% in the first year to 1.0% in Year 5.	Using one flat monthly amount and missing the lower rate in later years.
Travel & Entertainment	Semi-variable	Start with the $2,000 monthly budget, then review against deal activity.	Treating all travel as fixed even when site visits rise with acquisitions.
Payroll	Semi-fixed	Model staffing in steps as roles are added, from $404,000 in first-year annual payroll to $717,000 from Year 3 onward.	Smoothing hires evenly and hiding the Month 13 and Month 19 payroll jumps.
Rented Asset Payments	Fixed	Add fixed monthly rent once each rented property is active: $28,000 for one asset and $22,000 for the other.	Leaving rented properties out of overhead after acquisition starts.

How does break-even shift from lean opening to base stabilization and full stabilization?

Scenario table

Because room count, ADR, and ancillary mix are missing, keep them as user inputs. The table shows when revenue coverage starts to outrun fixed cost, and Month 42 is the first breakeven point.

Planning assumptions only; actual results move with occupancy, ADR, ancillary mix, and deal timing.

Scenario	Monthly Revenue	Variable Costs	Fixed Costs	CM Ratio	Operating Profit	Break-Even Signal
Lean opening	$692k	$38k	$654k	94.5%	-$65.3m	High burn and no cushion before Month 42.
Base stabilization	$999k	$32k	$967k	96.8%	$120.1m	Month 42 is the first clear breakeven point.
Full stabilization	$991k	$25k	$967k	97.5%	$208.6m	Strong cushion, with payback by Month 55.

What breaks the break-even plan for this hotel investment?

Stress test

The plan is fragile early on: Year 3 is still negative EBITDA at about -$10.7M, and the Month 41 cash trough reaches about -$130.6M. A 10% revenue miss, higher fixed costs, or weaker margins each push break-even higher fast.

Stress Case	Changed Assumption	Break-Even Revenue	Revenue Gap	Risk Signal
Current plan	No change.	$1,007k/month	$0 gap	At the edge already, so any miss hits cash fast.
Revenue shortfall	Revenue runs 10% below break-even.	$1,007k/month	$97k gap	A small top-line miss turns into a monthly operating loss.
Fixed-cost pressure	Fixed monthly costs rise 10%.	$1,108k/month	$101k gap	Overhead creep pushes the break-even line up quickly.
Margin pressure	Variable expenses rise from 40% to 60%.	$1,028k/month	$21k gap	Weaker margins eat the cushion even without a revenue miss.
Combined pressure	Revenue falls 10%, variable expenses rise to 60%, and fixed costs rise 10%.	$1,218k/month	$211k gap	That mix creates the sharpest monthly shortfall and cash strain.

Can this hotel portfolio clear break-even before you commit to the first acquisition?

Founder checklist

Not yet, unless you can fund the full ramp through Month 42 breakeven and Month 55 payback. The plan ties up $112M in owned purchases, $50k/month in rent, and $32.65M in build and setup capex before the portfolio turns cash positive.

1Owned Acquisitions$112M

Verify you can close the eight owned properties, because that purchase load lands before operating break-even and drives most of the capital risk.

2Rent Coverage$50k/mo

Confirm the two rented properties can be covered from committed cash or portfolio income, since the monthly rent starts before the model reaches breakeven.

3Project Capex$32.65M

Make sure construction budgets and launch setup spend are fully funded, because the build needs $32.3M and setup capex adds another $350k before revenue can catch up.

4Demand ProofNo room data

Validate occupancy and average daily rate with source data first, because the model gives no room-level demand proof and break-even depends on those assumptions.

5Payroll Ramp$40.4k→$71.7k/mo

Lock the staffing plan before hiring, since monthly payroll rises from about $40.4k in Year 1 to about $71.7k by Year 3 as the team expands.

6Downside Cash-$130.6M

Keep downside funding ready through the $130.6M minimum cash point, because losses still need to be carried until Month 42 breakeven and Month 55 payback.