Free Excel templates

A free gym membership break-even calculator in Excel

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.

Get the calculator

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.

The book behind this calculator

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

What is in the file

Four sheets. Blue type is an input; black type is a formula.

Inputs
Members at the start of the year and annual joins for two tiers; monthly churn and price per tier; enrollment and annual fees; card fees and bad debt; personal training sessions, price and trainer share; classes and instructor fee; retail; the advisor's commission; payroll taxes; fixed costs, marketing, debt service and member distributions.
Calculator
A twelve-month member engine for each tier, billed member-months and average members, ARPM, contribution per member-month, lifetime, lifetime value, CAC and its payback, revenue, contribution, EBITDA, the DSCR, break-even members and the members needed for a DSCR of 1.25, each with a one-line definition beside it.
Read Me
How to replace the case with your own gym, and which inputs to check with your advisers.
Checks
The calculator compared with the figures printed in the book for the case.

Three things to try

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.

Related reading