Pilates Studio Financial Projections Template in Excel

One file replaces hours of spreadsheet work. Type your numbers into the inputs tab, and the rest of the Pilates Studio model is already built.
Pilates Studio Financial Model overview header showing the model purpose and quick links to dashboard, inputs, scenarios and reports to guide users through forecasting and investor-ready outputs
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Pilates Studio Financial Model overview header showing the model purpose and quick links to dashboard, inputs, scenarios and reports to guide users through forecasting and investor-ready outputs
Industry Benchmarks
Projected balance sheet
Capital expenditure plan
Capitalization table
Cash flow forecast
Financial charts
COGS & Operating expense forecast
Financial model dashboard
DuPont analysis
Projected income statement
Payroll forecast
Financial ratio analysis
Return on invested capital analysis
Revenue forecast
Financial scenario analysis
Sources and uses of funds
Financial model summary
Top expense analysis
Top revenue streams
Business valuation analysis
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Pilates Studio Bundle
See included products:
Financial Model iPilates Studio Bundle Financial Model template included in this product.
$149 $109
ADD TO YOUR ORDER
Business Plan iPilates Studio Bundle Business Plan template included in this product.
$79 $59
Pitch Deck iPilates Studio Bundle Pitch Deck template included in this product.
$49 $29
YOU SAVE $0 TODAY
30-Day Money-Back Guarantee
Created by a Former CFO
Updated for 2026
One-Time Purchase
Description

This Pilates Studio Financial Model is an Excel template for an independent, eight-reformer small-group studio in Raleigh, North Carolina. It builds monthly financial projections for 2026–2030 from available class places, utilization, class mix, realized prices, payroll, and operating costs.

The illustrative setup uses an estimated 1,600-square-foot leased space and five reformer class formats, without retail, private lessons, a franchise, or a heated room. The supplied case documents operating projections through EBITDA; its assumptions are planning estimates, not observed results.

Forecast
5annual forecast years
Reformer stations
8places per class
Class formats
5unique class streams
Service days
26per modeled month
MODEL COMPONENTS

What Is Included in This Excel Model?

The workbook connects attendance planning, operating costs, funding assumptions, financial statements, and decision reports rather than treating revenue as a stand-alone estimate.

Revenue and Calc

Set class capacity, annual utilization, attendance allocation, realized prices, and launch timing; the monthly calculation schedule rolls these drivers into annual studio revenue.

COGS & OPEX and Payroll

Keep percentage-based consumables and fees, monthly fixed studio costs, and role-based staffing separate so every base salary is charged once.

CAPEX and funding

Schedule reformer equipment, fitout, and opening purchases, record equity in CapTable, and configure optional financing through Dashboard debt controls and Debt.

Statements and analysis

Review Income Statement, Cash Flow, Balance Sheet, Summary, Dashboard, Checks, Scenarios, Returns, and Valuation as separate reports with distinct financial uses.

REVENUE FORECAST

How Does Studio Class Attendance Create Revenue?

The revenue forecast multiplies one shared pool of filled reformer places by five exclusive class shares and their realized attendance prices.

Monthly capacity is 8 reformers × 7 scheduled classes per day × 26 service days, or 1,456 available places. The example applies annual filled-place utilization of 42%, 53%, 62%, 68%, and 72% from 2026 through 2030; empty spaces earn nothing.

Attendance is allocated once: Foundations receives 20% at $30, Flow 40% at $32, Strength Reformer 20% at $34, Stretch and Mobility 10% at $29, and Cardio Reformer 10% at $34. These are realized per-attendance prices after package effects and refunds, not additional cash-pack sales.

Revenue Forecast

The Revenue Forecast shows the capacity assumptions, filled places, class allocations, realized ticket prices, and revenue by stream. Its inputs feed the monthly Calc schedule, which switches revenue on in the launch month without prorating January 2026.

pilates studio financial model revenue fml30
Illustrative average month in 2026

1,456 places × 42% filled utilization × $31.90 weighted realized price ≈ $19,507 in monthly class revenue.

Class shares sum to 100%. Annual revenue adds monthly stream results, with no material seasonal adjustment imposed.

COSTS AND STAFFING

How Are Operating Costs and Payroll Calculated?

Direct consumables, revenue-linked fees and marketing, fixed premises costs, and staff base pay are calculated as distinct expense groups.

Class consumables are modeled as 1.5% of total revenue. Payment and dispute fees are 3.5%, while local marketing falls from 5% of revenue in 2026 to 3% in 2030; none of these percentage categories includes salaried personnel.

COGS and Operating Expenses

The COGS and Operating Expenses forecast separates consumables, payment fees, marketing, and fixed overhead. Monthly fixed coverage includes rent, utilities, software, insurance, cleaning, repairs, bookkeeping, communications, licenses, and certifications.

pilates studio financial model cogs opex fml30

Rent starts at $4,200 per month in 2026 and reaches about $4,727 in 2030. The $75,780 fixed-cost estimate for 2026 persists when attendance underperforms.

Instructors increase from 1.8 to 2.0 annual-average FTE, at $56,000 annual base per FTE. The manager remains half-time at $68,000 per full FTE, and member services increases from 0.5 to 0.75 FTE.

Payroll Forecast by Staff Role

The Payroll Forecast links FTE plans and annual base pay to monthly personnel costs. It includes $155,800 of 2026 and $177,500 of 2030 salary expense, without duplicating pay in direct, variable, or fixed expenses.

pilates studio financial model payroll fml30
STARTUP SPENDING

How Are Setup Assets and Opening Funding Handled?

Capital purchases, separate preopening cash items, working capital, and equity funding are planned outside the recurring operating EBITDA calculation.

Startup assets include eight reformer stations ($48,000), fitout and flooring ($35,000), mirrors and storage ($6,500), and reception furniture and lockers ($5,000). Computers, check-in, audio, and security equipment are separate assets.

Lease deposits, permits, launch marketing, training, preopening rent, utilities, and branding are separate startup cash items.

Capital Expenditure Plan

The Capital Expenditure Plan schedules reformers, fitout, other assets, and applicable depreciation. Purchase timing feeds investment and balance-sheet schedules, not recurring EBITDA expenses.

pilates studio financial model capex fml30

Working-capital inputs are 0 receivable days, 0 payable days, and 30 inventory days; these do not establish cash sufficiency.

Sources and Uses of Funds

The Sources and Uses of Funds report reconciles equity, financing, operating cash flows, and investment uses. Estimated initial owner funding of $194,036 includes setup, opening working capital, and a three-month cash operating reserve.

pilates studio financial model sources uses fml30
ILLUSTRATIVE PROJECTIONS

What Do the Five-Year Financial Projections Show?

The sample studio initially loses money at 42% filled utilization, then reaches positive EBITDA in 2027 as modeled attendance grows.

Illustrative annual Pilates studio forecast, USD
Year Revenue Operating Expenses EBITDA
2026 $234,090 $254,989 -$20,899
2027 $295,399 $266,116 $29,283
2028 $345,561 $279,195 $66,366
2029 $379,003 $290,422 $88,581
2030 $401,297 $294,895 $106,402

Illustrative assumptions, not actual business results; displayed figures are rounded to whole dollars and may differ slightly in arithmetic.

Annual revenue rises from $234,090 in 2026 to $401,297 in 2030 as the same eight reformers become more heavily used. That growth reflects utilization rising from 42% to 72%, not additional studios, stations, private sessions, or retail categories.

EBITDA changes from a $20,899 operating loss in 2026 to positive $29,283 in 2027 and $106,402 in 2030. EBITDA is not net income or cash flow; depreciation, financing expenses, tax assumptions, investment, and working-capital effects require separate financial statement review.

Cash Flow Forecast

The Cash Flow Forecast tracks operating, investing, and financing cash movements, then reconciles opening and closing cash. Compare it with EBITDA to identify whether equipment purchases, member receipts, working capital, or any modeled debt repayments create funding pressure.

pilates studio financial model cf fml30
DECISION TOOLS

Can the Workbook Evaluate Break-Even and Payback?

Break-even, recovery of invested cash, annual ROIC, and enterprise valuation are different calculations, not interchangeable measures of profitability.

Sales break-even measures revenue against operating costs; cash break-even concerns cash coverage. Investment payback follows cumulative project cash flow, while annual ROIC measures after-tax operating profit against invested capital, not EBITDA against startup funding.

Break-Even, Payback and ROIC

The Returns report separately calculates sales break-even, cash break-even, payback, and annual ROIC. The supplied Pilates case does not establish payback timing or an ROIC result; inspect these outputs under your assumptions.

pilates studio financial model returns fml30

Dashboard Scenario Controls change revenue and cost multipliers across Low, Base, and High cases. Scenarios compares profitability, Valuation provides DCF sensitivity, and Benchmarks uses user-entered reference values.

Test whether reduced class utilization can cover rent and instructors. These reports do not guarantee profits, borrowing approval, or local market pricing.

FREQUENTLY ASKED QUESTIONS

Pilates Studio Financial Model FAQ

These answers clarify the modeled class format, editable assumptions, funding example, and financial reporting boundaries.

Can I change the number of reformers and daily classes?

Yes. Change reformer places, daily class slots, service days, and annual utilization to recalculate monthly attendance capacity and the related revenue streams.

Are class packs recorded as extra revenue?

No. Attendance earns its realized per-visit price, which already reflects package discounts and refunds in the supplied example.

Does this model include private lessons or retail?

No. The documented operating example contains five small-group reformer class formats and excludes private lessons, retail, franchising, and heated rooms.

How is the January 2026 launch treated?

The native launch date is January 31, 2026. Earlier months have zero revenue, and the launch month is modeled as a full operating month without daily proration.

Is the estimated $194,036 enough to open?

It is an opening owner-funding assumption including startup needs and a three-month reserve, not a tested peak cash requirement or guaranteed sufficient capital.

Does positive EBITDA mean positive cash flow?

No. EBITDA excludes investing and financing cash flows; use the Cash Flow Statement and Balance Sheet to assess cash balances and funding risk.

Are payback, valuation, or return figures guaranteed?

No. Returns, valuation, and scenarios depend on editable assumptions, and the source brief does not establish a specific payback month, ROIC, or valuation.

What Does the Pilates Studio Financial Model Contain?

pilates studio financial model dashboard fml30

Financial Dashboard

KPIs, forecasts, and cash flow at a glance.

pilates studio financial model revenue fml30

Revenue Engine

Key assumptions and calculations driving revenue forecasts.

pilates studio financial model sources uses fml30

Sources & Uses

Funding sources, spending, and closing cash.

pilates studio financial model returns fml30

Returns & Break-Even

Cash break-even, payback, and ROIC.

pilates studio financial model valuation fml30

Business Valuation

DCF valuation and sensitivity analysis.

pilates studio financial model top expenses fml30

Expense Breakdown

Largest costs and spending trends.

pilates studio financial model summary fml30

Financial Summary

Annual and monthly financial performance.

pilates studio financial model benchmarks fml30

KPI Benchmarks

Compare margins and returns to benchmarks.

Trusted by 25,000+ startup founders, investors and CPAs

Formula Errors Kept Out

Megan Carter, TX

5 star rating

The template’s checks made it easy to trust the numbers, so one bad cell didn’t throw off the whole model. I saved about 3 hours of troubleshooting before sharing it with my lender.

Cash Flow Was Easier To See

Daniel Brooks, FL

5 star rating

I could finally see runway and shortfalls month by month without building the forecast from scratch. That made our planning call faster and got a follow-up meeting booked the same day.

Scenario Planning Took Minutes

Lauren Mitchell, CA

4 star rating

Switching between low, base, and high cases was simple, and I didn’t have to rebuild three separate sheets. It cut a half-day of scenario work down to under an hour.