I need the solution in the format of the excel sheet that I have posted below. Please solve this asap as this is due soon and I need to understand how to do this.

PR 3-5A Adjusting Entries and Adjusted Trial Balances Obj.2, 3, 4, 5, 6 Sears Editing Company is a small editorial services company owned and operated by Deloris Sears. On January 31, 20Y1, the end of the current year, Sears Editing Company's accounting clerk prepared the following unadjusted trial balance: Sears Editing Company Unadjusted Trial Balance January 31, 20Y1 Debit Balances Credit Balances 7,500 38,400 7,200 1,980 112,500 150,250 87,550 135,300 Cash ..... Accounts Receivable.............. Prepaid Insurance....................... Supplies ................ . Land Building ......... Accumulated Depreciation-Building........... Equipment.......... Accumulated Depreciation-Equipment .... Accounts Payable ................... Unearned Rent........................................ Common Stock Retained Earnings ......... Dividends ....... Fees Earned............ Salaries and Wages Expense............. Utilities Expense ...................... Advertising Expense................ Repairs Expense. Miscellaneous Expense..... 97,950 12,150 6,750 75,000 146,000 15,000 324,600 193,370 42,375 22,800 17,250 6,075 750,000 750,000 The data needed to determine year-end adjustments are as follows: Unexpired insurance at January 31, $2,400. Supplies on hand at January 31, $250. Depreciation of building for the year, $6,600. Depreciation of equipment for the year, $3,500. Rent unearned at January 31, $2,750. Accrued salaries and wages at January 31, $1,800. Fees earned but unbilled on January 31, $15,000. Instructions 1. Journalize the adjusting entries using the following additional accounts: Salaries and Wages Payable; Rent Revenue; Insurance Expense; Depreciation Expense-Building; Depreciation Expense-Equipment; and Supplies Expense. 2. Determine the balances of the accounts affected by the adjusting entries, and prepare an adjusted trial balance. Answer Check Figure: Total of Debit column: $776,900 2011 Account Debit Credit 31 31 Credit Balances Sears Editing Company Adjusted Trial Balance January 31, 20Y1 Debit Balances Cash Accounts Receivable Prepaid Insurance Supplies Land Building Accumulated Depreciation - Building Equipment Accumulated Depreciation - Equipment Accounts Payable Uneamed Rent Salaries and Wages Payable Common Stock Retained Eamings Dividends Fees Eamed Rent Revenue Salaries and Wages Expense Utilities Expense Advertising Expense Repairs Expense Depreciation Expense - Building Depreciation Expense - Equipment Insurance Expense Supplies Expense Miscellaneous Expense