Horizontal Analysis

Review this Excel spreadsheet. In the Horizontal worksheet, highlight the cells for the year 2003 that indicate the need for further examination.

Then review the Vertical worksheet and calculate the key ratios for each year as appropriate (you will not be able to calculate all ratios for year 2001). Add comments for the ratios that indicate the need for further investigation.

Submit your revised spreadsheet file.