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
| Tool | 13-Week Cash Flow |
| Source | original |
| Level | Professional |
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
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.