Tools › Finance and Business › Finance › 13-Week Cash Flow › Example

Stress case with a credit line: sales receipts down 25 % and collections two weeks later

Tool13-Week Cash Flow
Sourceoriginal
LevelProfessional

Problem

A business with 60,000 of opening cash and a 25,000 minimum stays above the line in its base forecast. In a stress case its sales receipts are 25 % lower and its open invoices arrive two weeks later still. It has a 40,000 credit line at 9 % a year. Does the line cover the gap?

Inputs to Enter

  • Advanced mode. Opening cash 60,000; minimum cash 25,000
  • In: customer receipts 34,000 every week. Out: payroll 44,000 every 2 weeks from week 1; suppliers 13,000 every week; rent and utilities 7,500 every 4 weeks from week 1; insurance premium 12,000 once in week 5
  • Open invoices 40,000 due week 1 and 30,000 due week 3; paid 1 week late; 1 % never collected
  • Stress case: sales receipts down 25 %, collected 2 weeks later. Credit limit 40,000 at 9 % a year
Open the 13-Week Cash Flow tool

Answers

  • Base forecast: lowest closing cash 29,500 in week 1, no week under the minimum
  • Stress case: lowest closing cash −58,200 in week 13; cash needed to stay at the minimum = 25,000 − (−58,200) = 83,200
  • With the line: the balance reaches the 40,000 limit in week 11; interest over the 13 weeks is 352.06 (balance carried × 9 % / 52 each week)
  • The limit is reached: cash is still 43,552 under the minimum in week 13

Notes

Open this case in the tool: /analysis-tools/business/finance/13-week-cash-flow/?try=sales-drop-credit-line. The line is drawn only in a week that would close under the minimum and repaid from cash above it; the stress cut applies to the sales items, not to invoices already billed. Illustrative numbers; checked against an independent numpy computation. Not financial advice.

More Examples for This Tool