Cash Flow Forecasts

Step-by-Step Construction

• Step 1: Estimate Inflows: Predict sales volumes and apply the expected timing of payments. Include other sources like planned bank loans or asset sales.

• Step 2: Estimate Outflows: List all operational costs (wages, rent) and variable costs (inventory). Ensure payments are recorded in the month they are actually paid, not when the invoice is received.

• Step 3: Calculate Net Cash Flow: Use the formula: $\text{Net Cash Flow} = \text{Total Inflows} - \text{Total Outflows}$

• Step 4: Determine Balances: Calculate the closing balance using: $\text{Closing Balance} = \text{Opening Balance} + \text{Net Cash Flow}$

• Step 5: Iteration: Carry the closing balance forward to become the opening balance of the next period.

• Positive vs. Negative Net Cash Flow: A positive net cash flow indicates a business is generating more cash than it spends, while a negative figure indicates a cash drain. A negative net cash flow is not always a sign of failure (e.g., during a startup phase), but it must be managed with existing reserves or financing.

• The 'Carry Forward' Check: Always ensure the closing balance of one month is exactly the same as the opening balance of the next month. This is the most common source of calculation errors in exams.

• Identify Non-Cash Items: Be vigilant for items like 'Depreciation' or 'Bad Debt Provisions' in a list of data. These should never be included in a cash flow forecast as no money changes hands.

• Watch the Signs: Pay close attention to negative numbers. If the net cash flow is negative, it must be subtracted from the opening balance. If the opening balance is already negative (an overdraft), a negative net cash flow will make it more negative.

• Sanity Check: If a business has a massive loan inflow in month one, the closing balance should reflect that jump. If the numbers don't look 'logical' relative to the events described, re-check your additions.

• Over-optimism Bias: Businesses often overestimate future sales inflows and underestimate the time it takes for customers to pay. This leads to a forecast that looks healthier than reality.

• Ignoring External Factors: Forecasts are often based on internal estimates and may fail to account for external shocks like interest rate hikes, supplier price increases, or economic downturns.

• Confusing Revenue with Inflow: Revenue is recognized at the point of sale, but cash inflow only occurs when the money hits the bank account. Forgetting this distinction leads to severe liquidity crises.