can you please help to me,

The following information relates to the Avenal Social Club (the club is not registered for GST). The club operates using the accrual accounting system. Instructions: For the year ended 30th June 2020, you are required to PR Task 1 Calculate Subscriptions income PR Task 2 Prepare a Trading Statement which discloses surplus deficit on refreshments PR Task 3 prepare an Income and Expenditure Strument PR Task 4 Prepare a Statement of Assets and Liabilities (Balance Sheet) Your teacher will provide you with an Excel spreadsheet templates fle to complete the required tasks, selle name below ENSACC414 Assessment 3 templates You must provide evidence of all calculations for each task ACCOUNT BALANCES AT 1ST JULY 2019 Furniture & equipment $36.000 Accumulated depreciation - Furniture & equipment 10,800 Cash at bank 14,300 Refreshment inventory 3,050 Refreshment wages owing 850 Subscriptions received in advance 3.450 Subscriptions in arrears 2.600 Receipts & Payments From 1 July 2019 to 30 June 2020 CASH RECEIPTS $ $ Subscriptions received $2,000 Interest received 1,500 Joining foes 4,000 Refreshment Sales 82,500 140.000 CASH PAYMENTS Refreshment Purchases 47.500 Rent 26.250 General expenses 14,400 Telephone 520 Prices and awards 1,500 Refreshment wages 18.500 108,670 ADDITIONAL INFORMATION At balance date 30th June 2020 the following account balances were identified: Subscriptions in advance 2,300 Subscriptions in arrears 3,900 Refreshments Inventory 2,560 Refreshment wages owing 530 Rent paid in advance 1,000 Furniture & Equipment is to be depreciated at 15% pa. using the straight line method