Gym Financial Model – Excel XLSX

BENEFITS OF THIS DOWNLOADABLE EXCEL DOCUMENT

1. Models the real 60-month membership churn-and-signup rollforward instead of a flat growth-rate guess.
2. Shows an honest Year 1 DSCR ramp (-2.59x to 4.25x by Year 3) rather than a fabricated early win.
3. Ties trainer commission directly to personal-training revenue, not a flat payroll percentage.

FINANCIAL MODELING EXCEL DESCRIPTION

Gym Financial Model is an Excel template (XLSX) available for immediate download upon purchase.

Most gym financial templates smooth over the hardest part of the business: the membership ramp. This model doesn't. It runs a real 60-month churn-and-signup rollforward – this month's members equal last month's members after churn, plus new signups – so the revenue curve a lender sees is the same one the gym will actually live through, not a flat growth-rate assumption that happens to look clean on a slide.

That honesty shows up directly in the numbers. Year 1 Debt Service Coverage Ratio (DSCR) comes in at -2.59x while the membership base is still building, then clears the 1.25x SBA 7(a) minimum by Year 2 and reaches 4.25x by Year 3. A model that showed a comfortable DSCR from month one for a gym with zero existing members would be the one to distrust – this one shows the real ramp, and the real point at which the business actually clears the bar a lender checks.

Change the churn rate or monthly dues on the Assumptions tab and it flows through the Membership Build, Staffing & Payroll, and Operating Expenses into a full Income Statement, Balance Sheet, and Cash Flow – then into the DSCR & Lender Ratios tab, the Executive Dashboard, and five native charts. One input, everything downstream updates, with the Balance Sheet checked for balance every single month rather than just at year-end.

All 19 tabs: Start Here, Disclaimer, Help & FAQ, Assumptions, Membership Build (the 60-month churn rollforward), Debt Schedule, Staffing & Payroll (with trainer commission tied to real personal-training revenue), CapEx & Depreciation for cardio/strength equipment and buildout, Operating Expenses, the three financial statements, Break-Even Analysis, DSCR & Lender Ratios with a built-in stress test, Scenario Analysis, an Executive Dashboard, Sensitivity Analysis (membership growth by dues), a Funding Requirement tab with sources and uses, and Settings.

Built as a native .xlsx with standard spreadsheet formulas only, no macros or add-ins, and checked to open correctly in Microsoft Excel, Google Sheets, LibreOffice Calc, WPS Office, Apache OpenOffice, and ONLYOFFICE. This is a planning tool built from sourced industry assumptions, not financial, legal, or tax advice – confirm actual figures with an accountant or lender before relying on it for a real loan application.

Source: Best Practices in Financial Modeling, Sport Management Excel: Gym Financial Model Excel (XLSX) Spreadsheet, WebsiteGeek