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. Please provide formulas for Trial Balance

1 2 On December 31, Maple Moving Company had the following balances before year-end a 3 4 Cash $62,500 5 Accounts Receivable 51,000 6 Supplies 67,600 7 Trucks 176,000 8 Accumulated Depreciation 17,600 9 Accounts Payable 37,500 10 Interest Payable 0 11 Salaries Payable 0 12 Unearned Revenue 6,600 13 Notes Payable 100,000 14 Common Stock 94,400 15 Dividends 5,000 16 Service Revenue 167,000 17 Salaries Expense 61,000 18 Supplies Expense 0 19 Depreciation Expense 0 20 Interest Expense 0 21 22 Required: 23 Use the unadjusted account balances above and the following year-end data to 24 determine adjusted account balances and prepare an adjusted trial balance. Note: If nothing belongs in a cell, leave it blank. 25 26 27 Interest owed but not yet paid: 10,800 28 Supplies on hand: 15,000 29 Truck depreciation expense 35,200 30 Unpaid wages earned by employees: 3,500 31 Unearned revenue that has been earned: 2,000 32 33 (Use cells A4 to B31 from the given information to complete this question.) 34 35 MAPLE MOVING COMPANY 36 Adjusted Trial Balance at December 31 Account Name Credits 37 38 39 Cash 40 Accounts Receivable 41 Supplies 42 Trucks 43 Accumulated Depreciation 44 Accounts Payable 45 Interest Payable 46 Salaries Payable 47 Unearned Revenue 48 Notes Payable 49 Common Stock 50 Dividends 51 Service Revenue 52 Salaries Expense 53 Supplies Expense 54 Depreciation Expense 55 Interest Expense 56 Totals 57 Debits $62,500 51,000 15,000 176,000 $304,500 $52,800 37,500 10,800 3,500 4,600 100,000 94,400 $303,600