How to project gym revenue
Gym revenue is made up of three streams that behave differently: the recurring membership base, the auxiliary income from personal training and drop-in classes, and ancillary sales (supplements, retail, corporate wellness). Each has different price elasticity, seasonality and margin. Projecting only the base MRR — as most Excel templates do — leaves 25%-40% of revenue outside the model and distorts cost planning.
Gym base MRR = Active members × ARPM (average revenue per member per month)
The trick is in "active members". It is not the total enrolled base: it is those who paid the monthly fee this month. The gap between enrolled and active memberships at an average Mexican gym runs 18%-24% — almost a quarter of your theoretical base is not paying.
ARPM: the metric that replaces list price
ARPM (average revenue per member) integrates real monthly payments, not list price, and is below the headline rate. Reasons: freezes, corporate discounts, family plans, partial dropout (members who pay one month, miss two, come back on the fourth), failed card charges. A gym that advertises USD 70/month typically operates with ARPM of USD 56-62.
ARPM = Total monthly membership revenue ÷ Active members for the month
Example: urban boutique gym with 280 active members, list price USD 105, actual month revenue USD 27,200. ARPM = USD 97 — 8% below the headline. Use historical ARPM, not the new price, to project.
Monthly churn: the metric that explains why March always hurts
Monthly churn = Cancellations in the month ÷ Active members at the start of the month × 100
IHRSA (International Health, Racquet & Sportsclub Association) benchmark: healthy monthly churn big-box gym 4%-6%, boutique 2.5%-4%. Translated to annual, median US attrition rate is 28.6%. A Mexican gym with 7% monthly churn loses half its base every 10 months.
The compound effect is what surprises new owners. Gym with 300 members and 7% churn: month 1 loses 21, month 2 loses 19 (on 279), month 3 loses 18. After 6 months without acquisition, the base falls to ~197. If monthly acquisition equals churn (21-22 new), the base stagnates; if lower, it bleeds out slowly. Most owners do not know their real churn and assume the base maintains itself.
Member LTV: what each enrollment is actually worth
LTV = (ARPM × gross margin) ÷ Monthly churn
Example: boutique studio with ARPM USD 97, gross margin 62% (after prorated rent, coach fees and amenities), 4% monthly churn. LTV = (97 × 0.62) ÷ 0.04 = USD 1,504. If your CAC (cost of acquisition per member) is USD 224 — ads + first-session promo + prorated sales staff — your LTV/CAC ratio is 6.7x. Any ratio above 3x is healthy; 1x-3x signals inefficient acquisition; below 1x is unsustainable.
How to calculate your 12-month projection step by step
- Capture initial base. Active members month 0, current ARPM, monthly ancillary income (PT + retail + drop-in classes).
- Estimate real monthly churn. Calculate on the last 6 months. Do not use the neighbor gym owner's number — your churn depends on your onboarding program, price mix and group-class capacity.
- Estimate monthly acquisition. Net new enrollments (not gross). Pro tip: 30%-40% of January "enrollments" cancel in the first 45 days; use net new.
- Apply seasonality. January +35% acquisition, February-March normal, April-June -5% to -10%, July-August -15% (vacation), September +20% (back-to-school), October-November normal, December -20%.
- Project monthly compounding. Base(t+1) = Base(t) + acquisition(t) − churn(t)% × Base(t). Carry month by month.
- Sum streams. Membership MRR + PT revenue (compute as % of active members who take PT × average ticket) + retail sales + corporate.
- Model scenarios. Optimistic (churn −1pp, acquisition +15%), realistic (historical), pessimistic (churn +2pp, acquisition −10%).
Revenue mix: not everything is membership
Average US gym — IHRSA 2025 benchmark: 68% memberships, 14% personal training, 8% retail/supplements, 6% drop-in classes, 4% corporate wellness. Typical boutique CrossFit: 80% memberships, 12% retail, 8% events and nutrition coaching. The owner who ignores PT leaves 15%-20% of revenue on the table; the one who pushes PT above 25% of total cannibalizes retention (members who only take PT without membership eventually churn).
Revenue per square meter: the benchmark no one watches
It is the toughest operational KPI to compare across models. Conventional big-box: USD 50-82 / m² / month. Boutique studio LatAm: USD 130-280 / m² / month. Smart Fit franchises in LatAm optimize the big-box with aggressive revenue per m²: large spaces, low price (USD 29-70/month), very high member density per m² (7-12 vs 3-5 in traditional conventional). The boutique competes on margin, not on volume.
Real LatAm seasonality
The "January fills the gym, March empties it" myth is partially true but oversimplified. Virtuagym and Mindbody LatAm 2024-2025 data: January +30%-40% acquisition vs baseline, 90-day retention of the January cohort is 52%-58% (worse than other months); September +15%-22% acquisition with 90-day retention of 68%-72% (best cohort of the year). July-August drop acquisition 15%-25% but lift PT through summer classes. December drops 20%-30% across the board. A useful model does not just adjust acquisition: it adjusts cohort retention by entry month.
2025 benchmarks by segment
- Conventional / big-box LatAm (Smart Fit, Sports World, Bodytech). 500-2,500 members per unit, ARPM USD 32-56, monthly churn 5%-7%, annual revenue per unit USD 470K-2.05M.
- Boutique studios (CrossFit boxes, HIIT, Pilates, yoga). 80-220 members, ARPM USD 88-165, churn 3%-4.5%, annual revenue USD 175K-470K.
- Independent neighborhood gyms. 150-400 members, ARPM USD 41-65, churn 6%-8%, annual revenue USD 88K-265K.
Break-even: how many members you need
Break-even members = Monthly fixed costs ÷ (ARPM × contribution margin)
Example urban boutique HIIT: rent USD 2,820 + coach payroll USD 4,410 + admin USD 880 + software/marketing USD 705 + utilities USD 470 = USD 9,290 monthly fixed spend. ARPM USD 115, contribution margin 72% (after variable cost per delivered class). Break-even = 9,290 ÷ (115 × 0.72) = 112 active members. Any base below operates at a loss; above that, each additional member contributes USD 83 of direct margin.
Mistakes that kill margin
- Unlimited freezes. A frozen member does not pay but occupies a locker and stays on the system. A policy without a cap turns 15%-20% of the base into zombies. Apply a maximum of 60 days per year with a symbolic monthly fee.
- Empty group classes. A class with 2 people costs the same as one with 15. Monitor class utilization (attendees ÷ capacity). If it drops below 45% over 60 days, consolidate.
- Unstructured PT. Selling single sessions without prepaid packages kills coach LTV and member repurchase. Packages of 10-20 sessions with expiration.
- Fixed price for a year without review. Inflation in Mexico 2024-2025 was 4.5%-6%. A gym that does not raise ARPM annually compresses margin ~2% each year.
- Not measuring churn. Most independent gym owners do not know their exact monthly churn. Without that number, every projection is fiction.
Excel template vs interactive model
The downloadable template solves a static calculation of current MRR and fails in projection. It does not model compound churn, does not adjust for cohort seasonality, does not separate streams, does not simulate the impact of a 2-point churn drop on 12-month ARR. An interactive model that carries churn and acquisition month by month, compares three scenarios and shows the moving break-even is the difference between having a number to show the banker and having real visibility on whether your gym is growing, holding or bleeding out.