Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

? X US $ FILE HOME Reporting adjusted account balances - Excel PAGE LAYOUT FORMULAS DATA REVIEW - Sign In INSERT VIEW B I A

image text in transcribedimage text in transcribedimage text in transcribed

? X US $ FILE HOME Reporting adjusted account balances - Excel PAGE LAYOUT FORMULAS DATA REVIEW - Sign In INSERT VIEW B I A Paste Clipboard U- Font | * Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles - Styles On December 31, 2016, Maple Moving Company had the following balances for 1 On December 31, 2016, Maple Moving Company had the following balances before year-end adjustments: 62,500 51,000 67,600 176,000 17,600 37,500 Cash Accounts Receivable Supplies 6 Trucks Accumulated Depreciation Accounts Payable nterest Payable 10 Nages Payable 11 Jnearned Revenue 12 Notes Payable 13 Common Stock 14 Retained Earnings 15 service Revenue 16 Nages Expense 17 Supplies Expense 18 Depreciation Expense 19 nterest Expense 6,600 100,000 66,000 23,400 167,000 61,000 21 Required: 22 Use the unadjusted account balances above and the following year-end data to determine adjusted account balances and prepare an adjusted trial balance. 23 Vote: If nothing belongs in a cell, leave it blank. NOTE: After completing the adjusted trial balance, you must click through every remaining blank cell in order to receive a "complete" message when submitting. 26 nterest owed but not yet paid: 27 Supplies on hand: 28 Truck depreciation expense 29 Jnpaid wages earned by employees: 30 Jnearned revenue that has been earned: 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 Accounts Receivable Supplies Trucks Accumulated Depreciation Accounts Payable nterest Payable Nages Payable Jnearned Revenue Notes Payable Common Stock Retained Earnings service Revenue Nages Expense Supplies Expense Depreciation Expense nterest Expense Totals

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

Financial Accounting

Authors: Robert F. Meigs, Jan R. Williams, Susan F Haka, Mark S. Bettner

10th Edition

0072316373, 978-0072316377

More Books

Students also viewed these Accounting questions

Question

What is a centroid?

Answered: 1 week ago

Question

solve

Answered: 1 week ago