Complete a Horizontal Analysis for XYZ Corporation. Open up the attached Excel file (see below) and enter your answers directly there. Save the completed file and upload it to this question.

Note that if you work on the Excel file beyond the expiry time for this test, I will be easily able to see the last time that you saved the Excel file to your computer. If it was saved later than the test's expiry time, it will not be marked.

AutoSave off Horizontal Analysis - GBD205.xlsx - Protected... - Saved to this PC Search Fenil Sureshkumar Patel x File Home Insert Page Layout Formulas Data Review View Automate Help Power Pivot Comments Share PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing B1 A B C D E F G H I K L M 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Horizontal Analysis for XYZ Corporation \begin{tabular}{|l|c|c|l|l|} \hline & 2022 & 2021 & & \\ \hline Revenue & 28,00,000 & 24,00,000 & & \\ \hline Cost of Sales & 15,50,000 & 15,50,000 & & \\ \hline Gross Profit & 12,50,000 & 8,50,000 & & \\ \hline Operating Expenses & & & & \\ \hline Salaries & 10,50,000 & 7,30,000 & & \\ \hline Utilities expense & 33,000 & 15,000 & & \\ \hline Depreciation & 56,000 & 30,000 & & \\ \hline Other expenses & 32,000 & 18,000 & & \\ \hline Total Operating expense & 11,71,000 & 7,93,000 & & \\ \hline Profit before taxes & 79,000 & 57,000 & & \\ \hline Income tax expense & 23,700 & 17,100 & & \\ \hline Net Income & 55,300 & 39,900 & & \\ \hline \end{tabular} HorizontalAnalysis Ready ? Tomorrow's high Near record Search W. ENG IN 02:16 PM 21-Nov-23