How to use · Cash flow & collections
See how one payment changes the cash ahead
Case background
A business is considering an $80k restock and wants to keep a $160k reserve. A three-week cash schedule is available; projections change with actual receipts and spending.
CaiGeekCan we afford an $80k restock now?
CaiGeekOn the current cash schedule, available cash falls to $145k in week three, below your $160k reserve.
Projected available cash
USD, thousandsBased on the current cash schedule. Update when collections, spending or order timing changes.
Where would you like to take this?
What if we pay half now and half in week two? How much could we pay upfront? What if $30k due in week three arrives in week four instead?What if we pay half now and half in week two?
CaiGeekCash is less tight in the first two weeks, but still ends at $145k in week three. Splitting payments does not close the later gap.
Projected available cash
USD, thousandsBased on the current cash schedule. Update when collections, spending or order timing changes.
Where would you like to take this?
How much could we pay upfront? What if $30k due in week three arrives in week four instead?How much could we pay upfront?
CaiGeekTotal restocking payments can reach $65k over these three weeks. The actual order still depends on demand, stock and lead times.
Total restocking payments in these three weeks must stay within this amount. Order quantities still depend on demand, inventory and lead times.
Where would you like to take this?
What if we pay half now and half in week two? What if $30k due in week three arrives in week four instead?What if $30k due in week three arrives in week four instead?
CaiGeekWeek-three cash would fall from $145k to $115k. Keeping the $160k reserve would limit total restocking payments in these three weeks to $35k.
Cash at the end of week three
USD, thousandsAssumes $30k expected in week three arrives in week four. Other periods still require checking against the actual cash schedule.
Where would you like to take this?
How much could we pay upfront? What if we pay half now and half in week two?Describe the planned payment and the room you want to preserve. Compare timing, and explore what happens if collections arrive late.
Start with my own question