Answered step by step
Verified Expert Solution
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
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