Boutique Fitness Studio Financial Model — Class Throughput Engine

Description
Opening a class-based 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.
The Class Throughput engine starts from physical capacity: seats per class × classes per week × fill rate = attended visits per month. Those visits are split into recurring membership (MRR), class-packs and drop-ins, and the supportable member base is derived from member visits ÷ visits per member — so the schedule tells you how many members it can physically carry. A Year-1 membership waterfall then builds the base month by month from your founding members toward capacity, net of churn: the member base is a stock that accumulates, not a flat headcount.

A single toggle reloads the whole economics — seats, drop-in and membership price, churn, instructor pay and equipment CAPEX — from an editable preset matrix, so Reformer Pilates, spin, yoga/barre and HIIT all live in one file. You also get a 12-month seasonality vector and a Year-1 monthly cash runway that exposes the launch dip, a 5-year P&L with EBITDA and SDE, and full returns: payback, cash-on-cash, DSCR, breakeven fill rate and a 5-year levered IRR.

The shipped Reformer Pilates default (1,500 sqft suburban, 55% financed) supports about 100 members at 65% fill, books $328,310 of stabilized revenue at a 34.0% SDE margin (ARPM $274), with a 2.24x DSCR, 24.6% cash-on-cash, a 4.1-year equity payback, a 57.2% breakeven fill rate and a 32.8% five-year IRR. Switch to Yoga/Barre and the higher class capacity lifts the supportable base to about 211 members and revenue to roughly $563,047 — same engine, a different business.

Every formula is machine-verified: the full calculation graph is recomputed by three independent engines, including Excel itself, before release. 10 sheets, Excel and Google Sheets compatible, no macros. Educational planning tool — not financial, legal, tax or investment advice; validate every input against your own market research.