McCormick Designs reported the following amounts on its balance sheets at December 31, 2018, 2017 and 2016: (Click the icon to view the data.) Sales and profits are high. Nevertheless, McCormick is experiencing a cash shortage. Perform a vertical analysis of the company's assets at the end of years 2018, 2017, and 2016. Use the analysis to explain the reason for the cash shortage. 2018 Perform a vertical analysis of McCormick Software's assets at the end of years 2018, 2017 and 2016. (Round your answers to the nearest one-tenth of a percent, X.X%.) McCormick Designs, Inc. Vertical Analysis Data Table Years Ended December 31, 2018, 2017, and 2016 2018 2017 2016 Amount Percent Amount Percent Amount Percent Cash S 17,700 10,740 "%. S 9,840 % Cash Receivables, net 17,700 5.370 % 9,840 Receivables, net Inventory 289.100 % 220,170 % 167,280 9 Inventory Prepaid expenses 29,500 9 37,590 1 % 29,520 Prepaid expenses Property, plant and equipment, net 236,000 % 263,130 9% 275,520 9 Property, plant and equipment, net S 590,000 $ 537,000 Total assets $ 492,000 %6 " Total assets 2017 10,740 2016 9,840 S 17,700 S $ 9,840 17,700 289,100 29,500 238,000 5,370 220,170 37,590 283.130 167,280 29,520 275,520 $ 590,000 S 537,000 $ 492,000 Print Done Enter any number in the edit fields and then click Check Answer. ? 1 part Clear All Check Answer remaining