Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Fiscal year is January-December. All values USD millions. 2014 2015 2016 2017 2018 5-year trend Sales/Revenue 18.61B 19.82B 20.29B 21.15B 21.97B Cost of Goods Sold

Fiscal year is January-December. All values USD millions. 2014 2015 2016 2017 2018 5-year trend
Sales/Revenue 18.61B 19.82B 20.29B 21.15B 21.97B
Cost of Goods Sold (COGS) incl. D&A 14.08B 13.05B 14.06B 14.34B 15.94B
COGS excluding D&A 13.15B 12.03B 12.84B 13.12B 14.74B
Depreciation & Amortization Expense 938M 1.02B 1.22B 1.22B 1.2B
Depreciation 925M 996M 1.22B 1.22B 1.2B
Amortization of Intangibles 13M 19M 3M 3M 3M
Gross Income 4.52B 6.78B 6.23B 6.81B 6.03B
2014 2015 2016 2017 2018 5-year trend
SG&A Expense 2.21B 2.21B 2.7B 2.85B 2.85B
Research & Development - - - - -
Other SG&A 2.21B 2.21B 2.7B 2.85B 2.85B
Other Operating Expense - - - - -
Unusual Expense 634M 988M - 225M 29M
EBIT after Unusual Expense 1.68B 3.58B - (225M) 3.14B
Non Operating Income/Expense 256M (42M) (21M) (468M) 9M
Non-Operating Interest Income 7M 9M 24M 35M 69M
Equity in Affiliates (Pretax) - - - - -
Interest Expense 130M 70M 75M 36M 58M
Gross Interest Expense 153M 101M 122M 85M 96M
Interest Capitalized 23M 31M 47M 49M 38M
Pretax Income 1.82B 3.48B 3.45B 3.27B 3.16B
Income Tax 680M 1.3B 1.27B (92M) 699M
Income Tax - Current Domestic 29M 1.41B 847M 976M 398M
Income Tax - Current Foreign 203M - - - -
Income Tax - Deferred Domestic 27M (108M) 420M (1.07B) 301M
Income Tax - Deferred Foreign 421M - - - -
Income Tax Credits - - - - -
Equity in Affiliates - - - - -
Other After Tax Income (Expense) 4M 4M 2M - -
Consolidated Net Income 1.14B 2.19B 2.19B 3.36B 2.47B
Minority Interest Expense - - - - -
Net Income 1.14B 2.19B 2.19B 3.36B 2.47B
Extraordinaries & Discontinued Operations - - - - -
Extra Items & Gain/Loss Sale Of Assets - - - - -
Cumulative Effect - Accounting Chg - - - - -
Discontinued Operations - - - - -
Net Income After Extraordinaries 1.14B 2.19B 2.19B 3.36B 2.47B
Preferred Dividends - - - - -
Net Income Available to Common 1.14B 2.19B 2.19B 3.36B 2.47B
EPS (Basic) 1.66 3.31 3.48 5.58 4.30
Basic Shares Outstanding 687M 661M 627M 601M 573M
EPS (Diluted) 1.64 3.27 3.45 5.57 4.29
Diluted Shares Outstanding 696M 669M 633M 603M 574M
EBITDA 3.26B 5.59B 4.74B 5.18B 4.37B

Please calculate each ratio for the last three fiscal year-ends.

Accounts Receivable Turnover; Average Collection Period for A/R; Current Ratio; Debt to Equity Ratio; Inventory turnover; Average Inventory days outstanding; Return on Assets; Return on Equity; Return on Investment; Return on Net Operating Assets; Profit Margin; Asset Turnover

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

Value Investing

Authors: Mike Hartley

1st Edition

979-8864443309

More Books

Students also viewed these Finance questions