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.

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 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