Group Class Fitness Studio Financial Model

Description

This financial model is built from the ground up for a group class fitness studio, where revenue is driven by a detailed weekly class schedule rather than a static membership base. Unlike generic templates that rely on average revenue per member, this model lets you define class types, time slots, instructor assignments, and room capacities to project occupancy and income from memberships, drop-in guests, and class packs. It accounts for the complex interplay between membership tiers (unlimited, limited, off-peak) and their usage patterns, ensuring the unit economics of each class are accurately reflected.

The model captures the operational realities of running a studio: instructor payroll is linked directly to classes taught per pay period, with flexible pay rates per class type and instructor. Variable costs respond to headcount (towels, cleaning), while fixed costs include rent, utilities, software, and marketing. Investment structure is fully modeled, covering leasehold improvements, equipment, pre-opening marketing, and initial working capital, with debt and equity financing options. A ramp-up curve and seasonal indices adjust attendance month by month to avoid the trap of uniform growth.

For decision-makers, the model delivers actionable outputs: break-even at the class level and per instructor, capacity utilization alerts, cash flow waterfall, and a full set of integrated financial statements (P&L, cash flow, balance sheet). It goes well beyond a simple template, letting you answer questions like 'How many classes do I need to sell at $20 drop-in to cover rent?' or 'What membership mix maximizes margin?' The approximate investment size falls in the small-business range (typically $125k–$1.25M), but actual figures will depend on your specific assumptions.

Modeling specifics

• Class schedule constructor with configurable time slots, class types, duration, instructor assignment, and room capacity — not just a one-line revenue assumption.
• Occupancy-based revenue projection: member bookings are constrained by membership tier usage limits and class capacity, while drop-in and pack purchases fill remaining spots, reflecting real booking dynamics.
• Detailed membership module with tiered plans (unlimited, limited visits per period, off-peak only), churn rates, and auto-renewal logic.
• Drop-in and class pack modeling including breakage (non-use), expiration, and deferred revenue recognition for accurate cash and P&L.
• Instructor payroll engine that varies directly with classes taught, supporting per-class rates, minimum guarantees, and subbing logic.
• Overhead allocation by floor area and per-class metrics to derive true class-level profitability and break-even.
• Ramp-up and seasonality curves applied to attendance at the class level, preventing over-optimistic first-year projections.
• Integrated debt and equity financing with flexible drawdowns, repayment, and covenant tracking — not an afterthought.

What's included in the base version

• Class schedule builder with room and instructor assignment
• Membership & class pack revenue engine (drop-in, pack, tiered memberships)
• Instructor payroll calculator linked to schedule
• Operating expense module (fixed, variable, semi-variable)
• Capex, pre-opening costs, and working capital
• Financing module (loan, equity, interest during construction)
• Integrated 5-year financial statements (P&L, cash flow, balance sheet)
• Break-even dashboard and unit economics per class/instructor

Common modeling mistakes

• Assuming uniform class attendance across all time slots — occupancy is overestimated for off-peak hours, inflating revenue by 15–30%.
• Modeling total members × average visits without restricting by membership tier limits — class attendance can be overstated by 20–40%, especially when unlimited members book disproportionately.
• Treating instructor payroll as a fixed monthly salary — the variable nature of pay-per-class costs is missed, distorting gross margin by 3–7 percentage points.
• Ignoring no‑show and late‑cancellation rates — effective class fill rate is inflated by 5–10%, leading to overstatement of drop‑in revenue and understatement of capacity requirements.
• Recognizing all revenue from class pack sales immediately — cash flow and balance sheet are skewed, and EBITDA is artificially high in early months due to unearned revenue.
• Overlooking seasonality and a gradual marketing ramp-up — first‑year revenue can be overestimated by 20–30%, making break‑even appear 4–8 months earlier than realistic.