Question

Done Coco Cola Income and Balance Sheet (4 of 11) 12 Months Ended CONSOLIDATED STATEMENTS OF INCOME-USD (S)shares in Millioas, S in Millions Dec. 31, 2018 Dec. 31, 2017 Dec. 31, 2016Dee.3,2015 Dec. 31, 2014 Dec. 31, 2013 31856 35410 3255 41863 16465 Cost of Goods and Services Sold GROSS PROFIT Selling, General and Administrative Expense Other Cost and Expense, Operating OPERATING INCOME Intcrest income Intcrest expense Equity income (loss)-n Other income (loss) net INCOME BEFORE INCOME TAXES 17482 17889 16427 1657 12654 5370 17218 7310 677 856 1008 8350 1623 6727 1764 6742 3560 1182 8136 1586 6350 2239 NET INCOME FROM CONTINUING OPERATIONS Income (Loss) from Discontinaed Operations, Net of Tax, Including Portion Atnibutable to Noncontrolling Interest CONSOLIDATED NET INCOME Net Income (Loss)Attributable to Noncontrolling Imerest NET INCOME ATTRIBUTABLE TO SHAREOWNERS OF THE COCA-COLA Income (Loss) from Continuing Operations, Per Basic Share Discontinued Opcration, Income (Loss) from Discoetinued Operation, Net of Tax, Por Basic Share 251 6476 1283 1248 0.28 1.69 BASIC NET INCOME PER SHARE (in dollars per share) Income (Loss) from Continuing Operations, Per Diluted Share Discontinued Operation, Income (Loss) from Discontinued Operation, Net of Tax, Per Diluted Share DILUTED NET INCOME PER SHARE (in dollars per share) AVERAGE SHARES OUTSTANDING (in shares) Effect of dilutive securities (in shares) AVERAGE SHARES OUTSTANDING ASSUMING DILUTION (in shares) 0.29 4259 4317 4324 4367 4509

use the income and balance sheet above to answer the questions below. (please show work, id appreciate it)

Answer 1

Ratio Description Formula Items Required Current Assets (A) Current Liabilities (B) Current Ratio (A/B) 2013 2014 2015 2016 2017 2018 31304 32986 33395 34010 36545 30634 27811 32374 26929 26532 27194 29223 1.13 1.02 1.24 1.281.34 1.05 It is a liquidity ratio which tells the Current Assets/Current Liabilities Current Ratio company's ability to pay short term loans and obligations, due within It is a liquidity ratio which tells the company's ability to meet its short term obligationswith its most liquid assets. Also known as Acid test Current Assets (A Inventory (B Prepaid Expenses (C Current Liabilities (D Quick Ratio [(A-B-C)/D] 31304 32986 33395 34010 36545 30634 3277 3100 2902 2675 2655 2766 2886 3066 2752 2481 2000 1962 26929 26532 27194 29223 (Current Assets- Inventory-Prepaid Quick Ratio Expenses)/Current 27811 32374 Liabilities 0.90 0.83 1.03 1.09 1.17 0.89 Interest It is a coverage ratio that measures EBIT (or Operating Coverage the portion of income that can be EBIT/Operating Profit (A Interest Expense (B TIE (A/B) 10228 9708 8728 8657 | 7599 8700 463 483856 733841 919 22.09 20.10 10.20 11.81 9.04 9.47 Profit)/Interest TIE) used to cover interest expense Expense Inventory (A Days Sales in Inventory It tells the average time in days that a company takes to convert its inventory into sales 3277 3100 2902 2675 2655 2766 18421 17889 17482 16465 13255 11770 365 365 365 366 365 365 COGS (B) (Inventory/COGS) 365 Days in Year (C ) 2016-Leap year Days Sales in Inventory [(A/B)*64.93 63.25 60.59 59.46 73.11 85.78 It tells how many times company has sold and replaced its inventory during a period Sales (or Revenue)/Inventory Revenue (A Inventory (B Inventory Turnover (A/B) 46854 45998 44294 41863 35410 31856 3277 3100 2902 2675 2655 2766 14.30 14.84 15.26 15.65 13.34 11.52 Inventory Turnover

Ratio Description Formula Items Required Net Income (A Revenue (B Net Profit Margin (A/B) 2013 2014 2015 2016 2017 2018 8584 | 7098 | 7351 | б527| 1248 | 6434 46854 45998 4429441863 35410 31856 0.180.15 0.17 0.16 0.04 0.20 Net Profit Tells us how much of revenue is Net Income/Revenue Margingetting converted to income Tells us how much revenue a company is able to generate from its assets Sales (or Revenue)/Total Assets Revenue (A Total Assets (B Asset Turnover (A/B 46854 45998 4429441863 35410 31856 90055 92023 89996 87270 87896 83216 0.52 0.50 0.49 0.48 0.40 0.38 Asset Turnover Equity Multiplier It is a financial leverage ratio which tells us how much of the assets is financed by the shareholder's Total Assets/ Shareholder's Equity Total Assets (A Shareholder's Eguity (B Equity Multiplier (A/B) 90055 92023 89996 87270 87896 83216 33173 30320 25554 23062 17072 16981 2.713.04 3.52 3.785.15 4.90 DuPont to calculate Return on Equity (ROE), using three criterias, namely Operating Efficiency measured by Net Profit Margin (A) Asset Turnover (B) Equity Multiplier (C) DuPont ROE (A B C) 0.18 0.15 0.17 0.16 0.04 0.20 Net Profit Margin Asset Turnover Equity Multiplier 0.52 0.50 0.49 0.48 0.40 0.38 DuPont ROE Net Profit Margin, Asset Efficiency measured by Asset Turnover and lastly financial leverage measured by Equity Multiplier 2.713.04 | 3.52 3.78 5.15 4.90 0.25 0.23 0.29 0.29 0.08 0.37
Values are taken from Income statement & Balance Sheet provided