Children's Training Pool Financial Model

Description

This model is built specifically for a stand‑alone children’s training pool – a dedicated swim school with a small, purpose‑built teaching pool, not a leisure centre. It translates the pool’s physical dimensions, lane configuration and operating hours into a granular class schedule, enforcing strict child‑to‑instructor and child‑to‑lifeguard ratios mandated by safety standards. Revenue comes from group courses, private lessons and package sales, all paced by realistic enrolment build‑up rather than an instant full house.

The demand engine is driven by month‑by‑month enrolment curves that reflect the sharp seasonality typical of children’s activities: back‑to‑school peaks, summer drop‑offs and holiday lulls. Drop‑out rates are modelled by age group and course type, while make‑up lessons and package expiry are tracked as a deferred revenue liability, preventing the common mistake of treating every sold lesson as immediate earned income. Capacity utilisation dashboards show exactly where a lane can absorb more students or where staffing becomes the bottleneck.

On the cost side, pool‑specific operating expenses are modelled from first principles – water heating, chemical dosing, filtration runtime and air handling are driven by pool volume, bather load and ambient temperature, not just a percentage of revenue. Staffing costs are automatically generated from the class timetable and mandated ratios, covering instructors, lifeguards and front‑desk. CAPEX covers pool shell construction, plant equipment, changing rooms and initial fit‑out. The model delivers a fully integrated 3‑statement forecast with scenario manager, so you can stress‑test assumptions without building a new workbook.

Modeling specifics

• Lane‑based capacity engine – slots classes into pool lanes by day, time and session length, capped by pool dimensions and operating hours, so utilisation is physics‑constrained, not a flat assumption.
• Dynamic instructor and lifeguard staffing – calculates required headcount per half‑hour based on the number of children in the water and legally required ratios (e.g. 1:4 for under‑4s, 1:6 for older), driving payroll costs by qualification level.
• Seasonal enrolment curves – month‑by‑month adjustment factors for new registrations, allowing a realistic ramp‑up and capturing back‑to‑school surges, summer camps and holiday troughs.
• Make‑up lesson and package expiry tracking – models the liability of unused lessons and the deferred revenue balance, preventing cash‑flow and profit overstatement from pre‑sold packages.
• Drop‑out probability modelling – age‑group‑specific monthly attrition rates reduce effective lesson sales over the course duration, reflecting real retention patterns.
• Pool utility cost model – water heating, pump electricity and chemical consumption calculated from pool volume, bather load, target water temperature and seasonal ambient conditions, not a fixed % of revenue.
• Facility utilisation dashboard – visualises lane occupancy, maximum theoretical throughput vs. actual bookings and instructor constraints, highlighting capacity bottlenecks before they appear in the numbers.

What's included in the base version

• Revenue module: group courses, private lessons, drop‑ins, lesson packages and seasonal camps
• Staffing module: instructors, lifeguards and admin headcount driven by the class schedule and ratios
• Operating expense module: pool chemicals, heating, electricity, water, maintenance, insurance, marketing and rent
• CAPEX schedule: pool shell, filtration plant, HVAC, changing rooms, initial equipment and pre‑opening costs
• Financing module: flexible debt/equity structure with drawdowns, interest and principal repayments
• Monthly 3‑statement model: P&L, cash flow and balance sheet fully integrated
• Key financial and operational dashboards with visual KPIs
• Scenario manager: base, best and worst case with toggle‑driven assumption changes

Common modeling mistakes

• Assuming pool lanes are fully booked every session year‑round – overstates lane utilisation by 25–45% and inflates gross revenue.
• Ignoring legally mandated child‑to‑instructor ratios – understates instructor headcount by 30–50%, leading to a serious payroll underestimation.
• Treating all course fees as earned at enrolment, neglecting make‑up lessons and unused packages – overstates recognised revenue and cash position.
• Modelling utility costs as a fixed percentage of revenue rather than from pool volume and heating load – underestimates operating costs in cold months by 20–35%.
• Omitting seasonal enrolment drop‑off during long school holidays – overstates Q1 and Q3 enrolment by 15–30% and distorts cash‑flow timing.