Recessive Interiors Unadjusted Trial Balance January 31, 2012 Account No. Debit Balances Credit Balances Cash 11 13,100 13 8,000 14 7,500 Supplies Prepaid Insurance Equipment Accumulated Depreciation- Equipment 16 113,000 17 12,000 Trucks 18 90,000 19 27,100 21 4,500 31 30,000 32 96,400 Accumulated Depreciation-Trucks Accounts Payable Common Stock Retained Earnings Dividends Service Revenue Wages Expense Rent Expense 33 3,000 41 155,000 51 72,000 52 7,600 53 5,350 Truck Expense 59 5.450 Miscellaneous Expense 1 325,000 325,000 925, The following additional accounts from Recessive Interiors' chart of accounts should be used: Wages Payable, 22 Depreciation Expense-Equipment, 54; Supplies Expense 55; Depreciation Expense Trucks, 56; Insurance Expense, 57 The data needed to determine year-end adjustments are as follows: a. Supplies on hand at January 31 are $2,850 b. Insurance premiums expired during the year are $3,150. t. Depreciation of equipment during the year is $5,250, d. Depreciation of trucs during the year is $4,000. e. Wages accrued but not paid at January 31 are $900. Use the attached spreadsheet to complete parts 2, 3, and 6: Click on the Spreadsheet icon above to open and save the Excel file to your computer. Your input into the spreadsheet will not be included in your grade in CengageNow on this problem. Required: 1. For each account listed in the unadjusted trial balance, notice that the balance has been entered in the appropriate general ledger account balance column in the spreadsheet. Posting to the general ledger will take place in step 3 and step 6. 2. (Optional) in the attached spreadsheet, enter the adjusting entries and complete the worksheet 3. Journalize the adjusting entries on page 26 of the journal. Then post to the appropriate accounts in the general ledger in the attached Spreadsheet inserting balance in the accounts affected. If an amount box does not require an entry, leave it blank Miscellaneous expense 5,450 Total expenses 106,550 Net income 48,450 Prepare a statement of stockholders equity. During the year ended January 31, 2012, additional common stock of $7,500 was issued Wat is incurred or dividends were paid, enter that amount as a negative number using a mission Recessive Interiors Statement of Stockholders' Equity For the Year Ended January 31, 2012 Common Stock Retained Earnings Total Prepare a balance sheet. Journal PAGE 27 Credit Date Account Post. Rot. Debit Jan. 31 HI Jan. 31 7. Prepare a post: closing trial balance. List the accounts in order by type: Assets, Liabilities, Capital, Dividends, Revence and Expenses amount box does not require an entry, leave it blank Recessive Interiors st-Closing Trial Balance