Hi, please I really need help on this. I don't necessarily need the answer but I need a thorough guideline on how to go about this.

A similar example will be great.

Thank you

AFA100 Introductory Financial Accounting, Winter 2023 D2L. file submission (financial statements \& memo) is due on April 9, 2023 at 11:59 pm. Instructions: I 1. This assignment is to be completed on an individual basis; group work is NOT permitted. 2. Prepare the financial statements (Excel) and memo (Word) required and upload them in to D2L under "Assignments". Include your journal entries on a separate tab in the same Excel file as the financial statements. Therefore, you will be uploading only 2 files: 1 Excel and 1 Word. 3. To submit the financial statements and memo, go to "Assessment" in the top D2L menu bar and then "Assignments". Click on the "Case Assignment Submission" link to submit. 4. Your financial statements and memo will be checked for plagiarism and manually graded and returned to you. 5. Round numbers to the nearest whole amount (e.g., round $125.43 to $125 ). Round ratios/percentages to the nearest whole percent (e.g., round 12.58% to 13\%). 6. The instructor will not answer any questions pertaining to the content of the case assignment prior the deadline. 7. Do not wait until the last minute to complete and submit. Please recognize the fact that you may have technical difficulties or other unexpected items when attempting to submit the assignment. There is no extra time beyond the stated deadline for technical issues experienced. This assignment All Sports Factory (ASF) 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). 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. 3. Prepare a professional memo to Olivia Lewis outlining 2 internal control weaknesses. Include an explanation of what can go wrong as a result of each weakness, and recommended changes. - Use the format provided below. - Consult the course textbook page 331-338 for guidance on internal controls. - See page 4 below for internal control guidance. Exhibit 1 All Sports Factory (ASF) Unadjusted Trial Balance, December 31, 2022 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. Olivia received 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. 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. 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 reconciliations 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 uncollectible. 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 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. AFA100 Introductory Financial Accounting, Winter 2023 D2L. file submission (financial statements \& memo) is due on April 9, 2023 at 11:59 pm. Instructions: I 1. This assignment is to be completed on an individual basis; group work is NOT permitted. 2. Prepare the financial statements (Excel) and memo (Word) required and upload them in to D2L under "Assignments". Include your journal entries on a separate tab in the same Excel file as the financial statements. Therefore, you will be uploading only 2 files: 1 Excel and 1 Word. 3. To submit the financial statements and memo, go to "Assessment" in the top D2L menu bar and then "Assignments". Click on the "Case Assignment Submission" link to submit. 4. Your financial statements and memo will be checked for plagiarism and manually graded and returned to you. 5. Round numbers to the nearest whole amount (e.g., round $125.43 to $125 ). Round ratios/percentages to the nearest whole percent (e.g., round 12.58% to 13\%). 6. The instructor will not answer any questions pertaining to the content of the case assignment prior the deadline. 7. Do not wait until the last minute to complete and submit. Please recognize the fact that you may have technical difficulties or other unexpected items when attempting to submit the assignment. There is no extra time beyond the stated deadline for technical issues experienced. This assignment All Sports Factory (ASF) 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). 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. 3. Prepare a professional memo to Olivia Lewis outlining 2 internal control weaknesses. Include an explanation of what can go wrong as a result of each weakness, and recommended changes. - Use the format provided below. - Consult the course textbook page 331-338 for guidance on internal controls. - See page 4 below for internal control guidance. Exhibit 1 All Sports Factory (ASF) Unadjusted Trial Balance, December 31, 2022 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. Olivia received 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. 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. 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 reconciliations 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 uncollectible. 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 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