Answer the following questions on an excel file and prodive step-bystep solutions with the formulas used to solve the problems:

Calculate financial ratios (liquidity, profitability, leverage, asset efficiency, returns) for the years included in the attached financial statements.

In each of five focus areas (liquidity, profitability, ), provide your view/thoughts/analysis of Midwest Shocks HISTORICAL performance.

Create a list with the numbers 1, 2 and 3. In order of priority (#1 being the highest), rank the three greatest concerns (not necessarily focus areas and not necessarily individual ratios) you have about the HISTORICAL performance. Your rankings are not necessarily entire focus areas (e.g., not all of profitability, but maybe one aspect of it) and should not necessarily be a ratio either. Briefly explain your thoughts.

Midwest Shocks 12/30/2021 Value Drivers These are the key variables that influence free cash flow and, therefore. DRIVE VALUE As part of this exercise, these "holes" are cells that participants must fill with FORMULAS that include value drivers in collumns H and X plus accountin Midwest Shocks LiquidityCurrentRatioQuickRatioCashConversionCycleReturnsROEROAROC Midwest Shocks 12/30/2021 Value Drivers These are the key variables that influence free cash flow and, therefore. DRIVE VALUE As part of this exercise, these "holes" are cells that participants must fill with FORMULAS that include value drivers in collumns H and X plus accountin Midwest Shocks LiquidityCurrentRatioQuickRatioCashConversionCycleReturnsROEROAROC