Tools › Finance and Business › Finance › 13-Week Cash Flow › Example
Profitable but out of cash: a 13-week forecast with invoices paid three weeks late
| Tool | 13-Week Cash Flow |
| Source | original |
| Level | Professional |
Problem
A business opens the quarter with 90,000 in the bank and wants to hold at least 15,000. Payroll, suppliers, rent and a loan payment run on their usual dates; customers owe three invoices and pay three weeks after the due date. In which week does cash fall below the minimum, how low does it go, and how much would keep every week at the line?
Inputs to Enter
- Opening cash 90,000; minimum cash 15,000; week 1 starts 2027-01-04
- Out: payroll 24,000 every 2 weeks from week 1; suppliers 9,000 every week; rent 6,000 every 4 weeks from week 1; loan payment 3,000 every 4 weeks from week 2
- In: new sales 28,000 every week from week 7
- Open invoices 60,000 / 85,000 / 70,000 due weeks 2 / 4 / 6; paid 3 weeks late; 2 % never collected
Answers
- First invoice: 60,000 × (1 − 2/100) = 58,800, received in week 2 + 3 = 5
- Week 3: closing cash = 39,000 + 0 − 33,000 = 6,000, the first week under the 15,000 minimum
- Lowest closing cash −3,000 in week 4; 3 of the 13 weeks close under the minimum (weeks 3, 4 and 6)
- Cash needed to stay at the minimum = 15,000 − (−3,000) = 18,000
- Over the 13 weeks receipts 406,700 exceed payments 318,000 by 88,700; cash after week 13 is 178,700
Notes
The tool opens on this case; press Submit, or open it in the tool: /analysis-tools/business/finance/13-week-cash-flow/?try=profitable-but-out-of-cash. With the invoices paid on their due dates no week closes under the minimum. Illustrative numbers, no real business; checked against an independent numpy computation (test_13_week_cash_flow.php). A forecast from the entries, not financial advice.