Do It! 2: Horizontal Analysis Summary information for Rosepatch Company is as follows. Required: Compute the amount and pecentage change in 2017 using horizontal analysis. Instructions: Complete a horizontal analysis CHICAGO CEREAL COMPANY Condensed income Statement For the Years Ended December 31 (in thousands) Step 1: SET YOUR BASE TO 100\% (Total Assets for Balance Sheet and Net Sales for Income Statement) Step 2: Represent all other numbers as a percentage of the base amount. Example H2 Instructions: Complete a vertical analysis for each year. LIABILITIES AND OWNER'S FOIITV Calculate the following ratios for 2022 1. CURRENT RATIO 2. INVENTORY TURNOVER 3. PROFIT MARGIN 4. RETURN ON ASSETS 5. RETURN ON COMMON STOCKHOLDERS' EQUITY the following data are taken from the financial statements of Colby Company A/R (net), end of year Net sales on account Instructions: For each year compute tha (discuss) BE10-12 a) Inventory turnover \begin{tabular}{l|l|l|} \hline Cost of Goods Sold \\ \hline Average Inventory = & \\ \hline \end{tabular} c) What conclusions concerning the management of the inventory can be drawn from the data? (discuss)