Excel

1 on December 31, 2016, Maple Moving Company had the following balances before 3 Cash 4 Accounts Receivable 5 Prepaid Rent 6 Prepaid Insurance 7 Supplies 8 Trucks 9 Accumulated Depreciation 10 Accounts Payable 11 Interest Payable 12 Wages Payable 13 Unearned Revenue 14 Notes Payable 15 Common Stock 16 Retained Earnings 17 Service Revenue 18 Wages Expense 19 Insurance Expense 20 Rent Expense 21 Supplies Expense 22 Depreciation Expense 23 Interest Expense 24 . ... Sheet1 READY Attempt(s) 62,000 51,000 1,000 750 67,600 176,000 17,600 37,500 5,000 10,000 6,600 100,000 66,000 23,400 167,000 61,000 2,750 11,000 25 Required: 26 Use the above account balances and the following year end data to determ balances and prepare an adjusted trial balance. 27 Note: If nothing belongs in a cell, leave it blank. You may include blank cells ir 28 NOTE: After completing the adjusted trial balance, you must click through e order to receive a "complete" message when submitting. 30 One month of rent used: 31 One month of insurance used: 32 Interest owed but not yet paid: 33 Supplies on hand: 34 Truck depreciation expense 35 Unpaid wages earned by employees: 36 Unearned revenue that has been earned: 1,000 250 10,800 15,000 35,200 3,500 2,000 Cred MAPLE MOVING COMPANY Adjusted Trial Balance at December 31, 2016 Account Name Debits 43 Cash $ 62,000 44 Accounts Receivable 51,000 45 Prepaid Rent 16 Dennis ... Sheet1 ... + F1 6 Credits 52,800 37,500 MAPLE MOVING COMPANY Adjusted Trial Balance at December 31, 2016 Account Name PS Debits #3 Cash R $ 62,000 44 Accounts Receivable 51,000 45 Prepaid Rent #6 Prepaid Insurance 27 Supplies 15,000 48 Trucks 176,000 -9 Accumulated Depreciation 10 Accounts Payable 1 Interest Payable 12 Wages Payable 13 Unearned Revenue 4 Notes Payable 5 Common Stock 6 Retained Earnings 7 Service Revenue 8 Wages Expense 9 Insurance Expense Rent Expense 1 Supplies Expense ... Sheet1 4,600 100,000 66,000 23,400 169,000 15,000 176,000 52,800 37,500 5 Prepaid Rent 6 Prepaid Insurance 7 Supplies 8 Trucks 9 Accumulated Depreciation 0 Accounts Payable 1 Interest Payable 2 Wages Payable 3 Unearned Revenue 4 Notes Payable 5 Common Stock 6 Retained Earnings 7 Service Revenue B Wages Expense Insurance Expense 0 Rent Expense 1 Supplies Expense 2 Depreciation Expense 3 Interest Expense 4 Totals 4,600 100,000 66,000 23,400 169,000 chin