Question: Using each account listed below (an Excel spreadsheet with the data is available on Blackboard), re-create the company's balance sheet and income statement in

Using each account listed below (an Excel spreadsheet with the data isavailable on Blackboard), re-create the company's balance sheet and income statement in

Using each account listed below (an Excel spreadsheet with the data is available on Blackboard), re-create the company's balance sheet and income statement in a reasonably correct manner. In addition, create a three-year vertical common-sized balance sheet for all items listed on the balance sheet and a three-year vertical common-sized income statement for all items listed on the income statement. Round the percentages to one decimal place (e.g., 11.6%). Please submit your work via the assignment submission feature in Blackboard. + (millions) 2021 2020 2019 Accounts payable 5,747 5,581 4,354 Accounts receivable, net 9,632 7,352 7,735 Accumulated other comprehensive income (loss) (880) (752) (622) Cash & equivalents $4,827 $5,865 $4,194 Common stock and additional paid-in capital 28,694 26,196 25,880 Current operating lease liabilities 680 550 448 Current portion of long-term debt $2,964 $790 $2,238 Deferred revenue Deferred taxes Earnings before tax Gain/(loss) on sale of assets Goodwill 1,391 1,017 673 2,667 3,843 2,044 21,635 25,014 24,027 349 2,017 2,369 26,963 26,971 26,276 Gross profit 43,815 43,612 42,140 Inventories 10,776 8,426 8,744 Less: Accumulated depreciation 85,294 77,646 73,321 Less: Cost of goods sold 35,209 34,255 $29,825 Less: Depreciation & amortization expenses 11,792 12,239 10,826 Less: Impairment of goodwill 488 577 Less: Income tax expense 3,335 4,179 720 3,010 Less: Interest expense 597 629 489 Less: Selling, general, & administrative expenses 9,941 7,497 8,886 Less: Treasury stock 2,876 2,590 1,754 Long-term debt 33,510 33,896 25,308 Long-term operating lease liabilities 5,704 2,778 1,032 Marketable securities 23,586 18,030 8,328 Net income Operating profit (EBIT) Other accrued expenses/payables Other current assets $18,300 $20,835 $21,017 22,082 23,876 22,428 11,324 10,504 9,805 8,897 7,575 2,238 Other current liabilities 1,876 3,074 2,708 Other income (expense) 289 327 439 Other intangible assets 1,336 5,698 10,827 Other long-term liabilities 4,360 7,422 8,326

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 Accounting Questions!