Break-Even Analysis & Forecasting
Galore Enterprise • Interactive financial model & break-even simulator
忍
Code Ninjas | Break-Even Worksheet
Official Franchise Financial Model & Breakeven Simulator
Franchise Breakeven Tool
Instructions:Fill out the YELLOW fields. GREEN fields are automatically calculated.
OPERATING EXPENSESMonthly Budget
| Expenses | Cost | Additional Information to Consider |
|---|---|---|
| Rent | Include your base rent, NNN, utilities and other recurring rent expenses | |
| Labor | $7,040.00 | Use the Labor Calculator Tool to estimate your labor costs |
| Marketing | Money spent on advertising - digital marketing, local events, social media etc. | |
| Misc | Supplies, inventory, incidental expenses | |
| Fixed Costs | Loan Repayment, Tech Fees | |
| Royalties (12%) | $2,486.40 | Royalties: royalty fee, brand fund, credit card fees (12% of Core Revenue) |
| Total BOE | $19,026.40 | BOE - Baseline/Breakeven Operating Expenses |
LABOR CALCULATORStaffing & Payroll Estimator
| Labor Parameters | Rate / Count | Monthly Total |
|---|---|---|
Sensei Hourly Rate Base pay per floor hour | $3,900.00 | |
Weekly Student Hours Days Open × Daily Hours (e.g. 5 days × 4h = 20) | hrs/week | |
Senseis Per Hour Senseis on staff concurrently | senseis/hr | |
CD Annual Salary Center Director Annual Compensation | $2,500.00 | |
Payload % Payroll Taxes, FICA, Benefits, etc. | % | $640.00 |
| Total Labor Expense (Monthly) | $7,040.00 | |
CREATE & JUNIOR PRICINGMonthly Student Tuition Rates
Create (Regular)
Base price for core program
$
Create Lite (80%)
Recommended 70-80% of regular
$207.20
Premium (140%)
Recommended 140% of regular
$362.60
Junior (75%)
Recommended 75% of regular
$194.25
BREAK EVEN - NINJASRequired Enrollment Targets
Breakeven Ninjas at REGULAR Price
Based on $259.00/mo tuition and current BOE
73 Ninjas
Breakeven Ninjas at LITE Price
Based on $207.20/mo tuition and current BOE
91 Ninjas
SALES ASSUMPTIONS / PROJECTIONSStudent Mix & Revenue Modeling
| Program | Price | Number of Enrollments | Projected Revenue |
|---|---|---|---|
| Regular Create | $259.00 | $12,950.00 | |
| Create Lite | $207.20 | $5,180.00 | |
| Premium | $362.60 | $1,813.00 | |
| Junior | $194.25 | $777.00 | |
| Total Core Projections | — | 84 Ninjas | $20,720.00 |
EVENT PRICING (CAMPS & PNO)Secondary Revenue Streams
| Event Type | Price | # Ninjas | Revenue |
|---|---|---|---|
| Day Camp | $180.00 | ||
| Week Long Camp | $675.00 | ||
| Summer Camp | $390.00 | ||
| PNO (Parents Night Out) | $240.00 | ||
| Total Event Revenue (Gross) | $1,485.00 | ||
| Less Event Royalties (12%) | -$178.20 | ||
| Net Event Revenue | $1,306.80 | ||
PROFIT ASSUMPTIONS / WATERFALLMonthly & Annual Net
| Total Core Revenue | $20,720.00 |
| Net Core Revenue After Royalties (12%) | $18,233.60 |
| Revenue After Rent (-$4,500.00) | $13,733.60 |
| Revenue After Labor (-$7,040.00) | $6,693.60 |
| Revenue After Marketing (-$1,500.00) | $5,193.60 |
| Revenue After Misc (-$500.00) | $4,693.60 |
| Core Monthly Profit (After Fixed Costs) | $1,693.60 |
Core Monthly Profit
$1,693.60
Annual: $20,323.20
Monthly Profit w/ Events
$3,000.40
Annual: $36,004.80