Skip to content
Tutorials Center
My learning

Topics

Lesson 29 of 37 ยท Finance and Cash Flow

Cash Flow Forecasts

Learn why cash is not profit, how to build a monthly cash flow forecast with opening and closing balances, and how to fix cash shortages, with a runnable forecast tool.

Many profitable businesses fail. The reason is usually cash flow: the movement of money into and out of the business. If a firm cannot pay wages and suppliers on time, it can collapse, even when its sales look good on paper.

Cash is not profit

  • Profit is revenue minus costs over a period.
  • Cash is the money the business actually has available.

A firm can sell $50,000 of goods on credit in March (profit appears) but not receive the money until May. In the meantime it must still pay rent and wages. That gap is why cash needs its own forecast.

Cash inflows and outflows

Inflows (receipts): sales paid in cash, customers paying their invoices, loans received, owner's capital, asset sales. Outflows (payments): materials, wages, rent, utility bills, loan repayments, equipment purchases, tax.

The cash flow forecast

A cash flow forecast is a table predicting, month by month, the money coming in and going out.

For each month:

net cash flow = total inflows - total outflows closing balance = opening balance + net cash flow

The closing balance of one month becomes the opening balance of the next.

Worked example. A small shop starts January with $2,000.

Jan Feb Mar
Opening balance 2,000 1,500 200
Receipts 6,000 5,000 9,000
Payments 6,500 6,300 6,000
Net cash flow -500 -1,300 3,000
Closing balance 1,500 200 3,200

Check: February net = 5,000 - 6,300 = -1,300; closing = 1,500 - 1,300 = 200. March net = 9,000 - 6,000 = 3,000; closing = 200 + 3,000 = 3,200.

The shop nearly runs out in February, so the manager should arrange an overdraft in advance.

Python Cash flow forecast builder

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Why forecast?

  • To spot shortages before they happen and arrange finance.
  • To support loan applications (banks want to see a forecast).
  • To plan large purchases.
  • To measure how well the business is doing against its plan (compare forecast with actual figures, find variances).

Limits of forecasts

Forecasts are estimates. Sales may be lower than expected, customers may pay late, and costs can rise. A forecast is only as good as its assumptions, so managers should update it regularly and prepare for the worst case too.

Improving cash flow

Action Effect Risk
Overdraft or short-term loan Covers gaps Interest cost
Ask customers to pay faster; discounts for early payment More cash sooner Discounts cut profit
Delay paying suppliers (negotiate longer credit) Keeps cash longer Harms supplier relations
Reduce stock Frees cash Risk of running out
Sell unused assets; sale and leaseback Cash now Lose assets
Cut costs or delay purchases Lower outflows May harm quality or growth
Debt factoring Cash from invoices at once Fee

A rapidly growing business can run short of cash because it must buy materials and pay staff before its new customers pay. This is called overtrading.

What-if testing

Change one assumption (for example, receipts 10% lower) and see what happens to the closing balance.

JS What if sales fall?

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Any negative number shows a month in which the firm would need more cash than it has.

Check your understanding

Quick check ยท 3 questions

of 3 answered You scored / 3 ยท perfect!

  1. 1. A month has opening balance $1,000, receipts $4,000 and payments $4,600. What is the closing balance?

    1,000 + 4,000 - 4,600 = 400.
  2. 2. Why can a profitable firm run out of cash?

    Timing differences between receipts and payments cause cash shortages.
  3. 3. Which action improves cash flow quickly?

    Early payment discounts bring cash in sooner, though they reduce profit.

Summary

  • Cash flow is the movement of money; profit and cash are different.
  • Net cash flow = inflows - outflows; closing = opening + net.
  • Forecasts show shortages in advance but depend on assumptions.
  • Firms improve cash flow with overdrafts, faster collection, slower payment and cost control.

Next: Income Statement and Profit