Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Fiscal year is July-June. All values USD millions. 2012 2013 2014 2015 2016 5-year trend Sales/Revenue 73.75B 77.65B 86.73B 92.97B 84.7B Cost of Goods Sold

Fiscal year is July-June. All values USD millions. 2012 2013 2014 2015 2016 5-year trend
Sales/Revenue 73.75B 77.65B 86.73B 92.97B 84.7B
Cost of Goods Sold (COGS) incl. D&A 17.53B 20.25B 26.93B 33.04B 32.78B
COGS excluding D&A 14.56B 16.49B 21.72B 27.08B 26.16B
Depreciation & Amortization Expense 2.97B 3.76B 5.21B 5.96B 6.62B
Depreciation 2.29B 2.81B 4.17B 4.58B 5.58B
Amortization of Intangibles 675M 949M 1.05B 1.38B 1.05B
Gross Income 56.22B 57.41B 59.8B 59.93B 51.92B
2012 2013 2014 2015 2016 5-year trend
SG&A Expense 28.24B 30.84B 32.01B 32.37B 31.25B
Research & Development 9.81B 10.41B 11.38B 12.05B 11.99B
Other SG&A 18.43B 20.43B 20.63B 20.32B 19.26B
Other Operating Expense - - - - -
Unusual Expense 6.86B 404M 561M 10.62B 1.88B
EBIT after Unusual Expense 21.13B 26.17B 27.22B 16.95B 18.79B
Non Operating Income/Expense 719M 639M 313M 1.58B 1.3B
Non-Operating Interest Income 800M 677M 883M 766M 903M
Equity in Affiliates (Pretax) - - - - -
Interest Expense 380M 429M 597M 781M 1.24B
Gross Interest Expense 380M 429M 597M 781M 1.24B
Interest Capitalized - - - - -
Pretax Income 22.27B 27.05B 27.82B 18.51B 19.75B
Income Tax 5.29B 5.19B 5.75B 6.31B 2.95B
Income Tax - Current Domestic 2.39B 3.46B 4B 4.03B 681M
Income Tax - Current Foreign 1.95B 1.75B 2.07B 2.07B 1.94B
Income Tax - Deferred Domestic 954M (19M) (331M) 224M 332M
Income Tax - Deferred Foreign - - - - -
Income Tax Credits - - - - -
Equity in Affiliates - - - - -
Other After Tax Income (Expense) - - - - -
Consolidated Net Income 16.98B 21.86B 22.07B 12.19B 16.8B
Minority Interest Expense - - - - -
Net Income 16.98B 21.86B 22.07B 12.19B 16.8B
Extraordinaries & Discontinued Operations - - - - -
Extra Items & Gain/Loss Sale Of Assets - - - - -
Cumulative Effect - Accounting Chg - - - - -
Discontinued Operations - - - - -
Net Income After Extraordinaries 16.98B 21.86B 22.07B 12.19B 16.8B
Preferred Dividends - - - - -
Net Income Available to Common 16.98B 21.86B 22.07B 12.19B 16.8B
EPS (Basic) 2.02 2.61 2.66 1.49 2.12
Basic Shares Outstanding 8.4B 8.38B 8.3B 8.18B 7.93B
EPS (Diluted) 2.00 2.58 2.63 1.48 2.10
Diluted Shares Outstanding 8.51B 8.47B 8.4B 8.25B 8.01B
EBITDA 30.95B 30.32B 32.99B 33.52B 27.29B

2] Applying common size on income statement (please do not use consistent year -- if you use 2014, the second year should be 2016.

3] Applying comparative analysis on balance with two years

4] Create the statement of cash flow with indirect method based on the information from your calculation on balance sheet

5] provide two ratios related a company

6] Interpretation on each statement - income statement; balance sheet and statement of cashflow

7] interpretation on each ratio

8] conclusion.

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

Financial Accounting A Critical Approach

Authors: John Friedlan

3rd Edition

0070967601, 978-0070967601

More Books

Students also viewed these Accounting questions