Boutique Fitness Studio Financial Model — Class Throughput Engine (Excel + Google Sheets)

Opening a boutique fitness studio — Reformer Pilates, spin, yoga/barre or HIIT? Every other template makes you type a guessed member count and a flat monthly fee. A studio cannot sell more visits than its schedule holds — so this model builds your revenue from real class throughput instead.

It starts from physical capacity — seats per class × classes per week × fill rate = attended visits per month — then splits those visits into recurring membership (MRR), class-packs and drop-ins, and lets the member base BUILD over Year 1 against your modality's churn. That ceiling is exactly what a guessed member count hides, and it is the number that decides whether your schedule is real.

What it builds for your studio:

• Revenue from real class throughput — seats × classes/week × fill → attended visits, split into membership MRR + class-packs + drop-ins. Change the fill or the schedule and watch revenue, SDE and breakeven move.
• 4-modality toggle — one switch reloads the whole economics (seats, prices, churn, instructor pay, equipment CAPEX) from an editable preset table: Reformer Pilates, Spin, Yoga/Barre, HIIT all in one file.
• Year-1 membership waterfall — the member base builds from your founding members toward capacity, net of churn — a stock that accumulates, not a flat headcount.
• 12-month seasonality + a Year-1 cash runway — see exactly which launch months you bleed before the base fills, the dip that sinks under-capitalised studios.
• 5-year P&L, SDE and margin — EBITDA struck after owner pay, SDE added back for what you actually take home.
• Payback, cash-on-cash, DSCR, breakeven fill and a 5-year IRR — the numbers an SBA lender or a clear-eyed buyer checks first.

What's inside:

• 10-sheet Excel workbook (works in Google Sheets too — no macros, no add-ins, no external links)
• 17-page PDF user guide — quick start, sheet-by-sheet walkthrough, how the Class Throughput engine works, how a lender reads your DSCR, payback and breakeven fill, where to find your real numbers, and a full FAQ
• START HERE sheet: your first projection in minutes, only amber cells to fill
• Class Schedule sheet — the throughput engine, with fill and revenue-mix levers
• Setup sheet with a 4-modality preset matrix you can edit to your exact concept
• Dashboard with KPI cards and a 5-year revenue-vs-SDE chart, formatted to share with a lender or partner
• Benchmarks sheet with sourced 2024-26 membership price, churn, fill, ARPM, rent and startup ranges

Why this one: every formula is machine-verified — the full calculation graph is recomputed by three independent engines (including Excel itself) before release, and the throughput engine, the churn waterfall and the modality toggle are all stress-tested. Models that balance to the cent.

Educational planning tool — not financial, legal, tax or investment advice. Membership prices, churn, fill rates and costs vary by market and modality and over time; validate every input against your own market research before relying on any number.