Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How to calculate in excel? Profit after tax? Balance sheet: COCA-COLA CO (KO) CashFlowFlag BALANCE SHEET Fiscal year ends in December. USD in millions except
How to calculate in excel?
Profit after tax?
Balance sheet:
COCA-COLA CO (KO) CashFlowFlag BALANCE SHEET | |||||
Fiscal year ends in December. USD in millions except per share data. | 2015-12 | 2016-12 | 2017-12 | 2018-12 | 2019-12 |
Assets | |||||
Current assets | |||||
Cash | |||||
Cash and cash equivalents | 7309 | 8555 | 6006 | 8926 | 6480 |
Short-term investments | 12591 | 13646 | 14669 | 7038 | 4695 |
Total cash | 19900 | 22201 | 20675 | 15964 | 11175 |
Receivables | 3941 | 3856 | 3667 | 3396 | 3971 |
Inventories | 2902 | 2675 | 2655 | 2766 | 3379 |
Prepaid expenses | 2752 | 2481 | 2000 | 1962 | 1886 |
Other current assets | 3900 | 2797 | 7548 | 6546 | |
Total current assets | 33395 | 34010 | 36545 | 30634 | 20411 |
Non-current assets | |||||
Property, plant and equipment | |||||
Gross property, plant and equipment | 22354 | 21256 | 16449 | 16245 | 18921 |
Accumulated Depreciation | -9783 | -10621 | -8246 | -8013 | -8083 |
Net property, plant and equipment | 12571 | 10635 | 8203 | 8232 | 10838 |
Equity and other investments | 15788 | 17249 | 21952 | 20274 | 19879 |
Goodwill | 11289 | 10629 | 9401 | 10263 | 16764 |
Intangible assets | 12843 | 10499 | 7235 | 7007 | 10002 |
Deferred income taxes | 2667 | 2412 | |||
Other long-term assets | 4207 | 4248 | 4560 | 4139 | 6075 |
Total non-current assets | 56698 | 53260 | 51351 | 52582 | 65970 |
Total assets | 90093 | 87270 | 87896 | 83216 | 86381 |
Liabilities and stockholders' equity | |||||
Liabilities | |||||
Current liabilities | |||||
Short-term debt | 15806 | 16025 | 16503 | 18191 | 15247 |
Accounts payable | 2795 | 2682 | 2288 | 2498 | 3804 |
Deferred income taxes | 692 | ||||
Taxes payable | 775 | 679 | 757 | 693 | 856 |
Accrued liabilities | 5485 | 4887 | 5259 | 5225 | 6045 |
Other current liabilities | 2069 | 1567 | 2387 | 2616 | 1021 |
Total current liabilities | 26930 | 26532 | 27194 | 29223 | 26973 |
Non-current liabilities | |||||
Long-term debt | 28407 | 29684 | 31182 | 25364 | 27516 |
Deferred taxes liabilities | 4691 | 3753 | 2522 | 1933 | 2284 |
Minority interest | 210 | 158 | 1905 | 2077 | 2117 |
Other long-term liabilities | 4301 | 4081 | 8021 | 7638 | 8510 |
Total non-current liabilities | 37609 | 37676 | 43630 | 37012 | 40427 |
Total liabilities | 64539 | 64208 | 70824 | 66235 | 67400 |
Stockholders' equity | |||||
Common stock | 1760 | 1760 | 1760 | 1760 | 1760 |
Additional paid-in capital | 14016 | 14993 | 15864 | 16520 | 17154 |
Retained earnings | 65018 | 65502 | 60430 | 63234 | 65855 |
Treasury stock | -45066 | -47988 | -50677 | -51719 | -52244 |
Accumulated other comprehensive income | -10174 | -11205 | -10305 | -12814 | -13544 |
Total stockholders' equity | 25554 | 23062 | 17072 | 16981 | 18981 |
Total liabilities and stockholders' equity | 90093 | 87270 | 87896 | 83216 | 86381 |
Income statement:
COCA-COLA CO (KO) CashFlowFlag INCOME STATEMENT | ||||||
Fiscal year ends in December. USD in millions except per share data. | 2015-12 | 2016-12 | 2017-12 | 2018-12 | 2019-12 | TTM |
Revenue | 44294 | 41863 | 35410 | 31856 | 37266 | 34326 |
Cost of revenue | 17482 | 16465 | 13256 | 11770 | 14619 | 13717 |
Gross profit | 26812 | 25398 | 22154 | 20086 | 22647 | 20609 |
Operating expenses | ||||||
Sales, General and administrative | 16427 | 15262 | 12496 | 10307 | 12103 | 10971 |
Restructuring, merger and acquisition | 1088 | 598 | 405 | |||
Other operating expenses | 1657 | 1510 | -857 | -600 | -394 | 167 |
Total operating expenses | 18084 | 16772 | 12727 | 10305 | 12114 | 11138 |
Operating income | 8728 | 8626 | 9427 | 9781 | 10533 | 9471 |
Interest Expense | 856 | 733 | 841 | 919 | 946 | 932 |
Other income (expense) | 1733 | 243 | -1844 | -512 | 1199 | 2180 |
Income before taxes | 9605 | 8136 | 6742 | 8350 | 10786 | 10719 |
Provision for income taxes | 2239 | 1586 | 5560 | 1623 | 1801 | 1511 |
Net income from continuing operations | 7366 | 6550 | 1182 | 6727 | 8985 | 9208 |
Net income from discontinuing ops | 101 | -251 | ||||
Other | -15 | -23 | -35 | -42 | -65 | -19 |
Net income | 7351 | 6527 | 1248 | 6434 | 8920 | 9189 |
Net income available to common shareholders | 7351 | 6527 | 1248 | 6434 | 8920 | 9189 |
Earnings per share | ||||||
Basic | 1,69 | 1,51 | 0,29 | 1,51 | 2,09 | 2,15 |
Diluted | 1,67 | 1,49 | 0,29 | 1,5 | 2,07 | 2,12 |
Weighted average shares outstanding | ||||||
Basic | 4352 | 4317 | 4272 | 4259 | 4276 | 4287 |
Diluted | 4405 | 4367 | 4324 | 4299 | 4314 | 4322 |
EBITDA | 12431 | 10656 | 8843 | 10355 | 13097 | 13162 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started