70.2K

Verified Solution

Link Copied!

please include excel functions

Jon December 31, 2016, Maple Moving Comparly had the following balances before year end adjustments: 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 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 determine adjusted account balances and prepare an adjusted trial balance. 27 Note: If nothing belongs in a cell, leave it blank. You may include blank cells in calculations. 28 NOTE: After completing the adjusted trial balance, you must click through every remaining blank cell in 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 Credits MAPLE MOVING COMPANY Adjusted Trial Balance at December 31, 2016 Account Name Debits Cash 44 Accounts Receivable 45 Prepaid Rent 16 Dessidur 44 Accounts Receivable 45 Prepaid Rent 46 Prepaid Insurance 47 Supplies 48 Trucks 49 Accumulated Depreciation 50 Accounts Payable 51 Interest Payable 52 Wages Payable 53 Unearned Revenue 54 Notes Payable 55 Common Stock 56 Retained Earnings 57 Service Revenue 58 Wages Expense 59 Insurance Expense 60 Rent Expense 61 Supplies Expense 62 Depreciation Expense 63 Interest Expense Totals

Answer & Explanation Solved by verified expert

See Answer