need journal entery with its format. as well as statement of earning, statement of financial position, statement of retained earning. please do this for a happy feedback. MAKER SURE TO MAKE ALL THESE WITH THE FORMATS

please look at page 2 to see what needs to be done. i need it on excel thank you.

Olivia Lewis, a professional skier, started All Sports Factory on January 1, 2022. All Sports Factory (ASF) is a retail store, in Calgary, AB, that sells ski and snow sports gear such as skis, snowboards, boots, and helmets, as well as skiing lessons offer by Olivia herself. After what Olivia feels was a successful first year, she is eager to see how the company has performed. The company's fiscal year-end is December 31. She has asked you to create a set of financial statements, excluding the statement of cash flows, as she feels she has a good understanding of her cash spending as compared to her budget. Olivia will use these statements for her own use to assist with planning for the future of the company. Exhibit 1 includes an unadjusted trial balance at December 31, 2022. Exhibit 2 includes information on 2022 transactions which require analysis and recording using Accounting Standards for Private Enterprises (ASPE). Exhibit 1 1. ASF uses a perpetual Inventory system. Below is a breakdown of inventory on hand at December 31, 2022: 2. The company ran out of a popular helmet. They placed an order for 8 of these helmets on account at a cost of $100 each on December 28. 2022. Terms of this order were 2/10,n/30 FOB shipping point: Ollvla recelved an email notifying her of shipment on December 31 , 2022. Olivia looked forward to replenishing this popular Item and adding it to inventory upon receipt. 3. A count of supplies was done on December 31:2022, where $1,550 worth of supplies was found on hand. 4. An insurance policy was purchased in March 2022 for the next 12 months starting April 1 , 2022 , and the purchase was properly recorded. 6. Olivia offers skiing lessons. Lessons are sold individually or in packages. An individual lesson sells for $100. Packages of 5 lessons sell for $450 and packages of 10 for $850. Cash received from the sales is deposited in the company's bank account at the end of each month. Bank reconcillations are prepared on an annual basis. There were 10 lesson packages sold in December 2022, but the lessons will not take place until January 2023 due to the Christmas holidays. These were all 5-lesson packages and the customers paid in full and look forward to learning from Olivia. These lessons have been recognized as service revenue in December 2022, given it was the period in which cash was collected. 7. A customer bought a 10-lesson package in November 2022, and the lessons occurred in both November and December. The customer promised to pay for the package on December 15 , however they have yet to pay this amount owing and all methods of contacting them have been exhausted and the amount has been deemed uncollectlble. This has Olivia worried that 10% of all her accounts receivable at the end of the year will not be collected. 8. The monthly salaries for employees are $8,000 (ignore payroll taxes), and salaries are paid on the 15m of each month for their work done in the previous month. Olivia has recorded salaries expense each month from January to November 2022. 9. ASF is subject to income tax and the tax rate is 30%. 10. Olivia hired a payroll clerk, who is a very hard worker and did not take vacation in 2022. Employees do not typically report payroll errors, so Olivia does not need to moniton the payroll clerk closely. Requlred: 1. Prepare the journal entries for 2022, including any required year-end adjusting entries. Provide an explanation of why each entry is required and how it was calculated. The company prepares annual adjusting entries. 2. Prepare the classified Statement of Earnings, Statement of Retained Earnings, and classified Statement of Financial Position, for the period ended and as at December 31, 2022. All Sports Factory (ASF) Olivia Lewis, a professional skler, started All Sports Factory on January 1, 2022. All Sports Factory (ASF) is a retail store, In Calgary, AB, that sells ski and snow sports gear such as skis, snowboards, boots, and helmets, as well as skiing lessons offer by Olivia herself. After what Olivia feels was a successful first year, she is eager to see how the company has performed. The company's fiscal year-end is December 31. She has asked you to create a set of financial statements, excluding the statement of cash flows, as she feels she has a good understanding of her cash spending as compared to her budget. Olivia will use these statements for her own use to assist with planning for the future of the company. Exhiblt 1 includes an unadjusted trial balance at December 31, 2022. Exhlblt 2 includes information on 2022 transactions which require analysis and recording using Accounting Standards for Private Enterprises (ASPE). 1. Prepare the journal entrles for 2022, including any required year-end adjusting entrles. Provide an explanation of why each entry is required and how it was calculated. The company prepares annual adjusting entries. 2. Prepare the classified Statement of Earnings, Statement of Retained Earnings, and classified Statement of Financial Position, for the period ended and as at December 31, 2022. Exhlblt 1 All Sports Factory (ASF) Addithonal Information 1. ASF uses a perpetual Inventory system. Below is a breakdown of inventory on hand at December 31,2022: 2. The company ran out of a popular helmet. They placed an order for 8 of these helmets on account at a cost of $100 each on December 28, 2022. Terms of this order were 2/10,n/30 FOB shipping point, Ollvla recelved an emall notifying her of shlpment on December 31 , 2022. Olivla looked forward to replenishing this popular Item and adding it to Inventory upon receipt. 3. A count of supplies was done on December 31, 2022, where $1,550 worth of supplies was found on hand. 4. An insurance policy was purchased in March 2022 for the next 12 months starting April 1 , 2022, and the purchase was properly recorded. 5. Olivia was ecstatic when the custom storefront sign arrived on March 1, 2022; just in time to be put up before the store's official grand opening! She hopes that the sign will last for the next 15 years. Olivia sure had fun designing and setting up the store! The furniture and fixtures she invested in (all of which was incurred within the first couple days of January 2022) are expected to last for the next 10 years. Olivia wanted to ensure that she could monitor the store's operations and her teaching schedule. As such, she invested in both a laptop and tablet. Everything was purchased on January 1, 2022 when she took advantage of some Boxing Day sales prices. She expects that both the laptop and tablet would be valuable for the next 5 years where she would need to expect to upgrade. Straight-line method is used for the storefront sign and the furniture and fixtures, and double declining-balance method is used for the laptop and tablet. sells for $100. Packages of 5 lessons sell for $450 and packages of 10 for $850. Cash received from the sales is deposited in the company's bank account at the end of each month. Bank reconcillations are prepared on an annual basls. There were 10 lesson packages sold in December 2022, but the lessons will not take place until January 2023 due to the Christmas holidays. These were all 5-lesson packages and the customers paid in full and look forward to learning from Olivla. These lessons have been recognized as service revenue in December 2022, given it was the period in which cash was collected. 7. A customer bought a 10 -lesson package in November 2022, and the lessons occurred in both November and December. The customer promised to pay for the package on December 15, however they have yet to pay this amount owing and all methods of contacting them have been exhausted and the amount has been deemed uncollectible. This has Olivia worrled that 10% of all her accounts recelvable at the end of the year will not be collected. 8. The monthly salaries for employees are $8,000 (ignore payroll taxes), and salaries are paid on the 15th of each month for their work done in the previous month. Olivia has recorded salaries expense each month from January to November 2022. 9. ASF is subject to income tax and the tax rate is 30%. 10. Olivia hired a payroll clerk, who is a very hard worker and did not take vacation in 2022. Employees do not typically report payroll errors, so Olivia does not need to monitor the payroll clerk closely