The following information is available for 2017.

1. 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
2. Prepare the 2017 financial statements using Excel, which includes:
   1. Income Statement (multi-step)
   2. Statement of Stockholders Equity (NOT just Retained Earnings)
   3. Balance Sheet (classified; also show both the 2017 and 2016 numbers)
   4. Statement of Cash Flow

(All balances presented in their natural account balances) 12/31/16 Closing Trial Balance 47,000 60,000 103,000 30,000 11,000 162,000 2,000 100,000 120,000 82,000 18,000 12/31/17 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 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 16,000 21,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 (due in 3 years) Buildings Cash Common Stock, $1 Par Cost of Goods Sold Depreciation Expense Dividends Equipment 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 Short-Term Equity Investments Treasury Stock 90,000 90,000 30,000 40,000 5,000 44,000