Accounting Applications Using Spreadsheets Microsoft Office,
(Figure 5-22)
Required:
Create a new worksheet "Chapters EX 39", and enter the previous data in it.
Insert necessary equations or functions in the related cells to calculate total current assets, total assets, and total liabilities owners' equity for the two years (2018 and 2019).
Insert necessary equations in the related cells to conduct horizontal and vertical analysis for all items of the Statement of Financial Position for the two years (2018 and 2019).
Exercise (4): The following data are the Statement of Profit Loss of Amman Company for the year ended on December 31, 201.
in the related cells to conduct 0 ... ill 221 224 6TOZ 5000 18000 17000 1000 34000 12500 2500. 10000 50000 (Figure 5-22) owners' equity for the two years (2018 and 2019). Insert necessary equations in the related cells to conduct Position RNY8I0T 1000 10000 15000 30000 0006 1000 2000 50000 Student Name EXT un Required: data in it.