Szenario überarbeiten
Maschinenplan, Team, Marketing und Finanzierung · geschlossene Monate sind auf Bank-Ist fixiert
Opening cash
0,00 €
Ending cash (18m)
DefinitionPrognostizierter Kassenbestand am Ende des Planungshorizonts im gewählten Szenario.BerechnungCash heute + geplante Einzahlungen − geplante Auszahlungen0,00 €
Runway
DefinitionZeitraum, den der aktuelle Kassenbestand bei unverändertem Net Burn trägt — bis wann ohne neue Finanzierung finanziert ist.BerechnungCash ÷ monatlicher Net Burn> horizon
Avg net / forecast month
0,00 €
Planned add. cost / mo
0,00 €
hires + marketing at full run rate, on top of baseline OpEx
Machine Sales Plan
Machines planned per month — drives the cash forecast, the ARR forecast and sales commission. Same field as the Cash Forecast, so both stay in sync.
| Period | Closed | Sep 26 | Oct 26 | Nov 26 | Dec 26 | Jan 27 | Feb 27 | Mar 27 | Apr 27 | May 27 | Jun 27 | Jul 27 | Aug 27 | 2027-Q31 mo (part) | 2027-Q43 mo | 2028-Q13 mo | Σ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| New machines | 0 | ||||||||||||||||
| Upsells | 0 |
Hiring plan
Fully loaded monthly cost, incremental to the baseline OpEx run rate. Sales reps with a level automatically add machine signings (ramped) and €/machine commission paid at quarter end.
No hires planned.
Marketing & experiments
Recurring spend between start and end; a one-off = same start and end month.
No marketing spend planned.
Debt & financing instruments
Draw-down lands as cash in; interest and principal follow the schedule (amortizing = annuity after the interest-only period, bullet = principal at maturity).
No debt planned.
Plan is saved.
Plan vs Actual — closed months
A month closes automatically once it is complete in the bank data. Closed months always show bank truth; the model's plan for the same month stays visible here.
No closed months in the window.
Setup checklist
Errors lock the export. Warnings are listed on the workbook's cover sheet.
- No classified bank transactions — actuals, opening cash and runway are unavailableImport and classify bank transactions first; a DD export without actuals is not credible.
- Opening cash is unknown — runway, funding need and ending cash cannot be computedImport and classify bank transactions so the model can read the cash balance at the start of the window.
- HubSpot mode but no installed machines foundCheck deal stages / installation dates, and that the dispenser-count property is synced.
- This scenario is not saved — exports should come from a saved stateSave the scenario first.
- No Worst/Best scenarios — due diligence expects a scenario rangeUse the Auto Worst/Best buttons on the forecast page.
Due-diligence workbook
Cover · Assumptions · Monthly Model · P&L (cash basis) · Cash Flow statement · Plan vs Actual · Dashboard with native Excel charts. All subtotals are live formulas; closed months carry bank actuals.
How months close
Completed bank months are closed: their cash lines are bank truth and cannot be edited. The current month stays a forecast until it completes. The model's plan for closed months is preserved, so Plan vs Actual keeps a full audit trail.