How do I solve the attached?

ACCT205 - Accounting Principles II Week 4 Homework Assignment Deadline Due by the end of Week 4 at 11:59pm, ET. Directions Using the information provided, create a Word or Excel document with your responses to each question, then upload the document into Blackboard. The following unadjusted trial balance is prepared at fiscal year-end for Nelson Company. B C NELSON COMPANY Unadjusted Trial Balance January 31, 2016 Debit Credit 2 Cash $ 1,000 3 Merchandise inventory 12,500 4 Store supplies 5,800 5 Prepaid insurance 2.400 6 Store equipment 42.900 7 Accumulated depreciation-Store equipment $ 15,250 8 Accounts payable 10,000 J. Nelson, Capital 32,000 10 J. Nelson, Withdrawals 2.200 11 Sales 111,950 12 Sales discounts 2,000 13 Sales returns and allowances 2,200 14 Cost of goods sold 38,400 15 Depreciation expense-Store equipment 16 Salaries expense 35,000 17 Insurance expense 18 Rent expense 15,000 19 Store supplies expense 20 Advertising expense 9,800 21 Totals $169,200 $169,200 22 Using Excel, prepare and complete the entire 10-column work sheet for Nelson Company. Prepare adjusting journal entries to reflect each of the following: a. Store supplies still available at fiscal year-end amount to $1,750. b. Expired insurance, an administrative expense, for the fiscal year is $1,400.Step 2. Enter C. Depreciation expense on store equipment, a selling expense, is $1,525 for the fiscal year. d. D. To estimate shrinkage, a physical count of ending merchandise inventory is taken. It shows $10,900 of inventory is still available at fiscal year-end