What it means
The projection starts with the opening cash balance, adds expected receipts and subtracts expected payments to arrive at a closing balance for each period. Most businesses build it weekly for the next three months and monthly for the rest of the year, because near term accuracy matters far more than distant precision.
The difference between estimated cash flow and forecast profit trips up more first time business owners than any other concept. A sale invoiced in March but paid in May contributes to March profit and to May cash, and a machine bought outright reduces cash immediately while only reducing profit gradually through depreciation.
Building the estimate well means working from behaviour rather than from terms. If your stated payment terms are 30 days but customers actually pay in 47 days on average, the projection must use 47, otherwise it will overstate cash in every single period and be quietly useless.
The output is normally three versions rather than one. A base case built on expected performance, a downside case assuming slower collections and softer sales, and an upside case, because the point of the exercise is to identify the range of outcomes the business needs to be able to survive.
An estimated cash flow only earns its place if it is compared against what actually happened. Reviewing forecast against actual each week shows where the model is systematically wrong, and after a couple of months of that discipline the projection becomes genuinely reliable.
In practice
Real-world examples.
Example
A seasonal garden centre projects cash weekly and sees a $95,000 trough in February before spring trading begins. It arranges an overdraft facility in November, when its balance sheet still looks strong, rather than in February when it does not.
Example
A recruitment agency wins a large contract requiring it to pay contractors weekly while the client pays in 60 days. The estimated cash flow shows the contract consuming $340,000 of working capital before it generates a cent, so the agency negotiates fortnightly billing before signing.
Example
A manufacturer planning a $500,000 equipment purchase runs a downside estimate assuming collections slow by two weeks. The projection shows the balance falling below its covenant floor, so it splits the purchase across two quarters instead.
Think of it
“Estimated cash flow is your forecast-what you think cash flows will be.
Formula
Calculation
Estimated closing cash = Opening cash balance + Estimated receipts - Estimated payments
A commercial cleaning company starts October with $180,000 in the bank. It expects to collect $640,000 from customers based on its actual invoice ledger and average collection pattern, plus $20,000 from the sale of an old van, giving total estimated receipts of $640,000 + $20,000 = $660,000.
Estimated payments for the month are $310,000 to suppliers and subcontractors, $220,000 of payroll, $75,000 of rent and overheads, and a $40,000 tax instalment. Total payments = $310,000 + $220,000 + $75,000 + $40,000 = $645,000.
Net cash movement = $660,000 - $645,000 = $15,000.
Estimated closing cash = $180,000 + $15,000 = $195,000.
The month looks comfortable in total, but the tax instalment and payroll both fall in the same week. If collections in that week come in at $90,000 against payments of $260,000, the balance dips by $170,000 mid month, which is why weekly rather than monthly projection matters.Case study
Seen in the real world.
The following is an illustrative, entirely fictional example. Copperfield Interiors, an invented commercial fit out contractor turning over $9,000,000 a year, was consistently profitable and consistently short of cash. Its finance function produced a monthly profit report and nothing else, and the managing director genuinely could not explain why a business making a 9% margin kept needing its overdraft extended.
A new financial controller built a thirteen week estimated cash flow from the actual sales ledger, the purchase ledger and the payroll calendar. It showed that Copperfield paid its subcontractors on 21 day terms while its main clients paid on 63 day terms in practice, so every new project consumed cash for six weeks before returning any.
In this fictional scenario the projection did not solve the problem by itself, but it made the problem visible and quantified. Copperfield moved subcontractors to 45 day terms, introduced stage applications for payment on projects over $250,000, and within two quarters was running with a positive cash balance rather than a permanent overdraft.
Watch out
Common mistakes.
- Building the projection from profit forecasts rather than from the timing of actual receipts and payments, which hides every working capital problem the business has.
- Using contractual payment terms instead of the collection pattern customers actually follow, which overstates cash in every future period.
- Forecasting monthly only, so a mid month squeeze between payroll and a tax payment never appears until it is happening.
Questions
People also ask.
How far ahead should an estimated cash flow run?
Thirteen weeks in detail is the common working horizon, extended to twelve months at a monthly level for budgeting and facility discussions.
Should VAT or sales tax be included?
Yes, because the business physically holds and then pays that money, and forecasts that ignore tax payments are the single most common cause of unexpected shortfalls.
How accurate should the estimate be?
Within roughly 5% for the first four weeks is a reasonable working standard, with accuracy naturally falling away over longer horizons.
From the founder's library
Take it further with the book.
Build your financial confidence beyond this definition. Shihan's full-length guide, Accounting Fundamentals, takes the same plain-English approach and turns it into a complete, practical playbook for non-finance managers, business owners and students - with chapter-end quiz answers and presentation slides included.
25% off with code MMHQ25, applied at checkout. Priced in USD - checkout may show the equivalent in your local currency.
View the book and save 25%