Fiscal year is July-June. All values USD millions. 2012 2013 2014 ...

60.1K

Verified Solution

Question

Accounting

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.

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students