each cell must be entered as a formula, for example "debits cash" is "+B3" and so on for the highlighted boxes :)

Reporting adjusted account balances. 1. Determine adjusting entries and prepare an adjusted trial balance. X Reporting adjusted account balances - Excel ? FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 AA % Paste BIU- Cells Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font A A1 fox On December 31, 2016, Maple Moving Company had the following balances F A B D E 1 On December 31, 2016, Maple Moving Company had the following balances before year-end adjustments: 2 3 Cash $ 62,500 4 Accounts Receivable 167,160 5 Supplies 67,600 6 Prepaid Rent 42,240 7 Accounts Payable 37,500 8 Interest Payable 9 Wages Payable 10 Unearned Revenue 6,600 11 Notes Payable 100,000 12 Common Stock 66,000 13 Retained Earnings 23,400 14 Service Revenue 167,000 15 Wages Expense 61,000 16 Supplies Expense 17 Rent Expense 18 Interest Expense 19 20 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 Note: If nothing belongs in a cell, leave it blank. Sheet1 100% READY Attempt(s) Hint Show Me 19 20 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 Note: If nothing belongs in a cell, leave it blank. 24 NOTE: After completing the adjusted trial balance, you must click through every remaining blank cell in order to receive a "complete" message when submitting. 25 26 Interest owed but not yet paid: 10,800 27 Supplies on hand: 15,000 28 Rent expense 35,200 29 Unpaid wages earned by employees: 3,500 30 Unearned revenue that has been earned: 2,000 21 XDA Reporting adjusted account balances - Excel ? FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In E2 - Calibri - 11 AA % Paste BIU A Cells Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font A1 On December 31, 2016, Maple Moving Company had the following balances D E F G 32 33 34 Credits 15,000 B 30 Unearned revenue that has been earned: 2,000 31 MAPLE MOVING COMPANY Adjusted Trial Balance at December 31, 2016 35 Account Name Debits 36 Cash $ 62,500 37 Accounts Receivable 167,160 38 Supplies 39 Prepaid Rent 7,040 40 Accounts Payable 41 Interest Payable 42 Wages Payable 43 Unearned Revenue | 44 Notes Payable 45 Common Stock 46 Retained Earnings 47 Service Revenue 48 Wages Expense 49 Supplies Expense 50 Rent Expense 51 Interest Expense 52 Totals 53 54 55 Sheet1 0 + 70% READY Attempt(s) Hint Show Me