please include your work and show formulas

Maple Moving Company has provided you their unadjusted account balances to before year-end adjustments. The Controller has asked you to prepare the Adjusted Trial Balance and has provided you with further year end information. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. On December 31,2016, Maple Moving Company had the following balances before year-end adjustments 62,500 51,000 67,600 176,000 17,600 37,500 Cash Accounts Receivable Supplies Trucks Accumulated Depreciation Accounts Payable Interest Payable 0 Wages Payable 1 Unearned Revenue 2 Notes Pavable 3 Common Stock 4 Retained Earnings 5 Service Revenue 6 Wages Expense 7 Supplies Expense 8 Depreciation Expense 9Interest Expense 6,600 100,000 66,000 23,400 167,000 61,000 1 Required: Use the unadjusted account balances above and the following year-end data to 3 determine adjusted account balances and propare an adjusted trial balance. Use the unadjusted account balances above and the following year-end data to determine adjusted account balances and prapare an adjusted trial balance. Note: If nothing belongs in a cell, leave it blank Interest owed but not yet paid: Supplies on hand: Truck depreciation expense Unpaid wages earned by employees: Unearned revenue that has been earned: 10,800 15,000 35,200 3,500 2,000 MAPLE MOVING COMPANY Adjusted Trial Balance at December 31,2016 Account Name Debits Credits 62,500 51,000 Cash Accounts Receivable Supplies Trucks Accumulated Depreciation Accounts Payable Interest Pavable Wages Payable Unearned Revenue Notes Pavable Common Stock Retained Earnings Service Revenue Wages Expense Supplies Expense Depreciation Expense Interest Expense Totals 176,000 37,500 100,000 66,000 23,400