solve the question in Excel

Questions: E4-16 The following items were taken from the financial statements of M. Wright Company (All dollars are in thousands.) Long-term debt $1,000 Accumulated depreciation 5,655 Prepaid insurance 880 Accounts payable 1.444 Equipment 11,500 Notes payable (due after 2013) 400 Long-term investments 264 Owner's capital 12.955 Short-term investments 3.690 Accounts receivable 1,696 Notes payable (due in 2013) 500 Inventory 1,256 Cash $ 2,668 Instructions Prepare a classified balance sheet in good form as of December 31, 2012. Question(2) Complete the worksheet and determined weather Net (Income - Loss) Account Income Statement Dr ($) GAS Unadjusted Trial Balance Dris) Ols 41,350 3.000 18,800 25,000 Cash Accounts Receivable Prepaid Rent Inventory Renovation and improveme Accumulated depreciation Accounts payable Accrued expenses Uhearned income Long-term labilities Common stock Dividends Revenues Cost of goods sold Depreciation expense Office rent expense Supplies expense Utilities expense Wages expense Interest expense 19.000 Bob's Donut Shoppe, Inc Accounting Worksheet for the month enng 31st January 2020 Adjusting Entries Adjusted Trial Balance Dr ( Crisi Drisi GS 9.000 750 49,600 3.000 750 750 18.800 25,000 500 500 19.000 700 700 9.000 9.000 24.500 50,000 500 3.600 1200 500 500 750 3.000 200 700 500 3.000 500 Balance sheet Dris) CHASI 49,500 3,000 750 18,800 25,000 500 19.000 700 9,000 24,500 50,000 500 24500 50.000 500 3.600 3,600 1.200 750 3,000 1200 500 750 3000 700 3,000 500 500 2.500 500 Totals 97.100 197100) 10,950 9,650 13,600) 97,650 103,700) (10.950) 107300 107,300) Net Totals 2