Using Excel, complete the entire 10-column work sheet for Nelson Company.

Prepare to adjust journal entries to reflect each of the following:

A B C NELSON COMPANY Unadjusted Trial Balance January 31, 2015 Debit Credit 2 Cash $ 1,000 3 Merchandise inventory 12,500 4 Store supplies 5,800 5 Prepaid insurance 2,400 Store equipment 42,900 7 Accumulated depreciation-Store equipment $ 15,250 8 Accounts payable 10,000 9 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 0 16 Salaries expense 35,000 17 Insurance expense 0 18 Rent expense 15,000 19 Store supplies expense 0 20 Advertising expense 9,800 21 Totals $169,200 $169,200 22