Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started