Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions

Question

need help please and thank you

Answered: 1 week ago