Hide Assignment Information Instructions ++EXCEL 1 Assignment – July 2021 Wilson Company’s fiscal year-end is December 31. The unadjusted trial balance as of December 31, 2020 appears below: Account Title Debits Credits Cash 33,000 Accounts receivable 40,000 Allowance for uncollectible accounts 3,000 Supplies 1,500 Inventory 60,000 Note receivable (current) 20,000 Interest receivable -0- Prepaid rent 2,000 Prepaid insurance -0- Equipment 80,000 Accumulated depreciation – equipment 30,000 Accounts payable 28,000 Wages payable -0- Note payable (due 9/30/24) 50,000 Interest payable -0- Unearned revenue -0- Common stock 60,000 Retained earnings 24,500 Sales revenue 148,000 Interest revenue -0- Cost of goods sold 70,000 Wage expense 18,900 Rent expense 11,000 Depreciation expense -0- Interest expense -0- Supplies expense 1,100 Insurance expense 6,000 Bad debt expense 0 $343,500 $343,500 Information necessary to prepare the year-end adjusting entries appear below: The equipment is depreciated on a straight-line basis, no salvage, eight-year life. The company estimates that $5,500 of the outstanding accounts receivable probably will not be collected. Employee wages are paid twice a month and wages earned from the last two weeks in December which will be paid in January total $1,500. The $50,000 note payable was borrowed on October 1, 2020 at a 12% interest rate. Interest is to be paid annually on September 30. On March 1, 2020 the company lent a supplier $20,000 and a note was signed requiring the principal and interest at 8% to be paid on February 28, 2019. On April 1, 2020, the company paid an insurance company $6,000 for a two-year fire insurance policy. The entire $6,000 was debited to insurance expense. $800 of supplies remained on hand at 12/31/20. A customer paid Wilson $2,000 in December for a product to be manufactured and delivered in Jan 2021. Wilson recorded the entire $2,000 in Sales Revenue. On December 1, Wilson paid $2,000 rent for December & January at $1,000 per month. For the purposes of this exercise, ignore income taxes. REQUIRED: Prepare an adjusting entry page (p.3-48) with all the necessary entries (see p. 3-47, for Uptown Cabinet Corp Illus 3C-1.) Prepare a 10-column worksheet (p. 3-47 – Illus 3C-1) Prepare an Income Statement, Statement of Retained Earnings, and a classified Balance Sheet. No common stock was issued and no dividends were paid. (pp. 3-35 to 3-37; Illus 3-41, 3-42, and 3-43) SUBMIT: adjusting entry page 10-column worksheet regular view 10-column worksheet formula view Income Statement (multiple-step), Statement of Retained Earnings, and a classified Balance Sheet Formula page for financial statements (i.e., the statements in formula view).