Syntha Lab RU

Testing a plan for strength and 13 weeks of cash

From plan sensitivity and scenarios to the weekly cash balance and the runway.

both

Open interactively →

Route steps

  1. Quick business check: two periods
    From basic figures of two periods calculates gross margin, operating profitability, turnover, days of inventory, receivables and payables, the cash cycle, the share of returns and old stock and shows which way each moved.
  2. Sales forecast: method, horizon, error
    Builds a forecast from sales history using four methods, shows each method’s error on past data and suggests which is more reliable for your series.
  3. Plan sensitivity and breaking point
    Moves one factor at a time (price, volume, exchange rate, returns, discount, variable and fixed costs) in both directions, ranks them by effect on profit (tornado) and finds how far each must worsen for the plan profit to reach zero.
  4. Plan scenarios: base, optimistic, pessimistic
    Compares the profit and cash of a plan in the base case and in two or three of your scenarios: price, volume, exchange rate, returns, discount depth, customers’ payment terms. You set the scenario shifts yourself in the table.
  5. The 13-week cash plan: balance, gap and stress
    Week by week calculates the cash balance from receipts and payments, finds the first week below the minimum balance and the size of the gap, then repeats the calculation with delayed and short customer receipts.
  6. Runway: how many months the cash lasts
    From cash, revenue, margin, fixed costs and revenue growth calculates the monthly cash flow, the month the cash runs out, the lowest balance, the month of operating break-even and how much to raise to keep a reserve.

Documents for this route

Other routes for this audience