This is an excel assignment so all work needs to have written solution please

Thank you

2021; and a ratio analysis as of December 31, 2021. Save the file as ch3-05_student_name.xls (replacing student_name with your name). Note: You will have to use Excel's help feature to create the column chart, because the columns are not adjacent to one another as in the chapter example. Use whatever chart layout you prefer. Print each completed worksheet in Value view, with landscape orientation, scaling to fit to 1 page wide by 1 page tall, and with your name and date printed in the lower left footer and the file name in the lower right footer. Use Excel's help feature to move charts on your worksheet so that they print on a separate page. Chapter 3 Case Problem 2: WINE DEPOT You are to create Wine Depot's financial analyses as of December 31, 2020, and as of December 31, 2021. Following the Chapter 3 examples, use the student file ch3-05.xls to create a vertical and horizontal analysis of the balance sheet and income statement in the columns provided. (Note: The horizontal analysis will compare December 31, 2020 with December 31, 2021.) Also create a pie chart of expenses for the year ended December 31, 2021; a column chart of expenses for the years ended December 31, 2020, and December 31, \begin{tabular}{|l|l|} \hline 1 & Wine Depot, Inc \\ \hline 2 & \multicolumn{1}{|c|}{ Ratio Analysis } \\ \hline 3 & December 2021 \\ \hline 4 & \\ \hline 5 & Profitability \\ \hline 6 & Return on owners' investment \\ \hline 7 & Return on total investment \\ \hline 8 & Profit margin \\ \hline 9 & Gross margin \\ \hline 10 & Liquidity \\ \hline 11 & Current ratio \\ \hline 12 & Quick ratio \\ \hline 13 & Receivable turnover \\ \hline 14 & Inventory turnover \\ \hline 15 & Solvency \\ \hline 16 & Debt-to-equity \\ \hline 17 & Liability \\ \hline 18 & \\ \hline 19 & \\ \hline \end{tabular} 2021; and a ratio analysis as of December 31, 2021. Save the file as ch3-05_student_name.xls (replacing student_name with your name). Note: You will have to use Excel's help feature to create the column chart, because the columns are not adjacent to one another as in the chapter example. Use whatever chart layout you prefer. Print each completed worksheet in Value view, with landscape orientation, scaling to fit to 1 page wide by 1 page tall, and with your name and date printed in the lower left footer and the file name in the lower right footer. Use Excel's help feature to move charts on your worksheet so that they print on a separate page. Chapter 3 Case Problem 2: WINE DEPOT You are to create Wine Depot's financial analyses as of December 31, 2020, and as of December 31, 2021. Following the Chapter 3 examples, use the student file ch3-05.xls to create a vertical and horizontal analysis of the balance sheet and income statement in the columns provided. (Note: The horizontal analysis will compare December 31, 2020 with December 31, 2021.) Also create a pie chart of expenses for the year ended December 31, 2021; a column chart of expenses for the years ended December 31, 2020, and December 31, \begin{tabular}{|l|l|} \hline 1 & Wine Depot, Inc \\ \hline 2 & \multicolumn{1}{|c|}{ Ratio Analysis } \\ \hline 3 & December 2021 \\ \hline 4 & \\ \hline 5 & Profitability \\ \hline 6 & Return on owners' investment \\ \hline 7 & Return on total investment \\ \hline 8 & Profit margin \\ \hline 9 & Gross margin \\ \hline 10 & Liquidity \\ \hline 11 & Current ratio \\ \hline 12 & Quick ratio \\ \hline 13 & Receivable turnover \\ \hline 14 & Inventory turnover \\ \hline 15 & Solvency \\ \hline 16 & Debt-to-equity \\ \hline 17 & Liability \\ \hline 18 & \\ \hline 19 & \\ \hline \end{tabular}