PLEASE HELP ME USING THIS EXCEL SHEET TEMPLATE

Bolances Shect A. Income Statement Easten Lad, which has just started trading on 1 January 2021, has the following account balances prior to the recording of the final month of the year. Account Balances as at 30 November 2021 Acoount CashAccountsreceivableStockofSuppliesProperty,Plant&Equipment(cost)AccountspayableBankLoanContributedcapital(26200shares)SalesrevenueOpentingexpenses(excludingdepreciation)OtheroperatingincomeCostofgoodssold$3700$6300$8000$50000$13800$25000$26200$85000$43000$9000$48000 In December 2021, the following transactions took place: 1. Credit purehases of goods $34,000. 2. Recelved payment from debtors $5,000. 3. Credit sales $58,000 (cost of goods sold $30,000 ). 4. Paid wages of 53,000 . 5. As the end of December, sold off an equipment that has costed 25,000 at the price of $22,000. The yearly depreciation expense of this equipment was $,000. 6. Paid rent of $1,200. 7. Paid annual interest expense. 8. Bank loan repayment of $3,000. Addinional Information as below: 1. Opernting expenses sbove include rent and wages but exclude depreciation. The interest nite of the bank loan of $25,000 is 10% per annum. The bank lan was acepired on 1 January 2021. Monthly rental expense is $800. 2. Annual depreciation expenes for the propenty, plant \& equipment before the disposal of the equipment at transaction 4 was $12,000. Required: 1. Record the Account balances prior to adjustments in the workboak. Then, ealculate and record the Adjustments in the workbook, lotal and balance the work book. Indlicate the transaction and additional information number aceordingly in the workbook. [3 marts] 2. Prepare a properly formatted Balance Shest as at 31 December 2021 and Income Statement for the year ended 31 December 2021. [2 marks]