s↗sokointel.

BUSINESS RESEARCH / FREE TOOL

Business cash stress and warning planner

Combine a dated cash forecast with explicit collection, supplier, margin and funding shocks. Use evidence and action dates, not a black-box failure score.

Jump to the worked result ↓

Fictional worked examples, prepared 25 September 2026. KES throughout. Replace inputs with your own dated records. Project 3 workbook: Overview D6:D7; Cash and CCC rows 6:18. CCC and margin controls are separately labelled illustrative additions.

Timing, evidence and scenario controls
Incremental cash only; do not repeat amounts already entered in supplier payments. A noncash write-down is not a payment.
Evidence warning only; include actual payments in the weekly schedule.
Customer receipts and committed uses — editable KES by week

The default fixed and other-committed buckets retain the workbook totals. Split them into additional categories only after reducing the original bucket, so a payment is counted once. Base and downside receipts/payments can differ; all other entered uses apply to both cases unless a stated stress control changes them.

WeekBase customer receiptsDownside customer receiptsBase supplier paymentsDownside supplier paymentsPayroll / fixed costsOther committed uses
1
2
3
4
5
6
7
8
9
10
11
12
13
Separate financing and additional uses — editable KES by week

The default fixed and other-committed buckets retain the workbook totals. Split them into additional categories only after reducing the original bucket, so a payment is counted once. Base and downside receipts/payments can differ; all other entered uses apply to both cases unless a stated stress control changes them.

WeekOther operating receiptsNew owner fundsNew borrowingAdditional taxAdditional maintenance capexAdditional growth capexAdditional interestAdditional principalAdditional owner withdrawals
1
2
3
4
5
6
7
8
9
10
11
12
13
Restore illustrative example

Editable fields use the amber background. Inputs are used for this response and are not saved to a member profile or lead list. CSV downloads contain the calculated tables for the submitted inputs.

Your scenario, step by step.

Base minimum cashKES 5,580,000.00
Downside minimum cashKES -3,490,000.00
First downside reserve breachWeek 8
First downside cash shortfallWeek 9

Base and downside comparison

MeasureBaseDownside
Lowest cash (including opening)KES 5,580,000.00KES -3,490,000.00
Closing week 13 cashKES 6,060,000.00KES -3,490,000.00
Initial cash injection to keep the reserveKES 0.00KES 4,240,000.00
Customer receipts shifted beyond week 13KES 0.00KES 0.00
Borrowing shifted beyond week 13KES 0.00KES 0.00

Base weekly schedule

WeekBeginsOpeningOperating receiptsOwner fundsNew borrowingAll usesClosingAbove / below reserve
12026-09-28KES 6,000,000.00KES 1,400,000.00KES 0.00KES 0.00KES 1,430,000.00KES 5,970,000.00KES 5,220,000.00
22026-10-05KES 5,970,000.00KES 1,200,000.00KES 0.00KES 0.00KES 1,330,000.00KES 5,840,000.00KES 5,090,000.00
32026-10-12KES 5,840,000.00KES 1,600,000.00KES 0.00KES 0.00KES 1,530,000.00KES 5,910,000.00KES 5,160,000.00
42026-10-19KES 5,910,000.00KES 1,000,000.00KES 0.00KES 0.00KES 1,330,000.00KES 5,580,000.00KES 4,830,000.00
52026-10-26KES 5,580,000.00KES 2,200,000.00KES 0.00KES 0.00KES 1,830,000.00KES 5,950,000.00KES 5,200,000.00
62026-11-02KES 5,950,000.00KES 1,500,000.00KES 0.00KES 0.00KES 1,430,000.00KES 6,020,000.00KES 5,270,000.00
72026-11-09KES 6,020,000.00KES 900,000.00KES 0.00KES 0.00KES 1,280,000.00KES 5,640,000.00KES 4,890,000.00
82026-11-16KES 5,640,000.00KES 1,800,000.00KES 0.00KES 0.00KES 1,630,000.00KES 5,810,000.00KES 5,060,000.00
92026-11-23KES 5,810,000.00KES 1,300,000.00KES 0.00KES 0.00KES 1,430,000.00KES 5,680,000.00KES 4,930,000.00
102026-11-30KES 5,680,000.00KES 2,000,000.00KES 0.00KES 0.00KES 1,780,000.00KES 5,900,000.00KES 5,150,000.00
112026-12-07KES 5,900,000.00KES 1,200,000.00KES 0.00KES 0.00KES 1,330,000.00KES 5,770,000.00KES 5,020,000.00
122026-12-14KES 5,770,000.00KES 1,700,000.00KES 0.00KES 0.00KES 1,530,000.00KES 5,940,000.00KES 5,190,000.00
132026-12-21KES 5,940,000.00KES 1,800,000.00KES 0.00KES 0.00KES 1,680,000.00KES 6,060,000.00KES 5,310,000.00

Downside weekly schedule

WeekBeginsOpeningOperating receiptsOwner fundsNew borrowingAll usesClosingAbove / below reserve
12026-09-28KES 6,000,000.00KES 900,000.00KES 0.00KES 0.00KES 1,530,000.00KES 5,370,000.00KES 4,620,000.00
22026-10-05KES 5,370,000.00KES 700,000.00KES 0.00KES 0.00KES 1,430,000.00KES 4,640,000.00KES 3,890,000.00
32026-10-12KES 4,640,000.00KES 1,000,000.00KES 0.00KES 0.00KES 1,680,000.00KES 3,960,000.00KES 3,210,000.00
42026-10-19KES 3,960,000.00KES 600,000.00KES 0.00KES 0.00KES 1,430,000.00KES 3,130,000.00KES 2,380,000.00
52026-10-26KES 3,130,000.00KES 1,200,000.00KES 0.00KES 0.00KES 1,980,000.00KES 2,350,000.00KES 1,600,000.00
62026-11-02KES 2,350,000.00KES 900,000.00KES 0.00KES 0.00KES 1,530,000.00KES 1,720,000.00KES 970,000.00
72026-11-09KES 1,720,000.00KES 500,000.00KES 0.00KES 0.00KES 1,380,000.00KES 840,000.00KES 90,000.00
82026-11-16KES 840,000.00KES 1,100,000.00KES 0.00KES 0.00KES 1,780,000.00KES 160,000.00KES -590,000.00
92026-11-23KES 160,000.00KES 750,000.00KES 0.00KES 0.00KES 1,480,000.00KES -570,000.00KES -1,320,000.00
102026-11-30KES -570,000.00KES 1,250,000.00KES 0.00KES 0.00KES 1,930,000.00KES -1,250,000.00KES -2,000,000.00
112026-12-07KES -1,250,000.00KES 700,000.00KES 0.00KES 0.00KES 1,430,000.00KES -1,980,000.00KES -2,730,000.00
122026-12-14KES -1,980,000.00KES 900,000.00KES 0.00KES 0.00KES 1,680,000.00KES -2,760,000.00KES -3,510,000.00
132026-12-21KES -2,760,000.00KES 1,100,000.00KES 0.00KES 0.00KES 1,830,000.00KES -3,490,000.00KES -4,240,000.00

Cash-cycle diagnostics (separate from the dated cash model)

MeasureBase daysDownside days
Inventory days30.0045.00
Receivable days20.0030.00
Payable days35.0020.00
Cash conversion cycle15.0055.00

Interpret the result.

The financing need is the peak reserve gap, not the sum of every negative closing balance. No corrective injection has been inserted into these schedules.

A week closes after that week’s receipts and uses. Cash needed earlier within a week still requires a daily schedule. No breach in 13 weeks is not infinite runway.

Borrowing and owner funds are financing inflows, not operating revenue. Shifted receipts beyond the horizon are disclosed, not silently deleted.

Downside cash is negative: identify a dated funding or operating action before the first shortfall.

The cash cycle lengthens. Reconcile the changed terms to the editable weekly receipts and payments.

Illustrative gross contribution is below average fixed/payroll payments, before tax, debt and capital spending.

Margin compression adds KES 0.00 of weekly cash cost in the downside, assuming constant sales and immediately paid variable costs.

CCC inputs are diagnostic: they do not also alter the schedule. Change weekly receipts, supplier payments or delay/acceleration controls to represent the terms. Avoid entering the same shock twice.

This is a fictional warning exercise, not the historical accounts of Nakumatt, Tuskys, Twiga or Copia, a failure probability, an insolvency finding or a recovery estimate.

Formulae and symbol definitions.

\[ C_t = C_{t-1} + R_t + E_t + F_t - U_t \]

Cₜ = Cₜ₋₁ + Rₜ + Eₜ + Fₜ − Uₜ

All terms are KES for week t: closing cash C, operating receipts R, new owner funds E, new borrowing F and all cash uses U. Opening cash C₀ is unrestricted. No emergency financing is inserted automatically.

\[ \mathrm{CCC} = \mathrm{DIO} + \mathrm{DSO} - \mathrm{DPO} \]

CCC = DIO + DSO − DPO

CCC is the cash conversion cycle in days. DIO is inventory days, DSO receivable days and DPO payable days. Use comparable periods and denominators; overdue claims still require review.

\[ \text{Extra weekly cash cost} = S \times \frac{m_b - m_s}{100} \]

Extra weekly cash cost = S × (mᵦ − mₛ) / 100

S is the illustrative KES weekly sales input, mᵦ base contribution margin and mₛ downside margin, entered as percentages. This stress assumes constant sales and immediately paid variable costs; it is separate from editable baseline supplier payments.

Read the example and its evidence.

The article and workbook explain the operating assumptions, evidence checks and limits behind this tool.

Open the companion article →