Test the price, capacity and costs behind your yoga studio. Explore the online worksheet previews alongside calculations from the current illustrative business case.
5 online worksheet illustrations, described below
Opening budget, scenario assumptions and dashboard views
Five-year forecast and separate operating break-even sensitivity
Editable Excel product with assumptions and formulas
04CAPEX and CapitalVisible workbook tabs separate investment and funding inputs.Explore layout ↓
05IS, CF and BSVisible tabs identify income statement, cash flow and balance sheet reports.Explore layout ↓
Explore the online worksheet illustrations
Open each online sheet presentation to read its specification and illustration. These web views are not screenshots or downloadable Excel files.
Yoga StudioPlanned XLSX
EBITDA = Revenue − operating costs
Illustrative workbook layout · annual USD
Income statement
Year 1
Year 2
Year 3
Revenue
$192,902
$307,356
$308,642
Payment fees and visit-linked supplies
$11,574
$18,441
$18,519
Owner, instructors, reception, burden and cover
$156,000
$156,000
$156,000
Rent, utilities, cleaning and operating overhead
$90,000
$90,000
$90,000
EBITDA
−$64,672
$42,915
$44,123
EBITDA margin
-33.5%
14.0%
14.3%
Planned presentation, not a completed file. Costs are shown as positive outflows; EBITDA excludes interest, tax, depreciation and amortization.
01RevenueWorksheet specification
Revenue
Planned purpose: The inspected paid-workbook input screen uses group places, occupancy, monthly fees and additional income per occupied place.
Inputs
Capacity by billing group
Occupied share
Monthly fee
Ancillary income per place
Outputs
Scenario revenue by group
Limits and completion needs
StartFigures visit-based analysis is a separate operational bridge. Convert membership and pack income consistently; do not treat each visit as a new monthly membership.
Set ancillary income to zero for this instruction-only case. Visible example amounts are not local benchmarks; literal formulas were not inspected.
02COGS & OPEXWorksheet specification
COGS & OPEX
Planned purpose: A visible workbook tab organizes direct costs and operating overhead.
Inputs
Variable payment and supply assumptions
Lease and overhead quotes
Outputs
Operating-cost schedule
Limits and completion needs
Keep scheduled teaching pay in payroll; avoid counting it again as a visit-linked cost. Adapt actual costs before relying on outputs.
03PayrollWorksheet specification
Payroll
Planned purpose: A visible workbook tab supports the paid staffing assumptions.
Inputs
Owner and employee compensation
Employer costs
Substitute and training provision
Outputs
Staffing-cost plan
Limits and completion needs
National wages and a payroll allowance do not verify a local hiring offer or worker classification.
04CAPEX and CapitalWorksheet specification
CAPEX and Capital
Planned purpose: Visible workbook tabs separate investment and funding inputs.
Inputs
Opening uses
Timing and funding assumptions
Outputs
Investment and financing schedules
Limits and completion needs
The page image does not verify each financing formula. Build the cash schedule from actual terms and avoid spending the operating reserve on fit-out.
05IS, CF and BSWorksheet specification
IS, CF and BS
Planned purpose: Visible tabs identify income statement, cash flow and balance sheet reports.
Inputs
Revenue, costs, investment and funding assumptions
Outputs
Financial statements
Limits and completion needs
Report presence is confirmed from the gallery; cell formulas, payment delivery and local assumptions are unverified. These online figures are independently authored.
Ways to prepare your files
Template
Current product · Shopify checkout
Edit the financial model with your own assumptions.
Define the revenue drivers, operating modules, outputs and review criteria before agreeing the work.
Project quote · Schedule agreed with you
Assumptions you can change
These are the current inputs behind the business case and the intended starting points for the editable workbook. Range endpoints represent modeled scopes or sensitivities, not measured national averages.
Yoga Studio input assumptions · USD unless stated
Driver
Base input
Scenario range / treatment
Role in the calculation
Recognized class revenue per attended visit
$16.50
$13.00 – $20.00
Revenue per sold unit
Attended class visits per open day across all classes
60
35 – 90
Daily throughput in the stated operating scope
Operating days per week
6
5 – 7
Trading schedule
Fixed operating costs / month
$20,500
Held constant
Operating break-even threshold
Contribution margin
94.0%
Held constant
Share of sales available for fixed costs
Starting share of mature volume
35.0%
Base ramp input
Opening month revenue
Mature volume added / month
5.0%
Base ramp input
Monthly ramp increment, capped at mature volume
Ramp horizon
24 months
Base ramp input
Period checked for operating break-even
The opening budget and annual expense inputs also need local quotes and staffing estimates. This page shows fixed examples; the free calculator lets you change price, volume and trading days.
Volume-only sensitivity · revenue at mature volume · monthly USD
Scenario
Daily units
Monthly revenue
Break-even revenue
First operating break-even
Lower volume
35
$15,003
$21,809
Not reached
Base volume
60
$25,720
$21,809
Month 11
Higher volume
90
$38,580
$21,809
Month 6
Only attended class visits per open day across all classes changes. Recognized class revenue per attended visit: $16.50; 6 operating days per week. Fixed costs and contribution margin stay constant. “Not reached” means no operating break-even within the 24-month ramp. This sensitivity is separate from the annual forecast and does not measure cash payback.
Sample outputs from the current case
These results are calculated from the website’s illustrative assumptions. They demonstrate intended workbook topics, not a tested Excel file.
01 / Annual forecast
Revenue across five years
$192.9k
Year 1
$307.4k
Year 2
$308.6k
Year 3
$333.9k
Year 4
$360.1k
Year 5
Annual USD. Full values appear in the Dashboard presentation.
02 / Opening allocation
Where the opening budget goes
Leasehold, flooring, ventilation, lighting and accessibility work$45,000
Design, permits, legal and insurance setup$12,000
Lease deposit and pre-opening occupancy$9,000
Mats, props, storage, reception and furnishings$8,000
Booking setup, website, audio, security and payment equipment$7,500
Pre-opening payroll, training and launch marketing$10,000
Construction and opening contingency$8,500
Operating cash reserve$80,000
One-time budget: $180,000. This allocation is not a cumulative cash-flow forecast.
03 / Operating earnings
Year 3 costs and EBITDA
Against annual revenue of $308,642.
Payment fees and visit-linked supplies$18,519
Owner, instructors, reception, burden and cover$156,000
Rent, utilities, cleaning and operating overhead$90,000
EBITDA$44,123
EBITDA margin: 14.3%. EBITDA is not cash available to the owner.
04 / Operating threshold
Volume needed to break even
Required whole units per day
51
Break-even revenue / month
$21,809
Base revenue / month at maturity
$25,720
First operating break-even
Month 11
Units mean attended class visits per open day across all classes. The ramp covers 24 months; operating break-even does not measure recovery of opening capital.
The annual forecast and fixed-cost sensitivity are separate planning views. The website does not yet supply a complete funding, debt, tax and working-capital schedule for a cumulative cash-flow or payback chart. Read the full input basis and limitations.
The annual forecast and original calculator inputs agree within $5 on Year 1 revenue, Year 1 operating result and the mature annual operating result. These checks do not validate demand, assumptions or cash funding.
Both products in one cart
Model + Business Plan
Write the strategy and test the assumptions for your yoga studio together. Update the narrative when you change the forecast.
The Business Plan uses Word and the Financial Model uses Excel. The online illustrations use this website's scenario data and may differ from the purchased files.
File format
XLSX
Editor
Microsoft Excel
Editing
Input cells, forecast assumptions and formulas; workbook behavior still needs verification.
Other software
Compatibility with alternative editors has not been verified.
Delivery and terms
Review the product description, delivery details, license and final total in Shopify before paying.
Use the purchase button to buy the Yoga Studio Financial Model for $109 through Shopify. This is a one-time price in USD before any applicable taxes.
What do the online previews show?
The online preview explains Revenue, COGS & OPEX, Payroll, CAPEX and Capital, IS, CF and BS using this website's illustrative case. It is separate from the downloadable Excel model.
Are these previews pages from a finished file?
The web previews are rendered from the website's case record. They illustrate planning concepts and calculations; they are not screenshots or a page-by-page inventory of the downloadable product.
What would I need to change for my business?
Review recognized class revenue per attended visit, attended class visits per open day across all classes, the operating schedule, opening budget and costs. These web previews do not edit a workbook. Test the website's price and volume assumptions in the business idea page's calculator.
Is the written business plan included?
The Financial Model is sold separately. The $168 Bundle adds the $59 Business Plan and $109 Financial Model for the same business to one cart, one of each.
Do the figures establish what my business will earn?
No. The figures describe an illustrative U.S. operating case, not measured industry averages or a prediction for your location. EBITDA is not owner cash, and operating break-even does not recover the opening investment. Check local costs, capacity and demand before using the assumptions.
