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
Get step-by-step solutions from verified subject matter experts
