1. Computers R US took out a 9 month, 4.25, $17,000 note onAugust 1, 2019 with interest and principal to be paid onmaturity.

2. On October 1, 2019, Computers R US rented some storage spaceat a rate of $450 per month. On that date, Computers R US recordedRent Expense for six months rent paid in advance.

3. Computers R US purchased $4,780 of office supplies during theyear and the asset office supplies account was increased A count ofthe supplies on hand Dec 31, 2019, indicates a balance of $485.

4. $16,500 of store supplies were purchased during the year andwere immediately expensed. A count of the store supplies on handDecember 31, 2019, indicates a balance of $1.275.

5. On June 1, 2019 an 18-month insurance policy was purchasedfor $9,000.

6. On Dec 1, 2019, Computers R US collected $32,000 forconsulting services to be performed from Dec. 1, 2019 to Feb. 28,2020. The company credited the revenue account when paid.

7. On October 1, 2019, Computers R Us issued a 5-month notereceivable to Morerams Inc. at an annual interest rate of 5%.Principle and interest will be paid at the end of the 5-months. Thenote was recorded in Notes Receivable and is the only noteoutstanding.

8. The company rented idle office space to Bytes and Bits onJune 1, 2019, at a rate of $1500 per month. On this date ComputersR Us credited Unearned Rent Revenue for one year of rent receivedin advance.

9. Computers R Us is open seven days a week and has a dailypayroll of $5,430. Employees are paid every Friday, December 31 isa Monday. 40% of the payroll is for office employees, 60% ofpayroll is for sales employees.

10.  Depreciation for store equipment is based on thefollowing: • Straight Line Depreciation • Store equipment – Assetswere held for the entire year; Residual Value = $8,200; Servicelife is estimated to be 6 years.

11. Depreciation for office equipment is based on the following:• Double-Declining Method • Office equipment – Assets werepurchased July 1; Residual Value = $4,000; Service life isestimated to be 4 years.

12. At 12/31/2019, based on the aging method, Computers R USdetermines that uncollectible accounts are $13,850.

13. Utilities expense of $3,700 remained unpaid. 40% of theutilities expense is for office and 60% of utilities expense is forthe store.

Based on the following information,

a. Prepare a worksheet (Show formulas and use an "IF"statement)

b. Prepare the adjusting journal entries

c. Prepare a multiple step income statement

d. Prepare a statement of retained earnings

e. Prepare a balance sheet

f. Prepare the closing entries