In this exercise, you will perform a financial statement analysis for Experienced Metalworks. 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 EA$9-$E$1-$FSA. For the two years showing, complete a horizontal analysis on the income statements and a vertical analysis on the balance sheets. Embed two pie charts beside the balance sheet$$one to display the $2027$ asset account percentages and another to display the $2028$ asset 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$ expense account percent change. Include a chart title and worksheet tab title.

Create a new worksheet to calculate the quick ratio, debt ratio, and profit margin for $2028$ and $2027,$ and assign an appropriate worksheet title. Expand the worksheet to include these ratio results: