Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Commercial Energy Auditing Reference Handbook

Authors: Steve Doty

2nd Edition

1439851972, 978-1439851975

More Books

Students also viewed these Accounting questions

Question

recognise typical interviewer errors and explain how to avoid them

Answered: 1 week ago

Question

identify and evaluate a range of recruitment and selection methods

Answered: 1 week ago

Question

understand the role of competencies and a competency framework

Answered: 1 week ago