Below are the ratios (with excel formulas) calculated for Pepsi-Co, Inc. for you all you need to do is calculate the Coca Cola Company ratios Pepsi-Co, Inc. Selected Financial Data: The Coca-Cola Company Selected Financial Data For years ended December 31 Acid-test ratio (CA-inventory-prepaid)/CL Current ratio (CA/CL) Debt ratio Earnings per share Inventory turnover Net income ($ in millions) Accounts Receivables turnover Return on assets Operating income percentage Revenues ($ in millions) Working capital (S in millions) CA-CL Notes: Debt ratio- TL/TA Inv. TO= CGS/Avg. Inv. Acciounts receivable TO-SALES/AVE AR Return on Assets-NI+ (Interest Expense (1-Tax)/Avg TA Operating Income %-operatinig income/SALES REVENUE For years ended December 31 2020 2019 2018 2020 2019 0.77 0.66 0.82 0.40 0.98 0.86 0.99 0.17 0.85 0.81 0.81 0.83 5.14 5.23 8,84 0.18 8.47 9.32 9.39 $7,120 $7,314 $12,515 8.67 8.98 9.05 9.34% 10.31% 17.69% 14.32% 15,32% 15.64% $ 70,372 $67,161 $64,661 (371) (2,816) (245) (9,229) 9426) 2018 Dec. 31, 2020 Dec. 31, 2019 Dec. 31, 2018 CURRENT ASSETS Cash and cash equivalents $6,795 $6,480 $9,077 Short-term investments 1,771 1,467 2,025 TOTAL CASH, CASH EQUIVALENTS AND SHORT-TERM INVESTMENTS 8,566 7,947 11,102 Marketable securities 2,348 3,228 5,013 Trade accounts receivable, less allowances of $524 and $501, respectively 3,144 3,971 3,685 Inventories 3,266 3,379 3,071 Prepaid expenses and other assets 1,916 1,886) 2,059 TOTAL CURRENT ASSETS 1 EQUITY METHOD INVESTMENTS 2 OTHER INVESTMENTS 3 OTHER ASSETS 4 Deferred Tax Assets, Net, Noncurrent 19,240 20,411 24,930 19,273 19,025 19,412 8121 854 867 6,184 6,075 4,148 2,460 2,412 2,674 5 PROPERTY, PLANT AND EQUIPMENT net 6 TRADEMARKS WITH INDEFINITE LIVES 10,777 10,838 9,598 10,395 9,266 6,682 7 BOTTLERS FRANCHISE RIGHTS WITH INDEFINITE LIVES 8 GOODWILL 9 OTHER INTANGIBLE ASSETS 20 TOTAL ASSETS 21 CURRENT LIABILITIES 22 Accounts payable and accrued expenses 23 Notes and Loans Payable, Current 24 Current maturities of long-term debt 25 Accrued income taxes 26 TOTAL CURRENT LIABILITIES 27 LONG-TERM DEBT 28 OTHER LIABILITIES 29 DEFERRED INCOME TAXES 0 109 51 17,506 16,764 14,109 649 627 745 87,296 86,381 83,216 11,145 11,312 9,533 2,183 10,994 13,835 485 4,253 5,003 788 414 411 14,601 26,973 28,782 40,125 27,516 25,376 9,453 8,510 7,646 1,833 2,284 2,354 23 Notes and Loans Payable, Current 24 Current maturities of long-term debt 25 Accrued income taxes: 26 TOTAL CURRENT LIABILITIES 27 LONG-TERM DEBT 28 OTHER LIABILITIES 29 DEFERRED INCOME TAXES 30 THE COCA-COLA COMPANY SHAREOWNERS' EQUITY 31 Common stock, $0.25 par value; authorized-11,200 shares; issued - 7,040 shares 32 Capital surplus 33 Reinvested earnings 34 Accumulated other comprehensive income (loss) 35 Treasury stock, at cost-2,760 and 2,772 shares, respectively 36 EQUITY ATTRIBUTABLE TO SHAREOWNERS OF THE COCA-COLA COMPANY 37 EQUITY ATTRIBUTABLE TO NONCONTROLLING INTERESTS 38 TOTAL EQUITY 39 TOTAL LIABILITIES AND EQUITY 40 41 B C D 2,183 10,994 485 4,253 13,835 5,003 788 414 411 14,601 26,973) 28,782 40,125 27,516 25,376 9,453 8,510 7,646 1,833 2,284 2,354 1,760 1,760 1,760 17,601 17,154 16,520 66,555 65,855 63,234 (14,601) (13,544) (12,814) (52,016) (52,244) (51,719) 19,299 18,981 16,981 1,985 2,117 2,077 $ 21,284 $21,098 $ 19,058 $87,296 $86,381 $ 83,216 CONSOLIDATED STATEMENTS OF INCOME USD ($) shares in Millions, $ in Millions Dec. 31, 2020 Dec. 31, 2019 Dec. 31, 2018 Revenues. Cost of Goods and Services Sold GROSS PROFIT Selling, General and Administrative Expense Other Cost and Expense, Operating OPERATING INCOME Interest income Interest expense Equity income (loss)- net Other income (loss)-net 33,014 37,266 34,300 13,433 14,619 13,067 19,581 22,647 21,233 9,731 12,103 11,002 8531 458 1,079 8,997 10,086 9,152 370 563 689 (1,437) (946) (950) 978 1,049 1,008 841 34 (1,674) INCOME BEFORE INCOME TAXES 9,749 10,786 8,225 Income taxes 1,981 1,801 1,749 CONSOLIDATED NET INCOME 7,768 8,985 6,476 Net Income (Loss) Attributable to Noncontrolling Interest 21 65 42 NET INCOME ATTRIBUTABLE TO SHAREOWNERS OF THE COCA-COLA COMPANY 7,747 8,920 6,434 BASIC NET INCOME PER SHARE (in dollars per share). 1.8 2.09 1.51 DILUTED NET INCOME PER SHARE (in dollars per share) 1.79 2.07 1.5 AVERAGE SHARES OUTSTANDING (in shares) 4295 4276 4259 Effect of dilutive securities (in shares) 28 38 40 AVERAGE SHARES OUTSTANDING ASSUMING DILUTION (in shares) 4323 4314 4299 NOTES: Tax rate Provision for Income Taxes/ Income before taxes 0.2032 0.1670 0.2126 0