Diagram · Unit 3 · 3.7

A cash flow forecast, month to month

SL and HL Fictional figures
A cash flow forecast, month to monthA three-month cash flow forecast in the guide’s layout. January: opening balance 5,000, total cash inflows 12,000, total cash outflows 14,000, net cash flow (2,000), closing balance 3,000. February: opening balance 3,000, total cash inflows 10,000, total cash outflows 15,000, net cash flow (5,000), closing balance (2,000). March: opening balance (2,000), total cash inflows 16,000, total cash outflows 11,000, net cash flow 5,000, closing balance 3,000. Each closing balance becomes the next month’s opening balance. February’s closing balance is negative, so the business would need an overdraft or another way to cover the gap.JanuaryFebruaryMarchOpening balanceTotal cash inflowsTotal cash outflowsNet cash flowClosing balance5,00012,000(14,000)(2,000)3,0003,00010,000(15,000)(5,000)(2,000)(2,000)16,000(11,000)5,0003,000Each month: opening balance + net cash flow = closing balance, and the closing balance becomes next month’sopening balance. February’s closing balance is negative, so the business would need an overdraft or another wayto cover the gap.Fictional figures, $. Negative numbers in brackets.

A cash flow forecast, month to month How each closing balance becomes the next opening balance.
Text description

A three-month cash flow forecast in the guide’s layout. January: opening balance 5,000, total cash inflows 12,000, total cash outflows 14,000, net cash flow (2,000), closing balance 3,000. February: opening balance 3,000, total cash inflows 10,000, total cash outflows 15,000, net cash flow (5,000), closing balance (2,000). March: opening balance (2,000), total cash inflows 16,000, total cash outflows 11,000, net cash flow 5,000, closing balance 3,000. Each closing balance becomes the next month’s opening balance. February’s closing balance is negative, so the business would need an overdraft or another way to cover the gap.

Download SVG

Section 01: Where it is used