a) Current ratio and quick ratio b) Net working capital and change in net working capital for the most recent year. c) EBITDA (or EBITD) margin, net profit margin (PM) and ROE. d) Total asset turnover ratio e) Total debt (liabilities) to asset (D/A), times interest earned (TIE) ratios and Net debt/EBITDA ratio. f) P/E and EV/EBITDA ratios only for the most recent year (with current market price). Note: For debt, include long-term and short-term debt; for cash, include marketable securities.). g) Three more ratios of your choice (explain shortly what motivated you to choose these ratios e.g. choose wisely). Do all calculations in Excel by linking formulas directly to the statements. Start your report with a description of the company you have been assigned to analyse. Please write your interpretations for the ratios you have calculated and a separate conclusion highlighting your main findings. Note that, in order to receive full points it is not enough to present the calculations and comments such as "good", "bad" or smth. alike. Note that I am pretty sure that you can calculate the values for the ratios, therefore your main contribution should be your comments and interpretations. The assignment should end with the conclusion of main findings. 2015-12 2016-12 2017-12 2018-12 2019-12 7309 12591 19900 3941 2902 2752 3900 33395 8555 13646 22201 3856 2675 2481 2797 34010 6006 14669 20675 3667 2655 2000 7548 36545 8926 7038 15964 3396 2766 1962 6546 30634 6480 4695 11175 3971 3379 1886 20411 1 COCA-COLA CO (KO) Cash FlowFlag BALANCE SHEET Fiscal year ends in December. USD in millions except per share data. 3 Assets 4 Current assets 5 Cash 6 Cash and cash equivalents 7 Short-term investments 8 Total cash 9 Receivables 10 Inventories 11 Prepaid expenses 12 Other current assets 13 Total current assets 14 Non-current assets 15 Property, plant and equipment 16 Gross property, plant and equipment 17 Accumulated Depreciation 18 Net property, plant and equipment 19 Equity and other investments 20 Goodwill 21 Intangible assets 22 Deferred income taxes 23 Other long-term assets 24 Total non current assets 25 Total assets 26 Liabilities and stockholders' equity 27 Liabilities 28 Current liabilities 29 Short-term debt 30 Accounts payable 31 Deferred income taxes 32 Taxes payable 33 Accrued liabilities 34 other current liabilities KO Statements 22354 -9783 12571 15788 11289 12843 21256 -10621 10635 17249 10629 10499 16449 -8246 8203 21952 9401 7235 16245 -8013 8232 20274 10263 7007 2667 4139 52582 83216 18921 -8083 10838 19879 16764 10002 2412 6075 65970 86381 4207 56698 90093 4248 53260 87270 4560 51351 87896 15806 2795 16503 2288 18191 2498 15247 3804 16025 2682 692 679 4887 1567 775 5485 2069 757 5259 23RZ 693 5225 2616 856 6045 1021 15806 2795 16503 2288 18191 2498 15247 3804 775 5485 2069 26930 16025 2682 692 679 4887 1567 26532 757 5259 2387 27194 693 5225 2616 29223 856 6045 1021 26973 28 Current liabilities 29 Short-term debt 30 Accounts payable 31 Deferred income taxes 32 Taxes payable 33 Accrued liabilities 34 Other current liabilities 35 Total current liabilities 36 Non-current liabilities 37 Long-term debt 38 Deferred taxes liabilities 39 Minority interest 40 Other long-term liabilities 41 Total non-current liabilities 42 Total liabilities 43 Stockholders' equity 44 Common stock 45 Additional paid in capital 46 Retained earnings 47 Treasury stock 18 Accumulated other comprehensive income 49 Total stockholders' equity 50 Total liabilities and stockholders' equity 51 52 28407 4691 210 4301 37609 64539 29684 3753 158 4081 37676 64208 31182 2522 1905 8021 43630 70824 25364 1933 2077 7638 37012 66235 27516 2284 2117 8510 40427 67400 1760 14016 65018 -45066 -10174 25554 90093 1760 14993 65502 -47988 - 11205 23062 87270 1760 15864 60430 -50677 -10305 17072 87896 1760 16520 63234 -51719 -12814 16981 83216 1760 17154 65855 -52244 -13544 18981 86381 2015-12 2016-12 2017-12 2018-12 2019-12 TTM 44294 41863 35410 31856 37266 34326 17482 16465 13256 11770 14619 13717 26812 25398 22154 20086 22647 20609 16427 15262 10971 COCA-COLA CO (KO) Cash FlowFlag INCOME STATEMENT Fiscal year ends in December. USD in millions except per share data. Revenue Cost of revenue Gross profit Operating expenses Sales, General and administrative Restructuring, merger and acquisition Other operating expenses Total operating expenses Operating Income Interest Expense Other income (expense) Income before taxes Provision for income taxes Net income from continuing operations Net income from discontinuing ops Other Net Income Net income available to common shareholders Earnings per share Basic Diluted Weighted average shares outstanding Basic Diluted EBITDA 1657 18084 8728 856 1733 9605 2239 7366 1510 16772 8626 733 243 8136 1586 6550 12496 1088 -857 12727 9427 841 - 1844 6742 5560 1182 101 -35 1248 1248 10307 598 -600 10305 9781 919 -512 8350 1623 6727 -251 -42 6434 6434 12103 405 -394 12114 10533 946 1199 10786 1801 8985 167 11138 9471 932 2180 10719 1511 9208 -15 7351 7351 -23 6527 6527 -65 8920 8920 -19 9189 9189 1,51 1,69 1,67 0,29 0,29 1,51 1,5 2,09 2,07 2,15 2,12 1,49 4352 4405 12431 4317 4367 10656 4272 4324 8843 4259 4299 4276 4314 4287 4322 13162 10355 13097