Please type in an excel formula format

Clipboard Font Styles fOn December 31,2016, Maple Moving Company had the following balanc A1 1On December 31,2016, Maple Moving Company had the following balances before year-end adjustments 3 Cash 4 Accounts Receivable 5 Supplies 6 Equipment 7 Accumulated Depreciation 62,500 51,000 67,600 176,000 17,600 37,500 unts Payable 9 Interest Payable 0 Salaries Payable 11 Deferred Revenue 12 Notes Payable 13 Common Stock 14 Retained Earnings 15 Service Revenue 16 Salaries Expense 7 Supplies Expense 18 Depreciation Expense 19 Interest Expense 20 21 Required: 22 Use the unadjusted account balances above and the following year-end data to 23 determine adjusted account balances and prepare an adjusted trial balance 24 Note: If nothing belongs in a cell, leave it blank 25 26 Interest owed but not yet paid 27 Supplies on hand 28 Equipment depreciation expense 29 Unpaid salaries owed to employees 30 Deferred revenue that has been earned 31 6,600 100,000 66,000 23,400 167,000 61,000 10,800 15,000 35,200 3,500 2,000 27 Supplies on hand: 28 Equipment depreciation expense 29 Unpaid salaries owed to employees 30 Deferred revenue that has been earned 31 32 15,000 35,200 3,500 2,000 MAPLE MOVING COMPANY Adjusted Trial Balance at December 31, 2016 34. 35 36 Cash 37 Accounts Receivable 38 Supplies 39 Equipment 40 Accumulated Depreciatiorn 41 Accounts Payable 42 Interest Payable 43 Salaries Payable 44 Deferred Revenue 45 Notes Payable 46 Common Stoclk 47 Retained Earnings 48 Service Revenue 49 Salaries Expense 50 Supplies Expense 51 Depreciation Expense 52 Interest Expense 53 Totals 54 Account Name Debits Credits 56