Worksheet tab name: Financial Ratios $($PG$-7)$

Location What to Enter$/$Do

Column A Width: $14($PG$-8$a$)$

Range B$1$:F$1$ In order, no commas: $2028,2027,2026,2025,2024($PG$-8$b$)$

Range A$2$:A$4$ In order, no commas: Quick Ratio, Debt Ratio, Profit Margin $($PG$-8$c$)$

Range B$2$:C$4$ Formulas to calculate ratios for $2028$ and $2027($PG$-8$d$)$

Range D$2$:F$4$ Enter the provided ratios $($PG$-8$e$)$

Range G$2$:G$4$ Line Sparklines that display all five years of ratio data $($PG$-8$f$)$

Formatting:

Range B$1$:F$1$: Bottom Border, Bold formatting, Center $($horizontal$)$ alignment $($PG$-9$a$)$

Range A$2$:A$4$: Bold formatting $($PG$-9$a$)$

All quick and debt ratios: Comma Style $($PG$-9$b$)$

All debt ratios: Show three decimal places $($PG$-9$b$)$

All profit margins: Percent Style, one decimal $($PG$-9$b$)$

After inputting and formatting the data:

Insert comments in the cells for the largest debt ratio and the smallest profit margin to indicate that further investigation is required. Respond to the comment for the smallest profit margin, indicating client attrition led to the reduced earnings for the year. Make sure the response is distinct from the original comment. $($PG$-10$a$)$

Embed a Line chart below the ratio data that displays the profit margin trend over the fiveyear period. Make sure to include an appropriate chart title! $($PG$-10$b$)$