🔮 What is a Cash Flow Forecast?
Definition: A cash flow forecast is a prediction of the expected cash inflows and outflows over a future period — usually the next 12 months, shown month by month.
It allows managers to anticipate when cash shortages might occur so they can plan ahead — like checking the weather forecast before a hike! ⛰️
- Helps identify months where cash may run low
- Enables the business to arrange finance in advance
- Essential for bank loan applications and investor pitches
- Helps with budgeting and financial planning
🏗️ Structure of a Cash Flow Forecast
A typical cash flow forecast has three sections arranged in rows, with months as columns:
- Section 1: Cash inflows — cash sales, credit sales received, loans, other income
- Total inflows = sum of all inflows for that month
- Section 2: Cash outflows — purchases, wages, rent, utilities, loan repayments, equipment
- Total outflows = sum of all outflows for that month
- Section 3: Net cash flow = Total inflows − Total outflows
- Opening balance = closing balance from the previous month
- Closing balance = Opening balance + Net cash flow
The closing balance is the most important number — a NEGATIVE closing balance means the business will run out of cash that month! 🚨
Practice with real exam questions
Answer exam-style questions and get AI feedback that shows you exactly what examiners want to see in a full-marks response.
Try Practice Free7-day free trial • No card required
🔢 Constructing & Amending Forecasts
Simple 3-month forecast:
| Jan | Feb | Mar Inflows | $8,000 | $10,000| $12,000 Outflows | $9,000 | $8,000 | $9,000 Net cash | −$1,000| $2,000 | $3,000 Opening bal| $3,000 | $2,000 | $4,000 Closing bal| $2,000 | $4,000 | $7,000
January has negative net cash flow but the opening balance covers it. The trend improves over the quarter.
In the exam, you may be asked to amend a forecast — e.g. 'what happens if sales increase by 10% in March?' Simply recalculate the affected figures.
When amending a forecast, change ONLY the figures affected and recalculate net cash flow and closing balance. Don't change figures that aren't impacted! ✏️
⚠️ Limitations of Cash Flow Forecasts
Forecasts are estimates based on assumptions — they are rarely 100% accurate.
- Based on predictions — actual sales may be higher or lower
- Unexpected costs can arise (repairs, legal issues, price increases)
- External shocks (recession, pandemic, new competitors) are unpredictable
- Only as good as the assumptions used to create them
- Can give a false sense of security if overly optimistic
A forecast is a PLAN, not a guarantee. Smart businesses update their forecasts regularly as new information becomes available 📊