Below is the unadjusted trial balance for Walton Anvils as of December 31, 2016, and the data for the adjustments. There is also an Excel Template for this problem that you may download and use (or you may use your own). Walton Anvils Unadjusted Trial Balance December 31, 2016 Balance Account Title Debt Credit Cash Accounts Receivable Prepaid Rent $ 16,900.0 17,500 2,50 ce Supplies quipment Accumulated Depreciation - Equipment 23 $ 7,000.00 Accounts Payable alaries Payable Unearned Revenue 5,600.0 Common Stock Retained Earnings Dividends 4,50 20,800 Service Revenue alaries Expense Expense preciation Expense Equipment upplies Expense S 69,200.00 69,200 Adjustment Data ber 31, a. Unearned revenue still unearned at December 31, 2016 $1,800 b. Prepaid rent still in force at December 31, 2016 c. Office supplies used d. Depreciation e. Accrued Salaries Expense at December 31, 2016 Requirements $2,300 $%1,400 $380 $210 1. Open T-accounts using the balances in the unadjusted trial balance 2. Complete the worksheet for the year ended December 31, 2016. 3. Prepare the adjusting entries and post to the T-accounts. 4. Prepare the adjusted trial balance. 5. Prepare the income statement, the statement of retained earnings, and the classified balance sheet in report form. 6. Prepare the closing entries and post to the T-accounts. 7. Prepare a post-closing trial balance. 8. Calculate the current ratio for the company. You may save and use the following EXCEL TEMPLATE or create your own. Upload your Excel workbook using the following naming protocol: LastnameFirstnameAssessment