Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

looking for some help, I'm missing something Maple Moving Company has provided you their unadjusted account balances to before year-end adjustments. The Controller has asked

looking for some help, I'm missing something

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.

image text in transcribedimage text in transcribed
On December 31, Maple Moving Company had the following balances before year-end 4 Cash $62,500 5 Accounts Receivable 51,000 6 Supplies 67,600 7 Trucks 176,000 8 Accumulated Depreciation 17,600 g 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 19 Depreciation Expense 20 Interest Expense O 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. 25 Note: If nothing belongs in a cell, leave it blank. 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,000MAPLE MOVING COMPANY Adjusted Trial Balance at December 31 Account Name Debits Credits Cash =B4 Accounts Receivable =B5 Supplies =B28 Trucks =B7 Accumulated Depreciation =B8+B29 Accounts Payable =B9 Interest Payable =B27 Salaries Payable =B30 Unearned Revenue =B12-831 Notes Payable =B13 Common Stock =B14 Dividends Service Revenue Salaries Expense Supplies Expense Depreciation Expense Interest Expense Totals =SUM(B39:855) =SUM(C39:C55) =IF(AND(SUM(B55:C55)>0,ISBLANK(B56)), "Formula in cell 856 must include all cells in tl =IF(AND(SUM(B55:C55)>O,ISBLANK(C56)), "Formula in cell C56 must include all cells in th

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial accounting

Authors: ramji balakrishnan, k. s i varamakrishnan, Geoffrey b. sprin

1st edition

471467855, 978-0471467854

More Books

Students also viewed these Accounting questions