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.

🌐 Make Excels visible on BP.isa-power.nl

Tick "Public" on the Excels you want visible to anonymous visitors on BP.isa-power.nl, then click here to download an updated public-excels.js.

After downloading: drop public-excels.js into the project folder (overwriting the old one), then run ./deploy.sh in your terminal. The login page on BP.isa-power.nl will show the file to any visitor β€” works on a fresh incognito window too.

Alternative: share via a public Google Sheet (no re-deploy needed)
  1. Click ⬇ Download on the file above to get a local copy.
  2. Upload it to Google Drive and set sharing to "Anyone with the link can view".
  3. Copy the Drive share URL.
  4. Open your public-scenarios Google Sheet and add a row: Name Β· URL Β· Date Β· Description.
  5. Done β€” the new row immediately appears on the login page of BP.isa-power.nl for any visitor, no deploy needed.
Total revenue (horizon)
€0
over 24 months
Total costs (horizon)
€0
incl. startup & lean months
Cost β€” active months
€0
over 0 active month(s)
Cost β€” empty months (lean)
€0
over 0 empty month(s)
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.