Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help making a horizontal analysis of General Motors using its latest yearly income statement using excel please Table of Contents GENERAL MOTORS COMPANY
I need help making a horizontal analysis of General Motors using its latest yearly income statement
using excel 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. 2018 2019 2017 122.697 133,0455 14,004 147,049 133.449 12.139 145,588 137,237 120,656 12.298 9,650 142,604 4,445 110,651 12.614 8,491 131.756 5,481 782 1.469 1.26 7.416 769 6,667 116,229 11,128 9,570 136,927 8,661 575 655 Net sales and revenue Automotive GM Financial Total net sales and revenue (Note 3) Costs 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 Loss from discontinued operations, net of tax (Note 22) Net Income (loss) Netloss attributable to noncontrolling interests Net Income (los) attributable to stockholders Net Income (los) attributable to common stockholders Earnings per share (Note 21) Basic earnings per common share continuing operations Basie loss per common share-discontinued operations Basic earnings (los) per common share Weighted average common shares outstanding - basic Diluted camings per common share - continuing operations Diluted loss per common share - discontinued operations Diluted camings (los) per common share Weighted average common shares outstanding-diluted 2.596 2.163 8.549 474 8,075 70 8,005 2.132 11,863 11,533 330 4.212 (3.882) 6,667 65 6,732 8,014 (3,864) 6,581 s 7,916 5 (3,880) $ 0.23 s 5.66 0,05 5.61 1411 s 4.57 0.22 $ $ 4.57 1.439 5.58 s 0.055 5.53 1.431 (2.60) 1.492 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started