Industries adjusted trial balance as of 12/31/2017 is presented in the accompanying Excel document, along with the 12/31/2016 closing trial balance. NOTE: all balances are presented in their natural account balances so you have to determine which are debits/credits.

The following information is available for 2017.

1. Equipment (cost $20,000 and accumulated depreciation $8,000) was sold for $10,000. All other changes in Property, Plant and Equipment accounts relate to purchases and depreciation expense, respectively.
2. No Intangible Assets were purchased or disposed of during 2017.
3. There was $20,000 in payments on the Bonds Payable during 2017; the remaining change in account related to new bonds issued.
4. There were no sales of Equity Investments during the year.

Prepare the 2017 financial statements using Excel, which includes:

1. Income Statement (multi-step)
2. Statement of Stockholders Equity (NOT just Retained Earnings. )

(All balances presented in their natural account balances) 12/31/2016 Closing Trial Balance 47,000 60,000 103,000 30,000 11,000 162,000 2,000 Accounts Payable Accounts Receivable Accrued Liabilities Accumulated Depreciation - Buildings Accumulated Depreciation - Equipment Additional Paid in Capital Allowance for Doubtful Accounts Amortization Expense Bonds Payable Buildings Cash Common Stock, $1 Par Cost of Goods Sold Depreciation Expense Dividends Equipment Equity Investments 12/31/2017 Adjusted Trial Balance 53,000 78,000 110,000 34,000 12,000 171,000 3,000 2,000 150,000 147,000 114,000 19,000 390,000 13,000 30,000 70,000 16,000 100,000 120,000 82,000 18,000 90,000 90,000 90,000 30,000 Equipment Equity Investments Gain from disposal of Discontinued Operation, net of tax Gains and Dividends Received on Equity Investment Income Taxes Interest Expense Interest Income Inventory Land Loss from Discontinued Operation, net of tax Loss on Sale or Property, Plant & Equipment Patents Prepaid Rent Rent Expense Retained Earnings Salaries Expense Sales Revenue Treasury Stock 70,000 16,000 39,000 3,000 14,000 5,000 9,000 104,000 30,000 10,000 2,000 38,000 3,000 72,000 44,000 248,000 760,000 21,000 40,000 5,000 44,000 (All balances presented in their natural account balances) 12/31/2016 Closing Trial Balance 47,000 60,000 103,000 30,000 11,000 162,000 2,000 Accounts Payable Accounts Receivable Accrued Liabilities Accumulated Depreciation - Buildings Accumulated Depreciation - Equipment Additional Paid in Capital Allowance for Doubtful Accounts Amortization Expense Bonds Payable Buildings Cash Common Stock, $1 Par Cost of Goods Sold Depreciation Expense Dividends Equipment Equity Investments 12/31/2017 Adjusted Trial Balance 53,000 78,000 110,000 34,000 12,000 171,000 3,000 2,000 150,000 147,000 114,000 19,000 390,000 13,000 30,000 70,000 16,000 100,000 120,000 82,000 18,000 90,000 90,000 90,000 30,000 Equipment Equity Investments Gain from disposal of Discontinued Operation, net of tax Gains and Dividends Received on Equity Investment Income Taxes Interest Expense Interest Income Inventory Land Loss from Discontinued Operation, net of tax Loss on Sale or Property, Plant & Equipment Patents Prepaid Rent Rent Expense Retained Earnings Salaries Expense Sales Revenue Treasury Stock 70,000 16,000 39,000 3,000 14,000 5,000 9,000 104,000 30,000 10,000 2,000 38,000 3,000 72,000 44,000 248,000 760,000 21,000 40,000 5,000 44,000