For this assignment, United Natural Foods Inc. (UNFI) annual report and the report two years prior to that (e.g., 2019 and 2017 or 2020 and 2018). With two years of annual reports, you will have four years of income statements (e.g., 2016, 2017, 2018 and 2019 if you have the 2017 and 2019 annual reports or 2017, 2018, 2019 and 2020 if you have the 2018 and 2020 annual reports). Using the financial statement data in the company's annual reports, create a comprehensive written analysis of the company's financial operations for the four most recent fiscal years. You written report should be structured as follows: Part I: Construct common size income statements for the four most recent fiscal years (that is why you need the two most recent annual reports). Also, include a line listing the annual growth rate in net revenue (or sales) for the four most recent years. See the next page for an example of what your table should look like. o Using the financial statement data in the company's annual reports, create a comprehensive written analysis of the company's financial operations for the four most recent fiscal years. You written report should be structured as follows: o Part I: Construct common size income statements for the four most recent fiscal years (that is why you need the two most recent annual reports). Also, include a line listing the annual growth rate in net revenue (or sales) for the four most recent years. Write an analysis of the ratio table you created. For example: What trends do you observe? What appears to be areas of strength or weaknesses? What are any potential areas of significant concern? Anything else? Part III: Create a statement of cash flows table for the four most recent fiscal years (that is why you need the two most recent annual reports). For this statement, you only need to list the three net accounts (i.e., Net Cash Flows from Operating Activities, Net Cash Flow from Investing Activities, and Net Cash Flow from Financing Activities). Then, evaluate these statements over this time period. What has been the major source of cash each year and what has been the major use of cash? Has the company generated sufficient internal cash to finance any capital spending? Anything else? Here is a sample listing of the Valley Mercantile Company's sales data from the most recent year in an Excel table. BEE (Click the icon to view the Excel worksheet.) For each of the situations listed below, indicate whether a sort, a filter, or both simultaneously would be the most efficient way of getting the information needed for management. Indicate the column(s) and the related sorting and/or filtering criteria: (Note: You do not need to perform the sorts and filters in Excel in this exercise.) Situatuit 1. Management Want Customers auto-up survey about any viver lidt tidied more than 100. Sort by Sales Situation 2. Due to unusually high returns by Cameron Howell's customers, management wants to audit each order placed by Cameron Howell's customers. Situation 3. Management wants to rank all the orders from largest to smallest sales Situation 4. Management wants a list of orders sorted from largest to smallest sales for Nicole Ross, a salesperson, so that Ross can follow up with her top customers. Submit tile Company's sales eet.) Data table - X te whether a sort, a fi d to perform the sorts Order # Date Product ID Sales Customer # Salesperson managemen 3425 3/30/2020 EM-770 $ 2,150 4694 Amro, Wei Howell, 9276 9/1/2020 IF-484 $ 18,772 7393 Cameron 4908 3/29/2020 EG-133 S 3,830 8141 Gerbig, Gracen 3548 4/3/2020 EM-770 $ 31,229 3799 Calvin, Frank 15185 6/27/2020 FD-101 S 1.509 5074 Harris, Gabriella Cameron Howell's c 7000 7/3/2020 IF-302 $ 2.231 6074 Ross Nicole Howell, 8393 8/4/2020 IF-484 $ 8,328 7362 Cameron he orders from larges 15870 4/29/2020 TR-134 $ 1,884 5514 Rossy Nicole ers sorted from larges ers