Case #1 (50 marks) Preparation of worksheet. Required: A. Prepare a 10-column worksheet for the year ended 30 June 2020. 1. On June 10, the company paid $ 4,600 to renew a 12-month lease contract. 2. On June 12, the company paid $5,200 to renew a 12-month insurance policy. 3. Depreciation of the company's office equipment's is based on an estimated life of 5 years. The equipment was purchased 2 years ago for $15,250. 4. On June 1st, had office supplies on hand of $ 10,000. During March they purchased additional supplies costing $ 5,000. On 30th June $4,500 of supplies were only remaining. 5. Received advance revenue from client for providing service which is due after 2 months for $3,500. Unadjusted Trial Balance Adjustments Adjusted Trial Balance Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 12,600.00 Accounts Receivable 11,800.00 Prepaid Insurance 1,800.00 Retained Earnings 1,000.00 Equipment 32,300.00 Accumulated Depreciation- Equipment 8,800.00 Accounts Payable 16,400.00 Owner, Capital 121,800.00 Owner, Drawings Insurance expenses 86,500.00 3,000.00 Total 148,000.00 148,000.00