1. Choose between one of the following public companies: a. McDonalds b. Jack in the Box c. Starbucks 2. Find the 2022 financial statements for the company that you choose 3. You will not be given an Excel template for this activity, but your project needs to be completed in Excel. 4. All of the financials for the companies you've been given, show multiple years of financial data on them. This can be helpful to complete the analysis. You only need to look at 2022 and 2021. 5. You will need to perform the following analyses: a. Vertical Analysis b. Horizontal Analysis c. Ratio Analysis 6. The information to perform vertical and horizontal analysis is already provided to you via the financial statements you have downloaded. You just need to know what each is and how to make the calculations. We will go over this extensively in class. 7. You will need to include the following ratios for your ratio analysis, if they are applicable to companies you are analyzing: a. Current Ratio b. Quick Ratio c. Accounts Receivable Tumover Ratio d. Average Days to Collect Receivables e. Inventory Tumover f. Debt to sset Ratio g. Debt to Equity Ratio h. Net Margin i. Asset Tumoter Ratio j. Retum on Investment k. Retum on Equity