Syntha Lab RU

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.

The 13-week cash plan For whom: Finance directors and owners who need a quick answer on when the reserve breaks and whether the measures are enough.

Calculate on your data →

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

FieldUnitValue in the exampleMeaning
Cash now₽9,000,000Free cash on accounts without pledged and earmarked funds. The example value is illustrative.
Weekly flow without measures₽−900,000The 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,000The 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%25The 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

StepFormula
Path without measurescash(w) = cash now + weekly flow × w
Lever effectone-off in the start week + weekly effect × (w − start + 1) for w ≥ start
Expected pathwithout measures + Σ probability × effect − launch cost
Conservative pathwithout measures + (1 − allowance) × Σ probability × effect − launch cost
Reserve breakthe 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 ₽
Cash by week: without measures, with expected and conservative measures
Line chart: No measures: 9m → −2.7m; Expected measures: 9m → 5.21m; Conservative measures: 9m → 3.17m−5m05m10m15m024681012reserveNo measures, 0: 9mNo measures, 1: 8.1mNo measures, 2: 7.2mNo measures, 3: 6.3mNo measures, 4: 5.4mNo measures, 5: 4.5mNo measures, 6: 3.6mNo measures, 7: 2.7mNo measures, 8: 1.8mNo measures, 9: 900kNo measures, 10: 0No measures, 11: −900kNo measures, 12: −1.8mNo measures, 13: −2.7mExpected measures, 0: 9mExpected measures, 1: 8.21mExpected measures, 2: 9.65mExpected measures, 3: 12.2mExpected measures, 4: 11.7mExpected measures, 5: 11.2mExpected measures, 6: 10.7mExpected measures, 7: 10.3mExpected measures, 8: 9.78mExpected measures, 9: 7.14mExpected measures, 10: 6.65mExpected measures, 11: 6.17mExpected measures, 12: 5.69mExpected measures, 13: 5.21mConservative measures, 0: 9mConservative measures, 1: 8.18mConservative measures, 2: 9.04mConservative measures, 3: 10.7mConservative measures, 4: 10.1mConservative measures, 5: 9.48mConservative measures, 6: 8.89mConservative measures, 7: 8.31mConservative measures, 8: 7.72mConservative measures, 9: 5.51mConservative measures, 10: 4.93mConservative measures, 11: 4.34mConservative measures, 12: 3.76mConservative measures, 13: 3.17m₽Week
  • No measures
  • Expected measures
  • Conservative measures
Data as a table
WeekNo measuresExpected measuresConservative measures
09m9m9m
18.1m8.21m8.18m
27.2m9.65m9.04m
36.3m12.2m10.7m
45.4m11.7m10.1m
54.5m11.2m9.48m
63.6m10.7m8.89m
72.7m10.3m8.31m
81.8m9.78m7.72m
9900k7.14m5.51m
1006.65m4.93m
11−900k6.17m4.34m
12−1.8m5.69m3.76m
13−2.7m5.21m3.17m
Lever contribution over 13 weeks weighted by probability
Bar chart: 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−3m−2m−1m01m2m3mSell dead stock through outside channelsSell dead stockthrough outside…Expected effect minus cost: 2.4m2.4mA 30-day payment deferral from suppliersA 30-day paymentdeferral from…Expected effect minus cost: 2.16m2.16mRepaying the deferred supplier paymentsRepaying thedeferred supplier…Expected effect minus cost: −2.16m−2.16mKeep advertising only in paying channelsKeep advertisingonly in paying…Expected effect minus cost: 1.4m1.4mHiring and bonus freezeHiring and bonusfreezeExpected effect minus cost: 912k912kA discount for early payment by receivablesA discount for earlypayment by…Expected effect minus cost: 900k900kPreorder for the loyal basePreorder for theloyal baseExpected effect minus cost: 725k725kMoving purchases to the next seasonMoving purchases tothe next seasonExpected effect minus cost: 1.3m1.3mReview of rent and contractorsReview of rent andcontractorsExpected effect minus cost: 270k270k₽
Data as a table
MeasureExpected effect minus cost
Sell dead stock through outside channels2.4m
A 30-day payment deferral from suppliers2.16m
Repaying the deferred supplier payments−2.16m
Keep advertising only in paying channels1.4m
Hiring and bonus freeze912k
A discount for early payment by receivables900k
Preorder for the loyal base725k
Moving purchases to the next season1.3m
Review of rent and contractors270k

Weeks and balances

WeekNo measuresExpected measuresConservative measures
18.1 m ₽8.21 m ₽8.18 m ₽
27.2 m ₽9.65 m ₽9.04 m ₽
36.3 m ₽12.2 m ₽10.7 m ₽
45.4 m ₽11.7 m ₽10.1 m ₽
54.5 m ₽11.2 m ₽9.48 m ₽
63.6 m ₽10.7 m ₽8.89 m ₽
72.7 m ₽10.3 m ₽8.31 m ₽
81.8 m ₽9.78 m ₽7.72 m ₽
9900,000 ₽7.14 m ₽5.51 m ₽
100 ₽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.

Terms used

Calculate on your data →