In the books of Maple Moving Company | |||
Adjusting Journal entries | |||
Date | Particluars | Debit | Credit |
Interest expense | 10,800.00 | ||
Interest payable | 10,800.00 | ||
(Being interest expense payable accrued) | |||
Supplies expense | 52,600.00 | ||
Supplies | 52,600.00 | ||
(Being supplies used expensed) | |||
Depreciation expense | 35,200.00 | ||
Acummulated depreciation | 35,200.00 | ||
(Being depreciation on truck accounted) | |||
Wages expense | 3,500.00 | ||
Wages payable | 3,500.00 | ||
(Being wages payable accrued) | |||
Unearned Revenue | 2,000.00 | ||
Service revenue | 2,000.00 | ||
(Being unearned revenue earned) |
Adjusted Trial Balance | ||
at December 31, 2016 | ||
Account Name | Debit | Credit |
Cash | 62,500.00 | |
Accounts Recivable | 51,000.00 | |
Supplies | 15,000.00 | |
Trucks | 176,000.00 | |
Accumulated deprectiaon | 52,800.00 | |
Accounts payable | 37,500.00 | |
Interest payable | 10,800.00 | |
Wages Payable | 3,500.00 | |
Unearned revenue | 4,600.00 | |
Notes payable | 100,000.00 | |
Common stock | 66,000.00 | |
Retained earnings | 23,400.00 | |
Service revenue | 169,000.00 | |
Wages expense | 64,500.00 | |
Supplies expense | 52,600.00 | |
Dpereciation expense | 35,200.00 | |
Interest expense | 10,800.00 | |
Total | 467,600.00 | 467,600.00 |
Please highlight answer/answers 1. Determine adjusting entries and prepare an adjusted trial balance. Reporting adjusted account...
please hell me with this
- 51,000 67,600 176,000 17,600 37,500 A 4 Accounts Receivable 5 Supplies 6 Trucks 7 Accumulated Depreciation 8 Accounts Payable 9 Interest Payable 10 Wages Payable 11 Unearned Revenue 12 Notes Payable 13 Common Stock 14 Retained Earnings 15 Service Revenue 16 Wages Expense 17 Supplies Expense 18 Depreciation Expense 19 Interest 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 23...
Reporting Adjusted Account Balances using Excel's SUM, Basic
Math Functions and Cell Referencing
Maple Moving Company has provided a list of its account balances
as of December 31, 2016 before year-end adjustments. The Controller
has also provided you with a list of year end data to determine the
adjusted account balances and has asked you to prepare the adjusted
trial balance. Use the information included in the Excel Simulation
and the Excel functions described below to complete the task.
Cell...
2. Determine the balances of the accounts affected by the adjusting entries, and prepare OBJ. 2,3,4 Rowland Company is a small editorial services company owned and operated by Marlene Rowland. On August 31, 2016, the end of the current year, Rowland Company's account PR 3-5A Adjusting entries and adjusted trial balances it 0 ing clerk prepared the following unadjusted trial balance: Rowland Company Unadjusted Trial Balance August 31, 2016 Debit Balances Credit Balances 7,500 38,400 7,200 1,980 112,500 150,250 87,550...
I need to enter everything in formula form. Thanks!
Maple Moving Company has provided you their unadjusted account balances to before year-end adjustments. The Controller has asked you to prepare the Adjusted Trial Balance and has provided you with further year end information. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation...
33) Using the adjusted trial balance below. write the four closing entries necessary to prepare the accounts for the beginning of the next accounting period. DODSON CONTAINERS Adjusted Trial Balance December 31 $ 3,050 400 830 80 4,200 $ 1,100 98,000 28,000 115,000 Cash. Accounts receivable.................. Prepaid insurance ................ Office supplies................... Office equipment... Accumulated depreciation office equipment Buildings... wwwww Accumulated depreciation-buildings..... Land ........ Wages Payable........... Property taxes payable........ Interest payable... Unearned rent......... Long-term notes payable... Common stock Retained earnings ........
33) Using the adjusted trial balance below write the four closing entries necessary to prepare accounts for the beginning of the next accounting period. DODSON CONTAINERS Adjusted Trial Balance December 31 $ 3,050 400 830 80 4,200 $ 1,100 98,000 28,000 115,000 880 1,400 2,200 Cash.... Accounts receivable.......... Prepaid insurance Office supplies ........... Office equipment Accumulated depreciation office equipment ... Buildings.. Accumulated depreciation—buildings.......... Land Wages Payable.............. Property taxes payable... Interest payable............. Unearned rent........... Long-term notes payable........... Common stock ........... •...
142 Chapter 3 The Adjusting Process PR 3-5A Adjusting entries and adjusted trial balances OBJ. 2, 3, 4 ✓ 2. Total of Debit Rowland Company is a small editorial services company owned and operated by Marlene column: $776,180 Rowland. On August 31, 2016, the end of the current year, Rowland Company's account- ing clerk prepared the following unadjusted trial balance: Rowland Company Unadjusted Trial Balance General Ledger August 31, 2016 Debit Credit Balances Balances Cash 7,500 Accounts Receivable. 38,400 Prepaid...
Prepare the Statement of Retained Earnings from the Adjusted
Trial Balance and Income Statement. Within each section of the
statement, use the drop-down menus to enter the accounts in Chart
of Accounts order and select the account balances.
Prepare the Statement of Retained Earnings from the Adjusted Trial Balance and Income Statement. Within each section of the statement, use the drop-down menus to enter the accounts in Chart of Accounts order and select the account balances. SMART TOUCH LEARNING SMART...
list of accounts
Sandhill Company had the following adjusted trial balance. $3,840 Sandhill Company Adjusted Trial Balance For the Month Ended June 30, 2020 Adjusted Trial Balance Account Titles Debit Credit Cash Accounts Receivable 4,070 Supplies 400 Accounts Payable $1,700 Unearned Service Revenue 190 Owner's Capital 3,900 Owner's Drawings Service Revenue 5,920 Salaries and Wages Expense 1,300 Miscellaneous Expense 200 Supplies Expense 1,930 Salaries and Wages Payable 540 $12,250 $12,250 510 Prepare closing entries at June 30, 2020. (Credit account...
Required: 1. Prepare the adjusting entries on the Trial
Balance tab, and complete the worksheet on the Trial Balance
tab
2. On the Financial Statements tab, prepare the income
Statement, Retained Earnings Statement, and Balance Sheet for the
2020 year
3. On the Tab complete T-Accounts for all accounts. The
ending balances in every should agree to the balances on the
Balance Sheet as of December 31, 2020
Prepaid Insurance 1,000 89,020 Accounts Receivable 103,100 103 100 Equipment 100,000 Allowance...