Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In excel show formula's for each line item of how Income statement was created? (12 months ended only) what information do i need to complete
In excel show formula's for each line item of how Income statement was created? (12 months ended only) what information do i need to complete
Consolidated Statements of Income - USD ($) shares in Thousands, $ in Thousands | 3 Months Ended | 12 Months Ended | ||||||||||
Dec. 31, 2019 | Sep. 30, 2019 | Jun. 30, 2019 | Mar. 31, 2019 | Dec. 31, 2018 | Sep. 30, 2018 | Jun. 30, 2018 | Mar. 31, 2018 | Dec. 31, 2019 | Dec. 31, 2018 | Dec. 31, 2017 | ||
Income Statement [Abstract] | ||||||||||||
Net revenues | $ 1,441,225 | $ 1,429,456 | $ 1,191,729 | $ 1,204,722 | $ 1,389,980 | $ 1,442,976 | $ 1,174,859 | $ 1,185,370 | $ 5,267,132 | $ 5,193,185 | $ 4,989,244 | |
Cost of goods sold | 2,796,599 | 2,852,714 | 2,737,830 | |||||||||
Gross profit | 681,527 | 689,898 | 554,321 | 544,787 | 625,227 | 665,207 | 526,584 | 523,453 | 2,470,533 | 2,340,471 | 2,251,414 | |
Selling, general and administrative expenses | 2,233,763 | 2,182,339 | 2,099,522 | |||||||||
Restructuring and impairment charges | 0 | 183,149 | 124,049 | |||||||||
Income (loss) from operations | 74,073 | 138,920 | (11,482) | 35,259 | (10,447) | 118,966 | (104,875) | (28,661) | 236,770 | (25,017) | 27,843 | |
Interest expense, net | (21,240) | (33,568) | (34,538) | |||||||||
Other expense, net | (5,688) | (9,203) | (3,614) | |||||||||
Income (loss) before income taxes | 209,842 | (67,788) | (10,309) | |||||||||
Income tax expense (benefit) | 70,024 | (20,552) | 37,951 | |||||||||
Income (loss) from equity method investment | (47,679) | 934 | 0 | |||||||||
Net income (loss) | $ (15,304) | $ 102,315 | $ (17,349) | $ 22,477 | $ 4,218 | $ 75,266 | $ (95,544) | $ (30,242) | $ 92,139 | $ (46,302) | $ (48,260) | |
Basic net income (loss) per share (in dollars per share) | $ (0.03) | $ 0.23 | $ (0.04) | $ 0.05 | $ 0.01 | $ 0.17 | $ (0.21) | $ (0.07) | $ 0.20 | $ (0.10) | $ (0.11) | |
Diluted net income (loss) per share (in dollars per share) | $ (0.03) | $ 0.23 | $ (0.04) | $ 0.05 | $ 0.01 | $ 0.17 | $ (0.21) | $ (0.07) | $ 0.20 | $ (0.10) | $ (0.11) | |
Weighted average common shares outstanding Class A, B and C common stock | ||||||||||||
Class A, B and C Basic (in shares) | 450,964 | 445,815 | 440,729 | |||||||||
Class A, B and C Diluted (in shares) | 454,274 | 445,815 | 440,729 | |||||||||
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