Cash Flow Statement  HELP
Options
Jentel
Registered Posts: 60 Regular contributor ⭐
:confused1:
Hi
Doing task 6.13 in osborne work book and just can't get it to agree. Can anyone give me the answer or present the cash flow statement for me so then i can work it out. I know i'm going wrong when it comes to the sale/purchase of assets, the proceeds and the depreciation.
My tutor just whizziesthrough these exercises and he just takes it for granted that people know what he is doing. I therefore have not been able to get my head round it. Usually, i can just go home, read the chapter, do the examples or work from the tutuorial book, but with cash flow i find that the tutorial is very confusing and the tasks that they give you are so different from the workbook that i don't know whether i am coming or going.
Hi
Doing task 6.13 in osborne work book and just can't get it to agree. Can anyone give me the answer or present the cash flow statement for me so then i can work it out. I know i'm going wrong when it comes to the sale/purchase of assets, the proceeds and the depreciation.
My tutor just whizziesthrough these exercises and he just takes it for granted that people know what he is doing. I therefore have not been able to get my head round it. Usually, i can just go home, read the chapter, do the examples or work from the tutuorial book, but with cash flow i find that the tutorial is very confusing and the tasks that they give you are so different from the workbook that i don't know whether i am coming or going.
0
Comments

Cash flow statement!
The easiest of the lot!
You already know the answer to your problem even before you start to solve it!
In any full cash flow statement you will be given 3 things
1) This year's profit and loss account
2) This year's balance sheet
3) Last year's Balance sheet
To know your answer take away last year's cash/bank balance away from this year's cash/ bank balance and that will be your net cash inflow or cash out flow. Beware, if any of the bank balance is an overdraft then you will need to add the balances.
Cash flow statement is split into two sections:
1st section will show how much net cash inflow there has been.
2nd section will show where has that cash been spent.
1st Section  how much net cash inflow into the business?
here you need to know where to start!
From your P&L a/c find profit before interest and draw a draw a line across the page underneath that.
Then there are 7 points that you MUST address
2 points from P&L a/c above the line drawn across the page, and
3 points from the balance sheet (current assets and current liabilities)
2 points from P&L a/c below the line drawn across the page
Start with your profit before interest figure and
1. ADD any loss (from above the line) that you may have made on the sale of the fixed asset; or LESS any profit that you may have made.
2. ADD the total depreciation expense for the year (from above the line, or from additional noted given)
1  STOCK  find the difference between last year's stock and this year's stock. If the stock has increased there is a net cash outflow or if the stock has decreased there is a net cash inflow:
ADD net cash inflow or LESS net cash out flow
2  Debtors  find the difference between last year's debtors and this year's debtors. If the debtors has increased there is a net cash outflow or if the debtors has decreased there is a net cash inflow:
ADD net cash inflow or LESS net cash out flow
3  Creditors  BECAREFUL HERE! It is the opposite of Debtors; find the difference between last year's creditors and this year's creditors. If the creditors has increased there is a net cash inflow or if the creditors has decreased there is a net cash outflow:
ADD net cash inflow or LESS net cash out flow
1  LESS Interest paid for the current year (found below the line from P&L)
2  LESS  Actual tax paid.( do your calculations in brackets to demonstrate your understanding) the calculations: last year's unpaid tax (B/S) plus this year's tax payable (P&L) less this year's unpaid tax creditors (B/S) equals actual tax paid to Inland Revenue.
After the above work out you will get NET CASH INFLOW from operating activities.
The 2nd sections starts with NET CASH INFLOW:
there are two things you must remember here:
1 We need to deal with the dividends paid (P&L) here
2 You MUST show your workings for Fixed Asset Register to show (a) how much cash been received for the sold asset and (b) how much cash outflow for the purchase of the new fixed assets.
your workings:
Opening balance of fixed assets from (B/S) xxxx (NBV)
LESS FA sold (cost less acc. dep = NBV)  xxxx (plus/minus profit/loss to
info from footnotes arrive Net Cash IN)
ADD PURCHASES ???? missing figure
LESS Depreciation expense for this year xxxx from (P&L) or Notes
EQUALS Closing balance of fixed assets (B/S) xxxx (NBV)
From the above workings you need to
1 ADD Net Cash IN from sale if Fixed Asset ( see my workings)
2 LESS net cash out for purchase of FIXED ASSET (see my workings)
3 Current Assets  deal with each item under this heading and it will be either cash in or cash out. (the difference between last year's and this year's balances if assets go up then net cash out and if assets go down then net cash IN) ADD if net cash In or LESS if net cash out.
REMEMBER YOU HAVE ALREADY DELT WITH STOCK, DEBTORS AND CREDITORS, so you need to avoid these items.
4 You do NOT have to deal with CASH because that is what you are working on  IGNORE
5 Current liabilities  same as current assets  (if CL go up then net cash IN and if CL go down then net cash OUT)
6 Long term Liabilities  same as current Liabilities
7 Share Capital  same as current Liabilities
8 Share Capital premium  same as current Liabilities
9 Retained P&L balances  IGNORE
10 Do NOT Forget to MINUS Dividends paid. (either from P&L or Footnote You might have to work out ACTUAL dividends paid.  SEE TAX calculations above for HOW?)
After the above calculation you will arrive at the EXPECTED ANSWER  of NET CASH increase or decrease.
ADD/LESS the Opening Cash Balance (B/S)
will equal to the Closing Cash Balance (B/S)
I Hope this will help.
If you want to this to be a second nature to you then you must practice the cashflow questions at least 10 questions consecutively in one sitting.
To understand why we add back the losses and deduct the profits on a sale of fixed asset, from profits before interest, we need to understand what profit and losses are.
Profit or loss is NOT cash inflow. Only the receipts of the sale of equipment is Cash inflow, which will be shown on the second statement.0 
Cash Flow
Visha
Thanks very much for your thoroughness. I have printed offyour reply. I have sinced tackled the task again and have now managed to get it to agree.
Understanding why things go into certain sections has made a difference. I will definetly practice more of these tasks
Thanks again0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 18.9K For AAT students
 268 NEW! Qualifications 2022
 147 General Qualifications 2022 discussion
 9 AAT Level 2 Certificate in Accounting
 44 AAT Level 3 Diploma in Accounting
 65 AAT Level 4 Diploma in Professional Accounting
 8.9K For accounting professionals
 23 coronavirus (Covid19)
 274 VAT
 92 Software
 274 Tax
 138 Bookkeeping
 7.3K General accounting discussion
 194 AAT member discussion
 3.8K For everyone
 38 AAT news and announcements
 352 Feedback for AAT
 2.8K Chat and offtopic discussion
 590 Job postings
 17 Who can benefit from AAT?
 36 Where can AAT take me?
 44 Getting started with AAT
 26 Finding an AAT training provider
 48 Distance learning and other ways to study AAT
 25 Apprenticeships
 65 AAT membership