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 totals.

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
—
Built from the color-coded Assumptions (Fixed + Trainer + Loan + PT payout if PT is enabled).
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 Summary (steady-state)

Scenario Steady members Annual revenue Annual cost Annual profit Total profit (Years 2–7)

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