Revenue and Calc
Edit class places, schedules, utilization, mix, prices, and launch timing; the monthly Calc schedule assigns each visit once.

The Zumba Fitness Studio Financial Model is an Excel template for attendance-based sales, staffing, startup investment, and monthly projections from 2026 through 2030. Editable assumptions feed revenue calculations and financial statements.
The illustrative case is one leased 1,800-square-foot studio in suburban Kansas City, Missouri, with 30 participant places and 100 classes each month. Customers pay for individual attendances or redeem class packs; the case excludes unlimited subscriptions, merchandise, private events, pool access, and franchise royalties.
The workbook connects Zumba studio inputs to detailed monthly schedules, financial statements, scenario controls, and investment reports.
Edit class places, schedules, utilization, mix, prices, and launch timing; the monthly Calc schedule assigns each visit once.
Adjust materials, processing, marketing, overhead, FTE staffing, and salaries while preserving separate cost categories.
Schedule capital assets, depreciation, equity contributions, and up to four optional debt facilities.
Review integrated monthly Income, Cash Flow, Balance Sheet, and Summary reports.
Compare Low, Base, and High assumptions using Scenarios, Returns, Valuation, Benchmarks, Charts, and model Checks.
Revenue is calculated from available class places, scheduled classes, attendance utilization, format allocation, and the realized price of each visit.
Thirty participant places across 100 monthly classes create 3,000 available attendances per month. The illustrated utilization assumption grows from 40% in 2026 to 66% in 2030, while the class schedule and room capacity remain unchanged.
The attendance mix is 50% Zumba dance fitness, 15% each Gold and Toning, and 10% each Step and Kids. Each visit belongs to one format, with class packs recognized on attendance rather than purchase.
The Revenue Forecast sets monthly class capacity, annual utilization, format mix, and realized attendance prices. Its assumptions drive the separate monthly Calc schedule and the annual sales forecast without adding another demand pool for each class type.
30 places × 100 classes per month × 40% utilization × $11.90 weighted price per attendance × 12 months = $171,360 annual revenue.
The 2026 mix weights dance fitness at $12, Gold at $11, Toning and Step at $13, and Kids at $10 per attendance.
By 2030, 66% utilization yields 1,980 attended places a month and illustrative annual revenue of $318,277. The January 2026 launch month is treated as a full operating month; the source case does not assume a separate monthly seasonality pattern.
The forecast distinguishes class consumables, revenue-linked charges, monthly studio overhead, and fixed base salaries so the same cost is not counted twice.
Class consumable materials are modeled as COGS at 0.5% of sales. Payment processing at 3.6% and ongoing local marketing at 3.0% are variable operating expenses based on total revenue, rather than extra instructional wages.
The COGS and Operating Expenses forecast separates direct materials, variable charges, and fixed studio spending. Rent, utilities, insurance, cleaning, software, music rights, accounting, maintenance, and renewals are scheduled without including the salaries already handled by Payroll.
The illustrative rent and occupancy assumption is $3,600 per month in 2026 and $4,052 per month in 2030. Across all fixed categories, annual fixed operating expenses rise from $67,260 to $75,702 in the example.
| Position | Average FTE | Base pay / FTE |
|---|---|---|
| Group fitness instructors | 1.5 | $48,000 |
| Studio manager | 0.5 | $52,000 |
| Front desk coordinator | 0.5 | $36,000 |
Base salaries are fixed planning inputs; employer payroll taxes and benefits are excluded from the illustrated costs.
The Payroll Forecast builds staffing by role and full-time equivalent, with hiring dates and salary inputs available for adjustment. The selected 2.5 combined FTE produce $116,000 of annual base payroll, kept outside COGS and other operating expense lines.
Startup equipment and opening cash requirements are planned separately from recurring operating costs and EBITDA.
Opening assets include $18,000 of dance flooring, $4,500 of mirrors, $2,500 of audio gear, and $2,500 of steps and toning equipment. Lighting, accessibility work, furniture, and booking hardware are also planned.
The Capital Expenditure Plan schedules studio fit-out purchases and records which items are depreciable. It separates the timing of asset spending from depreciation charges, allowing equipment investment to be evaluated independently of annual EBITDA.
Permits, deposits, training, preopening payroll, and launch promotion are separate cash items. Working-capital controls use zero receivables days, zero payables days, and 30 inventory days; the documented operating case ends at EBITDA.
The Sources and Uses of Funds report organizes owner equity, optional debt, operating receipts, and spending. It helps compare funding dates with equipment purchases and ongoing payments.
In the supplied 2026–2030 studio case, higher attendance and realized prices increase revenue faster than the modeled operating cost base.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $171,360 | $195,427 | -$24,067 |
| 2027 | $211,801 | $200,316 | $11,485 |
| 2028 | $254,500 | $205,425 | $49,074 |
| 2029 | $290,238 | $210,104 | $80,134 |
| 2030 | $318,277 | $214,299 | $103,978 |
Illustrative model outputs, not historical performance or industry averages. Whole-dollar rounding can create small differences between displayed lines.
The 2026 case projects an EBITDA loss of $24,067 because its $171,360 of sales do not cover the full $195,427 operating cost base. The illustration becomes EBITDA-positive in 2027 and reaches $103,978 of EBITDA by 2030.
EBITDA reflects revenue less direct costs, variable expenses, fixed expenses, and payroll before depreciation, financing expenses, and taxes. It is not net profit, investor cash flow, a funding-sufficiency test, or evidence that the studio will achieve these projections.
The Cash Flow Forecast tracks operating, investing, and financing cash movements, including equity, optional debt, capital spending, and loan payments. Unlike EBITDA, its opening-to-closing cash reconciliation is the relevant place to examine liquidity and potential funding gaps.
Use the included return and scenario reports to evaluate operating resilience and invested capital rather than treating projected EBITDA as investment payback.
Sales break-even compares revenue with operating costs; cash break-even compares cash inflows with outflows. Investment payback tracks cumulative project cash flows, while annual ROIC relates returns to invested capital.
The Returns analysis brings together sales break-even, cash break-even timing, cumulative investment payback, and return on invested capital. These are separate measures: a positive EBITDA year does not establish when opening investment is recovered.
The Dashboard varies revenue and expense multipliers across Low, Base, and High cases. Scenarios and Valuation can compare profitability and discounted cash flow, without supplying an unverified loan or valuation.
This template is designed around one leased studio with an attendance-based class timetable and a finite number of available class places.
It fits operators comparing class scheduling, attendance fill rates, differentiated Zumba prices, staffing plans, and studio overhead before committing to a lease or renovation. It is also useful for examining whether growth from the same movement room can support its operating expenses.
Answers to common questions about assumptions, revenue recognition, operating reports, and startup funding.
Yes. Edit the 30-place capacity, 100 monthly classes, and annual utilization assumptions to rebuild attendance volume and revenue.
It allocates one attendance pool among dance fitness, Gold, Toning, Step, and Kids, using a separate price and mix percentage for each.
No. Revenue is recognized per attended class, including redeemed class packs; unlimited subscriptions are outside the documented case.
No. The $116,000 annual base payroll is calculated separately, so instructor and other staffing salaries are not duplicated in direct or variable costs.
No. EBITDA excludes depreciation, financing expenses, and taxes; the Income Statement and Cash Flow reports address other financial measures.
Yes. CapTable records equity and the Dashboard includes optional debt controls, with financing schedules reflected in the workbook reports.
Not necessarily. It is an estimated opening contribution using a three-month reserve policy, not a verified maximum funding requirement.
KPIs, forecasts, and cash flow at a glance.
Key assumptions and calculations driving revenue forecasts.
Funding sources, spending, and closing cash.
Cash break-even, payback, and ROIC.
DCF valuation and sensitivity analysis.
Largest costs and spending trends.
Annual and monthly financial performance.
Compare margins and returns to benchmarks.
The template organized pricing, costs, and growth in one place, so I stopped chasing scattered inputs. I saved a full afternoon and could finally explain the model without second-guessing the numbers.
I’m not deep into Excel, and this model still made sense from the first tab. The color-coded inputs and clear structure saved me hours of trial and error.
I wasn’t sure what investors would expect, but the layout made it obvious what to show. I got my pitch materials aligned in one evening and walked into the meeting with a cleaner story.