Thirteen week cash flow
Every commitment below sits in the week it actually falls, taken from this year's payment history. The three inputs you control are underneath. Change them and the whole calendar moves.
Amex charges about $22,540 a week. Pay less than that and the bottom row shows the balance climbing, against a card with $0 of Pay Over Time left. Over the last twelve weeks the card was paid $20,580 a week, which is $1,960 short and is exactly why the balance went from $42,853 in January to $62,856 now. Paying it down slower does not free up cash, it moves the shortfall onto the card.
| Week beginning | Aug 6 | Aug 13 | Aug 20 | Aug 27 | Sep 3 | Sep 10 | Sep 17 | Sep 24 | Oct 1 | Oct 8 | Oct 15 | Oct 22 | Oct 29 |
|---|
Commitments do not arrive evenly. The SBA loan, the vehicle loan, the Line of credit minimum and a payroll run all land inside the same seven days twice in this window, on top of the Amex draw that never stops.
The earlier model repeated one average week thirteen times. This one places each commitment on the date it has actually landed all year. Below is the evidence for each, so nothing here is a guess dressed up as a schedule.
| Commitment | Each time | Pattern in the ledger | Dates in this window |
|---|---|---|---|
| Payroll and payroll taxes | $6,405 | Fourteen runs since January, every other week, never more than $56 apart | Aug 12, Aug 26, Sep 9, Sep 23, Oct 7, Oct 21, Nov 4 |
| Rent | $5,765 | Seven for seven, between the 7th and the 10th, identical amount | Aug 10, Sep 9, Oct 9 |
| Store credit card | $1,914 | The 14th of every month without exception. Amount varies, this is the average | Aug 14, Sep 14, Oct 14 |
| SBA loan | $3,258 | The 17th, seven for seven, same amount every month | Aug 17, Sep 17, Oct 17 |
| Vehicle loan | $791 | Same day as the SBA payment all year | Aug 17, Sep 17, Oct 17 |
| Line of credit minimum | $1,886 | Statement due the 21st. This is the minimum, not a paydown | Aug 21, Sep 21, Oct 21 |
| Overseas contractor | $980 | Sixteen payments since January 2, every other week | Aug 14, Aug 28, Sep 11, Sep 25, Oct 9, Oct 23 |
| Amex | $22,540 a week | Thirty five payments in thirteen weeks, roughly three a week. Card closes the 15th and debits the 10th | Every week |
| Supplier wires | $6,125 a week | The main suppliers and the smaller factories. Order driven and genuinely lumpy, so this one is an assumption you set | Spread evenly |
| Everything else | $5,005 a week | Utilities, insurance, smaller contractors, fees. What is left after the named lines | Spread evenly |
| Receipts | $36,750 a week | Twelve full weeks to July 27, averaging $36,750 with a middle range of $29,960 to $40,670 | Every week |