Cashflow simulation

Month-by-month projection of cash inflows, outflows, and cumulative balance. Uses the cost model, staffing, and lean-month settings configured in the overview & simulator pages β€” change them and the projection follows.

Setup

Configureer scenario en horizon
Horizon
Initial cash β€” startkapitaal€75,000
€0€200k
Tariff per client β€” tarief/cliΓ«nt€30,000
€15k€50k
Day-shift staff β€” dagdienst2 people
14
Night-shift staff β€” nachtdienst1 person
02
Company overhead β€” overheadkosten (Kim, accountant, directors…) + €0/mo β–Ύ

Optional company-level overhead, applied every month of the projection (active and empty months alike). Edit each amount, then toggle the switch to include or exclude it.

Total active overhead €0/mo

Captures horizon, initial cash, tariff, day/night staff, and the per-month occupancy. Click a name to load, Γ— to delete. Cost-model inputs (personnel, fixed, lean, startup) come live from the overview & simulator pages.

Initial cash defaults to €75,000 (the desired-reserves total β€” configurable on the overview page). Use the Occupancy editor tab below to set client counts per month; empty months use the lean cost from your overview-page toggles.

Generates a multi-sheet .xlsx with the current configuration, cost model, key metrics, and the full month-by-month projection β€” perfect to share with an advisor without giving them access to the simulator. Filename pattern: YYMMDD - {name} - version YY.xlsx (version auto-increments per name). A copy is kept here so you can re-download, toggle public visibility, or delete.

πŸ“€ Cross-device publishing

Toggling Public only affects YOUR browser by default. To make a file visible to anyone visiting BP.isa-power.nl from any computer, you must include it in the deployable bundle.

Show deployment steps
  1. Click the button above β€” a file named public-excels.js downloads to your Mac.
  2. Move it into your project folder, replacing the existing public-excels.js.
  3. From a terminal in that folder, run ./deploy.sh β€” the bundle is rsynced to the VPS.
  4. From now on, anyone visiting BP.isa-power.nl sees those files on the login page.
Total revenue (horizon)
€0
over 24 months
Total costs (horizon)
€0
incl. startup & lean months
Cumulative net profit
€0
revenue βˆ’ all costs
End-of-horizon cash
€0
initial + cumulative net
Lowest cash point
€0
in month β€”
Cash break-even month
β€”
when cumulative net > 0
Months of runway from start
β€”
if you started with no income
Active vs empty months
0 / 0
active / empty in horizon

πŸ’‘ Hover any metric for the quick formula. Click a card for the full breakdown with inputs and a plain-English explanation. All metrics update live as you change the horizon, initial cash, tariff, staff, or per-month occupancy.

Positive net month Negative net month Cumulative cash balance

Bars show each month's net profit (revenue βˆ’ cost). The line shows cumulative cash starting from the initial balance. A dip below the dashed zero line means the house went cash-negative that month.

Month Clients Revenue Staff Fixed Overhead Startup Total cost Net Cumulative cash

Empty months (0 clients) are highlighted in amber and run on the lean fixed-cost total from the overview page. Negative net or negative cumulative cash is shown in red.

πŸ‘‹ Start here. Fill in the expected number of clients for each month β€” that drives every downstream metric (revenue, costs, cash, break-even). Defaults to a flat 5 clients/month if you skip filling, but explicit values from a realistic intake plan give a much more meaningful projection.

Set the number of clients for each month of the horizon. Use this to model rolling intake, holidays, ramp-up, or empty periods.