Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1 2,965 Home Insert Page Layout Formulas Data Review View Cut Copy E Wrap Text Paste Format at BIERAAD = Merge & E65 x fx

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
1 2,965 Home Insert Page Layout Formulas Data Review View Cut Copy E Wrap Text Paste Format at BIERAAD = Merge & E65 x fx CEF CONSOLIDATED BALANCE SHEETS - USD ($) $ In Millions Jun 30, 2016 Jun 30, 2015 2 CURRENT ASSETS 3 Cash and Cash Equivalents, at $ 7,102 $ 6,836 4 Available-for-sale Securities 6,246 4,767 5 Accounts Receivable, Net, 4,373 4,568 6 INVENTORIES 7 Inventory, Raw Materials and 1,188 1,266 8 Inventory, Work in Process, Gross 563 525 9 Inventory, Finished Goods, Gross 3,188 10 Inventory, Net 4,716 4,979 11 Deferred Tax Assets, Net of 1,507 1,356 12 Prepaid Expense and Other 2,653 2,708 13 Disposal Group, Including 7,185 4,432 14 Assets, Current 33,782 29,646 15 Property, plant and Equipment, 19,385 19,655 16 Goodwill 44,350 44,622 17 Intangible Assets, Net (Excluding 24,527 25,010 18 Disposal Group, Including 5,204 19 Other Assets, Noncurrent 5,092 5,358 20 Total Assets 127,136 129,495 21 CURRENT LIABILITIES 22 Accounts Payable, Current 9,325 8,138 23 Accrued Liabilities, Current 7,449 8,091 24 Disposal Group, Including 2,343 1,543 25 Debt, Current 11,653 12,018 26 Liabilities, Current 30,770 29,790 27 Long-term Debt, Excluding 18,945 18,327 28 Deferred Tax Liabilities, Net, 9,179 9,113 29 Disposal Group, Including 10 325 R432 30 Other Liabilities. Noncurrent Sheet1 + 717 E65 4x fe A 00 10,325 69,153 11 717 8,432 6 6,445 m 29 Disposal Group, Including 30 Other Liabilities, Noncurrent 31 Liabilities 32 SHAREHOLDERS' EQUITY 33 Common Stock, Value, Issued 34 Additional Paid in Capital 35 Reserve for ESOP Debt 36 Accumulated Other 37 Treasury Stock, Value 38 Retained Earnings (Accumulated 39 Stockholders' Equity Attributable 40 Total Stockholders Equity 41 Total Liabilities and Equity 42 Preferred Class A 43 SHAREHOLDERS' EQUITY 44 Preferred Stock, Stated Value, 45 Preferred Class B 46 SHAREHOLDERS' EQUITY 47 Preferred Stock, Stated Value 4,0094 ,009 63,714 6 3,852 (1,290) (1,320) (15,907) (12,780) (82,176) (77,226) 87,953 8 4,807 642 57,983 63,050 127,136 129,495 Average Average 1,038 1,077 $0 $ 0 12 Months Ended Sin lun 30, 2016 Jun. 30, 2015 49 CONSOLIDATED STATEMENTS OF EARNINGS- USD ($) $ in 50 Millions 51 Net Sales 52 Cost of Goods Sold 53 Gross Profit 54 Selling, General and 55 Venezuela Deconsolidation 56 Operating Income (Loss) 57 Interest Expense 58 Investment Income, Interest Co Other in Sheet1 + $ 65,299 32,909 32,390 18,949 $ 70,749 37,056 33,693 20,616 2,028 11,049 626 149 13,441 579 182 Endinn Innm B 0 13,441 579 182 55 Venezuela Deconsolidation 56 Operating Income (Loss) 57 Interest Expense 58 Investment Income, Interest 59 Other Nonoperating Income 60 Income Loss From Continuing 61 Income Taxes on Continuing 62 Net Earnings from Continuing 63 Net Earnings/(Loss) from 64 Net Earnings 65 Net Earnings Attributable to 66 Net Income 325 13,369 3,342 10,027 577 10,604 2,028 11,049 626 149 440 11,012 2,725 8,287 (1,143) 7,144 108 $ 7,036 96 $ 10,508 68 Tax Rate 35% 2015 O Exhibit 8-1 70 Net Profit Margin 71 Average Total Assets 72 Total Asset Turnover 73 Return on Assets 74 Dupont Return on Assets 75 Operating Income Margin 76 Return on Investment 77 Return on Equity 78 Gross Profit Margin O Exhibit 8-3 O Exhibit 8-4 O Exhibit 8-5 O Exhibit 8-7 O Exhibit 8-12 O Exhibit 8-13 O Exhibit 8-16 Please include excel formula and short description

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_2

Step: 3

blur-text-image_3

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 Management Theory And Practice

Authors: Prasanna Chandra

11th Edition

9355322208, 978-9355322203

More Books

Students also viewed these Finance questions