can someone help me make an excel spreadsheet showing a horizontal analysis using the latest yearly income statement of General Motors? PLEASE
Table of Contents GENERAL MOTORS COMPANY AND SUBSIDIARIES Item 8. Financial Statements and Supplementary Data CONSOLIDATED INCOME STATEMENTS In millions, except per share amounts) Years Ended December 31. BOIN 2017 s 122.6975 14500 137237 133,045 14.004 147,019 133,449 12,139 145,588 120,656 116.229 9,650 Net sales and revenue Automotive GM Financial Total net sales and revenue (Note 3) Corts and expenses Automotive and other cost of sales GM Financial interest, operating and other expenses Automotive and other selling general and administrative expense Total costs and expenses Operating income Automotive interest expense Interest income and other non-operating income, net (Note 19) Equity income (Note 8) Income before income taxes Income tax expense (Note 17) Income from continuing operations Los from discontinued operations, net of tax (Note 22) Net Income (loss) Netloss anbutable to non controlling interests Net income (loss) attributable to stockholders 110651 12.614 8,491 131,756 5,481 782 1469 1268 7,436 4,445 655 9,570 136.927 8.661 $75 1.645 2.132 11.163 11.333 2,163 8.549 6667 65 6.732 8,075 70 8.005 9 8,014 4.212 (3.8K2) 18 (3.864) 7.916 5 (3.880) 0.23 Net income (losa) attributable to common stockholders Earnings per share (Note 21) Basic eamings per common share continuing operations 4.62 S Basic loss per common share-discontinued operations s Basic earnings (ess) per common sture s Weighted average common shares outstanding - basic 1,434 Diluted camins per common share - continuing operations 4.57 Diluted loss per common share-discontinued operations s Diluted earnings (less) per common share 4.575 Weighted average common shares outstanding-diluted CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME (la milions) 5.66 0035 5615 1,411 (2.65) 5.58 5 0.05 5 5.53 $ 0.22 2.82 Year Ended December 31. 2018 R.0055 2017 Net Income (los) Other comprehensive income (less), net of tax (Note 28) Foreign currency translation adjustments and other Defined benefit plans Other comprehensive income (loss.net of tax (115) (6) 2.122) 747 570 Comprehensive income dow) Comprehensive loss attributable to noncontrolling interests Comprehensive income (os) attributable to stockholders 4519 76 15 20 2.545) 7.05 Reference should be made to the notes to colidated financial statements 47 Table of Contents GENERAL MOTORS COMPANY AND SUBSIDIARIES Item 8. Financial Statements and Supplementary Data CONSOLIDATED INCOME STATEMENTS In millions, except per share amounts) Years Ended December 31. BOIN 2019 2017 s 122,697 s 1450 137237 133,045 14,004 133,449 12,139 145,588 120,656 GM 110SSI 12.614 116.29 11.126 9.570 136.927 9,650 142.004 Net sales and revenue Automotive GM Financial Total net sales and revenue (Note 3) Costs and expenses Automotive and other cost of sales M Financial interest operating and other expenses Automotive and other selling general and administrative expense Total costs and expenses Operating income Automotive interest expense Interest income and other non-operating income, net (Note 19) Equity income (Note 8) Income before income taxes Income tax expense (Note 17) Income from continuing operations Los from discontinued operations, net of tax (Note 22) Net Income (loss) Netloss butable to non controlling interests Net income (loss) attributable to stockholders $75 131.756 5,481 782 1.469 126 7,436 769 655 2,596 2.163 8,549 2.112 11.163 11.313 6667 6667 8,075 70 8.005 9 8,014 4.212 (3.2) 18 (3.864) 6,732 7.916 5 (3.880) 0.23 5.66 $ 0.055 5615 Net income (losa) attributable to common stockholders 6581 Earnings per share (Note 21) Basic earings per common share continuing operations 4.62 S Basic loss per common share -- discontinued operations s Basic earnings (ess) per common sture $ Weighted average common shares outstanding -- basic Diluted camins per common share - continuing operations 4.57 $ Diluted loss per common share - discontinued operations s Diluted carings (less) per common share 457 s Weighted average common shares outstanding-diluted CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME (In millions) 0.22 2.82 558 5 005 5 550 5 1,431 2019 Year Ended December 31. 2018 8.0055 2017 Net Income on) Other comprehensive income (less), net of tax (Note 28) Foreign currency translation adjustments and other Defined benefit plans Other comprehensive income (loss.net of tax (6) 2.122) (2.128) (715) (221) 747 570 Comprehensive income dow) Comprehensive loss attributable to non controlling interests Comprehensive income ess) attributable to stockholders 4519 76 15 20 (2.545) 7.05 Reference should be made to the notes to consolidated financial statements 47
