Please use Excel to complete the following use case: Please see attached Excel File: 1) Prepare a 12

Please use Excel to complete the following use case:

Please see attached Excel File:

1) Prepare a 12-column work sheet for the year ended 2010 December 31. You need not include account numbers or explanations of adjustments.

2) Prepare an income statement.

3) Prepare a statement of retained earnings.

4) Prepare a classified balance sheet.

5) Prepare adjusting and closing entries. The following trial balance and additional data are for Roswell Interior Decorators, Inc.: ROSWELL INTERIOR DECORATORS, INC Trial Balance 2019 December 31 Debits Credits Cash   85,100 0 Accounts Receivable 81,000 0 Supplies on Hand 4,600 0 Prepaid Rent 12,240 0 Prepaid Advertising 2,880 0 Prepaid Insurance 4,400 0 Office Equipment 5,400 0 Accumulated Depreciation—Office Equipment 0 2,760 Office Furniture 29,200 0 Accumulated Depreciation—Office Furniture 0 8,280 Accounts Payable 0 25,200 Notes Payable (due 2020) 0 4,000 Capital Stock 0 100,000 Retained Earnings, 2019 January 1 0 22,400 Dividends 45,520 0 Service Revenue 0 250,000 Salaries Expense 98,800 0 Utilities Expense 20,000 0 Miscellaneous Expense 23,500 0 412,640 412640 Financial Data Supplies on hand at 2019 December 31, are 1,000. Rent expense for 2019 is 10,000. Advertising expense for 2019 is 2,304. Insurance expense for 2019 is 2,400. Depreciation expense is office equipment, 912, and office furniture, 3,000. Accrued interest on notes payable is 150. Accrued salaries are 4,200 Questions 1) Prepare a 12-column work sheet for the year ended 2010 December 31. You need not include account numbers or explanations of adjustments. 2) Prepare an income statement. 3) Prepare a statement of retained earnings. 4) Prepare a classified balance sheet. 5) Prepare adjusting and closing entries.