Test the price, capacity and costs behind your gym & fitness center. Explore the online worksheet previews alongside calculations from the current illustrative business case.
6 online worksheet illustrations, described below
Opening budget, scenario assumptions and dashboard views
Five-year forecast and separate operating break-even sensitivity
Editable Excel product with assumptions and formulas
The online preview illustrates 6 planning sections using this website's scenario. These illustrations are separate from the downloadable workbook.
01Acquisition, trials and paid activationsUses the verified E12 subscription-cohort engine for a full-service urban membership gym: marketing and acquisition assumptions create trial and direct-paid starts, then trial cohorts convert after the selected delay.Explore layout ↓
02Membership tiers, churn and recognized revenueAllocates paid activations across membership tiers, trial conversions, direct-paid starts and retained subscriber cohorts, carries prior cohorts after churn and applies the matching price plus separately supported usage or additional revenue.Explore layout ↓
03Member capacity and service deliveryBridges active membership to floor area, exercise-machine mix, accessible routes, peak visits, class places, trainer hours, lockers, cleaning, maintenance and emergency coverage, with visit patterns, peak use, classes, training, cleaning and equipment downtime visible rather than treating every member as simultaneous demand.Explore layout ↓
04Direct costs, staffing and operating expensesSeparates trainer or instructor payouts tied to add-ons, payment fees, member supplies, refunds and other revenue-linked costs, paid payroll and fixed facility overhead so member contribution and complete operating coverage remain visible.Explore layout ↓
05Startup uses, funding and scenariosSchedules fitness build-out, equipment, locker rooms, access systems, studios, amenities and reserve, working capital and financing, then compares low, base and high acquisition, conversion, churn, price, contribution and fixed-cost paths.Explore layout ↓
06Statements and dashboardConnects subscriber cohorts, revenue layers, direct cost, payroll, operating expense, capital and funding schedules to five-year statements, cash flow, balance sheet, KPIs and a management dashboard.Explore layout ↓
Explore the online worksheet illustrations
Open each online sheet presentation to read its specification and illustration. These web views are not screenshots or downloadable Excel files.
Gym & Fitness CenterPlanned XLSX
EBITDA = Revenue − operating costs
Illustrative workbook layout · annual USD
Income statement
Year 1
Year 2
Year 3
Revenue
$900,000
$1,350,000
$1,800,000
Training payouts, payment fees, member supplies and revenue-linked costs
$162,000
$229,500
$270,000
Paid management, front-desk, fitness, instruction, cleaning and maintenance payroll
$620,000
$670,000
$720,000
Rent, utilities, insurance, software, marketing, repairs and overhead
$560,000
$590,000
$620,000
EBITDA
−$442,000
−$139,500
$190,000
EBITDA margin
-49.1%
-10.3%
10.6%
Planned presentation, not a completed file. Costs are shown as positive outflows; EBITDA excludes interest, tax, depreciation and amortization.
01Acquisition, trials and paid activationsWorksheet specification
Acquisition, trials and paid activations
Planned purpose: Uses the verified E12 subscription-cohort engine for a full-service urban membership gym: marketing and acquisition assumptions create trial and direct-paid starts, then trial cohorts convert after the selected delay.
Inputs
Marketing spend
Customer acquisition cost
Trial share and duration
Trial conversion
Direct-paid starts
Launch timing
Outputs
Leads and trials
Paid activations by cohort
Acquisition cost and conversion
Limits and completion needs
Spend divided by CAC is an assumption-driven funnel, not proof that qualified prospects or conversions exist.
Membership marketing, consent, renewal, freeze, cancellation, refund and collection terms must match current federal, state and local requirements and the actual member contract.
02Membership tiers, churn and recognized revenueWorksheet specification
Membership tiers, churn and recognized revenue
Planned purpose: Allocates paid activations across membership tiers, trial conversions, direct-paid starts and retained subscriber cohorts, carries prior cohorts after churn and applies the matching price plus separately supported usage or additional revenue.
Inputs
Starting members
Tier mix
Tier prices
Churn or lifetime
Usage and setup revenue
Refunds, freezes and failed payments
Outputs
Active members by cohort and tier
Subscription MRR
Additional operating revenue
Limits and completion needs
The public average recognized revenue per active billed member is a readable blend; the workbook must retain tier, cohort and revenue-layer detail.
Do not count a member again as both a retained subscriber and a new activation or count training, usage and setup revenue in both tier price and additional revenue.
03Member capacity and service deliveryWorksheet specification
Member capacity and service delivery
Planned purpose: Bridges active membership to floor area, exercise-machine mix, accessible routes, peak visits, class places, trainer hours, lockers, cleaning, maintenance and emergency coverage, with visit patterns, peak use, classes, training, cleaning and equipment downtime visible rather than treating every member as simultaneous demand.
Inputs
Visits per member
Peak and off-peak shares
Equipment and room capacity
Class and trainer schedule
Downtime and closures
Outputs
Peak utilization
Service capacity
Crowding and coverage gaps
Limits and completion needs
Active members do not prove that the premises can absorb peak visits or deliver promised services.
Access, cleaning, maintenance, accessibility, class setup and safety reduce usable capacity.
04Direct costs, staffing and operating expensesWorksheet specification
Direct costs, staffing and operating expenses
Planned purpose: Separates trainer or instructor payouts tied to add-ons, payment fees, member supplies, refunds and other revenue-linked costs, paid payroll and fixed facility overhead so member contribution and complete operating coverage remain visible.
Inputs
Revenue-linked cost
Roles and headcount
Pay rates and employer burden
Facility expenses
Maintenance and replacement policy
Outputs
Direct cost
Monthly payroll
Operating expense and coverage
Limits and completion needs
National occupation data do not set local offers or a complete employer burden.
Front desk, floor, instruction, cleaning, maintenance, emergency, sales and management duties must be assigned.
05Startup uses, funding and scenariosWorksheet specification
Startup uses, funding and scenarios
Planned purpose: Schedules fitness build-out, equipment, locker rooms, access systems, studios, amenities and reserve, working capital and financing, then compares low, base and high acquisition, conversion, churn, price, contribution and fixed-cost paths.
Inputs
Opening uses
Equipment and build-out timing
Reserve policy
Debt and equity
Scenario multipliers
Outputs
Sources and uses
Cash runway
Funding gap
Break-even and sensitivity
Limits and completion needs
The StartFigures allocation is not a property, equipment, contractor, insurer or lender quote.
Debt service, tax, deposits, installation timing and replacement capital require a dated cash schedule.
06Statements and dashboardWorksheet specification
Statements and dashboard
Planned purpose: Connects subscriber cohorts, revenue layers, direct cost, payroll, operating expense, capital and funding schedules to five-year statements, cash flow, balance sheet, KPIs and a management dashboard.
Inputs
Selected scenario
Billing and collection timing
Financing
Tax assumptions
Opening balances
Outputs
P&L
Cash flow
Balance sheet
Dashboard and ratios
Limits and completion needs
Outputs inherit every funnel, cohort, price, churn, usage, cost, funding and collection assumption.
A forecast does not certify demand, retention, accessibility, safety or profitability.
Ways to prepare your files
Template
Current product · Shopify checkout
Edit the financial model with your own assumptions.
Define the revenue drivers, operating modules, outputs and review criteria before agreeing the work.
Project quote · Schedule agreed with you
Assumptions you can change
These are the current inputs behind the business case and the intended starting points for the editable workbook. Range endpoints represent modeled scopes or sensitivities, not measured national averages.
Gym & Fitness Center input assumptions · USD unless stated
Driver
Base input
Scenario range / treatment
Role in the calculation
Recognized revenue per active member per open day
$4.13
$3.00 – $5.75
Revenue per sold unit
Active billed members represented each open day
1,200
750 – 1,800
Daily throughput in the stated operating scope
Operating days per week
7
6 – 7
Trading schedule
Fixed operating costs / month
$111,667
Held constant
Operating break-even threshold
Contribution margin
85.0%
Held constant
Share of sales available for fixed costs
Starting share of mature volume
30.0%
Base ramp input
Opening month revenue
Mature volume added / month
4.0%
Base ramp input
Monthly ramp increment, capped at mature volume
Ramp horizon
18 months
Base ramp input
Period checked for operating break-even
The opening budget and annual expense inputs also need local quotes and staffing estimates. This page shows fixed examples; the free calculator lets you change price, volume and trading days.
Volume-only sensitivity · revenue at mature volume · monthly USD
Scenario
Daily units
Monthly revenue
Break-even revenue
First operating break-even
Lower volume
750
$93,772
$131,373
Not reached
Base volume
1,200
$150,035
$131,373
Month 16
Higher volume
1,800
$225,052
$131,373
Month 9
Only active billed members represented each open day changes. Recognized revenue per active member per open day: $4.13; 7 operating days per week. Fixed costs and contribution margin stay constant. “Not reached” means no operating break-even within the 18-month ramp. This sensitivity is separate from the annual forecast and does not measure cash payback.
Sample outputs from the current case
These results are calculated from the website’s illustrative assumptions. They demonstrate intended workbook topics, not a tested Excel file.
01 / Annual forecast
Revenue across five years
$900k
Year 1
$1.4m
Year 2
$1.8m
Year 3
$2.1m
Year 4
$2.4m
Year 5
Annual USD. Full values appear in the Dashboard presentation.
02 / Opening allocation
Where the opening budget goes
Leasehold, flooring, electrical, HVAC, fire and accessibility work$500,000
Strength, cardio, functional and group-fitness equipment$450,000
Locker rooms, showers, plumbing and member amenities$180,000
Studios, recovery area, furniture and storage$110,000
Access control, security, network, software and audio$60,000
Design, permits, professional fees and pre-opening$100,000
Deposits, opening supplies, hiring and launch marketing$50,000
Working capital and contingency reserve$400,000
One-time budget: $1,850,000. This allocation is not a cumulative cash-flow forecast.
03 / Operating earnings
Year 3 costs and EBITDA
Against annual revenue of $1,800,000.
Training payouts, payment fees, member supplies and revenue-linked costs$270,000
Paid management, front-desk, fitness, instruction, cleaning and maintenance payroll$720,000
Rent, utilities, insurance, software, marketing, repairs and overhead$620,000
EBITDA$190,000
EBITDA margin: 10.6%. EBITDA is not cash available to the owner.
04 / Operating threshold
Volume needed to break even
Required whole units per day
1,051
Break-even revenue / month
$131,373
Base revenue / month at maturity
$150,035
First operating break-even
Month 16
Units mean active billed members represented each open day. The ramp covers 18 months; operating break-even does not measure recovery of opening capital.
The annual forecast and fixed-cost sensitivity are separate planning views. The website does not yet supply a complete funding, debt, tax and working-capital schedule for a cumulative cash-flow or payback chart. Read the full input basis and limitations.
Annual forecast and calculator comparison
The annual forecast and calculator use separate scenarios. Their revenue ramp or cost allocations differ, as shown below. The calculator's break-even month does not reconcile the annual forecast.
Original base inputs · USD per year
Check
Annual forecast
Calculator inputs
Year 1 revenue
$900,000
$936,215
Year 1 operating result
−$442,000
−$544,221
Year 3 / mature annual operating result
$190,000
$190,348
Calculator figures use the original first 12 months and mature monthly result × 12; sliders do not change this comparison. Neither column measures cash flow or payback. Input basis.
Both products in one cart
Model + Business Plan
Write the strategy and test the assumptions for your gym & fitness center together. Update the narrative when you change the forecast.
The Business Plan uses Word and the Financial Model uses Excel. The online illustrations use this website's scenario data and may differ from the purchased files.
File format
XLSX
Editor
Microsoft Excel
Editing
Input cells, forecast assumptions and formulas; workbook behavior still needs verification.
Other software
Compatibility with alternative editors has not been verified.
Delivery and terms
Review the product description, delivery details, license and final total in Shopify before paying.
Use the purchase button to buy the Gym & Fitness Center Financial Model for $109 through Shopify. This is a one-time price in USD before any applicable taxes.
What do the online previews show?
The online preview explains Acquisition, trials and paid activations, Membership tiers, churn and recognized revenue, Member capacity and service delivery, Direct costs, staffing and operating expenses, Startup uses, funding and scenarios, Statements and dashboard using this website's illustrative case. It is separate from the downloadable Excel model.
Are these previews pages from a finished file?
The web previews are rendered from the website's case record. They illustrate planning concepts and calculations; they are not screenshots or a page-by-page inventory of the downloadable product.
What would I need to change for my business?
Review recognized revenue per active member per open day, active billed members represented each open day, the operating schedule, opening budget and costs. These web previews do not edit a workbook. Test the website's price and volume assumptions in the business idea page's calculator.
Is the written business plan included?
The Financial Model is sold separately. The $168 Bundle adds the $59 Business Plan and $109 Financial Model for the same business to one cart, one of each.
Do the figures establish what my business will earn?
No. The figures describe an illustrative U.S. operating case, not measured industry averages or a prediction for your location. EBITDA is not owner cash, and operating break-even does not recover the opening investment. Check local costs, capacity and demand before using the assumptions.
