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

Tool13-Week Cash Flow
Sourceoriginal
LevelProfessional

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
Open the 13-Week Cash Flow tool

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.

More Examples for This Tool