Problem 5-4A The trial balance of Marvin's Fine Gems at December 31, 2017, and is shown below Excel Spreadsheet Template Preparing a merchandser's worksheet under the perpetual inventory system MARVIN'S FINE GEMS Unadjusted Trial Balance Net income, $235,600 December 31, 2017 Cash 6,200 Accounts receivable 57,000 354,800 Inventory Prepaid rent 28,000 Equipment 108,000 S 43200 Accumulated amortization-equipment Accounts payable 43,200 Salary payable Interest payable Note payable, long-term J. Marvin, capital 87,000 270,000 J. Marvin, withdrawals 153,000 Sales revenue 835,400 Cost of goods sold 328,000 Salary expense Rent expense Advertising expense 118,600 44,000 21,600 Utilities expense 30,800 Amortization expense-equipment Insurance expense 13,200 Interest expense 2600 Miscellaneous expense 13,000 Total $1.278,800 $1,278,800 304 Part 1 The Basic Structure of Accounting Additional data at December 31, 2017 a. Rent expense for the year, $48,000 b. The equipment has an estimated useful life of 10 years and is expected to have no value when it is retired from service c. Accrued salaries at December 31, $7,000. d. Accrued interest expense at December 31, $2,600. Inventory based on the inventory count on December 31, $351,200. e. Required Complete Marvin's Fine Gems worksheet for the year ended December 31, 2017. Marvin's Fine Gems uses the perpetual inventory system