Use the information downloaded to create ONE Excel Workbook with 4 tabs: a. Tab 1:Income Statement for most recent three years. b. Tab 2:Balance Sheet for most recent three years. c. Tab 3:Statement of Cash Flows for most recent three years. d. Tab 4:Ratio Analysis 4. Financial Analysis: a. Using Excel formulas, calculate the Dollar Change between each year (all tabs). b. Using Excel formulas, calculate the Percent Change between each year (all tabs). c. Using Excel formulas, calculate the Common Size Percents: i. Use Total Assets as the base amount for the Balance Sheet. ii. Use Sales as the base amount for the Income Statement. iii. No Common Size Percents must be calculated for the Statement of Cash Flows. d. Using Excel formulas, calculate the following ratios for EACH of the three years presented: i. Current ratio ii. Acid-test ratio iii. Accounts receivable turnover (for two most recent years only, not required for third year) iv. Inventory turnover(for two most recent years only, not required for third year) v. Days' sales uncollected vi. Total asset turnover(for two most recent years only, not required for third year) vii. Debt-to-equity ratio viii. Profit Margin ix. Return on total assets (for two most recent years only, not required for third year) x. Earnings per share (may be obtained from 10-K)

CONSOLIDATED BALANCE SHEETS - USD ($) $ in Millions

Dec. 31, 2019

Current Assets:

Cash and cash equivalents

$ 5,238

Marketable securities

503

Accounts receivable, net

9,552

Current income taxes receivable

382

Other current assets

1,428

Total Current Assets

17,103

Property, Plant and Equipment, Net

30,482

Operating Lease, Right-of-Use Asset

2,856

Goodwill

3,813

Intangible Assets, Net

2,167

Investments and Restricted Cash

24

Deferred Income Tax Assets

330

Other Non-Current Assets

1,082

Total Assets

57,857

Current Liabilities:

Current maturities of long-term debt and commercial paper

3,420

Operating Lease, Liability, Current

538

Accounts payable

5,555

Accrued wages and withholdings

2,552

Hedge margin liabilities

495

Self-insurance reserves

914

Accrued group welfare and retirement plan contributions

793

Other current liabilities

1,641

Total Current Liabilities

15,413

Long-Term Debt and Finance Leases

21,818

Operating Lease, Liability, Noncurrent

2,391

Pension and Postretirement Benefit Obligations

10,601

Deferred Income Tax Liabilities

1,632

Self-Insurance Reserves

1,282

Other Non-Current Liabilities

1,437

Shareowners' Equity:

Additional paid-in capital

150

Retained earnings

9,105

Accumulated other comprehensive loss

(5,997)

Deferred compensation obligations

26

Less: Treasury stock (0.4 shares in 2019 and 0.6 shares in 2018)

(26)

Total Equity for Controlling Interests

3,267

Noncontrolling Interests

16

Total Shareowners' Equity

3,283

Total Liabilities and Shareowners' Equity

57,857

Class A Common Stock:

Shareowners' Equity:

Common stock

2

Class B Common Stock:

Shareowners' Equity:

Common stock

$ 7

Dec. 31, 2018

Dec. 31, 2017

$ 4,225

$ 3,320

810

749

8,958

8,773

940

1,573

1,277

1,303

16,210

15,718

26,576

22,118

3,872

3,811

1,964

2,075

483

170

266

141

1,153

1,033

45,574

50,016

4,011

2,805

3,934

2,608

5,188

17

3,047

705

325

677

810

951

715

12,886

1,522

20,278

14,087

7,061

19,931

756

1,765

8,347

1,804

1,619

1,571

0

1,424

5,852

(4,867)

0

37

8,006

(37)

(4,994)

994

32

30

(32)

1,024

3,021

45,574

16

3,037

50,016

2

Rate 5 more documents to earn a free unlock.

Helpful Unhelpful