hello can you please solve it by making a proper format

thank you.

Question (40 marks). Rowe lne, has been in operations for approximately 5 years. It is a private company, so the company prepares financial stanenents ence a year. The company has bo plans in the ncar fature to go pablic. See the excel file for the trial balance. 1. The company has a two year insurance policy that was taken out on May 1=, 2022. 2. On August Ist Rowe lac. converted a customer that owed $50 from an accounts receivable to a notes receivable. Rowe lec, borrows funds at 4% and the customer bocrows fands at 5% 3. The company wrote off a cusiomer for $10. The company estimates that 4% of the ending aceounts receivable balance will not be collected. 4. The building was purchased 5 years ago. It has an estimated usefal life of 20 years and a residual value of $20. 5. During the year the company purchased $2 in supplies. This has already been recotded. At the end of the year it was determined that there are $4 in supplies. 6. The company stopped business and physically coanted inventory. Their inventory count at the end of the year was $202. 7. On October 1 " Rowe Ine, collected money in advance from Zinc Inc, to provide consulting services over the next 8 months. The work will be done evenly over the contract. 8. Employees are paid every Mooday for the previous work week. They work Monday to Friday. There are 3 employees and they each make $10 per week. This year December 31 is on Saturday. Complete your assignament is the excel spreadshect provided. i. Prepare any necessary journal eatries and adjusting entries for December 31 ", 2022. Show your calculations. ( 18 marks) ii. Figare out what openimg retained earnings is assuming there are no errors in the trial balance. Put your adjustments in the adjustment columns and then prepare an adjusted trial balance ( 6 marks) iii. If the company decided to dispose of their Montreal division and this meet the criteria for a discontinued operation. The revenue for the division was $110 and expenses for the division were $124. The equipment lad a cost of $20 and accunvalated depreciation of 55 . The company estimates that they can sell the equipment for $11 less $2 in auction costs. Prepare the discontinued operations section of the income statenent. Assume the tax rate is 25% (4 marks) iv. Assime that the company sold 10 gift cards to customers for $20 each in December. The customers pay eash in December. The customers use the 6 gifts eards in January and the 4 gift cards in February. Explain when revenue should be recognized. Be sure to use GAAP to support your answer. (8 marks) v. Peer evaluation (4 marks)