Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please answer in excel format! Thank you! The unadjusted trial balance as of December 31, 2016, the end of the annual accounting period for Super
Please answer in excel format! Thank you!
The unadjusted trial balance as of December 31, 2016, the end of the annual accounting period for Super Employment Services, follows: SUPER EMPLOYMENT SERVICES Unadjusted Trial Balance December 31, 2016 Balance Account Title Debit Credit Cash $ 6,000 Accounts Receivable 5,000 Office Supplies 1,000 Furniture 10,000 Accumulated Depreciation --Furniture $ 4,000 Building 40,000 Accumulated Depreciation Building 30,000 Land 10,000 Accounts Payable 2,000 Salaries Payable Unearned Revenue 8,000 Common Stock 12,000 Dividends 25,000 Service Revenue 60,000 Salaries Expense 16,000 Supplies Expense Depreciation Expense-Furniture Depreciation Expense-Building Advertising Expense 3,000 Total $ 116,000 $ 116,000 Data needed for the adjusting entries include the following: a. Office Supplies on hand at year-end, $200. b. Depreciation on furniture, $2,000. c. Depreciation on building, $1,000. d. Salaries owed but not yet paid, $500. e. Accrued service revenue, $1,300. f. $3,000 of the unearned revenue has been carned. Requirements 1. Open the ledger accounts in T-account form with their unadjusted balances as shown on the unadjusted trial balance. 2. Journalize Super's adjusting entries at December 31, 2016. Use the letter (a, b, and so on) as the date. 3. Post the adjusting entries to T-accounts. Determine the ending balances in the T-accounts on December 31, 2016. 4. Prepare an adjusted trial balance. 5. Prepare a partial worksheet including the account names, unadjusted trial balance, ad- justments, and adjusted trial balanceStep 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