has an FYI, the information presented is in billions. The company that has been assigned to you is Costco. Please calculate the financial ratios that were discussed in the video lecture for all five years. Inext want you to develop a presentation for the ratios and evaluate the trend over the 5 years. For each ratio have a separate slide and make sure to include the following: o Explanation of ratio o Graph (on graph make sure to identify each year's actual ratio amount and include the trend line) o Trend analysis (Is it good or bad?) I would lastly like you to identify the top 3 ratios that are the strongest or most positive and the 3 ratios that are the weakest or ones that should be of concern. Please provide a brief explanation of why you chose these ratios. I strongly suggest that you review the sample that is posted in Canvas under Module 6 which is a past project to see how past students have presented their projects. I encourage you to submit a draft of your presentation for my feedback and suggestions prior to your official your submission on Canvas. I will review all drafts that are received before Wednesday, October 13th by 12:00 pm. The project can be done entirely done in PowerPoint if you would like. There may others that want to write a paper which includes this information which is fine. The way you chose to deliver your analysis will not be used to evaluate the quality of your presentation - I am most concerned with your interpretation and analysis of each of the ratios. 2016 2017 2018 2019 2020 Sales COGS SGA Expenses Operating Profit Earnings Before Taxes Receivables Inventory Current Assets Total Assets Accounts Payable Accruals Current Liab Total Liab Net Worth $ $ $ $ $ $ $ $ $ $ $ $ 118.72 $ 102.90 $ 12.07 $ 3.67$ 3.625 1.25$ 8.97 15.225 33.165 7.61 S 4.035 15.585 20.83$ 12.33 $ 129.03S 111.88 $ 12.95$ 4.11$ 4.04 $ 1.43S 9835 17325 3635$ 9.61$ 3.66 $ 17.50 S 25.27 11.08$ 141585 123.15$ 13885 4485 444$ 1.67 $ 11.04 $ 20.29 $ 40.83$ 11.245 4056 1993 $ 27.73 $ 13.10$ 152.70 $ 132.89 $ 14.99$ 4.74 $ 4.77S 1.54S 11.405 23.495 45.40 $ 11.68 $ 4.36 $ 23.246 29.82 $ 15.58$ 166.76 144.94 16.33 5.44 5.37 1.55 12.24 28.12 55.56 14.17 5.00 24.84 36.85 18.71 has an FYI, the information presented is in billions. The company that has been assigned to you is Costco. Please calculate the financial ratios that were discussed in the video lecture for all five years. Inext want you to develop a presentation for the ratios and evaluate the trend over the 5 years. For each ratio have a separate slide and make sure to include the following: o Explanation of ratio o Graph (on graph make sure to identify each year's actual ratio amount and include the trend line) o Trend analysis (Is it good or bad?) I would lastly like you to identify the top 3 ratios that are the strongest or most positive and the 3 ratios that are the weakest or ones that should be of concern. Please provide a brief explanation of why you chose these ratios. I strongly suggest that you review the sample that is posted in Canvas under Module 6 which is a past project to see how past students have presented their projects. I encourage you to submit a draft of your presentation for my feedback and suggestions prior to your official your submission on Canvas. I will review all drafts that are received before Wednesday, October 13th by 12:00 pm. The project can be done entirely done in PowerPoint if you would like. There may others that want to write a paper which includes this information which is fine. The way you chose to deliver your analysis will not be used to evaluate the quality of your presentation - I am most concerned with your interpretation and analysis of each of the ratios. 2016 2017 2018 2019 2020 Sales COGS SGA Expenses Operating Profit Earnings Before Taxes Receivables Inventory Current Assets Total Assets Accounts Payable Accruals Current Liab Total Liab Net Worth $ $ $ $ $ $ $ $ $ $ $ $ 118.72 $ 102.90 $ 12.07 $ 3.67$ 3.625 1.25$ 8.97 15.225 33.165 7.61 S 4.035 15.585 20.83$ 12.33 $ 129.03S 111.88 $ 12.95$ 4.11$ 4.04 $ 1.43S 9835 17325 3635$ 9.61$ 3.66 $ 17.50 S 25.27 11.08$ 141585 123.15$ 13885 4485 444$ 1.67 $ 11.04 $ 20.29 $ 40.83$ 11.245 4056 1993 $ 27.73 $ 13.10$ 152.70 $ 132.89 $ 14.99$ 4.74 $ 4.77S 1.54S 11.405 23.495 45.40 $ 11.68 $ 4.36 $ 23.246 29.82 $ 15.58$ 166.76 144.94 16.33 5.44 5.37 1.55 12.24 28.12 55.56 14.17 5.00 24.84 36.85 18.71
