ONLY NEED 4-6! Thanks in advance! Will rate positively if helpful :)

EXCEL TEMPLATE Recessive Interiors Unadjusted Trial Balance January 31, 2012 Account Debit Credit No. Balances Balances Cash. 11 13,100 Supplies 13 8,000 Prepaid Insurance.. 14 7,500 Equipment 16 113,000 Accumulated Depreciation-Equipment 17 12,000 Trucks... 18 90,000 Accumulated Depreciation-Trucks 19 27,100 Accounts Payable 21 4,500 Common Stock 31 30,000 Retained Earnings 32 96,400 Dividends.. 33 3,000 Service Revenue. 155,000 Wages Expense.. 51 72,000 Rent Expense... 52 7,600 Truck Expense. 53 5,350 Miscellaneous Expense.. 59 SASO 325,000 325,000 The data needed to determine year-end adjustments are as follows: (a) Supplies on hand at January 31 are $2,850. (b) Insurance premiums explred during the year are $3,150. (0) Depreciation of equipment during the year is $5,250. (d) Depreciation of trucks during the year is $4,000. (e) Wages accrued but not pald at January 31 are $900. Instructions 1. For each account listed in the unadjusted trial balance, enter the balance in the appropriate 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 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 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. 4. Prepare an adjusted trial balance. 5. Prepare an income statement, a statement of stockholders' equity, and a balance sheet. During the year ended January 31, 2042, additional common stock of $7,500 was issued: 6. Journalize and post the closing entries. Record the closing entries on Page 27 of the journal. Indicate closed accounts by inserting a line in both Balance columns opposite the closing entry. 7. Prepare a post-closing trial balance