please fill in and solve

2017 Amount The Coca Cola Company December 31, CONSOLIDATED BALANCE SHEETS Dollars in millions 2018 ASSETS Amount CS% Contecats Current assets Cash and cash equivalents 8,926 Short-term investments 2,025 Accounts receivables 3,396 Inventories 2,766 Prepaid expenses & other current assets 13,521 Total current assets 30,634 6,006 9,352 [A] 2,655 14,865 36,545 8,232 8,203 [B] 7,007 10,263 27,080 83,216 9,401 26,512 [C] $ $ $ Property, plant & equipment, net Intangible assets, net Goodwill Other non-current assets Total assets LIABILITIES Current liabilities Accounts payable & accrued expenses Short-term debt obligations Other current liabilities Total current liabilities Long-term debt obligations Other non-current liabilities Total liabilities STOCKHOLDERS' EQUITY Contributed capital Retained earnings Treasury stock & other Total stockholders' equity Total liabilities & stockholders' equity 8,932 18,191 2,100 29,223 25,364 9,571 64,158 8,748 [D] 1,943 27,194 31,182 10,543 [E] 18,280 63,234 (62,456) 19,058 $ 83,216 17,624 [E] (59,077) 18,977 [G] Referring to The Coca-Cola balances presented on the previous page, complete the following questions: 1) For the cells in the December 31, 2018 "CS%" column that have not been blacked out, calculate the common-size percentages using the balances provided in the "Amount" column. 17 points] 2) For the December 31, 2017 balance sheet, calculate the following missing balances: (7 points] [A] Accounts receivable, net [B] Intangible assets, net [C] Total assets [D] Short-term debt obligations [E] Total liabilities [F] Retained earnings [G] Total liabilities & stockholders' equity 3) Calculate to two decimal places Coca-Cola's current ratio as of: [4 points - 2 points each] December 31, 2018 December 31, 2017 4) Coca-Cola's current ratio, which measures the company's (liquidity / solvency 7 profitability) position, has improved / deteriorated) from December 31, 2017 to December 31, 2018. 12 points] 5) Calculate to two decimal places Coca-Cola's debt ratio as of: [4 pts 2 pts each] December 31, 2018 December 31, 2017 6) Coca-Cola's debt ratio, which measures the company's (liquidity / solvency / profitability) position, has improved / deteriorated) from December 31, 2017 to December 31, 2018, indicating that it has taken on slightly (more / less) financial risk. (3 points) 7) Which line item on the balance sheet clearly shows that Coca-Cola had acquired another company before December 31, 2018? (1 point)