2 4 55 Exercise 7-The following are excerpts from Your Co's financial statements. 2019 Your Co. 2018 2017 $ 1,620.00 $ 1,440.00 $ 1,320.00 6 Net Sales 7 COGS 8 Other Expenses 9 Cash 10 A/R 11 Inventory 12 Prepaid Insurance 13 Total Assets 14 750.00 690.00 660.00 480.00 420.00 360.00 120.00 150.00 60.00 240.00 180.00 210.00 300.00 270.00 270.00 30.00 60.00 60.00 690.00 660.00 600.00 15 a) Perform horizontal analysis below, using 2017 as the base year (100%). 16 17 Net Sales 18 COGS 19 Other Expenses 20 2019 13.0% 2018 17.0% 21 b) Perform vertical analysis below, using total assets as the base. 23 24 25 22222222 Cash A/R Inventory 26 Prepaid Insurance 27 Total Assets 28 29 2019 2018 2017 100.0% X X 100.0% X X 100.0% X X 2017 X X X X X X XXX XXX XXX