Cash Flow Forecasting

A business can post record EBITDA and still miss payroll. I have seen it happen. Not because the business was failing, but because the finance team confused profitability with liquidity. The P&L said the quarter was strong. The bank account said otherwise.

This is the gap that separates reporting-focused finance teams from ones the CFO actually relies on. The P&L tells you whether the business is earning money. It does not tell you whether that money is available, when it arrives, or whether there is enough of it on the day the payroll file runs. That question belongs to the cash flow forecast, and getting it right is one of the most consequential things an FP&A team can do.

Why EBITDA Lies About Cash

EBITDA is a useful proxy for operating performance. It is a terrible proxy for cash availability. The gap between the two is not a rounding error. It is structural, and the list of items that sit in that gap is long enough to make a profitable business illiquid.

Working capital movements are the most common culprit. Revenue hits the P&L when it is recognised, not when it is collected. If DSO extends from 30 to 50 days because a few large enterprise customers negotiate longer payment terms, the P&L does not change at all. But the cash position changes materially because revenue that the business has “earned” is sitting in the receivables ledger instead of the bank account. I covered the mechanics of DSO, DPO, and the cash conversion cycle in Working Capital Management: The CFO’s Lever on Cash, and every one of those dynamics feeds directly into the cash forecast.

Capital expenditure is the second gap. EBITDA excludes depreciation, which is the accounting treatment of past capex. But it also excludes the cash outflow of current capex, the purchase orders and milestone payments happening right now. A business investing heavily in capacity, fit-out, or technology will show healthy EBITDA while burning through cash at a pace that EBITDA completely obscures.

Debt service is the third. Interest expense sits below the EBITDA line. Principal repayment does not appear in the P&L at all. A business with ₹5Cr in annual debt service has a ₹5Cr claim on its cash that EBITDA pretends does not exist.

Tax timing is the fourth. The P&L shows tax expense based on accrual accounting. Advance tax payments follow a different schedule entirely. A business with lumpy quarterly advance tax outflows will show a smooth tax line in the P&L and a very unsmooth cash impact in the bank statement.

Each of these items is well understood in isolation. The problem is that most finance teams model them separately (or not at all) and never reconcile the total picture back to the bank balance. The result is an EBITDA figure that leadership celebrates and a cash position that treasury scrambles to manage.

The Direct Method: Building a Cash Forecast That Stands on Its Own

Most finance teams build their cash flow forecast indirectly: start with net income, add back non-cash items, adjust for working capital, subtract capex and debt service. This is the standard three-statement model approach, and it works for annual planning. It fails for short-term liquidity management because it inherits every accrual assumption from the P&L and balance sheet, and those assumptions do not reflect when cash actually moves.

The direct method forecasts cash flows from their source: actual inflows and actual outflows, timed to when they hit the bank account.

Cash inflows start with the receivables schedule, not the revenue forecast. The question is not “how much will we sell?” but “how much will we collect, and when?” That means mapping each customer or customer segment to their expected payment behaviour. Some customers pay on terms. Some pay late consistently. Some pay early when offered a discount. The cash forecast reflects the collection pattern, not the billing pattern.

Cash outflows are built category by category, each with its own timing logic. Payroll runs on fixed dates. Rent and lease payments hit on contractual dates. Supplier payments follow the payables ageing schedule and the payment runs the AP team executes. Tax payments follow the statutory calendar. Debt service follows the loan amortisation schedule. Capex follows the project milestone plan, not the depreciation schedule.

Building the forecast this way is more work than the indirect method. But it produces a forecast that answers the question the CFO and treasury team actually care about: on any given day in the next thirteen weeks, how much cash will be in the bank account?

The 13-Week Cash Forecast

The 13-week cash forecast is the standard liquidity management tool, and for good reason. Thirteen weeks is one full quarter, long enough to see upcoming cash constraints in time to act and short enough to forecast with genuine accuracy.

The structure is week-by-week, with every material cash flow line itemised and timed to the specific week it hits the bank.

Week 1 is nearly certain. The receivables due this week are known from the AR ledger. The payment runs scheduled are confirmed. Payroll is fixed. The variance between forecast and actual in week 1 should be minimal.

Weeks 2 through 4 are high confidence. Collections are based on confirmed invoices and known payment patterns. Outflows are based on committed obligations and scheduled payment runs. The uncertainty at this horizon comes from timing (a payment arriving Thursday instead of Tuesday) rather than from whether the cash flow happens at all.

Weeks 5 through 8 introduce more estimation. Collections depend on revenue that has been invoiced but where payment timing is less certain. Outflows include discretionary spending where the timing of approval or execution may shift. The forecast at this horizon should show a range rather than a single point where material uncertainty exists.

Weeks 9 through 13 are directional. The forecast extends to maintain the full-quarter view, but the precision decreases with each passing week. The outer weeks rely more heavily on pattern-based assumptions (average weekly collections, average payment run size) and less on specific transaction-level detail.

This layered precision is the same principle I discussed in Rolling Forecasts: Why Your Annual Budget Is Obsolete by February, where near-term periods carry high confidence and outer periods carry directional accuracy. The discipline is the same: update with specifics as the week approaches, lock actuals as they close, and track forecast accuracy by week to improve the process over time.

The 13-week forecast rolls forward every week. When week 1 closes, actuals replace the forecast, and a new week 13 extends the horizon. The rolling mechanism keeps the forecast current without requiring a full rebuild.

Working Capital Timing: Where the Forecast Gets Real

The working capital assumptions in the 13-week forecast deserve their own section because this is where most cash forecasts break down.

The annual cash flow forecast models working capital as a net change: receivables went up by ₹2Cr, payables went down by ₹80L, net working capital absorbed ₹2.8Cr of cash. That is fine for understanding the year. It tells you nothing about which week the cash impact lands.

In the 13-week forecast, working capital timing is granular. Receivables are not “we expect to collect ₹X this quarter.” They are “invoice #4782 for ₹32L is due in week 3 and the customer has a 92% on-time payment rate based on the last eight invoices.” Payables are not “we expect to pay ₹Y this quarter.” They are “the next AP payment run is scheduled for Thursday of week 2 and includes ₹1.4Cr across 47 invoices.”

This transaction-level detail is essential for the near-term weeks. It is not feasible for the outer weeks, which is why the layered precision matters. By week 8, you are modelling aggregate collection rates and average payment run sizes. By week 12, you are using historical patterns adjusted for known events (a large customer payment, a quarterly tax outflow, a capex milestone).

The most dangerous working capital dynamic for cash forecasting is seasonality in collections that does not match seasonality in costs. A business that bills heavily in March but collects in May, while its cost base runs evenly throughout the year, has a predictable but severe cash trough in April. The P&L will show a profitable Q1. The bank account will show a business that needs a working capital facility to make it through the collection lag.

Capex and Debt Service: The Cash Flows the P&L Hides

Capital expenditure is the line item that consistently surprises finance teams in the cash forecast, not because the total annual capex is unknown, but because the timing of payments rarely follows the project timeline that was budgeted.

A ₹10Cr capex programme budgeted evenly across twelve months will almost never generate even cash outflows. Vendor milestone payments are lumpy. Equipment deposits are front-loaded. Construction progress billing follows completion certificates, not calendar months. The cash forecast needs the project-level payment schedule from the capex team, not the annual capex budget divided by twelve.

Debt service is simpler to forecast because it follows a contractual schedule, but it demands attention precisely because it is non-negotiable. Principal and interest payments happen on their scheduled dates regardless of business performance. A business that models EBITDA coverage of its debt obligations without modelling the cash flow timing of those obligations is answering the wrong question. The question is not whether the business generates enough profit to service its debt over a year. The question is whether the bank account has enough cash on the specific day the payment is due.

For businesses with variable-rate debt, the interest component of the forecast needs to reflect the current rate environment and any hedging arrangements in place. For businesses with bullet repayments or balloon structures, the principal repayment schedule creates cash flow cliffs that need to be visible in the forecast well before they arrive.

Presenting the Cash Position to the CFO

I have presented cash forecasts to leadership enough times to know what works and what does not. The detailed week-by-week forecast is the analytical backbone. It is not the presentation.

The CFO and board need three things from the cash position presentation.

The current position and trajectory. Opening cash balance, net cash movement over the forecast horizon, and closing cash balance. Presented as a waterfall that shows the major inflow and outflow categories between opening and closing. This is the single most important visual in the entire presentation because it shows where the cash is going and how much remains.

The minimum cash point. The lowest cash balance that the forecast reaches at any point during the 13-week horizon, and the week in which it occurs. This is the liquidity constraint. If the minimum cash point is above the operating cash buffer (the amount the business needs to maintain for daily operations and unexpected outflows), the position is comfortable. If the minimum point approaches or breaches the buffer, that is the conversation the CFO needs to have now, not when the week arrives.

Scenario sensitivity. What happens if DSO extends by five days (a large customer pays late)? What happens if the capex milestone payment accelerates by two weeks? What happens if revenue softens by 10% in the outer weeks? Presenting two or three scenarios alongside the base case demonstrates that the forecast has been stress-tested and that the finance team has thought about what could go wrong. It also gives the CFO actionable levers. If the downside scenario breaches the cash buffer, the discussion shifts immediately to which lever to pull: accelerate collections, defer discretionary capex, draw on the credit facility.

The discipline of presenting the cash forecast this way (position, constraint, and scenarios) is what transforms the cash forecast from a finance team exercise into a tool the CFO uses for capital allocation decisions. A CFO who trusts the cash forecast will fund investment proposals faster because they can see the impact on liquidity in real time. A CFO who does not trust it will hold cash buffers larger than necessary, which is a hidden cost the business bears without ever seeing a line item for it.

Building Credibility: Forecast Accuracy and the Feedback Loop

A cash forecast earns credibility the same way any forecast does: by tracking its accuracy, diagnosing its misses, and improving its assumptions systematically over time.

Every week when actuals replace the forecast for the closed period, I record the variance. Not just the net variance (forecast said ₹12Cr, actual was ₹11.4Cr) but the variance by line item. Did the miss come from collections, from a payment run that was rescheduled, from a capex payment that arrived a week early? The diagnosis matters because it tells you which assumptions to improve.

A cash forecast that is consistently accurate within 5% at the two-week horizon and 10% at the four-week horizon is a forecast leadership can rely on. A forecast that swings by 25% week to week because the assumptions are too rough or the data inputs are stale will be ignored regardless of how sophisticated the model is.

The most common accuracy killer I have seen is stale receivables data. If the cash forecast is built on Monday using the AR ageing from Friday, but the AR team processed ₹80L in collections over the weekend that have not yet been reconciled, the forecast is already wrong on the day it is produced. Real-time or daily AR data feeds into the forecast model solve this, and the improvement in near-term accuracy is immediate.

The cash flow forecast connects directly to nearly every other FP&A deliverable. The working capital assumptions flow from the working capital analysis. The revenue inputs come from the rolling forecast and the driver-based model that powers it. The scenario analysis uses the same methodology I covered in Scenario Planning: Building the Decision Architecture CFOs Actually Use. Cash flow forecasting is not a standalone exercise. It is the point where the entire FP&A infrastructure converges into the single question that matters most: do we have the cash to execute the plan?

If you are building or rebuilding your cash forecasting process, or wrestling with the gap between your P&L story and your treasury reality, I would welcome the conversation. Let’s connect.