Editable Gym Financial Model in Excel

Five-year projections, dashboard, P&L, cash flow, balance sheet, and three scenarios - pre-built in Excel and Google Sheets. Built for gym planning. Delivered as an instant download.
Gym Financial Model - overview header showcasing the model
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Gym Financial Model - overview header showcasing the model's key sections and purpose, summarizing KPIs, runway and performance at a glance to prevent cash-flow blind spots and support investor-ready presentations
Industry Benchmarks
Projected balance sheet
Capital expenditure plan
Capitalization table
Cash flow forecast
Financial charts
COGS & Operating expense forecast
Financial model dashboard
DuPont analysis
Projected income statement
Payroll forecast
Financial ratio analysis
Return on invested capital analysis
Revenue forecast
Financial scenario analysis
Sources and uses of funds
Financial model summary
Top expense analysis
Top revenue streams
Business valuation analysis
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Gym Bundle
See included products:
Financial Model iGym Bundle Financial Model template included in this product.
$149 $109
ADD TO YOUR ORDER
Business Plan iGym Bundle Business Plan template included in this product.
$79 $59
Pitch Deck iGym Bundle Pitch Deck template included in this product.
$49 $29
YOU SAVE $0 TODAY
30-Day Money-Back Guarantee
Created by a Former CFO
Updated for 2026
One-Time Purchase
Description

The Gym Financial Model is an Excel template that connects paid memberships, inclusive package prices, operating expenses and staffing to financial projections. Its illustrative 2026–2030 operating case shows how a growing member base changes revenue and EBITDA.

The planning case covers an independent, leased 8,000-square-foot suburban U.S. club in existing fitness premises. It excludes a pool, sauna, childcare, retail and franchise operations; the assumptions are estimates without a site-specific lease.

Forecast
5years
Membership packages
5exclusive packages
Club area
8000square feet, estimated
WORKBOOK CONTENTS

Editable Inputs Connect Memberships to Financial Reports

The workbook links gym operating assumptions with monthly calculations, financial statements and decision reports.

Revenue & Calc

Edit annual-average paid members, exclusive package shares, monthly prices and launch timing to build monthly revenue by package and annual sales totals.

COGS & OPEX and Payroll

Plan revenue-linked costs, monthly fixed spending and role-based FTE separately to understand how membership growth absorbs rent, staffing and other overhead.

CAPEX, CapTable & Debt

Schedule investment and owner contributions, then use Dashboard debt controls and Debt schedules for financing assumptions entered by the user; this case assumes no committed non-owner funding.

Statements and management reports

IS, CF, BS and Summary connect profitability, cash flow and financial position; Dashboard, Scenarios and Returns support comparison and investment review without establishing additional numerical results for this illustration.

MEMBERSHIP REVENUE

One Member Pool Drives Five Inclusive Packages

Revenue equals paid member months multiplied by each exclusive package share and its inclusive monthly price.

Annual-average paid membership rises from 450 in 2026 to 600, 720, 820 and 900 in subsequent years. Each member month belongs to one package, so coaching and personal training are not duplicated as additional revenue.

The January 31, 2026 launch activates the full calendar month without daily proration, giving 12 active months in 2026. Annual averages step up by forecast year, with no selected monthly seasonality or independent capacity ceiling.

Estimated membership mix and inclusive monthly prices
Package Member-month share Monthly price
Open Gym 35% $39
Gym and Classes 35% $59
All Access 20% $79
Small Group Coaching 7% $129
Personal Training 3% $249

Shares total 100%; the weighted average monthly price is $66.60.

Revenue Forecast

The Revenue Forecast connects membership demand, package mix, prices and launch timing to monthly sales. Adjust these inputs to compare the revenue effect of recruiting more members, changing the mix or revising prices.

gym financial model revenue fml30
Illustrative 2026 membership revenue

450 average paid members × $66.60 per member month × 12 active months = $359,640 annual revenue.

COSTS AND STAFFING

Separate Revenue-Linked Costs From Fixed Staffing

Direct and variable costs scale with revenue, while monthly overhead and fixed base salaries remain separate.

Estimated COGS includes hygiene supplies at 1.2%, exercise accessories at 0.5% and purchased laundry at 0.8% of revenue. Payment and billing fees at 3.4% and performance marketing at 4% are variable operating expenses.

Fixed costs cover rent, utilities, insurance, software, cleaning, maintenance, administration and other facility charges. Rent and common area charges begin at $12,000 per month; total fixed operating expenses increase from $215,400 in 2026 to $242,435 in 2030.

COGS and Operating Expenses

The COGS & Operating Expense Forecast organizes direct, variable and fixed costs into monthly spending. Reviewing these categories against membership revenue helps assess how much additional sales contribute toward payroll, facility overhead and EBITDA.

gym financial model cogs opex fml30
Estimated annual-average staffing and fixed annual base pay
Role 2026 FTE 2030 FTE Annual base / FTE
General manager 1 1 $62,000
Member services 1.5 2 $34,000
Fitness coaches 1 1.75 $48,000
Group fitness instructors 0.4 0.6 $42,000

FTE measures full-time-equivalent staffing, not a count of individual employees.

Payroll Forecast by Staff Role

The Payroll Forecast converts role-level FTE and salaries into personnel expenses. Annual base payroll rises from $177,800 in 2026 to $239,200 in 2030, with salaries recorded once through Payroll and excluded from COGS and other operating expense categories.

gym financial model payroll fml30
STARTUP AND FUNDING

Opening Funding Covers More Than Equipment

Estimated initial owner funding of $499,302 covers the startup budget, opening working capital and a three-month first-year cash-outflow reserve.

Capital Expenditure Plan

The Capital Expenditure Plan schedules asset purchases and depreciation. Specified startup budgets include $90,000 for strength equipment, $80,000 for cardio equipment, $100,000 for leasehold improvements and $15,000 for group training equipment, with access hardware and reception furnishings also included as asset categories.

gym financial model capex fml30

Separate opening cash items include refundable lease and utility deposits, permits, legal formation, launch marketing, preopening training and base pay, preopening rent and utilities, and website setup. These startup allocations are distinct from annual operating expenses and operating earnings.

Sources and Uses of Funds

The Sources and Uses of Funds report reconciles cash sources with operating, investment and financing uses over selected forecast months. Use it to review how planned owner contributions and any separately entered financing support cash allocation.

gym financial model sources uses fml30
ILLUSTRATIVE RESULTS

Membership Growth Turns EBITDA Positive in 2027

The estimated 2026–2030 case shows revenue rising as membership expands, with a first-year operating loss followed by positive EBITDA.

Illustrative annual operating forecast, nominal USD
Year Revenue Operating Expenses EBITDA
2026 $359,640 $428,804 −$69,164
2027 $479,520 $469,734 $9,786
2028 $575,424 $508,485 $66,939
2029 $655,344 $525,352 $129,992
2030 $719,280 $552,843 $166,437

Illustrative projections, not observed results or industry averages; amounts are rounded to whole dollars.

Operating expenses include COGS, variable expenses, fixed overhead and payroll. The member ramp improves EBITDA while staffing and facility costs remain in place; the 2027 positive result does not establish a specific monthly break-even date.

EBITDA is not net profit or available cash. Depreciation, interest, taxes, capital purchases, working-capital movements and financing require their respective statement calculations before assessing investor returns or liquidity.

Cash Flow Forecast

The Cash Flow Forecast presents operating, investing and financing movements with an opening-to-closing cash reconciliation. Use it to examine purchase timing, owner contributions and cash collection separately from the EBITDA forecast shown here.

gym financial model cf fml30
DECISION SUPPORT

Compare Operating Coverage, Payback and Investment Returns

Returns and scenario tools help evaluate distinct operating and investment questions using the assumptions entered in the workbook.

Dashboard Low, Base and High multipliers adjust revenue, COGS, variable expenses, fixed expenses and payroll. Compare their effect on revenue, margins and EBITDA to examine how softer membership revenue or higher staffing costs change operating performance.

Break-Even, Payback and ROIC

The Return on Invested Capital Analysis combines sales break-even, cash break-even, investment payback and annual ROIC. Sales break-even assesses operating cost coverage, cash break-even identifies when cash inflows cover cash outflows, payback tracks investment recovery, and ROIC measures returns relative to invested capital.

gym financial model returns fml30
MODEL FIT

Plan an Independent Membership-Based Local Club

This model fits a leased gym using recurring, inclusive membership packages and a fixed-base-pay staffing plan.

Use the supplied estimates as a starting point for your own member targets, package pricing, lease terms, staffing and equipment budgets. Clubs with pools, childcare, retail, franchise charges or separately sold coaching need assumptions reflecting those additional activities.

COMMON QUESTIONS

Gym Financial Model Questions and Answers

These answers clarify the editable assumptions, forecast scope and interpretation of the illustrated case.

Which membership assumptions can I edit?

You can edit annual-average paid members, exclusive package shares, inclusive monthly prices and launch timing to build the revenue forecast.

Is personal training added on top of membership revenue?

No; Personal Training is an exclusive, inclusive package within the same member pool, so its revenue is not counted again as a coaching add-on.

Does the January 31 launch reduce first-year revenue?

The launch control activates the full calendar month without daily proration, so this January 31, 2026 case includes 12 active months in its first year.

Are payroll taxes and benefits included in this case?

The documented staffing case includes fixed base salaries only and excludes employer taxes, benefits and workers compensation, even though the standard Payroll sheet supports broader personnel inputs.

Does positive EBITDA prove the startup investment is recovered?

No; investment payback depends on the relevant cash flows and initial investment, while EBITDA measures operating earnings before interest, taxes, depreciation and amortization.

Are these figures industry benchmarks or guaranteed results?

No; they are illustrative projections based on estimated planning inputs, and the documented case does not establish net profit, cash sufficiency or an investment payback period.

What Does the Gym Financial Model Contain?

gym financial model dashboard fml30

Financial Dashboard

KPIs, forecasts, and cash flow at a glance.

gym financial model revenue fml30

Revenue Engine

Key assumptions and calculations driving revenue forecasts.

gym financial model sources uses fml30

Sources & Uses

Funding sources, spending, and closing cash.

gym financial model returns fml30

Returns & Break-Even

Cash break-even, payback, and ROIC.

gym financial model valuation fml30

Business Valuation

DCF valuation and sensitivity analysis.

gym financial model top expenses fml30

Expense Breakdown

Largest costs and spending trends.

gym financial model summary fml30

Financial Summary

Annual and monthly financial performance.

gym financial model benchmarks fml30

KPI Benchmarks

Compare margins and returns to benchmarks.

Trusted by 25,000+ startup founders, investors and CPAs

Clear Break-Even View

Megan Ellis, TX

5 star rating

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.

Investor Format Was Clear

Derek Johnson, NY

4 star rating

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.

Easy For Non-Finance Users

Priya Sharma, CA

5 star rating

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.