Question: Using each and every line item of data found below (an Excel spreadsheet with the data is found on Blackboard), re-create the companys balance sheet

Using each and every line item of data found below (an Excel spreadsheet with the data is found on Blackboard), 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%).

2018

2017

Accounts payable

528

584

Accounts receivable

1,225

453

Accrued expenses

759

555

Accumulated other comprehensive income

(8)

6

Cash

$315

$108

Common stock and additional paid-in capital

8,855

8,472

Current portion of long-term debt

136

70

Deferred income taxes

4

16

Deferred revenue

11

85

Earnings before taxes

376

(22)

Equity method investments

58

60

Gain (loss) on sale of fixed assets

15

0

Goodwill

299

289

Gross fixed assets

1,055

1,001

Gross profit

2,447

1,787

Income/(loss) from equity method investments

(2)

(7)

Inventories

745

845

Less: Accumulated depreciation

707

739

Less: Amortization expense

91

67

Less: Cash operating expenses

1,783

1,516

Less: Cost of goods sold

4,028

3,466

Less: Depreciation expense

94

77

Less: Interest expense

121

126

Less: Treasury stock

125

108

Long-term debt

1,294

1,324

Marketable securities

841

1,077

Net fixed assets

348

262

Net income

$315

($40)

Operating income (EBIT)

479

127

Other current assets

404

151

Other current liabilities

490

178

Other intangible assets

192

200

Other long-term investments

34

36

Other noncurrent assets

95

71

Other noncurrent liabilities

88

102

Other nonoperating income (expense)

5

(16)

Retained earnings

(7,536)

(7,774)

Sales

$6,475

$5,253

Short-term debt

45

35

Tax expense

61

18

Taxes payable

15

7

Total assets

$4,556

$3,552

Total current assets

3,530

2,634

Total current liabilities

1,984

1,514

Total equity

1,186

596

Total liabilities

3,370

2,956

Total liabilities and equity

$4,556

$3,552

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!