Tools › Finance and Business › Finance › 13-Week Cash Flow


13-Week Cash Flow

Enter opening cash, the minimum to hold, dated items (an amount, a first week and how often it repeats) and the invoices customers still owe; get the closing cash of each of the next 13 weeks, the week it falls below the minimum, the lowest point and the amount needed to stay above the line, drawn on one chart. A stress case, a credit line and a monthly runway mode (how many months the cash lasts, and how many months each planned hire costs) are included. Every default is an illustrative number. The tool computes a forecast from what is entered; it is not financial advice.

  • Week-by-week cash: opening, receipts, payments, net and closing, with the week cash falls below the minimum marked on the chart

  • Dated and repeating items, receivables with a collection delay and a share never collected, a stress case and a credit line

  • Monthly runway mode: months of cash, the break-even month and the runway given up for each planned hire

13-Week Cash Flow

/

Forecast


Cash (any one currency)




Money In and Out (amounts per occurrence)

1
2
3
4
5

Invoices Customers Still Owe

1
2
3

Collections



More Items (optional; one per line as name, kind, amount, first week, every, last week)


Stress Case (0 and 0: none)



Credit Line (limit 0: none)



Runway (monthly amounts)





Planned Hires

1
2

Funding Event (optional)



×

13-Week Cash Flow

13-Week Cash Flow: Will the Cash Last?

The tool places every expected receipt and payment in the week the cash actually moves and works out the bank balance at the end of each of the next 13 weeks. It marks the first week the balance falls below the minimum you want to hold, the lowest point, and the amount that would keep every week at or above the line. A second mode does the same by month to answer how long the cash of a business that spends more than it takes in will last. The tool computes a forecast from what is entered; it is not financial advice.

The idea: cash is counted when it moves

An income statement counts a sale when it is made and a cost when it is incurred. The bank balance changes only when the customer pays and when the bill is paid. The U.S. Small Business Administration's guide puts the difference in one example: a sale made in January and paid in February is on January's books under the accrual method and on February's under the cash method. A cash forecast is the cash method looking forward. That is why a business can be profitable on paper and still be unable to make payroll: the profit is sitting in invoices that customers have not paid yet.

Thirteen weeks is one quarter. Weeks are used because payroll, rent, loan payments and tax deposits fall on particular days, and a month that ends with plenty of cash can still have a week in the middle with none.

Closing cash by week falling below the minimum line in week 3 while invoices are collected late, with weekly receipts and payments as bars
Figure 1: The default case (illustrative numbers). Payments run every week; the invoices customers owe arrive three weeks late, in weeks 5, 7 and 9. Receipts exceed payments by 88,700 over the quarter, yet the balance is below the minimum in weeks 3, 4 and 6.

The weekly forecast

Each item has an amount, a first week, a repeat interval in weeks and, optionally, a last week. An item with first week 2 and interval 4 falls in weeks 2, 6 and 10; interval 0 means once. Each open invoice has an amount and the week it is due; it arrives late by the collection delay and smaller by the share never collected:

cash from an invoice = amount × (1 − share never collected), received in week (week due + weeks paid late)

An invoice that lands after week 13 is outside the forecast and is listed as such. Then, for every week t from 1 to 13:

closing casht = opening casht + receiptst − paymentst, and opening casht+1 = closing casht

cash needed to stay at the minimum = minimum cash − lowest closing cash (zero when the lowest balance is above the minimum)

The stress case repeats the forecast with every "In: sales" item lowered by a percentage and the open invoices collected a further number of weeks late. Invoices already billed are not cut by the sales percentage.

The credit line is drawn in a week that would otherwise close below the minimum, by just enough to reach it and never beyond the limit, and is repaid from any cash above the minimum in later weeks. Interest on the balance carried into a week is paid in that week:

interestt = line balancet−1 × yearly rate / 52

The monthly runway

For month m, with revenue growing at a constant percentage g per month and each planned hire adding its monthly cost from its start month on:

revenuem = revenue1 × (1 + g)m − 1

closing cashm = opening cashm + revenuem − costsm + fundingm

The cash runs out in the first month k that closes below zero. The runway counts the k − 1 full months before it plus the fraction of month k that the opening cash covers:

runway = (k − 1) + opening cashk / (opening cashk − closing cashk)

The tool repeats the calculation with all hires left out, and with one hire left out at a time. The difference is the runway that hire uses. With growing revenue the answer can change in kind, not just in size: a plan that reaches the month where revenue covers costs before the cash is gone never runs out, and one more hire can move it to the other side.

What it assumes

  • Every amount and week is what you entered. Nothing is estimated, fetched or benchmarked.
  • A week is one block: all receipts and payments of a week are netted, so a payment on Monday and a receipt on Friday of the same week cancel.
  • All customers pay late by the same number of weeks and the same share of every invoice is never collected.
  • The stress case cuts "In: sales" items only; payments stay as entered.
  • The credit line is available on demand up to its limit, interest is simple at one fifty-second of the yearly rate per week, and no fees are charged.
  • In the runway mode revenue is cash received in the month, growth is the same every month, and costs change only through the listed hires.

When it misleads

  • When the dip is inside a week. A week that closes above the minimum can still be overdrawn for a few days.
  • When receipts are entered as sales. A sale made on 30-day terms in week 3 is cash in week 7 or later.
  • When one large customer pays later than the rest. Enter that invoice with its own later due week.
  • When the forecast is old. A 13-week forecast is usually rebuilt every week with actual balances; this tool holds no history.
  • When constant growth is carried too far. Eight percent a month is a revenue ten times larger in thirty months; the runway mode does not question the rate entered.
  • When costs follow sales. Suppliers, commissions and sales taxes move with revenue; here they move only if you change them.

Common mistakes

  • Using profit instead of cash. Depreciation is a cost that moves no cash; a loan repayment moves cash and is not a cost.
  • Counting an invoice twice: once as an open invoice and again inside a weekly sales receipt.
  • Forgetting payments that are not monthly: quarterly tax deposits, insurance premiums, annual licenses, a third payroll in a five-week month for a business that pays every other week.
  • Entering payments as negative numbers. Amounts are positive; the kind says whether the item comes in or goes out.
  • Reading the last week only. The question is the lowest week, not the final balance.
  • Dividing cash by this month's net outflow to get a runway when revenue or costs are changing. That shortcut holds only if every month looks like this one.

Checks

Every figure of the five "Try this" cases, 60 seeded random weekly cases (items, invoices, stress case and credit line) and 40 seeded random runway cases is compared with an independent computation written separately in Python with numpy. The method is arithmetic; no published worked example is reproduced. The Small Business Administration page was read for the terms (cash against accrual accounting, receivables and payables), not for a method.




References

U.S. Small Business Administration (2026). Manage Your Business: Manage Your Finances. Business Guide, U.S. Small Business Administration, Washington, DC.


DISCLAIMER: The methods and calculation on aNOWysis.com are provided as means to educate the reader. There is no warranty, expessed or implied, as to the relevance or accuracy of the methods or calculations. All calculations should be checked by a qualified analyst for appropriateness and accuracy. We will not be held liable for any damages, injuries or deaths caused by using methods or calculations from this site.