Step 1: Identify Inflows: List all sources of cash entering the business, such as cash sales, payments from credit customers, loans received, and asset sales.
Step 2: Identify Outflows: List all cash leaving the business, including payments to suppliers, wages, rent, tax, interest, and equipment purchases.
Step 3: Calculate Net Cash Flow: Determine the difference for the period using the formula:
Step 4: Determine Balances: Calculate the final position by adding the Net Cash Flow to the Opening Balance:
The Carry-Forward Rule: Always ensure the closing balance of Month 1 is exactly the same as the opening balance of Month 2; this is the most common source of calculation errors.
Bracket Notation: In financial documents, negative numbers are often shown in brackets, e.g., . Ensure you subtract these when calculating the closing balance.
Sanity Check: If a business has a large negative net cash flow but a positive closing balance, check if the opening balance was large enough to cover the deficit.
Identify Non-Cash Items: Be vigilant for items like 'Depreciation' or 'Bad Debt Provisions'—these are accounting adjustments and should NEVER appear in a cash flow forecast.
Over-optimism: Businesses often overestimate the speed at which credit customers will pay, leading to a predicted surplus that never materializes.
Ignoring Seasonality: Failing to account for seasonal dips in sales or peaks in expenses (like annual insurance premiums) can lead to unexpected cash shortages.
Mixing Cash and Credit: Recording a sale the moment it happens rather than when the cash is actually received is a fundamental error in cash flow forecasting.
