Members, joins, monthly churn, prices and costs in; ARPM, contribution per member-month, member lifetime, lifetime value, CAC, EBITDA, the debt service coverage ratio and break-even members out. No macros.
The file comes prefilled with Corvane Athletic Club, the fictional gym of the book, for 2025: two membership tiers, an ARPM of $65.86, a contribution of $58.75 per member-month, a member lifetime of 25.8 months, a lifetime value of $1,518.53 against a CAC of $148.63, EBITDA of $402,587, a DSCR of 1.32, and a break-even of 1,716 average members against 2,188 needed for the covenant.
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.
Gym_Membership_Break_Even_Calculator.xlsx (21 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
This file is the one-page summary of The Gym Owner. The book explains every line: why members come before dollars, the one way to state churn, why a price increase can lower lifetime value, what a join really costs, what a personal training session leaves the club, why the busiest hour sets the ceiling, and how the year is planned to the bank covenant.
DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide
Four sheets. Blue type is an input; black type is a formula.
Add half a point of monthly churn. Lifetime shortens, lifetime value falls and the average member count drifts down month after month; watch how quickly the headroom over the covenant line disappears.
Raise the price and the churn together. A higher price lifts ARPM at once; a little more churn takes it back over the year. The calculator shows which effect wins for your inputs.
Replace the case. Type your own members, prices and costs over the blue cells. If a line does not make sense, the definition beside it says what it measures.