- ++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) Interest payable 50,000 -0- Unearned revenue -0- Common stock 60,000 Retained earnings Sales revenue 24,500 148,000 Interest revenue -0- Cost of goods sold 70,000 Wage expense 18,900 Rent expense 11,000 Depreciation expense -0- Interest expense Supplies expense 1,100 Insurance expense 6,000 Bad debt expense 0 $343 500 -0- eran Information necessary to prepare the year-end adjusting entries appear below: 1. The equipment is depreciated on a straight-line basis, no salvage, eight-year life. 2. The company estimates that $5,500 of the outstanding accounts receivable probably will not be collected. 3. 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. 4. 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. 5. 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, 2021. 6. 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. 7. $800 of supplies remained on hand at 12/31/20. 8. 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. 9. On December 1, Wilson paid $2,000 rent for December & January at $1,000 per month. 10. For the purposes of this exercise, ignore income taxes. REQUIRED: A. Prepare an adjusting entry page (p.3-48) with all the necessary entries (see p. 3-47, for Uptown Cabinet Corp Illus 3C-1.) B. Prepare a 10-column worksheet (p. 3-47 - Illus 3C-1) C. 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: A. adjusting entry page B. 10-column worksheet regular view C. 10-column worksheet formula view D. Income Statement (multiple-step), Statement of Retained Earnings, and a classified Balance Sheet E. Formula page for financial statements (ie, the statements in formula view)