Boutique Fitness Studio Model: Class Throughput Engine – Excel XLSX

BENEFITS OF THIS DOWNLOADABLE EXCEL DOCUMENT

1. Capacity comes first: seats per class times classes per week times fill rate gives attended visits per month, so the schedule sets the revenue ceiling instead of a guessed member count.
2. One switch reloads seats, prices, churn, instructor pay and equipment capex from an editable preset table, so Reformer Pilates, spin, yoga and barre, and HIIT are compared on the same basis in one file.
3. Twelve months of seasonality and a Year-1 cash runway show the launch months that bleed cash, and a reconciliation block proves the ramp actually reaches the member base Years 2 to 5 are billed on.

SPORT MANAGEMENT EXCEL DESCRIPTION

Boutique Fitness Studio Model: Class Throughput Engine is an Excel template (XLSX) with a supplemental PDF document available for immediate download upon purchase.

This is a startup and planning model for opening a boutique fitness studio: Reformer Pilates, spin, yoga and barre, or HIIT. Most templates in this category ask you to type a guessed member count and a flat monthly fee. A studio cannot sell more visits than its schedule holds, so this model builds revenue from real class throughput instead, and that ceiling is exactly what a guessed member count hides.

The engine starts from physical capacity: seats per class times classes per week times fill rate gives attended visits per month. Those visits are then split into recurring membership revenue, class packs and drop-ins, and the member base is allowed to build across Year 1 against your modality's churn rather than sitting flat. Change the fill rate or the schedule and revenue, SDE and the breakeven fill all move together, so you can see whether the timetable you are planning is real before you sign a lease.

A four-modality toggle reloads the whole economics from an editable preset table (seats, prices, churn, instructor pay and equipment capex), so Reformer Pilates, spin, yoga and barre, and HIIT all live in one file and can be compared on the same basis. A Year-1 membership waterfall treats the member base as a stock: each month you sign your gross new members and lose churn off the whole base, so it climbs only as fast as the difference, instead of a headcount you assert. Twelve months of seasonality and a Year-1 cash runway show which launch months bleed cash before the base fills, which is the dip that sinks under-capitalised studios.

On top of that sit a five-year P&L with EBITDA struck after owner pay and SDE added back for what an owner-operator actually takes home, plus payback, cash-on-cash, DSCR, breakeven fill and a five-year IRR, which are the numbers an SBA lender or a clear-eyed buyer checks first.

The file is a 10-sheet Excel workbook that also works in Google Sheets, with no macros, add-ins or external links, delivered with a 18-page PDF user guide covering quick start, a 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. A START HERE sheet gets a first projection out in minutes with only amber cells to fill. The Class Schedule sheet holds the throughput engine with its fill and revenue-mix levers. The Setup sheet carries the four-modality preset matrix, editable to your exact concept. A Dashboard presents KPI cards and a five-year revenue-versus-SDE chart formatted to share with a lender or partner, and a Benchmarks sheet collects sourced 2024-26 ranges for membership price, churn, fill, ARPM, rent and startup costs.

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 each stress-tested. This is an 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, so validate every input against your own market research before relying on any number.

The model also reconciles the two halves most templates leave apart. Your timetable sets a ceiling on how many members it can carry; your marketing sets the level you actually hold against churn (gross new members divided by monthly churn). Years 2 to 5 are billed on the LOWER of the two, the sheet names which constraint is binding, and it prints the gross new members per month you need just to stand still. It also shows the effective fill rate your seats will actually see, which drops below the fill rate you typed whenever acquisition is the binding constraint.

Source: Best Practices in Sport Management, Integrated Financial Model Excel: Boutique Fitness Studio Model: Class Throughput Engine Excel (XLSX) Spreadsheet, ProformaWorks