Tools › Finance and Business › Finance › 13-Week Cash Flow › Example
Payroll and a quarterly tax payment in the same week: one week under the minimum in a steady quarter
| Tool | 13-Week Cash Flow |
| Source | original |
| Level | Professional |
Problem
A business takes in 24,000 a week and pays a 30,000 payroll every other week. A quarterly tax payment of 38,000 falls in week 6, a payroll week. Opening cash is 30,000 and the minimum to hold is 20,000. Does any week close under the minimum?
Inputs to Enter
- Opening cash 30,000; minimum cash 20,000
- In: customer receipts 24,000 every week
- Out: payroll 30,000 every 2 weeks from week 2; suppliers 4,000 every week; rent 5,000 every 4 weeks from week 1; quarterly tax payment 38,000 once in week 6
Answers
- Week 6: closing cash = 60,000 + 24,000 − 72,000 = 12,000 (payments: payroll 30,000 + suppliers 4,000 + tax 38,000)
- Week 6 is the only week of the 13 under the minimum; cash needed to stay at the minimum = 20,000 − 12,000 = 8,000
- Receipts exceed payments by 22,000 over the quarter; cash after week 13 is 52,000
Notes
Open this case in the tool: /analysis-tools/business/finance/13-week-cash-flow/?try=payroll-and-tax-same-week. Illustrative numbers; checked against an independent numpy computation. A forecast from the entries, not financial advice.