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. 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