The unadjusted trial balance of Oak and Brass Interiors at December 31, 2012, the end of the
Question:
The unadjusted trial balance of Oak and Brass Interiors at December 31, 2012, the end of the current year, is shown below.
The data needed to determine year-end adjustments are as follows:a. Supplies on hand at December 31 are $1,750.b. Insurance premiums expired during the year are $2,000.c. Depreciation of equipment during the year is $5,000.d. Depreciation of trucks during the year is $2,200.e. Wages accrued but not paid at December 31 are $1,000.
Instructions1. For each account listed in the unadjusted trial balance, enter the balance in the ap-propriate Balance column of a four-column account and place a check mark (??) in the Posting Reference column.2. Optional: Enter the unadjusted trial balance on an end-of-period spreadsheet (worksheet) and complete the spreadsheet. Add the accounts listed in part (3) as needed.3. Journalize and post the adjusting entries, inserting balances in the accounts affected. Record the adjusting entries on Page 26 of the journal. The following additional ac-counts from Oak and Brass Interiors?? chart of accounts should be used: Wages Pay-able, 22; Depreciation Expense??Equipment, 54; Supplies Expense, 55; Depreciation Expense??Trucks, 56; Insurance Expense, 57.4. Prepare an adjusted trial balance.5. Prepare an income statement, a retained earnings statement, and a balance sheet.
6. Journalize and post the closing entries. Record the closing entries on Page 27 of the journal. (Income Summary is account #34 in the chart of accounts.) Indicate closed accounts by inserting a line in both Balance columns opposite the closing entry.7. Prepare a post-closing trial balance.
Step by Step Answer:
Financial and Managerial Accounting Using Excel for Success
ISBN: 978-1111993979
1st edition
Authors: James Reeve, Carl S. Warren, Jonathan Duchac