Search In this exercise, you will perform a financial statement analysis for Carpet Emporium. You will perform horizontal/vertical analyses and create charts to highlight key information from these analyses. You will also calculate financial ratios, insert cell comments, and create a chart for one set of ratio data. Open EA9-E2-FSA. For the two years showing, complete a horizontal analysis on the balance sheets and a vertical analysis on the income statements. Embed two pie charts beside the income statement-one to display the 2027 expense account percentages and another to display the 2028 expense account percentages. Ensure that each has a chart title, legend, and data labels that are logically displayed. Place a column chart on its own worksheet that displays each 2028 asset account dollar change. Include a chart title and worksheet tab title. Create a new worksheet to calculate the current ratio, debt-to-equity ratio, and profit margin for 2028 and 2027, and assign an appropriate worksheet title. Expand the worksheet to include these ratio results: Ratio 2026 2025 2024 Current Ratio 10.65 17.23 67.39 Debt-to-Equity 0.11 0.10 0.01 Ratio Profit Margin 0.46 0.19 0.26 Ensure that the ratios are presented logically and that cells are formatted to properly present the data. Enter cell comments for the largest profit margin and smallest debt-to- equity ratio to indicate that further investigation is needed for each. Then add a response to the profit margin comment, indicating that a temporary rent expense reduction was Annotations