apter 14 Problem Test Instructions Chart of Accounts Amount Descriptions Spreadsheet Instructions 34 Totals Neff uses the periodic inventory system. Year-end adjustment data are as follows: ebook (f) 743,350.00 (a, b) A physical count shows that merchandise inventory costing $51,800 is on hand as December 31, 20--. (g) (h) (0) (c, d, e) Neff estimates that customers will be granted $2,000 in refunds of this year's sale next year and the merchandise expected to be returned will have a cost of $1,200 Supplies remaining at the end of the year, $600. Unexpired insurance on December 31, $2,600. Depreciation expense on the building for 20--, $5,000. Depreciation expense on the store equipment for 20-, $3,000. Wages earned but not paid as of December 31, $1,800. () 743,3 Neff also offers boat rentals which clients pay for in advance. Unearned boat renta revenue as of December 31 is $3,000. Required: 1. Prepare a year-end spreadsheet. 2. Journalize the adjusting entries. 3. Compute cost of goods sold using the spread