Gym ROI Model (Year 1 + Years 2–7) — ramp + scenarios + PT toggle

Includes: scenario ramp, member-based revenue, trainer + owner share, loan payment, PT toggle, and Years 2–7 detail.

Assumptions & Toggles

Bad
Slow acquisition / weaker differentiation; lower steady membership by Month = ramp months.
Base
Reasonable opening cohort + steady growth; operational stability by Month = ramp months.
Optimistic
Strong branding + execution; faster capture, higher steady membership, leverage on fixed costs.
Ramp-up months: months to move linearly from “Start members” (Month 1) to “Target members” (Month = ramp). After ramp, membership stays at target for the rest of Year 1.
Fixed costs
Loan inputs
Trainer/owner inputs
PT inputs (if enabled)

Outputs (Dashboard)

Loan Monthly loan payment
—
Amortizing payment (principal + interest).
Fixed Trainer Loan Total monthly operating cost
—
Includes fixed costs + loan + trainer payroll (group) + PT trainer payout (if PT enabled).
Avg people / group class (derived)
—
Uses selected scenario’s average monthly member revenue (ex-PT), divided by an implied net price per attendee, then divided by classes/month.
Cost / group class & Profit / group class
—
Cost/class = group-only monthly cost ÷ classes/month. Profit/class = group-only monthly profit ÷ classes/month (ex-PT).
Selected scenario — Year 1 profit
—
Sum of monthly profits over 12 months.
Selected scenario — ROI on equity (Year 1)
—
Year 1 profit ÷ equity investment.

Scenario ramp (start → target)

Scenario Start members Target members Description
Bad Lower capture; tests downside with same cost base.
Base Reasonable opening cohort + 6-month ramp.
Optimistic Fast capture; strong operating leverage.

Year 1 Summary (all scenarios)

Scenario Avg members Year revenue Year cost Year profit ROI (equity)

Years 2–7 Detail (steady-state, per year)

Scenario Year Steady members Cost / month Profit / month Total cost / year Total profit / year
Total (selected scenario) —
Years 2–7 assume steady-state membership = scenario target members and steady costs = current monthly operating cost.

Monthly P&L (selected scenario)

Month Members Revenue Cost Profit
Revenue = members × net rev/member + (PT revenue if enabled).
Cost = fixed costs + loan payment + trainer payroll (group classes + PT trainer payout if enabled).
PT pricing note: PT modeled as 15,000 HUF net revenue per session. Trainer payout is 8,000 HUF per session. Owner share reduces PT payout (owner-run sessions keep payout inside business).

Calculation Reference (auditable formulas)

This section describes how each computed value is calculated. It’s meant to be reviewed independently. Values update live when inputs change.

Core calculations (cost + revenue engines)
Computed cell Formula / Logic Current value
Scenario ramp calculation (members per month)
Computed cell Formula / Logic Current value
For month m (1..12), with start S, target T, ramp months R: members(m) = S + (T-S) * (m-1)/max(R-1,1) if m ≤ R, else T.
Year 1 + Years 2–7 calculation
Computed cell Formula / Logic Current value