A 13-week cash plan with levers: when the reserve breaks and what holds it
Spreads the brand’s cash over 13 weeks: the path without measures at a given weekly outflow, the path with the expected effect of levers (one-off receipts and weekly effects times probability, less cost) and a conservative path with a shortfall allowance. Shows the week when cash falls below the reserve in each path, the lowest balance, the strongest lever and how much is missing to the reserve if only part of the measures works.
At a glance
- What question does it answer?
- In which week cash falls below the reserve without measures, with expected and with conservative measures and how much money is missing.
- What data is needed?
- The cash now, the weekly net flow without measures and the reserve.
- How to read the result?
- Example on the default values (cash RUB 9 million, outflow 0.9m a week, reserve 3m): without measures the reserve breaks in week 7; with expected measures 0, with conservative ones 0; the lowest balance with conservative measures is RUB 3.17 million, a shortfall to the reserve of RUB 0. The strongest lever is counted with probability. Example on the default values: Runway without measures to the reserve: 6.7 wk; Week the reserve breaks without measures: 7 wk; Week the reserve breaks with expected measures: does not happen within 13 weeks; Week the reserve breaks with conservative measures: does not happen within 13 weeks. The figures are illustrative: enter your own to see your result.
Why and how to reason
When cash leaves every week the main question is not “what is the yearly plan” but “in which week will I fall below the reserve and will the measures make it”. The path without measures is simple: cash now plus the weekly flow times the week number. Here RUB 9,000,000, an outflow of RUB 900,000 a week and a reserve of RUB 3,000,000: in week 7 there are RUB 2,700,000 left, the reserve is broken. Each lever adds a one-off amount in the start week and a weekly effect from that week, times probability, and subtracts the launch cost. Selling dead stock for RUB 3,000,000 at an 80% probability gives an expectation of RUB 2,400,000. The conservative path cuts the effect of levers by the allowance (25%) because measures almost always work later and weaker. A supplier deferral gives RUB 3,600,000 in week 2 and takes it back in week 9: if the second row is not recorded the plan misleads.
When to use it
Use it in the first days of a crisis and weekly within it when a quick answer is needed on whether the measures suffice before the reserve breaks. It does not replace a 13-week cash plan by line: that is built per payment and accounts for taxes, seasonal payments to factories and payroll by date. This calculation averages the base flow, so for decisions on specific payments move to the detailed plan. Assumptions: levers do not depend on each other, one probability covers a whole lever, costs are borne in the start week.
How to read the result
First look at the week of the break without measures: it shows how much time you have. Then compare the expected and the conservative paths. Here with expected measures the lowest balance is RUB 5,211,000 and with conservative ones RUB 3,170,750, just RUB 170,750 above the reserve: the margin is thin and one failed lever eats it. Look at the effect of the first four weeks: it is RUB 6,550,000, so the measures make it before week 7. There are usually one or two strongest levers, give them to the most reliable owner. If the lowest point of the conservative path is below the reserve the shortfall must be closed beyond the plan: a loan, an owner contribution, a new lever.
Common mistakes
The most dangerous error: record the receipt from a deferral and not the repayment. The second: put the start of all measures in week one while really they start later. The third: take the weekly outflow from the plan instead of the last weeks of fact. The fourth: count a probability of 100% for measures that depend on other people (a supplier, a platform). Empty one-off, weekly and cost fields are counted as zero.
What data is needed?
- The cash now, the weekly net flow without measures and the reserve.
- The list of levers: a one-off amount, a weekly effect, the start week, probability, cost.
- The shortfall allowance on the measures.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Cash now | ₽ | 9,000,000 | Free cash on accounts without pledged and earmarked funds. The example value is illustrative. |
| Weekly flow without measures | ₽ | −900,000 | The net weekly change of cash without crisis measures: negative means an outflow. Take it from the last 4-6 weeks, not from the plan. The example value is illustrative. |
| Minimum reserve | ₽ | 3,000,000 | The balance below which you must not go: the mandatory payments of the next two or three weeks (taxes, payroll, rent). The example value is illustrative. |
| Shortfall allowance on the measures | % | 25 | The conservative path counts the effect of levers this many percent below the expectation: measures almost always work worse and later than planned. The example value is illustrative. |
How it is calculated
| Step | Formula |
|---|---|
| Path without measures | cash(w) = cash now + weekly flow × w |
| Lever effect | one-off in the start week + weekly effect × (w − start + 1) for w ≥ start |
| Expected path | without measures + Σ probability × effect − launch cost |
| Conservative path | without measures + (1 − allowance) × Σ probability × effect − launch cost |
| Reserve break | the first week in which the balance is below the reserve |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Runway without measures to the reserve
- 6.7 wk(cash − reserve) ÷ weekly outflow.
- Week the reserve breaks without measures
- 7 wk
- Week the reserve breaks with expected measures
- does not happen within 13 weeks
- Week the reserve breaks with conservative measures
- does not happen within 13 weeks
- Lowest balance with expected measures
- 5.21 m ₽
- Lowest balance with conservative measures
- 3.17 m ₽Reached in week 13.
- Shortfall to the reserve with conservative measures
- 0 ₽This is what must be found beyond the plan: a loan, an owner contribution, one more lever.
- Expected effect of measures over 13 weeks
- 8.16 m ₽One-off and weekly effects weighted by probability, before cost.
- Cost of launching the measures
- 250,000 ₽
- Expected effect in the first 4 weeks
- 6.55 m ₽If it is small the measures will not make it before the reserve breaks.
- Strongest lever
- Sell dead stock through outside channels · 2.4 m ₽
- No measures
- Expected measures
- Conservative measures
Data as a table
| Week | No measures | Expected measures | Conservative measures |
|---|---|---|---|
| 0 | 9m | 9m | 9m |
| 1 | 8.1m | 8.21m | 8.18m |
| 2 | 7.2m | 9.65m | 9.04m |
| 3 | 6.3m | 12.2m | 10.7m |
| 4 | 5.4m | 11.7m | 10.1m |
| 5 | 4.5m | 11.2m | 9.48m |
| 6 | 3.6m | 10.7m | 8.89m |
| 7 | 2.7m | 10.3m | 8.31m |
| 8 | 1.8m | 9.78m | 7.72m |
| 9 | 900k | 7.14m | 5.51m |
| 10 | 0 | 6.65m | 4.93m |
| 11 | −900k | 6.17m | 4.34m |
| 12 | −1.8m | 5.69m | 3.76m |
| 13 | −2.7m | 5.21m | 3.17m |
Data as a table
| Measure | Expected effect minus cost |
|---|---|
| Sell dead stock through outside channels | 2.4m |
| A 30-day payment deferral from suppliers | 2.16m |
| Repaying the deferred supplier payments | −2.16m |
| Keep advertising only in paying channels | 1.4m |
| Hiring and bonus freeze | 912k |
| A discount for early payment by receivables | 900k |
| Preorder for the loyal base | 725k |
| Moving purchases to the next season | 1.3m |
| Review of rent and contractors | 270k |
Weeks and balances
| Week | No measures | Expected measures | Conservative measures |
|---|---|---|---|
| 1 | 8.1 m ₽ | 8.21 m ₽ | 8.18 m ₽ |
| 2 | 7.2 m ₽ | 9.65 m ₽ | 9.04 m ₽ |
| 3 | 6.3 m ₽ | 12.2 m ₽ | 10.7 m ₽ |
| 4 | 5.4 m ₽ | 11.7 m ₽ | 10.1 m ₽ |
| 5 | 4.5 m ₽ | 11.2 m ₽ | 9.48 m ₽ |
| 6 | 3.6 m ₽ | 10.7 m ₽ | 8.89 m ₽ |
| 7 | 2.7 m ₽ | 10.3 m ₽ | 8.31 m ₽ |
| 8 | 1.8 m ₽ | 9.78 m ₽ | 7.72 m ₽ |
| 9 | 900,000 ₽ | 7.14 m ₽ | 5.51 m ₽ |
| 10 | 0 ₽ | 6.65 m ₽ | 4.93 m ₽ |
| 11 | −900,000 ₽ | 6.17 m ₽ | 4.34 m ₽ |
| 12 | −1.8 m ₽ | 5.69 m ₽ | 3.76 m ₽ |
| 13 | −2.7 m ₽ | 5.21 m ₽ | 3.17 m ₽ |
The calculation helps to see when to act and which measures make it in time. A payment deferral lever gives cash now and takes it back later: both movements must be in the table, otherwise the plan misleads. It does not replace a 13-week cash plan by line: that one is built for each payment, here a quick answer to “will the measures be enough” is needed. For footwear and children’s the base outflow and the repayment timing differ: seasonal prepayment to factories, the school peak.
Nuances and limits
- Forgetting to repay the money from a supplier deferral: the plan misleads.
- Putting the start of all measures in week one: they start later.
- Taking the weekly outflow from the plan and not from the last weeks of fact.