please use excell and show all the formulas. I need to see how you got the answers. please

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 153 Cost Of Sales (76) Gross Profit 76 Distribution Expenses (20) Administrative Expenses (28) Operating Profit 29 Interest Payable (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 O 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 207 (101) 106 (22) (20) 22646 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 2 34 3 39 236 Continue on next page ... Industrial Accounting 3 (EBIAC3A) Practical 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 formatting and calculation on Excel). 3/4