Chapter $3$ Case Problem $3$: SNICK'S BOARD SHOP

You are to create a financial analysis for Snick's Board Shop as of December $31,2017,$ and December $31,2018.$ Following the Chapter $3$ examples, use the student file ch$3-06.$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,2017,$ with December $31,2018.)$ Also create a pie chart of expenses for the year ended December $31,2018,$ formatted in a manner similar to your chapter work; a column chart of expenses for the years ended December $31,2017,$ and December $31,2018,$ formatted in a manner similar to your chapter work; and a ratio analysis as of December $31,2018.$ Save the file as ch$3-06\_$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.

Chapter $3$ Case Problem $4$: ROSEY'S ROSES

You are to create a financial analysis for Rosey's Roses as of December $31,2022,$ and December $31,2023.$ Following the Chapter $3$ examples, use the student file ch$3-07.$xls to create a vertical analysis of the balance sheet and income statement as of December $31,2022,$ and December $31,2023-$as well as a horizontal analysis of both the income statement and balance sheet comparing December $31,2022,$ with December $31,2023.$ Place the vertical analysis in columns D and G on the income statement labeled $\%$ of Sales in cells D$5$ and G$5.$ Place the vertical analysis in columns D and G on the balance sheet labeled of Assets in cells D$5$ and G$5.$ Place the horizontal analysis in column I labeled $\%$ Change in cell I$5$ for both the income statement and balance sheet.

Also create a pie chart of expenses for the year ended December $31,2023,$ formatted in a manner similar to your chapter work; a column chart of expenses for the years ended December $31,2022,$ and December $31,2023,$ formatted in a