Guide / Timing & priority
Cash waterfall vs. 13-week cash forecast
A waterfall allocates a pool of cash. A forecast shows whether that cash will be there when you need it.
The two tools answer different questions. An operating cash waterfall orders claims on a stated amount of cash: operating needs, tax payments, debt service, reserve funding and, finally, an optional distribution. A 13-week forecast follows expected receipts and payments through time, usually week by week. Neither replaces the other.
J.P. Morgan’s treasury guidance distinguishes a current cash position from a forecast of future cash levels based on anticipated inflows and outflows. This calculator adds a priority allocation to a single-period pool; it does not supply a schedule of when the underlying transactions happen.
What each model can tell you
| Question | Cash waterfall | 13-week cash forecast |
|---|---|---|
| Primary decision | Which uses get funded first? | When will liquidity tighten? |
| Core inputs | Available cash, priorities, requests and a cash floor. | Opening cash and dated receipts, payments and financing. |
| Typical output | Funded amounts, unfunded requests and retained cash. | Weekly cash balances and funding needs. |
| Key limitation | Aggregating the period can hide an earlier cash gap. | A forecast alone does not establish the right to make a payment. |
A positive ending balance can hide a shortage
Imagine a fictional company starts the month with $100,000, expects $600,000 of receipts and plans $550,000 of cash payments. A monthly summary ends at $150,000. That looks comfortable until you learn that $200,000 of payroll falls due before most customer receipts arrive.
If just $20,000 is collected before that payroll, the business has $120,000 against a $200,000 payment. It needs an $80,000 timing solution even though the full-month model ends positive. A single-period waterfall pools the $600,000 of receipts and cannot reveal that sequence. A weekly forecast may reveal it; a daily view is better when material dates fall within the same week.
Practical rule: only include cash in a decision-period waterfall if it will be available before the proposed payment. If that assumption is uncertain, examine the dates before relying on the allocation.
Use the two tools together
- Build the dated cash view. Start with reconciled available balances. Identify expected collections and separately schedule payroll, critical suppliers, tax and debt payments. Show assumptions that depend on collection timing.
- Identify the decision date. Select the date or interval for the allocation. Do not combine next month’s collections with a payment due this Friday.
- Apply the priority sequence. Use the applicable agreement and operating requirements to decide what comes first. The order in this tool is an illustrative operating example.
- Return the result to the forecast. A distribution reduces later liquidity. An earmarked reserve remains cash but may no longer be usable for ordinary payments. Reflect each in the appropriate balance.
- Stress the dependency. Delay a major receipt or reduce collections. Check both the first cash shortfall and the effect on lower-priority uses.
Keep the forecast alive
A useful management routine is to compare the latest week’s expected receipts and payments with actual cash movements, explain the differences and roll forward the remaining periods. Maintain a named owner for large uncertain items. An unexplained “other inflows” balance can hide the same problem a detailed forecast was supposed to expose.
For the wider reporting context, explore LenderReporting.com. Use the cash waterfall calculator to examine how a changed liquidity pool affects allocations, then reflect the result in your actual forecast.
Source & scope
J.P. Morgan: Making cash positioning and forecasting processes more efficient (June 16, 2022) informs the distinction between cash position and forecast. The numerical example and workflow are educational illustrations. This guide does not assess any company’s borrowing availability, solvency or contractual payment rights.