Preparing and analyzing the statement of cash flows by use of the direct method Appendix 1 and the attached excel sheet contain an internal income statement for the period 1 January to 31 December 2016 as well as extracts from the balance sheet per. 31 December 2015 and 2016 for the company Ex-Cept A / S. In addition, further information is available during 2016. These are; . Fixed assets have been purchased for a total of DKK 222,000, of which DKK 170,000 was paid in cash and the rest DKK 52,000 set up as an interest-free bank loan. . Payments in connection with the sale of land at book value of total DKK 28,000. Payment in connection with the issue of new shares totaling DKK 90,000 Payment on the newly created bank loan in total DKK 18,000 . Payment of dividends totaling DKK 13,000 Income Statement 1/1 - 31/12 2016 Extract of balance sheet i Kr. i Kr. 31/12 2016 31/12 2015 ndring +/- Income: Revenue Other income 283.000 8.000 291.000 Assets Inventory Accounts receivable Prepaid expenses Cash 930.000 42.000 9.400 30.000 991.000 59.000 8.700 10.800 -61.000 -17.000 700 19.200 Total income: Omkostninger: Cost of goods sold Salary Depreciation Marketing cost Financial expense Tax expense (Paid) Liabilities Accounts payable Other debt 38.000 18.000 27.000 99.000 11.000 -81.000 103.000 78.000 26.000 4.500 2.600 8.000 222.100 Total Cost: Net income: 68.900 Please solve the problem in excel/computer (NOT in hand) and show calculations and explanations