Pls answer question 1 A (10 column worksheet) - please clearly label headings and use the template provided.

The unadjusted trial balance of Trendy Consulting Pty Ltd is as follows: The following additional information should be taken into account: 1. Salaries accrued but unrecorded on 30 June 2020 were $2,690 2. An electricity bill has been received but not yet recorded of $990 (GST included) 3. Insurance unexpired at 30 June 2020 was $450. 4. Office equipment is to be depreciated using straight line depeciation. The useful life is 4 years and it has a residual value of $18,560. 5. Office supplies unused at 30 June amounted to $1,540 6. On 30 June, the Directors declared a Dividend to be paid to shareholders in July, 2020 totalling $5000. 7. Interest to be accrued on the bank loan at 30 June is $210. Required: A. Prepare a 10-column worksheet for the year ended 30 June 2020. (19 marks) B. Prepare a statement of changes in equity. (5 marks) C. Journalise the closing entries. (6 marks) The unadjusted trial balance of Trendy Consulting Pty Ltd is as follows: The following additional information should be taken into account: 1. Salaries accrued but unrecorded on 30 June 2020 were $2,690 2. An electricity bill has been received but not yet recorded of $990 (GST included) 3. Insurance unexpired at 30 June 2020 was $450. 4. Office equipment is to be depreciated using straight line depeciation. The useful life is 4 years and it has a residual value of $18,560. 5. Office supplies unused at 30 June amounted to $1,540 6. On 30 June, the Directors declared a Dividend to be paid to shareholders in July, 2020 totalling $5000. 7. Interest to be accrued on the bank loan at 30 June is $210. Required: A. Prepare a 10-column worksheet for the year ended 30 June 2020. (19 marks) B. Prepare a statement of changes in equity. (5 marks) C. Journalise the closing entries. (6 marks)