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

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 03, 2024

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
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
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