Principles of Managerial Finance, 14th ed.

Question: Chapter 3, Spreadsheet Exercise

Part C:

c1. Create a table (similar to table 3.8) that reflects both 2015 and 2014 operating ratios for Dayton, Inc., segmented into (a) liquidity, (b) activity, (c) debt, (d) profitability, and (e) market. Assume that the current market price for the stock is $90.

c2. Create a spreadsheet (similar to table 3.8) to compare the 2015 ratios to the 2014 ratios. Indicate whether the results "outperformed the prior year" or "underperformed relative to the prior year."