This needs to be done in excel so please include formulas$/$cell references to show your work$/$calculations so I can learn how to do this. Thank you so much.

No dividends were declared or paid for the years ended October $31,2020$ and The market value per common share on October $31,2020$ and $2019$ were $$29$ and $$25$ respectively.

Industry averages for $2020$ are provided in the chart below.

Required:

Create the chart below in Excel and calculate all the ratios listed for $2020$

and $2019.$ For ratios expressed as a percentage include the percent sign

in your worksheet. Round all ratios to two decimal places. State whether

each ratio is favourable or unfavourable $($F$/$U$)$ compared to the previous

year and the industry average.

Choose $5$ of your favorite ratios from the list above and explain why the

change is favorable or unfavorable.Other information

$1.$ No dividends were declared or paid for the years ended October $31,2020$ and $2019.$

$2.$ The market value per common share on October $31,2020$ and $2019$ were $$29$ and $$25$ respectively.

$3.$ Industry averages for $2020$ are provided in the chart below.

$4.$ Create the chart below in Excel and calculate all the ratios listed for $2020$ and $2019.$ For ratios expressed as a percentage include the percent sign in your worksheet. Round all ratios to two decimal places. State whether each ratio is favourable or unfavourable $($F$/$U$)$ compared to the previous year and the industry average.

$5.$ Choose $5$ of your favorite ratios from the list above and explain why the change is favorable or unfavorable.