1. Side-by-side scenario comparison
Vergelijking van alle scenario's uit het spreadsheet
Show all scenarios from the spreadsheet — klik om uit te klappen ▾
All figures below come directly from the source spreadsheet. The two columns to compare most carefully are annual profit and annual margin, because those bake in the empty / non-paying months.
| Scenario | Clients | Tariff /mo | Active months | Annual revenue | Annual costs | Annual profit | Margin |
|---|---|---|---|---|---|---|---|
| Closed group — 4 clients × 3 months @ €39kScenario 3 | 4 | €39,000 | 3 | €468,000 | €398,740 | €69,260 | 14.8% |
| Closed group — 5 clients × 3 months @ €39kScenario 2 | 5 | €39,000 | 3 | €585,000 | €398,740 | €186,260 | 31.8% |
| Closed group — 6 clients × 3 months @ €25kScenario 4 | 6 | €25,000 | 3 | €450,000 | €411,660 | €38,340 | 8.5% |
| — Two-group scenarios (8 active months / year) — | |||||||
| 2 groups × 3 clients × 4 mo @ €39kScenario 1 | 3 | €39,000 | 8 | €936,000 | €763,390 | €172,610 | 18.4% |
| — Continuous rolling intake (recommended model) — | |||||||
| Rolling intake @ €29k (6-month sim.)Sheet "29.000" | 2–6 | €29,000 | 6 | €696,000 | €575,880 | €120,120 | 17.3% |
| Rolling intake @ €35k (6-month sim.)Sheet "35.000" | 2–6 | €35,000 | 6 | €840,000 | €575,880 | €264,120 | 31.4% |
| Rolling intake @ €39k (6-month sim.)Sheet "39.000" | 2–6 | €39,000 | 6 | €936,000 | €575,880 | €360,120 | 38.5% |
| — Steady-state full-occupancy (12 active months, theoretical) — | |||||||
| 3 clients @ €39k — full year | 3 | €39,000 | 12 | €1,404,000 | €1,011,360 | €392,640 | 28.0% |
| 4 clients @ €39k — full year | 4 | €39,000 | 12 | €1,872,000 | €1,315,560 | €556,440 | 29.7% |
| 5 clients @ €39k — full year | 5 | €39,000 | 12 | €2,340,000 | €1,315,560 | €1,024,440 | 43.8% |
| 6 clients @ €39k — full year | 6 | €39,000 | 12 | €2,808,000 | €1,315,560 | €1,492,440 | 53.2% |
Biggest single insight: the jump from 3 → 5 clients increases monthly profit from €32,720 to €85,370 — a +161% increase for only +€78k more revenue, because staffing cost barely moves (you only add 1 extra coach). Margin scales hard with group size, not with tariff.
2. Build your own scenario
Eigen scenario doorrekenen
Drag the sliders to test any combination. The cost model uses the same logic as the spreadsheet:
- Staff (the biggest monthly cost) scales with real people. Default 24/7 coverage = 1 coach + 1 nurse (day) + 1 coach or nurse (night) = 3 people, €63,800/mo. Slide day-shift up to 4 (each extra coach = +€25,350/mo at 13h × €65) or down to 1 (€-23,400). Slide night-shift up to 2 (each extra night person = +€14,400/mo). The recommendation for ≥4 clients is at least 3 day-shift people — a warning shows below the slider if you go under.
- Non-staff fixed costs default to €20,480/mo when active — click the "Fixed costs (active month)" panel below to edit each line item or switch any off. Empty-month cost is currently €15,280/mo — toggle items in or out on the overview page.
- One-time startup costs of €15,250 are deducted from year-one results.
Quick presets:
Captures all slider values (clients, tariff, active months, day/night-shift staff, standby coaches, and royalty settings in Internal view). Click a name to restore; × to delete. Fixed-cost amounts are shared with the overview page and stored separately.
1 coach + 1 nurse (day) + 1 coach or nurse (night) = 3 people covering 24/7
Cost: 2×€23,400 (coach + nurse, 12h each) + €14,400 night + €2,600 ZAG = €63,800/month
Standby coverage (sleep-over allowance) slaapstandby vergoeding — click to expand + €0/mo ▾
A coach with next-day duty can sleep over and claim a flat standby allowance per night. If woken to help, those active hours are paid €65/hr. This is in addition to the regular night-shift staff above. Rule: at most two coaches per night can claim the allowance — a 3rd coach sleeping over without next-day duty cannot claim. The slider below is a global count, all coaches combined.
Allowance cost€0/mo
Wake-up active pay (@ €65/hr)€0/mo
Total standby cost€0/mo
Fixed costs (active month) vaste kosten actieve maand €20,480/month ▾
Monthly revenue (active)
€150,000
Monthly cost (active)
€109,630
Monthly profit (active)
€40,370
Active margin
26.9%
Annual profit (after empty months & startup)
€357,890
Annual revenue
€1,500,000
Break-even (active months)
0.4
Cost during 1 empty month (lean mode)
€15,280
Verdict will appear here.
3. How the math works
Berekeningsmodel
| Formula | Value used |
|---|---|
| Monthly revenue = clients × tariff | Direct from sliders |
| Monthly staff cost = day-shift cost + night-shift cost + €2,600 ZAG. Day-shift: up to 2 base people × €23,400 (12h × €65 × 30) + any extras × €25,350 (13h × €65 × 30). Night-shift: people × €14,400 (2h active + 10h sleep). | Default coverage = 1 coach + 1 nurse (day) + 1 coach or nurse (night) = 3 people, €63,800/mo. Slide day-shift 1-4 and night-shift 1-2 to scale up or down. Recommended minimum is 3 day-shift at ≥4 clients. |
| Monthly fixed cost (active) = sum of all active line items (rent, groceries, psychiatrist, utilities, founder, insurance, …) | Default total €20,480. Each item can be edited or toggled off on the fixed-cost panel above. The spreadsheet's €23,080 line includes €2,600 of ZAG team meetings already counted in staff. |
| Monthly cost (empty) = €15,280 × fixed-cost adjustment | Spreadsheet "Totale kosten lege maand" — rent, utilities, founder, insurance only |
| Annual profit = (active months × monthly profit) − (empty months × empty cost) − €15,250 startup | One-off startup costs from "Opstartkosten" |
| Break-even months = startup costs ÷ monthly profit | How many active months needed to recoup the €15,250 launch spend |