please calculate using excel

QUESTION 2 (21) Acacia Ltd manufactures and sells quality furniture. Their income statements and statements of financial position are given: Income Statements For The Years Ended 31 December 2014 And 2015ok 2014 2015 Rm Rm Revenue 207 153 Cost Of Sales (101) (76) Gross Profit 106 76 Distribution Expenses (22) (20) Administrative Expenses (20) (28) Operating Profit 64 29 Interest Payable (4) (4) Profit Before Taxation 60 37 Taxation (16) (6) Profit For The Year 44 19 Statements of Financial Position as at 31 December 2014 And 2015 2014 2015 ASSETS Rm Rm Non-Current Assets Property, Plant And Equipment Land And Buildings Plant And Machinery Current Assets Inventories Trade Receivables Cash In Bank And In Hand TOTAL ASSETS EQUITY AND LIABILITIES Equity Called-up ordinary share capital Retained earnings Non-Current Liabilities Borrowings - loan notes (10%) Current Liabilities Borrowings (all bank overdraft) Trade Payables Taxation TOTAL EQUITY AND LIABILITIES 110 62 172 22 26 19 69 241 100 56 156 40 - 37 8 | 45 241 130 56 186 25 25 50 236 100 57 157 40 BWAN 34 39 236 Continue on next page ustrial Accounting 3 (EBIAC3A) ctical Assignment (2022) Page 3 of 4 Included in'cost of sales', 'distribution expenses' and 'administrative expenses', depreciation was as follows: 2014 2015 Rm Rm Land And Buildings 6 10 Plant And Machinery 10 12 There were no non-current asset disposal in either year. The amount of cash paid for interest equalled the explense in each ear. Dividends were paid totalling R18 million in each year. Required: Prepare a statement of cash flows for the business for 2015. (6 marks is for formatting and calculation on Excel)