The following is an extract from a cash flow forecast - Edexcel - GCSE Business - Question 17 - 2018 - Paper 1
Question 17
The following is an extract from a cash flow forecast.
Fill in the three blanks to complete the cash flow forecast.
Cash inflow
Cash outflow
Net cash flow
Opening ... show full transcript
Worked Solution & Example Answer:The following is an extract from a cash flow forecast - Edexcel - GCSE Business - Question 17 - 2018 - Paper 1
Step 1
Cash outflow
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
To find the cash outflow for February, we note that the net cash flow is calculated as:
Net Cash Flow=Cash Inflow−Cash Outflow
So, for February:
12=26−Cash Outflow
Solving for Cash Outflow gives us:
Cash Outflow=26−12=14
Thus, the cash outflow for February is 14.
Step 2
Net cash flow for March
99%
104 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
For March, we calculate the net cash flow as follows:
Net Cash Flow=Cash Inflow−Cash Outflow
Plugging in the values:
Net Cash Flow=32−83=−51
So, the net cash flow for March is -51.
Step 3
Closing bank balance for February
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The closing bank balance for February is calculated as:
Closing Bank Balance=Opening Bank Balance+Net Cash Flow
Using the values provided:
Closing Bank Balance=32+(−14)=18
Therefore, the closing bank balance for February is 18.