Data Window Help 75% 1 Mon 11:47 PM % 10 Q AE Excel File Edit View Insert Format Tools AutoSave ABDO OFF ACCT2302_WK12_HW_CH17 (2) QP Home Insert Draw Page Layout Formulas Data Review View Tell me Share 0 Comments Arial Rounded MT v 11 ~ Al Wran Text General SH AYO. (O) LG $ Wid Pasto BIU OA y Insert $ - % Merge & Center Delete Y Conditional Format Cell Formatting as Table Styles Format Sort Filter Find & Select Analyze Data Yes No H M N. P . 5 w w Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left oft? H52 + x fx A B B D E F G 1 ! 13 14 Instructions: Prepare a vertical analysis of Great Value's assets for 2018 and 2017 15 (calculate percentage) 16 2018 2018 17 Amount Percent Amount Percent 18 Cash And Receivables S 80,640 ON 80,575 D% 15 Merchandise Inventory 56,840 0% 54,450 0% 20 Property, Plant, and Equipment 142,520 0% 139,975 0% 21 Total Assets S 280,000 OW 275,0DD D% 22 23 24 Hint: To celou te vertical analysis specific ne item/base (total) amount) x 100 25 26 Problem 2 Performing horizontal analysis 27 28 Crystal Corp.reported the following on its comparative income statement: 20 30 fir millions) 2019 2018 2017 32 Revenue $ 9,890 $ 9,690 $ 9,135 32 Cost of Goods Sold 6,250 6.000 5.890 33 34 Instructions: Prepare a horizontal analysis of revenue and gross profit-both in dollar amounts and in 35 percentages for 2019 and 2011 36 Increase (Decrease) 37 (a) (b) (c) 2019 2018 (ab) 38 (Amounts i millora 2019 2018 2017 Amount Percent (b-c) Amount Percent -c 30 Revenue $ 9,890 S 9,690 S $ 9,135 S D.D%$ 0.0% 40 Cost of Goods Sold 8,250 6,000 5.890 42 Gross prorit $ $ 3,640 $ 3,690 $ 3,2458 0.0% 0.0% 42 43 (Hint to calculate horizontal analysia % (dollar amount of change/base perlod amount) x 100 44 45 46 Sucstion 1 What are the three main ways to analyze financial statements? (a 47 Part 1 Part 2 + Ready + 100% & tv A