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 ch3-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 D5 and G5. Place the vertical analysis in columns D and G on the balance sheet labeled % of Assets in cells D5 and G5. Place the horizontal analysis in column I labeled % Change in cell I5 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 manner similar to your chapter work; and a ratio analysis as of December 31, 2023. 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.
Save the workbook as ch3-07_student_name (replacing student_name with your name). Print all worksheets in Value view, with your name and date printed in the lower left footer and the file name in the lower right footer.