prepare an adjusted trial balance. Please provide the formulas. Thank you!
Extracted text: Reporting adjusted account balances - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in Calibri 11 - Alignment Number Conditional Format as Cell Formatting Table Styles Paste BIU- Cells Clipboard G Fant Styles v On December 31, 2016, Maple Moving Company had the following balances A1 A E F 1 On December 31, 2016, Maple Moving Compady had the following balances before year-end adjustments: з Сash 62,500 4 Accounts Receivable 51,000 5 Supplies 6 Trucks 7 Accumulated Depreciation 8 Accounts Payable 9 Interest Payable 10 Wages Payable 11 Unearned Revenue 67,600 176,000 17,600 37,500 6,600 12 Notes Payable 13 Common Stock 14 Retained Earnings 100,000 66,000 23,400 167,000 15 Service Revenue 16 Wages Expense 17 Supplies Expense 61,000 18 Depreciation Expense 19 Interest Expense 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.
Extracted text: Calibri Paste BIU- Alignment Number Conditional Format as Cell Cells Formatting Table Styles Clipbard Font Styles A1 On December 31, 2016, Maple Moving Company had the following balances A. 26 nterest owed but not yet paid: 10,800 27 upplies on hand: 28 ruck depreciation expense 29 Jnpaid wages earned by employees: 15,000 35,200 3,500 30 Jnearned revenue that has been earned: 2,000 31 32 MAPLE MOVING COMPANY 33 Adjusted Trial Balance at December 31, 2016 34 35 Account Name Debits Credits 36 ash 37 iccounts Receivable 38 upplies 39 rucks 40 iccumulated Depreciation 41 iccounts Payable 42 nterest Payable 43 Vages Payable 44 Inearned Revenue 45 lotes Payable 46 ommon Stock 47 tetained Earnings 48 ervice Revenue 49 Vages Expense Sheet1 READY 100% Attempt(s) Hint