Answered step by step
Verified Expert Solution
Question
1 Approved Answer
XIA ? Reporting adjusted account balances - Excel PAGE FORMULAS DATA REVIEW VIEW HOME INSERT FILE X Sign In % Paste Clipboard Calibri 11 AA
XIA ? Reporting adjusted account balances - Excel PAGE FORMULAS DATA REVIEW VIEW HOME INSERT FILE X Sign In % Paste Clipboard Calibri 11 AA M BIU - 2. . A AlignmenumbeonditioFormat Cell Cells Editing Formattir as Styles Font Styles D34 A B D E F G 1 On December 31, Year 2, Maple Moving Company had the following balances before year-end adjustments: s 62.500 167.160 67,600 42.240 37,500 3 Cash 4 Accounts Receivable 5 Supplies 6 Prepaid Rent 7 Accounts Payable 8 Interest Payable 9 Wages Payable 10 Unearned Revenue 11 Notes Pay 12 Common Stock 13 Retained Earnings 14 Service Revenue 15 Wages Expense 16 Supplies Expense 17 Rent Expense 18 Interest Expense 19 20 Required: 6,600 100.000 66.000 23,400 167,000 61,000 21 account balances and prepare an adjusted trial balance. 22 Note: If nothing belongs in a cell leave it blank. cell in order to receive a "complete" message when submitting. 25 Interest owed but not yet paid: 26 Supplies on hand: 27 Rent expense 28 Unpaid wages earned by employees: 29 Unearned revenue that has been earned: 30 Sheet1 10.800 15.000 35,200 3.500 2.000 # C F READY Attempt(s) Hint + 10% Show Me XI H5 ? Reporting adjusted account balances - Excel PAGE FORMULAS DATA REVIEW VIEW HOME INSERT FILE X Sign In Paste Calibri 11 AA % BIU - O. A Alignmentimbeconditio.Format Cell Cells Editing Formattir as Styles Font Styles Clipboard D34 *** D E F G 15,000 33 Credits B 22 Note: If nothing belongs in a cell, leave it blank. 23 cell in order to receive a "complete" message when submitting. 24 25 Interest owed but not yet paid: 10,800 26 Supplies on hand: 27 Rent expense 35.200 28 Unpaid wages earned by employees: 3.500 29 Unearned revenue that has been earned: 2.000 30 31 MAPLE MOVING COMPANY 32 Adjusted Trial Balance at December 31. Year 2 34 Account Name Debits 35 Cash 36 Accounts Receivable 37 Supplies 38 Prepaid Rent 39 Accounts Payable 40 Interest Payable 41 Wages Payable 42 Uncarned Revenue 43 Notes Payable 44 Common Stock 45 Retained Earnings 46 Service Revenue 47 Wages Expense 48 Supplies Expense 49 Rent Expense 50 Interest Expense 51 Totals 52 Sheet1 T READY Attempt(s) Hint + 10% Show Me
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started