{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Info","Trial","Instructions","Input","Direct","Indirect"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Info","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Trial","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Instructions","index":2,"n_rows":141,"n_cols":1,"rows_kept":141,"cut":false,"hidden":true,"merged":[]}
["Excel Skills | Cash Flow Statement Template"]
["Instructions"]
["www.excel-skills.com"]
[]
["This template enables users to automatically compile a complete cash flow statement by simply entering basic income statement and balance sheet information. The template includes a current and comparative financial period and detailed instructions on the calculation of the line items which are included on the cash flow statement. The template includes statements of cash flow that have been compiled based on both the direct and indirect methods."]
[]
["The following sheets are included in this template:"]
["Input - this sheet includes all the input cells used in compiling the cash flow statement. User input consists of an income statement and a balance sheet section as well as some additional information which is required in order to produce a cash flow statement."]
["Direct - this sheet contains a cash flow statement based on the direct method which is automatically calculated from the information entered on the Input sheet. No user input is required on this sheet."]
["Indirect - this sheet contains a cash flow statement based on the indirect method which is automatically calculated from the information entered on the Input sheet. No user input is required on this sheet."]
[]
["User Input"]
[]
["All the cells on the Input sheet which require user input are indicated by a yellow or green cell background in the column to the right of the appropriate input cell. The cells which are indicated in yellow require positive values to be entered, while the cells which are indicated in green require negative values to be entered. Cells that don't have a yellow or green colour next to them contain formulas and should be left unchanged."]
[]
["If you are concerned about replacing the formulas in the cells that do not require user input, you can protect the sheet with a user defined password. Only valid input cells will then be available for user input. The Protect Sheet feature can be accessed by selecting the Review tab on the ribbon and selecting the Protect Sheet option from the Changes section of the ribbon. You will be required to enter and to confirm a user defined password (all input cells have already been unlocked in order to allow user input)."]
[]
["The default reporting periods can be amended by simply entering a new year in cell B2. All the other cells in this template that contain references to the reporting periods will automatically be amended."]
[]
["The additional information section requires users to specify whether any business acquisitions, disposals of property, plant and equipment or intangibles and raising of long term finance occurred during the current and previous financial periods. The default input values in these cells can be replaced by nil values if they are not applicable."]
[]
["You'll also notice that three years' balance sheet information is required in order to produce a cash flow statement with accurate comparative data."]
[]
["The Input sheet also contains 4 control totals in rows 56 to 59 which should all be nil otherwise the cash flow statements will not balance. Each of these control totals are covered in more detail in the Control Totals sub section of these instructions which follows next."]
[]
["Control Totals"]
[]
["The balance sheet control total in row 56 has been added to the sheet to highlight an imbalance on the balance sheet after entering the required balance sheet information. If an imbalance is encountered, the cells in this row will be highlighted in orange and it simply means that your balance sheet does not balance which will also result in your cash flow statements not balancing."]
[]
["The depreciation control total in row 57 highlights an inconsistency between the depreciation charges in the income statement and the accumulated depreciation charges in the balance sheet (with disposals being taken into account). The income statement charges are added back in the cash flow statement which means that if these charges are not consistent with the balance sheet movement in accumulated depreciation, the cash flow statement may not balance as a result of this inconsistency."]
[]
["The amortization control total in row 58 basically functions in the same way as the depreciation control total but is applied to amortization and accumulated amortization on intangibles instead of depreciation on property, plant and equipment. The same principle applies - the income statement charges are added back on the cash flow statement and if these charges are not consistent with the movement in accumulated amortization, the cash flow statements may not balance."]
[]
["The retained earnings control total in row 59 tests whether the balance sheet movement in the retained earnings line is consistent with the profit or loss for the period. If it is not, it indicates that other adjustments (like for example a prior year adjustment) have been made directly against retained earnings instead of being included in the income statement. If such adjustments have been made, the adjustments need to be included in the adjustment section of the cash flow statements on the Direct and Indirect sheets."]
[]
["Cash Flow Statement Calculations"]
[]
["This section of the instructions provides more information on the calculations which are performed for each line item on the cash flow statements. Note that both cash flow statements are calculated automatically and no user input is therefore required on either the Direct or Indirect sheets."]
[]
["Cash receipts from customers"]
[]
["This amount is calculated by adding the turnover amount to the opening trade accounts receivable balance and the trade accounts receivable balance which forms part of business acquisitions for the particular period. The closing trade accounts receivable balance is then deducted from this total in order to calculate the amount of cash which has been received from customers."]
[]
["Cash paid to suppliers and employees"]
[]
["This amount is determined by calculating the cash generated from operations and deducting it from the cash receipts from customers. The calculation of cash generated from operations is discussed in the next section."]
[]
["An alternative calculation of the cash paid to suppliers and employees is as follows:"]
["Profit before taxation"]
["Less: Turnover"]
["Add: Depreciation"]
["Add: Amortization"]
["Add: Interest expense"]
["Less: Investment income"]
["Add: Other non-cash items which are included in expenditure (for example: loss on disposal of equipment or intangibles)"]
["Add: Inventory opening balance"]
["Less: Inventory closing balance"]
["Add: Trade payables closing balance"]
["Less: Trade payables opening balance"]
[]
["As you can see, this calculation is quite complicated and we therefore recommend calculating the cash generated from operations and then simply deducting the cash receipts from customers from this amount."]
[]
["Cash generated from operations"]
[]
["A detailed calculation of this amount is included below the cash flow statement on the Direct sheet and at the top of the cash flow statement on the Indirect sheet. The calculation starts with the profit or loss before taxation and all non-cash income & expenses and items which are included in other line items on the cash flow statements are then added back from the calculated amounts."]
[]
["Investment income and interest expenses are added back because these items are included separately on the cash flow statement. The depreciation, amortization, profit or loss from sale of property, plant & equipment and profit or loss from the sale of intangibles are non-cash items and are also added back. Balance sheet movements in reserves are also non-cash items and also added back."]
[]
["The net effect of all working capital balances is then deducted in the calculation because these items also form part of operating cash flow. Note that an increase in accounts receivable and inventory results of an outflow of cash and should therefore be deducted. An increase in payables, however, results in an inflow of cash (because less payments are made to creditors) and should therefore be added in the calculation. A decrease in payables is therefore an outflow of cash and should be deducted."]
[]
["Note: The receivables and payables lines include multiple balance sheet items which have been consolidated into a single line for cash flow statement purposes. Trade receivables, loans & advances and other receivables are grouped together in the receivables lines and trade payables, sales tax, payroll accruals and other accruals are grouped together in the payables lines on the cash flow statements."]
[]
["Interest, Income Tax and Dividends"]
[]
["These amounts are all calculated by adding the appropriate income statement amounts to the opening balance of the appropriate provisions (liabilities) and deducting the closing balance of the appropriate provisions from this calculation. All three amounts are negative because all three items result in an outflow of cash."]
[]
["Business Acquisitions"]
[]
["This amount should be the total amount which was paid in order to acquire a new or existing business net of the cash amount received from the business acquired."]
[]
["Also note that the amounts that are included in each individual asset class should be added to the appropriate opening balance of the asset class in determining the increase or decrease in the balance of each asset class. For example, in determining the increase in inventory, the inventory amount which forms part of the business acquisition section is added to the opening inventory balance on the balance sheet before deducting the closing inventory balance in order to determine the movement in inventory between the two financial years under review."]
[]
["Purchase of property, plant and equipment"]
[]
["The amount of cash purchases of property plant & equipment is determined as follows:"]
["Property, plant & equipment - closing balance at cost"]
["Less: Property, plant & equipment - opening balance at cost"]
["Less: Property, plant & equipment - acquired through business acquisitions"]
["Add: Cost of assets which were sold during the period under review"]
["Less: Acquisitions financed through financial leases"]
[]
["Note that the calculated amount is a cash outflow and should be included on the cash flow statement as a negative amount and that financial leases do not result in an immediate outflow of cash and should therefore be excluded from this line item. Payments of financial leases should be included under the financing activities section of the cash flow statement."]
[]
["Also note that revaluations of property, plant and equipment should also be excluded from the cash flow statement by deducting the movement in the revaluation reserve in the above calculation."]
[]
["Purchase of intangible assets"]
[]
["These amounts are calculated in much the same way as the property, plant and equipment amounts but are based on intangible assets instead. Finance leases also play no role in the calculation of intangible amounts because these are unique to property, plant & equipment."]
[]
["Proceeds from sale of equipment or intangibles"]
[]
["These amounts are the cash amounts which are received after the sale of equipment or intangible assets and are included in the Additional information section on the Input sheet."]
[]
["Acquisition of investments"]
[]
["This amount is calculated by deducting the closing investment balance from the opening investment balance and deducting any amounts received through business acquisitions."]
[]
["Investment income"]
[]
["This amount is included in this section of the cash flow statement because it does not form part of operating cash flows. Note that investment income is deducted in the cash generated from operations calculation because it is included in the profit before tax and it is included as a separate line item on the cash flow statement."]
[]
["Proceeds from issue of share capital"]
[]
["This amount is calculated by deducting the opening share capital balance from the closing share capital balance. An increase in share capital results in an inflow of cash."]
[]
["Proceeds from long-term borrowings"]
[]
["This amount is specified in the Additional information section on the Input sheet and should include all the long term debt which was raised during the period under review, but should exclude all the finance leases that are deducted from the property, plant & equipment cash acquisitions total."]
[]
["Payment of long-term borrowings"]
[]
["This amount is calculated as follows:"]
["Long term debt closing balance"]
["Less: Long term debt opening balance"]
["Less: Long term debt included in business acquisitions"]
["Less: Long term debt raised"]
["Less: Finance lease acquisitions"]
[]
["The calculation should be included on the cash flow statement as a negative amount because the payment of long term debt results in an outflow of cash. The finance lease acquisitions should be excluded because this amount is set off against the property, plant & equipment acquisitions and the long term debt raised is deducted because it is included in a separate line item on the cash flow statement."]
[]
["Cash Flow Statement Control Total"]
[]
["The cash balance control total in row 34 on the Direct sheet and row 45 on the Indirect sheet has been included in order to highlight an imbalance between the closing cash balance on the balance sheet and the closing cash balance on the cash flow statement. If an imbalance is encountered on one of these sheets, the appropriate cells in this row will be highlighted in orange."]
[]
["Help & Customization"]
[]
["If you experience any difficulty while using this template and you are not able to find the appropriate guidance in these instructions, please e-mail us at support@excel-skills.com for assistance. This template has been designed with flexibility in mind to ensure that it can be used in most business environments. If however you need an Excel based template that is customized specifically for your business requirements, please e-mail our Support function and provide a brief explanation of your requirements."]
[]
["© Copyright"]
[]
["This template remains the intellectual property of www.excel-skills.com and is protected by international copyright laws. Any publication or distribution of this template outside the scope of the permitted use of the template is expressly prohibited. In terms of the permitted use of this template, only the distribution of the template to persons within the same organisation as the registered user or persons outside the organisation who can reasonably be expected to require access to the template as a direct result of the use of the template by the registered user is allowed. Subsequent distribution of the template by parties outside of the organisation is however expressly prohibited and represents an infringement of international copyright laws."]

{"sheet":"Input","index":3,"n_rows":91,"n_cols":6,"rows_kept":91,"cut":false,"hidden":true,"merged":[]}
["Cash Flow Statement Data"]
["Current Reporting Period",2020]
["© www.excel-skills.com"]
["Income Statement",{"$f":"IF(ISBLANK($B$2),YEAR(TODAY()),$B$2)","v":2020},null,{"$f":"IF(ISBLANK($B$2),YEAR(TODAY()),$B$2)-1","v":2019}]
["Turnover",316500,null,265200]
["Cost of sales",-260000,null,-242800]
["Gross profit",{"$f":"SUM(B5:B6)","v":56500},null,{"$f":"SUM(D5:D6)","v":22400}]
["Depreciation",-4700,null,-2500]
["Amortization",-1000,null,-1000]
["Administrative and selling expenses",-9500,null,-8000]
["Interest expense",-4000,null,-3000]
["Investment income",5000,null,3500]
["Profit before taxation",{"$f":"SUM(B7:B12)","v":42300},null,{"$f":"SUM(D7:D12)","v":11400}]
["Taxes on income",-12000,null,-4000]
["Profit",{"$f":"SUM(B13:B14)","v":30300},null,{"$f":"SUM(D13:D14)","v":7400}]
["Dividends paid",-7575,null,-1850]
["Retained Earnings",{"$f":"SUM(B15:B16)","v":22725},null,{"$f":"SUM(D15:D16)","v":5550}]
[" "]
["Balance Sheet",{"$f":"$B$4","v":2020},null,{"$f":"$D$4","v":2019},null,{"$f":"$D$19-1","v":2018}]
[" "]
["Assets"]
["Non-current assets"]
["Property, plant and equipment",{"$f":"SUM(B24:B25)","v":25800},null,{"$f":"SUM(D24:D25)","v":11500},null,{"$f":"SUM(F24:F25)","v":7000}]
["Property, plant and equipment at cost",37300,null,19000,null,15000]
["Accumulated depreciation",-11500,null,-7500,null,-8000]
["Intangible assets",{"$f":"SUM(B27:B28)","v":8000},null,{"$f":"SUM(D27:D28)","v":9000},null,{"$f":"SUM(F27:F28)","v":0}]
["Intangible assets at cost",10000,null,10000,null,0]
["Accumulated amortization",-2000,null,-1000,null,0]
["Investments",25000,null,15000,null,13500]
["Current assets"]
["Inventory",22000,null,15500,null,12000]
["Trade receivables",18000,null,9000,null,6950]
["Loans & advances",1200,null,800,null,500]
["Other receivables",1800,null,1000,null,500]
["Interest receivable",1000,null,800,null,0]
["Cash and cash equivalents",11500,null,1600,null,3200]
["Total assets",{"$f":"SUM(B23,B26,B29:B36)","v":114300},null,{"$f":"SUM(D23,D26,D29:D36)","v":64200},null,{"$f":"SUM(F23,F26,F29:F36)","v":43650}]
[]
["Equity & liabilities"]
["Equity"]
["Share capital",150,null,150,null,125]
["Retained earnings",33275,null,10550,null,5000]
["Reserves",0,null,0,null,0]
["Non-current liabilities"]
["Long term loans",29900,null,23850,null,16300]
["Current liabilities"]
["Trade payables",17500,null,14800,null,10900]
["Sales tax",5000,null,2900,null,1325]
["Payroll accruals",4700,null,4000,null,3500]
["Other accruals",2000,null,1100,null,1200]
["Interest payable",2200,null,1000,null,800]
["Income taxes payable",12000,null,4000,null,3000]
["Dividends payable",7575,null,1850,null,1500]
["Total equity and liabilities",{"$f":"SUM(B40:B53)","v":114300},null,{"$f":"SUM(D40:D53)","v":64200},null,{"$f":"SUM(F40:F53)","v":43650}]
[]
["Balance Sheet Control",{"$f":"B37-B54","v":0},null,{"$f":"D37-D54","v":0},null,{"$f":"F37-F54","v":0}]
["Depreciation Control",{"$f":"B25-D25+B76-B8","v":0},null,{"$f":"D25-F25+D76-D8","v":0}]
["Amortization Control",{"$f":"B28-D28+B83-B9","v":0},null,{"$f":"D28-F28+D83-D9","v":0}]
["Retained Earnings Control",{"$f":"B42-B17-D42","v":0},null,{"$f":"D42-D17-F42","v":0}]
[]
["Additional Information",{"$f":"$B$4","v":2020},null,{"$f":"$D$4","v":2019}]
[]
["Business Acquisitions Values"]
["Property, plant and equipment",15000,null,0]
["Intangible assets",0,null,0]
["Investments",0,null,0]
["Inventories",3000,null,0]
["Accounts receivable",1500,null,0]
["Cash",1000,null,0]
["Trade payables",-2000,null,0]
["Long-term debt",0,null,0]
[" ",{"$f":"SUM(B64:B71)","v":18500},null,{"$f":"SUM(D64:D71)","v":0}]
[]
["Disposal of Property, Plant & Equipment"]
["Cost",1000,null,3000]
["Accumulated Depreciation",-700,null,-3000]
["Book value",{"$f":"SUM(B75:B76)","v":300},null,{"$f":"SUM(D75:D76)","v":0}]
["Proceeds on sale of property, plant & equipment",0,null,400]
["Profit / (Loss) on sale of equipment",{"$f":"B78-B77","v":-300},null,{"$f":"D78-D77","v":400}]
[]
["Disposal of Intangible Assets"]
["Cost",0,null,0]
["Accumulated Amortization",0,null,0]
["Book value",{"$f":"SUM(B82:B83)","v":0},null,{"$f":"SUM(D82:D83)","v":0}]
["Proceeds on sale of intangible assets",0,null,0]
["Profit / (Loss) on sale of intangibles",{"$f":"B85-B84","v":0},null,{"$f":"D85-D84","v":0}]
[]
["Long Term Debt"]
["Loans raised",10000,null,4000]
["Finance lease acquisitions",0,null,5000]
[null,{"$f":"SUM(B89:B90)","v":10000},null,{"$f":"SUM(D89:D90)","v":9000}]

{"sheet":"Direct","index":4,"n_rows":56,"n_cols":4,"rows_kept":56,"cut":false,"hidden":true,"merged":[]}
["Statement of Cash Flows"]
["© www.excel-skills.com",{"$f":"IF(ISBLANK(Input!B$4),YEAR(TODAY()),Input!B$4)","v":2020},null,{"$f":"B2-1","v":2019}]
["Cash flows from operating activities"]
["Cash receipts from customers",{"$f":"Input!D32+Input!B5-Input!B32+Input!B68","v":309000},null,{"$f":"Input!F32+Input!D5-Input!D32+Input!D68","v":263150}]
["Cash paid to suppliers and employees",{"$f":"B6-B4","v":-269500},null,{"$f":"D6-D4","v":-249625}]
["Cash generated from operations",{"$f":"B52","v":39500},null,{"$f":"D52","v":13525}]
["Interest paid",{"$f":"-(Input!D51-Input!B11-Input!B51)","v":-2800},null,{"$f":"-(Input!F51-Input!D11-Input!D51)","v":-2800}]
["Income taxes paid",{"$f":"-(Input!D52-Input!B14-Input!B52)","v":-4000},null,{"$f":"-(Input!F52-Input!D14-Input!D52)","v":-3000}]
["Dividends paid",{"$f":"-(Input!D53-Input!B16-Input!B53)","v":-1850},null,{"$f":"-(Input!F53-Input!D16-Input!D53)","v":-1500}]
["Net cash from operating activities",{"$f":"SUM(B6:B9)","v":30850},null,{"$f":"SUM(D6:D9)","v":6225}]
[]
["Cash flows from investing activities"]
["Business acquisitions, net of cash acquired",{"$f":"-Input!B72+Input!B69","v":-17500},null,{"$f":"-Input!D72","v":0}]
["Purchase of property, plant and equipment",{"$f":"Input!D24-Input!B24+Input!B64-Input!B75+Input!B90","v":-4300},null,{"$f":"Input!F24-Input!D24+Input!D64-Input!D75+Input!D90","v":-2000}]
["Purchase of intangible assets",{"$f":"Input!D27-Input!B27+Input!B65-Input!B82","v":0},null,{"$f":"Input!F27-Input!D27+Input!D65-Input!D82","v":-10000}]
["Proceeds from sale of equipment",{"$f":"Input!B78","v":0},null,{"$f":"Input!D78","v":400}]
["Proceeds from sale of intagibles",{"$f":"Input!B85","v":0},null,{"$f":"Input!D85","v":0}]
["Acquisition of investments",{"$f":"Input!D29-Input!B29+Input!B66","v":-10000},null,{"$f":"Input!F29-Input!D29+Input!D66","v":-1500}]
["Investment income",{"$f":"Input!D35+Input!B12-Input!B35","v":4800},null,{"$f":"Input!F35+Input!D12-Input!D35","v":2700}]
["Net cash used in investing activities",{"$f":"SUM(B13:B19)","v":-27000},null,{"$f":"SUM(D13:D19)","v":-10400}]
[]
["Cash flows from financing activities"]
["Proceeds from issue of share capital",{"$f":"Input!B41-Input!D41","v":0},null,{"$f":"Input!D41-Input!F41","v":25}]
["Proceeds from long-term borrowings",{"$f":"Input!B89","v":10000},null,{"$f":"Input!D89","v":4000}]
["Payment of long-term borrowings",{"$f":"Input!B45-Input!D45+Input!B71-Input!B91","v":-3950},null,{"$f":"Input!D45-Input!F45+Input!D71-Input!D91","v":-1450}]
["Net cash used in financing activities",{"$f":"SUM(B23:B25)","v":6050},null,{"$f":"SUM(D23:D25)","v":2575}]
[]
["Net increase in cash and cash equivalents",{"$f":"SUM(B10,B20,B26)","v":9900},null,{"$f":"SUM(D10,D20,D26)","v":-1600}]
[]
["Cash and cash equivalents at beginning of period",{"$f":"Input!D36","v":1600},null,{"$f":"Input!F36","v":3200}]
[]
["Cash and cash equivalents at end of period",{"$f":"SUM(B28,B30)","v":11500},null,{"$f":"SUM(D28,D30)","v":1600}]
[]
["Cash Balance Control Total",{"$f":"B32-Input!B36","v":0},null,{"$f":"D32-Input!D36","v":0}]
[]
["Notes to the Statement of Cash Flows",{"$f":"B2","v":2020},null,{"$f":"D2","v":2019}]
[]
["Cash flows from operating activities"]
["Profit / (Loss) before taxation",{"$f":"Input!B13","v":42300},null,{"$f":"Input!D13","v":11400}]
["Adjustments for:"]
["Depreciation",{"$f":"-Input!B8","v":4700},null,{"$f":"-Input!D8","v":2500}]
["Amortization",{"$f":"-Input!B9","v":1000},null,{"$f":"-Input!D9","v":1000}]
["Investment income",{"$f":"-Input!B12","v":-5000},null,{"$f":"-Input!D12","v":-3500}]
["Interest expense",{"$f":"-Input!B11","v":4000},null,{"$f":"-Input!D11","v":3000}]
["Profit / (Loss) on the sale of property, plant & equipment",{"$f":"-Input!B79","v":300},null,{"$f":"-Input!D79","v":-400}]
["Profit / (Loss) on the sale of intangible assets",{"$f":"-Input!B86","v":0},null,{"$f":"-Input!D86","v":0}]
["Movement in reserves",{"$f":"Input!B43-Input!D43","v":0},null,{"$f":"Input!D43-Input!F43","v":0}]
["Working capital changes:"]
["(Increase) / Decrease in trade and other receivables",{"$f":"Input!D32+Input!D33+Input!D34-Input!B32-Input!B33-Input!B34+Input!B68","v":-8700},null,{"$f":"Input!F32+Input!F33+Input!F34-Input!D32-Input!D33-Input!D34+Input!D68","v":-2850}]
["(Increase) / (Decrease) in inventories",{"$f":"Input!D31-Input!B31+Input!B67","v":-3500},null,{"$f":"Input!F31-Input!D31+Input!D67","v":-3500}]
["Increase / (Decrease) in trade and other payables",{"$f":"Input!B47+Input!B48+Input!B49+Input!B50-Input!D47-Input!D48-Input!D49-Input!D50+Input!B70","v":4400},null,{"$f":"Input!D47+Input!D48+Input!D49+Input!D50-Input!F47-Input!F48-Input!F49-Input!F50+Input!D70","v":5875}]
["Cash generated from operations",{"$f":"SUM(B39:B51)","v":39500},null,{"$f":"SUM(D39:D51)","v":13525}]
[]
[]
[]
[" "]

{"sheet":"Indirect","index":5,"n_rows":50,"n_cols":4,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
["Statement of Cash Flows"]
["© www.excel-skills.com",{"$f":"IF(ISBLANK(Input!B$4),YEAR(TODAY()),Input!B$4)","v":2020},null,{"$f":"B2-1","v":2019}]
["Cash flows from operating activities"]
["Profit / (Loss) before taxation",{"$f":"Input!B13","v":42300},null,{"$f":"Input!D13","v":11400}]
["Adjustments for:"]
["Depreciation",{"$f":"-Input!B8","v":4700},null,{"$f":"-Input!D8","v":2500}]
["Amortization",{"$f":"-Input!B9","v":1000},null,{"$f":"-Input!D9","v":1000}]
["Investment income",{"$f":"-Input!B12","v":-5000},null,{"$f":"-Input!D12","v":-3500}]
["Interest expense",{"$f":"-Input!B11","v":4000},null,{"$f":"-Input!D11","v":3000}]
["Profit / (Loss) on the sale of property, plant & equipment",{"$f":"-Input!B79","v":300},null,{"$f":"-Input!D79","v":-400}]
["Profit / (Loss) on the sale of intangible assets",{"$f":"-Input!B86","v":0},null,{"$f":"-Input!D86","v":0}]
["Movement in reserves",{"$f":"Input!B43-Input!D43","v":0},null,{"$f":"Input!D43-Input!F43","v":0}]
["Working capital changes:"]
["(Increase) / Decrease in trade and other receivables",{"$f":"Input!D32+Input!D33+Input!D34-Input!B32-Input!B33-Input!B34+Input!B68","v":-8700},null,{"$f":"Input!F32+Input!F33+Input!F34-Input!D32-Input!D33-Input!D34+Input!D68","v":-2850}]
["(Increase) / (Decrease) in inventories",{"$f":"Input!D31-Input!B31+Input!B67","v":-3500},null,{"$f":"Input!F31-Input!D31+Input!D67","v":-3500}]
["Increase / (Decrease) in trade and other payables",{"$f":"Input!B47+Input!B48+Input!B49+Input!B50-Input!D47-Input!D48-Input!D49-Input!D50+Input!B70","v":4400},null,{"$f":"Input!D47+Input!D48+Input!D49+Input!D50-Input!F47-Input!F48-Input!F49-Input!F50+Input!D70","v":5875}]
["Cash generated from operations",{"$f":"SUM(B4:B16)","v":39500},null,{"$f":"SUM(D4:D16)","v":13525}]
["Interest paid",{"$f":"-(Input!D51-Input!B11-Input!B51)","v":-2800},null,{"$f":"-(Input!F51-Input!D11-Input!D51)","v":-2800}]
["Income taxes paid",{"$f":"-(Input!D52-Input!B14-Input!B52)","v":-4000},null,{"$f":"-(Input!F52-Input!D14-Input!D52)","v":-3000}]
["Dividends paid",{"$f":"-(Input!D53-Input!B16-Input!B53)","v":-1850},null,{"$f":"-(Input!F53-Input!D16-Input!D53)","v":-1500}]
["Net cash from operating activities",{"$f":"SUM(B17:B20)","v":30850},null,{"$f":"SUM(D17:D20)","v":6225}]
[]
["Cash flows from investing activities"]
["Business acquisitions, net of cash acquired",{"$f":"-Input!B72+Input!B69","v":-17500},null,{"$f":"-Input!D72","v":0}]
["Purchase of property, plant and equipment",{"$f":"Input!D24-Input!B24+Input!B64-Input!B75+Input!B90","v":-4300},null,{"$f":"Input!F24-Input!D24+Input!D64-Input!D75+Input!D90","v":-2000}]
["Purchase of intangible assets",{"$f":"Input!D27-Input!B27+Input!B65-Input!B82","v":0},null,{"$f":"Input!F27-Input!D27+Input!D65-Input!D82","v":-10000}]
["Proceeds from sale of equipment",{"$f":"Input!B78","v":0},null,{"$f":"Input!D78","v":400}]
["Proceeds from sale of intagibles",{"$f":"Input!B85","v":0},null,{"$f":"Input!D85","v":0}]
["Acquisition of investments",{"$f":"Input!D29-Input!B29+Input!B66","v":-10000},null,{"$f":"Input!F29-Input!D29+Input!D66","v":-1500}]
["Investment income",{"$f":"Input!D35+Input!B12-Input!B35","v":4800},null,{"$f":"Input!F35+Input!D12-Input!D35","v":2700}]
["Net cash used in investing activities",{"$f":"SUM(B24:B30)","v":-27000},null,{"$f":"SUM(D24:D30)","v":-10400}]
[]
["Cash flows from financing activities"]
["Proceeds from issue of share capital",{"$f":"Input!B41-Input!D41","v":0},null,{"$f":"Input!D41-Input!F41","v":25}]
["Proceeds from long-term borrowings",{"$f":"Input!B89","v":10000},null,{"$f":"Input!D89","v":4000}]
["Payment of long-term borrowings",{"$f":"Input!B45-Input!D45+Input!B71-Input!B91","v":-3950},null,{"$f":"Input!D45-Input!F45+Input!D71-Input!D91","v":-1450}]
["Net cash used in financing activities",{"$f":"SUM(B34:B36)","v":6050},null,{"$f":"SUM(D34:D36)","v":2575}]
[]
["Net increase in cash and cash equivalents",{"$f":"SUM(B21,B31,B37)","v":9900},null,{"$f":"SUM(D21,D31,D37)","v":-1600}]
[]
["Cash and cash equivalents at beginning of period",{"$f":"Input!D36","v":1600},null,{"$f":"Input!F36","v":3200}]
[]
["Cash and cash equivalents at end of period",{"$f":"SUM(B39,B41)","v":11500},null,{"$f":"SUM(D39,D41)","v":1600}]
[]
["Cash Balance Control Total",{"$f":"B43-Input!B36","v":0},null,{"$f":"D43-Input!D36","v":0}]
[]
[]
[]
[]
[" "]