Cash Flow Forecast Template for Gyms

Gyms and fitness studios run on memberships, which makes income feel predictable, until the January sign-ups have left by March and the summer lull arrives. Rent, trainer pay and equipment finance don’t change with the season. A cash flow forecast built on member numbers, churn and dues shows how much of the new-year surge needs to be kept for the quieter months.

Why gym cash flow is different

• Membership is the engine. Revenue is members times average dues, so churn matters as much as sign-ups.
• January is huge, summer is quiet. New-year sign-ups can be several times a normal month, and many cancel within three months.
• Equipment is financed. Treadmills, racks and studio fit-outs usually mean years of fixed monthly payments.
• Rent is large. Gyms need a lot of space, and rent is often the biggest fixed cost after staff.
• Secondary income helps. Personal training, class packs and retail add margin but vary more.

A worked example

A gym starts October with 700 members paying an average of $55 a month. It signs up about 45 members a month, more in January, and loses 3.5 percent each month.

Membership income grows, but churn takes back a large share of every month’s sign-ups: at 3.5 percent a month, about 35 percent of members leave each year. Every point of churn you save is worth more than an extra marketing campaign, and the forecast shows exactly how much.

How to build a gym cash forecast

1. Start with current members and average monthly dues.
2. Forecast new members by month, with a January peak.
3. Apply monthly churn to the member base.
4. Add class packs, personal training, retail and joining fees.
5. Add trainer pay, rent, equipment finance, utilities, cleaning and software.
6. Keep a buffer to cover the summer dip.

Common mistakes

Forecasting new sign-ups without churn. Treating annual memberships paid up front as monthly income. Forgetting equipment finance continues after a quiet month. And launching new classes without a cost plan.

What the template gives you

The Gym & Fitness Studio template includes a Memberships tab that calculates members and membership income from sign-ups, churn and average dues, with a seasonal pattern for the January rush. Change churn by one point and see its effect on the whole year.

Key assumptions built into the Gym & Fitness Studio template

• The Memberships tab builds “Memberships” from members: 700 at the start, new members each month, 3.5% leaving each month and an average of $55 per member per month. It shows members lost, members at month end and revenue, so you can see exactly what a change in churn is worth.
• 5 cash in lines and 7 cash out lines are already named for gym & fitness studio businesses, and every one can be renamed or extended.
• The example figures follow a typical gym & fitness studio year, busiest in January and February and quietest in December and July, so the tight months show up where they usually fall.

Every assumption sits in a yellow input cell, so you replace the example with your own numbers in minutes. The same figures flow through a 13-week weekly view, a 12-month monthly view and a 3-year outlook, and a dashboard shows your lowest balance, the weeks that fall below your minimum buffer and your cash runway.

Free or premium?

If you only need the basics, the free 12-month template or the free 13-week template will get you started today. The premium Gym & Fitness Studio template saves the setup time and adds the tabs above, best and worst case scenarios, and an actual vs forecast tracker that shows where your forecast was wrong, so next month’s is better.

Gym & Fitness Studio cash flow forecasting: questions

What is a typical churn rate for gyms?

Many gyms lose 3 to 5 percent of members a month, which adds up to 30 to 50 percent a year. Boutique studios with strong communities often do better.

How should a gym forecast January sign-ups?

Use last year’s January as a base, then apply your normal churn with extra early cancellations in February and March.

Should equipment finance be in a gym’s cash flow forecast?

Yes. It’s a fixed monthly payment for years, so it must be covered in the quietest months as well as the busiest.