Create a properly classified December 31. 2016, Balance sheet

Corrections to Balance Sheet You may use the attached spread sheet to help you complete this activity, but you are not required to do so. You wil find the Minett Boatbuilders Company prepared the following balance sheet spreadsheet by dicking on the green Excel icon in the upper left Minet: Boatbuliders Company Balance Sheet for Year Ended December 31, 2016 Working capital22,800 Noncurrent sebities $62,000 152,000 Shareholders equity 112,800 $174,800 Total 174,800 Total Your analysis of these accounts reveals the following information: . Working capital consists of Land Accounts due from customers Accounts due to supplers Inventories, including office supplies of $3,500 Income taxes owed Wages owed Note owed to bank (due December 31, 2018) Securities held as a short-term investment 12,000 18,000 (22,700) 5,500 (16,400) (3,600) 17,000) 17,000 1 22,800 Other aswets include PreviousNext Spreadsheet Calculator 2. Other assets include: Cash Prepaid insurance Buildings and equipment Discount on bonds payable Investment in available-for-sale stock Treasury stock (at cost) $12,300 2,400 100,000 3,000 29,000 5,300 $152,000 3. Noncurrent liabilities consist of: $33,000 1,400 2,600 25,000 62,000 Bonds payable (due 2023) Allowance for doubtful accounts Additional paid-in capital on preferred stock Common stock, $5 par 4. Shareholders' equity includes: Accumulated depreciation: Buildings and equipment Preferred stock, $100 par Additional paid-in capital on common stock Retained earnings Accrued pension cost Unrealized decrease in value of available-for-sale securities 40,000 12,000 15,600 40,000 6,500 (1,300) $112,800 WK 4 Spreadsheet Calculator Required: Based on your analysis, prepare a properly classified December 31, 2016, balance sheet for Minett Boatbuilders. Minett Boatbuilders Company Balance Sheet December 31, 2016 Assets Current Assets Prepaid items: Total current assets Long-Term Investments Property, Plant, and Equipment Check My Work HWK 4 Spreadsheet Calculator Total property, plant, and equipment Total Assets Liabilities Current Liabilities Total current liabilities Long-Term Liabilities Total long-term liabilities Total Liabilities Shareholders' Equity Contributed Capital HWK 4 Spreadsheet Calculator Long-Term Liabilities Total long-term liabilities Total Liabilities Accounting numeric field Shareholders' Equity Contributed Capital Total contributed capital Accumulated Other Comprehensive Loss Total Shareholders' Equity Total Liabilities and Shareholders' Equity