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. 2 3 4 Cash 62,000 5 Accounts Receivable 51,000 6 Prepaid Rent 1,000 7 Prepaid Insurance 750 8 Supplies 67,600 9 Trucks 176,000 10 Accumulated Depreciation 17,600 11 Accounts Payable 37,500 12 Interest Payable 5,000 13 Wages Payable 10,000 14 Unearned Revenue 6,600 15 Notes Payable 100,000 16 Common Stock 66,000 17 Retained Earnings 23,400 18 Service Revenue 167,000 19 Wages Expense 61,000 20 Insurance Expense 2,750 21 Rent Expense 11,000 37 A B C D E LL F G 22 Supplies Expense 23 Depreciation Expense 24 Interest Expense 25 26 Required: Use the above account balances and the following year end data to determine adjusted account 27 balances and prepare an adjusted trial balance. 28 29 One month of rent used: 30 One month of insurance used: 31 Interest owed but not yet paid: 32 Supplies on hand: 33 Truck depreciation expense 34 Upaid wages earned by employees: 35 Unearned revenue that has been earned: 36 37 Here are some tips for using Excel: 38 39 Cell Reference: Basic Math Functions: 1,000 250 10,800 15,000 35,200 3,500 2,000 Allows you to refer to data from another cell in the worksheet. If you entered "=85" into a blank cell, the formula would output the value from cell B5. Allow you to use the basic math symbols to perform mathematical functions. You can use the following keys: +(plus sign to add), - (minus sign to subtract), (asterisk sign to multiply), and/ (forward slash to divide). For example, if you entered "=84+85" in a blank cell, the formula would add the values from those cells and output the result. 41 Note: Use cells A4 to B35 from the given information to complete this question. If nothing belongs in a cell, leave it blank. 42 43 441 45 46 Account Name 47 Cash 48 Accounts Receivable MAPLE MOVING COMPANY Adjusted Trial Balance at December 31 Debits Credits 49 Prepaid Rent 50 Prepaid Insurance 51 Supplies 52 Trucks 53 Accumulated Depreciation 54 Accounts Payable 55 Interest Payable: 56 Wages Payable 57 Unearned Revenue 58 Notes Payable 59 Common Stock 60 Retained Earnings 61 Service Revenue 62 Wages Expense 63 Insurance Expense 64 Rent Expense 65 Supplies Expense 66 Depreciation Expense 67 Interest Expense 68 Totals 69