Swimming School Financial Model

Description

Unlike a generic fitness center model, a swimming school operates under strict safety ratios, lane-level capacity constraints, and pool water management. This model precisely maps class schedules to pool zones (lanes, shallow/deep ends) and instructor availability, ensuring every session respects real-world operational limits.

Revenue logic deconstructs the business into multi-week term enrollments, drop-in passes, private coaching, lane rentals to clubs, and ancillary streams such as swim camps and birthday parties. Seasonal demand curves drive heating and chemical costs, while a built-in driver calculates water evaporation and replacement rates, tying directly to utility expenses.

The model accommodates both asset-light operations in a leased pool and full facility ownership, with a detailed CAPEX module for pool construction, locker rooms, and equipment. Investment scales from a few hundred thousand dollars to several million, reflecting real spend ranges (illustrative orders of magnitude, not final values).

Modeling specifics

• Hourly lane scheduling engine linked to class size limits and instructor availability (toddler, kids, adult ratios differ).
• Seasonal attendance curves that cascade into monthly water heating, chemical dosing, and staffing requirements.
• Water treatment OPEX modeled on pool volume, bather load, and local evaporation rates, not a single flat monthly figure.
• Dual financial path: lease model with step-rent clauses vs. owned facility with construction depreciation and maintenance reserves.
• Instructor recruitment timelines tied to enrollment growth, preventing blanket headcount assumptions that ignore certification lead times.
• Revenue mix builder that handles session-based enrollments with multi-week proration, drop-in passes, and lane rental agreements simultaneously.

What's included in the base version

• Revenue model with class, pass, rental, and pro-shop streams
• Capacity-driven scheduling engine allocating lane-time by program type
• Instructor & lifeguard staffing planner with ratio logic and certification tracking
• Comprehensive OPEX: pool chemicals, water heating, pool maintenance, utilities, rent/lease
• CAPEX builder for pool fit-out or construction, including locker rooms and FF&E
• 3-statement financial model (P&L, cash flow, balance sheet) on a monthly 5-year timeline
• Scenario toggle: Lease vs. Own facility with automatic depreciation and interest schedules
• Sensitivity tables on key drivers (lane utilization, average tuition, staff cost, chemical prices)

Common modeling mistakes

• Failing to insert buffer times between half-hour sessions for lane clearance and instructor rotation — inflates achievable class count and revenue by 15–25%.
• Using a flat annual attendance rate without seasonal modulation — distorts cash flow timing and can underestimate peak-period staffing needs by up to 30%.