find following ratios with the given income statement and balance sheet:

liquidity ratios

asset management ratios

debt management ratios

profitability ratios

market value ratios

Insert Draw Formulas View Home Data Review Page Layout 12 A A = Calibri (Body) ab Wra X Cut Copy IN E BIU - Mer lil Paste Format A3 Sx Pepsico, Inc. A B Pepsi co, Inc. Financial statement (in millions) Income statement for years ended December31(in million $) 2019 2018 Revenue 67,161 64,661 Total revenue 67,161 64,661 2017 63,525 63,525 Cost of goods sold Gross profit 30,132 37,029 29,381 35,280 28,796 34,729 Selling general and administration exp. Operating expense 26,738 56,870 25,170 54,551 24,453 53,249 Operating income 10,291 10,110 10,276 Total non-operating income/expense -921 -674 9,312 9,189 9,602 Pre-tax Income Income tax Other non operating income expense Other income expense 979 Tax provision met income continuous operations Cut 12 A A ab Copy Format Paste Calibri (Body) B I U bile HO 1 D31 fx =D25+D30 A B C D 2018 10,990 7,142 3,128 633 2017 19,510 7,024 2,947 1,546 2 3 Pepsi co, Inc. 4 Balance sheet 5 (in millions) 6 Balance sheet for years ended December 31 7 2019 8 Cash 5,738 9 Accounts receivables 7,822 10 Inventory 3,338 11 Pre-paid expenses 747 12 other current assets 13 Total current assets 17,645 14 PPE.net 19,305 15 Long-term investments 2,683 16 Goodwill and intangible assets 31,544 17 Other long-term assets 3,011 18 Total long-term assets 60,902 19 Total assets 78,547 20 Total current liabilities 20,461 21 Long-term debt 29,148 22 Other non-current liabilities 9,979 23 deferred income tax 4,091 24 Total long term liabilities 43,218 25 Total liabilities 63,679 26 Common stock net 23 27 Retained earnings 61,946 28 Comprehansive income -14,300 29 Other share holders equity 30 Share holders equity 14,868 31 Total liabilities ans share holders equity 78,547 32 21,893 17,589 2,409 30,633 760 55,755 77,648 22,138 28,295 9,114 3,499 40,908 63,046 23 59,947 -15,119 31,027 17,240 2,042 28,582 913 48,777 79,804 20,502 33,796 11,283 3,242 48,321 68,823 24 52,839 -13,057 14,602 77,648 10,981 79,804 Income statement Balance sheet Patio + Ready