SmartHelping / Gym & Fitness Center / Excel
Gym & Fitness Center Financial Model
Build a 10-year financial plan for opening and operating a gym. Connect membership capacity, monthly fees, equipment investment, and operating costs with funding needs, three financial statements, and projected investor returns.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
Video walkthrough & spreadsheet preview
See how the gym forecast comes together.
Explore the model's assumptions, operating forecast, financial reports, and investment analysis. Open the screenshots below for a closer look at the workbook.
From opening day to target membership
Build revenue from capacity and membership fees.
Set a maximum member count, the share of that capacity reached at launch, and a monthly ramp toward the target. The model connects projected membership with your monthly pricing assumptions.
Membership capacity
Use the station and simultaneous-user planning table to explore capacity estimates, then enter the maximum membership target you want to use in the forecast.
Opening membership
Choose the revenue start month and the initial percentage of your membership target. This establishes the starting member count when the gym begins earning revenue.
Monthly membership ramp
Set the monthly increase in capacity attained for each forecast year. Membership builds toward the chosen maximum, with capacity attained capped at 100%.
Pricing by forecast year
Enter a monthly membership fee for each of the 10 forecast years. Revenue follows the projected number of members and the fee applicable to that year.
How membership growth works
A clear ramp toward your capacity target.
The monthly growth assumption adds percentage points to the share of capacity attained. For example, starting at 20% with a 2% monthly improvement moves the forecast to 22%, then 24%, until the target is reached.
The capacity planning table is a guide. Enter your chosen maximum member count in the revenue assumptions to apply it to the forecast.
Opening costs & ongoing operations
Plan the investment behind the gym.
Bring equipment purchases, opening expenses, staffing budgets, and recurring overhead into the same financial forecast.
46 operating-cost lines
Budget monthly costs by forecast year and set individual start dates. Customize the descriptions for payroll, rent, utilities, maintenance, insurance, and other running costs.
16 startup-cost lines
Itemize the expenses required to get the business ready to operate, alongside the separate schedule for capital assets.
78 capital-asset entries
Schedule equipment and other capital investment using cost, expenditure date, and useful life. The CapEx schedule calculates straight-line depreciation and tracks asset book values.
Property & equipment planning
The capital schedule includes a dedicated building/property entry and a separate building sale-value assumption. Budget rent in running costs when planning a leased location.
Debt, equity & the holding period
Connect the operating plan with its funding.
Review the cash needed to launch and sustain the business, then evaluate how financing and an optional exit affect the investment.
Debt financing
Enter the loan amount, interest rate, term, payment frequency, and first-payment date. Follow interest expense, principal repayments, and the remaining balance through the debt schedule.
Equity requirement
Review the projected funding requirement after bank financing. The model uses the peak cumulative cash deficit to help estimate the equity needed for the plan.
Cap table & distributions
Enter contributions and share allocations to review fully diluted ownership, annual distributions, and individual investment returns. The model assumes the main equity funding is contributed upfront.
Taxes & optional exit
Set income and capital-gains tax assumptions. Choose an end month within the 10-year forecast and optionally include a business exit value based on trailing 12-month EBITDA and an input multiple.
Monthly detail & investment reporting
Review the business from cash flow to investor returns.
Use the detailed forecasts to understand the operating plan, then review the executive summary and charts to assess the overall investment case.
Integrated financial statements
Review monthly and annual income statements, balance sheets, and cash flow statements linked to the model's operating and financing schedules.
Executive summary
Follow annual revenue, year-end membership, EBITDA, taxes, capital expenditures, debt service, cash flow, funding needs, and cash returned.
Project, investor & owner returns
Evaluate annual IRR, equity multiples, and ROI for the project and the investor/owner interests. Review discounted cash flow and NPV using separate input discount rates.
Operating & financing metrics
Review membership capacity attained, EBITDA per member, and debt service coverage alongside the forecast to understand the economics of the gym.
Membership & performance charts
Visualize membership and capacity attained, revenue, expenses, EBITDA, EBITDA per member, and debt service coverage.
Cash flow charts
Compare monthly and accumulated cash flow, and review the projected cash flows attributable to investors and owners.
Optional business sale
Evaluate the effect of an exit.
Turn terminal value on to estimate a business sale from trailing 12-month EBITDA multiplied by your chosen exit multiple. The model includes asset-sale allocation and a separate building sale-value input.
When terminal value is enabled, the remaining loan balance is repaid at exit. You can also turn terminal value off to review the forecast without a modeled business sale.
A practical planning workflow
Build your gym's financial plan.
-
Define capacity, launch timing, and pricing
Set the maximum member target, starting membership, monthly capacity ramp, and membership fee for each forecast year.
-
Budget the opening and ongoing operations
Add startup expenses, capital assets, running costs, loan assumptions, equity ownership, and the planned holding period.
-
Review funding needs and returns
Use the financial statements, executive summary, and charts to evaluate the plan. Adjust the assumptions to explore different membership ramps, prices, costs, or exit values.
Also included in bundles
Explore the broader model collections.
This model is included in the Industry-Specific Financial Model Bundle and the Hospitality Financial Models Bundle.
Questions before you buy
A few useful details.
Who is this model designed for?
It is designed for planning the opening and operation of a single gym or fitness center with monthly membership revenue. Use it to connect membership assumptions with equipment investment, operating costs, financing, cash flow, and investment returns.
How long is the forecast?
The model includes up to 10 years of monthly and annual projections. Set the end month to evaluate a shorter operating or holding period.
Does the model forecast member churn or separate membership tiers?
The included revenue engine uses a maximum member count, a starting capacity percentage, a monthly ramp toward that target, and one monthly membership fee for each forecast year. Separate churn, membership-tier, class, or personal-training revenue schedules would require customization.
Does the station calculator automatically set the member target?
No. It provides estimates to help with planning. Enter the maximum member count you choose in the revenue assumptions to use that target in the forecast.
Can I plan equipment purchases and depreciation?
Yes. The capital schedule includes 78 asset entries, including a dedicated building/property row. Enter each asset's cost, expenditure date, and useful life to project capital spending, straight-line depreciation, and book value.
Can I model a leased gym location?
Yes. Budget lease payments in running costs and enter the equipment and capital improvements relevant to your plan. Use a building purchase and sale assumption only when it applies to the investment you are modeling.
Are all three financial statements included?
Yes. The workbook includes integrated monthly and annual income statements, balance sheets, and cash flow statements, along with detailed operating forecasts, an executive summary, charts, and return analysis.
Are taxes included?
Yes. The model includes income-tax and capital-gains-tax inputs and incorporates modeled taxes into cash flow. The applicable assumptions should be set for the business and transaction you are evaluating.
Can I include a business sale?
Yes. Enable terminal value and enter an EBITDA multiple to calculate a business exit value from trailing 12-month EBITDA. The model also includes asset-sale allocation and a separate building sale-value assumption. With terminal value enabled, outstanding debt is repaid at exit.
What do I receive after purchasing?
The one-time price is $75 for the Excel workbook, available immediately after purchase. The walkthrough and screenshot preview above show the model, and the bundle links provide other purchasing options.
Plan your gym or fitness center
Connect membership growth with cash flow and returns.
Get the Gym & Fitness Center Financial Model. Have a question? Contact SmartHelping.
