1. Complete the 2017 income statement and the balance sheets of 2016 and 2017 (i.e. fill in the colored cell with proper formulas). Make sure you have a balanced balance sheet for each year.

AutoS. CH" Template for Mid Term Exam - Excel Scarch 0 0 achombom ng All Share izs Contents ZC Draw JI Calibri Page Layout P 11 Formulas M AA Data Review A R == View Help W Y 29 Wrap Text 200 1 AutoSum General File Home Insert N X CO [Copy Paste Format Painter Cipboard AR Fich) LEN Analyze Data OA BIU Sensitivity Merge & Center Insert Delete Format $ -% -% Clear Conditional Formalas Cell Formatting Table Styles Styles Sort & Find & Filter Select Editing Font Alignment Number Calls Analysis Sensitivt B46 B E F Dec 31, 2017 D Dec 31, 2016 $ 191 1,026 360 1,500 57 $ 181 812 399 1,404 70 12,370 6,763 11,699 6,423 1 1 CONSOLIDATED STATEMENTS OF FINANCIAL POSITION - USD ($) $ in Millions 2 Current assets 3 Cash and cash equivalents 4 Trade receivables, net of allowance for doubtful accounts 5 Miscellaneous receivables 6 inventories 7 Other current assets 8 Total current assets 9 Properties 10 Properties and equipment at cost 11 Less: Accumulated depreciation 12 Net PPF 13 Goodwill 14 Intangible assets, net of accumulated amortization 15 Other noncurrent assets 16 Total assets 17 Current liabilities 18 Payables and other current liabilities 19 Borrowines due within one year current portion of interest-bearing debt) 20 Total current liabilities 21 Long term borrowings 22 Deferred income tax liabilities 23 Post-employment obligations 24 Other long-term liabilities 25 Total liabilities 26 Stockholders' equity Common stock ($0.01 par value per share - 350,000,000 shares authorised; shares issued - 27 218,369,992 and 217,707,600 for 2017 and 2016, respectively) 28 Additional paid-in capital QA1 STATEMENTS OF EARN QW1 STATEMENTS OF FINA 042 043 Sheel 3 4,527 2,373 349 4,461 2,479 3/5 1,589 393 1,512 283 6,147 993 963 534 6,311 1,206 1,018 519 1.981.00 1,916 Reacy 1 Type here to search + 100% 5:53 PM 9/23/2021 O E 83F Mostly sunny AutoSave C H2 Template for Mid Term Exam Excel O Scarch achombom abong LA File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments Calibri - A A AutoSum - 11 == == PM 29 Wrap Text 200 1 General 27 Fah) X Out [Copy Paste Format Painter Cipboard O A BIU-- Sensitivity Merge Center Insert Delete Format $ -% -% Conditional Formalas Cell Formatting Table Styles Olcar Sort & Find & Filter Select Editing Analyze Data Font Alignment Number Stvies Colis Analysis Sensitivty B46 B D E F 4,527 2,373 349 4,461 2,479 375 1,589 1,512 283 393 6.147 893 963 534 6,311 1,206 1,018 519 A 13 Goodwill 14 Intangible assets, not at accumulated amortization 15 Other noncurrent assets 16 Total assets [1] 17 Current liabilities 18 Payables and other current liabilities 19 Borrowings due within one year (current portion of interest-bearing debt) 20 Total current liabilities 21 Long-term borrowings 22 Deferred income tax liabilities 23 Post employment obligations 24 Other long-term liabilities 25 Total liabilities 26 Stockholders' equity Common stock ($0.01 par value per share - 350,000,000 shares authorized; shares issued - 27 218,369,992 and 217,707,600 for 2017 and 2016, respectively) 28 Additional paid-in capital 29 Related earnings 30 Accumulated other comprehensive loss 31 Total stockholders' equity before treasury stock 32 Less: Treasury stock at cost (75,454,111 shares for 2017 and 71,269,474 shares for 2016) 33 Total Eastman stockholders' equity 34 Nuncontrolling interest 35 Total equity 36 Total liabilities and stockholders' equity 37 3 39 40 QA1 STATEMENTS OF EARN QW1 STATEMENTS OF FINA Q42 043 Sheel 3 1,916 5,722 (281) 1,984.00 6,803.00 (209.00) 8,578 3,175 5,403 77 2,825 76 Reacy + 1004 Type here to search O E 83F Mostly sunny 5:53 PM 9/23/2021