the interpretation and amendment of simple cash flow forecasts including calculating opening and closing balances

5.3 Forecasting and Managing Cash Flows – Cash Flow Forecasts

What is a Cash Flow Forecast?

Think of it as a budget planner for your business’s money. It tells you how much cash you expect to receive (inflows) and spend (outflows) over a period, usually month‑by‑month. The goal is to avoid running out of cash or having too much idle money.

Key Components of a Simple Forecast

  1. Opening Balance – cash you have at the start of the period.
  2. Cash Inflows – money coming in (sales, loans, etc.).
  3. Cash Outflows – money going out (rent, salaries, supplies).
  4. Closing Balance – cash at the end of the period.

The relationship is simple:



\$C{\text{closing}} = C{\text{opening}} + C{\text{inflows}} - C{\text{outflows}}\$

Example Forecast (Monthly)

MonthOpening Balance ($)Cash Inflows ($)Cash Outflows ($)Closing Balance ($)
January$5,000$3,200$2,500$5,700
February$5,700$2,800$3,000$5,500
March$5,500$4,000$2,200$7,300

Notice how the closing balance becomes the opening balance for the next month. This “rolling” method keeps the forecast continuous.

Interpreting the Forecast

  • 🔍 Positive closing balance means you have cash left over – good for future investments.
  • ⚠️ Negative closing balance (not shown here) indicates a cash shortfall; you may need a loan or to cut costs.
  • 📈 Increasing inflows over months suggests growing sales or better collection.
  • 💸 Consistent outflows help you spot recurring expenses that could be renegotiated.

Exam Tip Box

• When asked to amend a forecast, first identify the error (e.g., missing inflow).

• Re‑calculate the affected month’s closing balance using the formula above.

• Remember: each month’s opening balance equals the previous month’s closing balance.

• Show all steps clearly – examiners appreciate a tidy, logical approach.

• Use emojis or colour coding in your notes to keep track of changes, but keep the final answer neat and readable.

Analogy: The Cash Flow Forecast is Your “Money Calendar”

Imagine a calendar where each day you write down how much money you expect to receive and spend. By the end of the month, you can see if you’ll have enough to pay the rent or if you need to save a bit more. That’s exactly what a cash flow forecast does for a business – it keeps the money moving smoothly, just like a well‑planned personal budget keeps your allowance from running out before the next payday.