Acquire Signups
New signups equal marketing spend divided by CAC, then split between free-trial and direct-paid starts.
This editable five-year Gym Financial Model links acquisition, trials, subscriber tiers, churn, pricing, costs, and scenarios to integrated financial statements and dashboard outputs.
Use it to test how marketing spend, conversion, plan mix, churn, pricing, usage, fees, staffing, and operating costs shape the gym forecast.
Editable assumptions flow through monthly calculations into revenue, expenses, cash flow, balance sheet, scenario comparisons, and management reporting.
The model links marketing-driven signups to trial conversion, direct-paid activation, tier allocation, churn, subscription pricing, and enabled non-subscription revenue layers.
New signups equal marketing spend divided by CAC, then split between free-trial and direct-paid starts.
After the trial-duration lag, earlier trial cohorts convert using the trial-to-paid rate and join direct-paid activations.
Paid activations are allocated across membership tiers, then combined with prior subscribers after subtracting churn.
Active subscribers generate tier MRR, while enabled usage, setup fees, boxes, and add-ons contribute additional recognized revenue.
Monthly recognized revenue sums subscription and enabled non-subscription layers; annual revenue sums the monthly amounts.
The Revenue worksheet organizes acquisition, free trials, paid activation, tier mix, churn or lifetime, pricing, setup fees, and usage assumptions.
REVENUE
The COGS & OPEX worksheet separates direct costs, variable expenses, and fixed operating expenses across the five-year forecast.
COGS & OPEX
The Scenarios view compares Low, Base, and High cases across revenue, margins, EBITDA, and selected operating assumptions over the five-year forecast.
SCENARIOS
The Dashboard combines scenario controls, core financials, revenue mix, profitability, cash flow, payback, and selected operating metrics in one management view.
DASHBOARD
It fits subscription-led gym plans using these cohort, pricing, churn, and reporting mechanics; materially different revenue structures may need custom modeling.
The template is a planning starting point, not a guarantee of performance.
Financial Models Lab can build or adapt a model when you need different revenue logic, operating schedules, or financial reporting.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive the editable Gym Financial Model as an instant download for use in Excel or Google Sheets.
Change the model's planning assumptions and inputs to reflect your gym plan.
Review 60 months of projected operating and financial performance.
Compare Low, Base, and High cases across key model outputs.
Review the P&L, cash flow statement, balance sheet, dashboard, and summary outputs.
The essential answers are visible in full, with no accordion clicks required.
Revenue starts with marketing-driven signups, trial and direct-paid activation, plan allocation, active subscribers after churn, tier pricing, and enabled usage, setup, box, or add-on revenue.
You can edit launch timing, marketing spend, CAC, trial mix and duration, conversion, plan mix, starting subscribers, churn or lifetime, tier prices, usage, setup fees, and enabled add-on assumptions.
You can compare Low, Base, and High cases across selected assumptions and resulting revenue, gross margin, contribution margin, EBITDA, and other model outputs.
The workbook shows the P&L, cash flow statement, balance sheet, Dashboard, Summary, Scenarios, Break-Even, ROIC, Charts, KPIs, and additional reports visible in the product gallery.
Yes. Financial Models Lab offers custom financial modeling when you need different revenue logic, operating schedules, or reporting structure.
It is a planning forecast based on editable assumptions, not a guarantee of financial or operating performance.
This downloadable gym financial projection template for Excel includes everything you need to build a complete financial plan for your new fitness center.
Core inputs and core outputs
Three scenario analysis
Presentation ready
DuPont analysis
Researched revenue assumptions
Lender-friendly financial outputs
Revenue stream detailed view
Performance metrics benchmark
This template made margins and break-even easy to see in one place, so I could spot the weak spots fast. It saved me hours of manual checks and gave me a cleaner plan to discuss with my team.
I finally understood what investors wanted to see and how to structure the numbers. That clarity helped me finish the model faster and book a meeting without second-guessing the format.
I’m not strong in advanced Excel, and this kept the model simple to use. The layout helped me build a full forecast without hiring extra help, and I finished it in one afternoon.