A B C D E F 1 On December 31, 2016, Maple Moving Company had the following balances before year end adjustments: 2 3 Cash $ 62,000 4 Accounts Receivable 51,000 5 Prepaid Rent 1,000 6 Prepaid Insurance 750 7 Supplies 67,600 8 Trucks 176,000 9 Accumulated Depreciation 17,600 10 Accounts Payable 37,500 11 Interest Payable 5,000 12 Wages Payable 10,000 13 Unearned Revenue 6,600 14 Notes Payable 100,000 15 Common Stock 66,000 16 Retained Earnings 23,400 17 Service Revenue 167,000 18 Wages Expense 61,000 19 Insurance Expense 2,750 20 Rent Expense 11,000 21 Supplies Expense 22 Depreciation Expense 23 Interest Expense 21 5 Required: 6 Use the above account balances and the following year end data to determine adjusted account balances and prepare an adjusted trial balance. 7 Note: If nothing belongs in a cell, leave it blank. You may include blank cells in calculations. 8 00 NOTE: After completing the adjusted trial balance, you must click through every remaining blank cell in order to receive a "complete" message when submitting. 9 0 One month of rent used: 1 One month of insurance used: 2 Interest owed but not yet paid: 3 Supplies on hand: 4 Truck depreciation expense 1,000 250 10,800 15,000 35,200 5 Unpaid wages earned by employees: 3,500 6 Unearned revenue that has been earned: 2,000 7 8 9 MAPLE MOVING COMPANY Adjusted Trial Balance at December 31, 2016 Account Name Debits Credits 0 -1 -2 -3 Cash 4 Accounts Receivable -5 Prepaid Rent Prepaid Insurance Supplies Trucks Accumulated Depreciation Accounts Payable Interest Payable Wages Payable Unearned Revenue Notes Payable Common Stock Retained Earnings Service Revenue Wages Expense Insurance Expense Rent Expense Supplies Expense Depreciation Expense Interest Expense Totals