Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance For Executives Managing For Value Creation

Authors: Gabriel Hawawini, Claude Viallet

3rd Edition

0324274319, 9780324274318

More Books

Students also viewed these Finance questions