Completing cash flow forecasts
Net cash flow is calculated by subtracting cash outflows from cash inflows during a given period of time
|
Term
|
Explanation
|
|
Cash inflows
|
|
|
Cash outflows
|
|
|
Opening balance
|
-
The opening balance is the cash position at the beginning of each month
-
In the first month, this is usually:
-
In later months, the opening balance is the closing balance carried forward from the previous month
|
|
Net cash flow
|
|
|
Closing balance
|
|
Completing a cash flow forecast
Step 1: Calculate total cash inflows
Explanation
-
In this instance, the business expects to receive cash inflows from sales in March, April and May
-
Owners’ capital of €6,000 will be introduced in March
-
The total for each month is calculated by adding cash from sales to capital introduced
Step 2: Calculate total cash outflows
Explanation
-
In this instance, the business expects to pay rent of €1,400 in March, April and May
-
It will purchase a significant amount of stock in March, with smaller amounts in April and May
-
Wages are expected to be €2,100 in each month
-
Utilities of €460 will be paid in March and April, increasing to €480 in May
-
Total cash outflows each month is calculated by adding these together
Step 3: Calculate net cash flows
<img alt=”Cash flow table for March, April, May. Inflows: €10,500, €4,800, €5,300. Outflows: €10,760, €4,560, €4,780. Net flow: -€260, €240, €520.” class=”ContentBlock_figure__vJw2q” data-nimg=”1″ decoding=”async” height=”429″ sizes=”(max-width: 320px) 320w, (max-width: 640px) 640w, (max-width: 960px) 960w, (max-width: 1280px) 1280w, 1920w” src=”https://cdn.savemyexams.com/cdn-cgi/image/f=auto,width=3840/https://cdn.savemyexams.com/uploads/2025/06/15495_httpscdn-savemyexams-comuploads20240525592-ocr-gcse-business-net-cash-flow.png” srcset=”https://cdn.savemyexams.com/cdn-cgi/image/f=auto,width=16/https://cdn.savemyexams.com/uploads/2025/06/15495_httpscdn-savemyexams-comuploads20240525592-ocr-gcse-business-net-cash-flow.png 16w, https://cdn.savemyexams.com/cdn-cgi/image/f=auto,width=32/https://cdn.savemyexams.com/uploads/2025/06/15495_httpscdn-savemyexams-comuploads20240525592-ocr-gcse-business-net-cash-flow.png 32w, https://cdn.savemyexams.com/cdn-cgi/image/f=auto,width=48/https://cdn.savemyexams.com/uploads/2025/06/15495_httpscdn-savemyexams-comuploads20240525592-ocr-gcse-business-net-cash-flow.png 48w, https://cdn.savemyexams.com/cdn-cgi/image/f=auto,width=64/https://cdn.savemyexams.com/uploads/2025/06/15495_httpscdn-savemyexams-comuploads20240525592-ocr-gcse-business-net-cash-flow.png 64w, https://cdn.savemyexams.com/cdn-cgi/image/f=auto,width=96/https://cdn.savemyexams.com/uploads/2025/06/15495_httpscdn-savemyexams-comuploads20240525592-ocr-gcse-business-net-cash-flow.png 96w, https://cdn.savemyexams.com/cdn-cgi/image/f=auto,width=128/https://cdn.savemyexams.com/uploads/2025/06/15495_httpscdn-savemyexams-comuploads20240525592-ocr-gcse-business-net-cash-flow.png 128w, https://cdn.savemyexams.com/cdn-cgi/image/f=auto,width=256/https://cdn.savemyexams.com/uploads/2025/06/15495_httpscdn-savemyexams-comuploads20240525592-ocr-gcse-business-net-cash-flow.png 256w, https://cdn.savemyexams.com/cdn-cgi/image/f=auto,width=384/https://cdn.savemyexams.com/uploads/2025/06/15495_httpscdn-savemyexams-comuploads20240525592-ocr-gcse-business-net-cash-flow.png 384w, https://cdn.savemyexams.com/cdn-cgi/image/f=auto,width=640/https://cdn.savemyexams.com/uploads/2025/06/15495_httpscdn-savemyexams-comuploads20240525592-ocr-gcse-business-net-cash-flow.png 640w, https://cdn.savemyexams.com/cdn-cgi/image/f=auto,width=750/https://cdn.savemyexams.com/uploads/2025/06/15495_httpscdn-savemyexams-comuploads20240525592-ocr-gcse-business-net-cash-flow.png 750w, https://cdn.savemyexams.com/cdn-cgi/image/f=auto,width=828/https://cdn.savemyexams.com/uploads/2025/06/15495_httpscdn-savemyexams-comuploads20240525592-ocr-gcse-business-net-cash-flow.png 828w, https://cdn.savemyexams.com/cdn-cgi/image/f=auto,width=1080/https://cdn.savemyexams.com/uploads/2025/06/15495_httpscdn-savemyexams-comuploads20240525592-ocr-gcse-business-net-cash-flow.png 1080w, https://cdn.savemyexams.com/cdn-cgi/image/f=auto,width=1200/https://cdn.savemyexams.com/uploads/2025/06/15495_httpscdn-savemyexams-comuploads20240525592-ocr-gcse-business-net-cash-flow.png 1200w, https://cdn.savemyexams.com/cdn-cgi/image/f=auto,width=1920/https://cdn.savemyexams.com/uploads/2025/06/15495_httpscdn-savemyexams-comuploads20240525592-ocr-gcse-business-net-cash-flow.png 1920w, https://cdn.savemyexams.com/cdn-cgi/image/f=auto,width=2048/https://cdn.savemyexams.com/uploads/2025/06/15495_httpscdn-savemyexams-comuploads20240525592-ocr-gcse-business-net
Responses