Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using each line item of data found below (an Excel spreadsheet with the data is available), re-create the companys balance sheet and income statement in

Using each line item of data found below (an Excel spreadsheet with the data is available), re-create the companys balance sheet and income statement in a reasonably correct manner. In addition, create a two-year vertical common-sized balance sheet and a two-year vertical common-sized income statement for all items listed on the balance sheet and income statement. Round the percentages to one decimal place (e.g., 11.6%).

(millions)

2020

2019

Sales

$256,776

$194,579

Total assets

$222,449

$196,456

Total liabilities and equity

$222,449

$196,456

Total liabilities

159,279

137,913

Less: Cost of goods sold

158,719

156,447

Gross profit

98,057

38,132

Other noncurrent assets

82,499

83,724

Less: Selling, general, & administrative expenses

81,699

25,244

Long-term debt

64,699

71,444

Total equity

63,170

58,543

Other long-term investments

56,744

56,140

Total current liabilities

53,303

44,009

Total current assets

50,302

45,243

Retained earnings

46,283

41,136

Common stock and additional paid-in capital

45,816

45,317

Property, plant, & equipment, gross

28,934

26,869

Less: Treasury stock

28,929

27,910

Accounts payable

23,093

20,316

Right-of-use leased assets

20,860

Accounts receivable, net

19,617

17,631

Long-term operating lease liabilities

18,926

Less: Accumulated depreciation

16,890

15,520

Inventories

15,516

16,450

Other long-term liabilities

14,057

14,783

Other accrued expenses

12,133

10,711

Property, plant, & equipment, net

12,044

11,349

Operating profit (EBIT)

11,987

10,170

Earnings before tax

9,485

13,625

Deferred taxes

8,294

7,677

Deferred revenue

7,870

6,586

Net income

7,119

11,623

Net income to parent company

$7,119

$11,623

Other current assets

7,113

4,581

Cash & equivalents

$5,683

$4,059

Less: Depreciation & amortization expenses

4,371

2,718

Current portion of long-term debt

$4,364

$1,985

Less: Interest expense

3,035

2,619

Marketable securities

2,373

2,522

Less: Income tax expense

2,366

2,002

Other current liabilities

2,079

2,472

Current operating lease liabilities

1,934

Taxes payable

1,830

1,939

Other income (expense)

454

6,074

Gain/(loss) on sale of assets

79

0

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

The Palgrave Handbook Of Technological Finance

Authors: Raghavendra Rau, Robert Wardrop, Luigi Zingales

1st Edition

3030651169, 978-3030651169

More Books

Students also viewed these Finance questions

Question

Briefly describe the two basic sources of return to investors.

Answered: 1 week ago

Question

cat. NaOEt

Answered: 1 week ago