Balance Sheet A2 2Balance Sheet 3 All numbers in thousands 31.12.2015 31.12.2016 31.12.2017 31.12.2018 4 Period Ending 5 Current Assets 7 309 000 12 591 000 3 941 000 2 902 000 4 748 000 8 555 000 006 000 926 000 6 Cash And Cash Equivalents 7 Short Term Investments 8 Net Receivables 9 Inventory 10 Other Current Assets 11 Total Current Assets 13 646 000 14 669 000 038 000 3 856 000 667 000 3 396 000 2 675 000 655 000 2 766 000 3 592 000 646 000 6 659 000 33 395 000 34 010 000 36 545 000 30 634 000 12 16 868 000 18 569 000 23 281 000 13 Long Term Investments 14 Property Plant and Equipment 15 Goodwill 16 Intangible Assets 17 Accumulated Amortization 21 533 000 12 571 000 10 635 000 8 203 000 8 232 000 11 289 000 10 629 000 10 263 000 9 401 000 12 843 000 10 499 000 7 235 000 7 007 000 3 030 000 2 928 000 3 231 000 5 547 000 18 Other Assets 19 Deferred Long Term Asset Charg 20 Total Assets 360 000 326 000 330 000 2 667 000 89 996 000 87 270 000 87 896 000 83 216 000 21 22 Current Liabilities 23 Accounts Payable 24 Short/Current Long Term Debt 2 795 000 2 682 000 2 288 000 2498 000 2 729 000 3 527 000 3 298 000 4 997 000 2 333 000 1 817 000 2 023 000 2 186 000 25 Other Current Liabilities 26 Total Current Liabilities 26 929 000 26 532 000 27 194 000 29 223 000 27 31 221 000 29 732 000 28 543 000 25 404 000 28 Long Term Debt 29 Other Liabilities 30 Deferred Long Term Liability Cha- 31 Minority Interest 32 Negative Goodwill 33 Total Liabilities 8760 000 10 504 000 7 786 000 9531 000 158 000 2077 000 1905 000 210 000 68 919 000 64 050 000 64 232 000 64 158 000 34 35 Stockholders' Equity 36 Misc. Stocks Options Warrants 37 Redeemable Preferred Stock 38 Preferred Stock 39 Common Stock 40 Retained Earnings 41 Treasury Stock 42 Capital Surplus 43 Other Stockholder Equity 1760 000 60 430 000 -60 982 000 1 760 000 760 000 1 760 000 65 502 000 -59 193 000 14 993 000 63 234 000 65 018 000 -55 240 000 -64 533 000 15 864 000 16 520 000 14 016 000 -12 814 000 16 981 000 -10 305 000 -11 205 000 -10 174 000 44 Total Stockholder Equity 17 072 000 23 062 000 25 554 000 45 46 Number of shares Outstanding 4 268 000 000 Actual Number-not in thousands 47 48 49 50 PRODUCT NOTICE Most of the features of Excel have been disabled because it hasn't been activaled Revenue A5 D C B 1 2 Income Statement 3 All numbers in thousands 31.12.2015 31.12.2016 31.12.2017 31.12.2018 4 5 Revenue 44 294 000 41 863 000 35 410 000 6 Total Revenue - Net Sales 7 Cost of Revenue (Cost of Goods Sold) 31 856 000 17 482 000 16 465 000 13 255 000 11770 000 26 812 000 25 398 000 22 155 000 20086 000 8 Gross Profit 10 Operating Expenses 11 Research Development 12 Selling General and Administrative 13 Non Recurring 14 Others 15 Total Operating Expenses 16 427 000 15 401 000 10 561 000 12 827 000 145 000 274 000 250 000 17 000 34 054 000 32 140 000 26 332 000 22 348 000 10 240 000 9 723 000 9 078 000 9 508 000 16 Operating Income or Loss 17 18 Income from Continuing Operations 19 Total Other Income/Expenses Net 20 Earnings Before Interest and Taxes 21 Interest Expense -635 000 1587 000 -2 336 000 1 158 000 10 240 000 723 000 9 078 000 9 508 000 -856 000 -733 000 -841 000 -919 000 8350 000 9605 000 8 136 000 6 742 000 22 Income Before Tax 5560 000 2 239 000 1586 000 1 623 000 23 Income Tax Expense 210000 1905 000 158 000 2077 000 24 Minority Interest 25 Net Income From Continuing Ops 182 000 5 550 000 7 366 000 6 727 000 26 27 Non-recurring Events 28 Discontinued Operations 29 Extraordinary Items 30 Effect Of Accounting Changes 31 Other Items 101 000 101 000 -251 000 101 000 32 Net Income 7 351 000 33 Net Income 6434 000 1 248 000 6527 000 34 Preferred Stock And Other Adjustments 35 Net Income Applicable To Common Shar 248 000 6527 000 351 000 6434 000 36 37 38 39 40 Income Statement Balance Sheet Ehabie Editing Activate Each ratio calculation and explanation is worth 10 points. Current Assets Current Ratio = Current Liabilities Asset Turnover Ratio Sales Revenue Average Total Assets 2 Net Profit Margin = 3 Net Income Net sales 4 Earnings Per Share Net Income Average Number of Common Shares Outstanding during the Period Net Income 5. Return on Assets = Average Total Assets Receivables Turnover Net Sales 6 Average Trade Receivables Debt to Equity Total Liabilities Stockholder's Equity 7 Current Stock Price per Share Earnings Per Share 8 Price/Earnings Ratio = For the Current Stock per Share Coca-Cola use $51.49 Per Share (Closing price 6/7/2019) Cost of Goods Sold Average Inventory 9. Inventory Turnover = Cost of Goods Sold may be referred to as Cost of Revenue Return on Equity = Net Income Average Stockholder's Equity 10