Horizontal Analysis Tab Range K$8$:K$21$: Create formulas to calculate the dollar change where appropriate. $($PG$-1$a$)$ Range M$8$:M$21$: Create formulas to calculate the percent change where appropriate. $($PG$-1$b$)$ Create an embedded Clustered Column chart. $($PG$-2)$ Based on: Percent change in each expense account Position: To the right of and top$-$aligned with the income statement Chart Title: Enter an appropriate name, centered above the column chart. Resize the chart as necessary so all elements are logically displayed. Change the chart type to Clustered Bar and remove gridlines. Vertical Analysis Tab Columns K$-$L: Create formulas to complete a vertical analysis on the balance sheet for $2028$ and $2027.($PG$-3)$ Create a Clustered Column Chart. $($PG$-4)$ Placement: On its own tab named Asset Chart $-2028$ Based on: $2028$ asset account percentages and including the Total Assets cell Chart Title: Enter an appropriate name, centered above the column chart. Change the chart type to $3-$D Pie. $($PG$-5)$ Filter out: Total Assets and Land $($PG$-5$a$)$ Layout and style: Layout $6,$ Style $7($PG$-5$b$)$ Legend: Display it at bottom. $($PG$-5$c$)$ Data labels: Outside End; display Percentages, two decimals $($PG$-5$d$)$ Y$-$axis: Rotate to $50$ degrees. $($PG$-5$e$)$ Chart title background: Solid, standard blue fill $($PG$-5$f$)$ Explode the smallest pie slice. $($PG$-5$g$)$ Display Column Sparklines to the right of each asset, liability, and owner's equity account $($hint: column N; based on percentages; exclude totals$)$ on the balance sheet and adjust the border around the balance sheet to include them. $($PG$-6$a$)$ Use the header Sparkline Trends and make its formatting consistent with that of the adjacent headers. $($PG$-6$b$)$ Calculate Ratios and Insert Cell Comments Ratio $202620252024$ Current Ratio $7\mathrm{.}623\mathrm{.}458\mathrm{.}21$ Debt$-$to$-$Equity Ratio $0\mathrm{.}170\mathrm{.}280\mathrm{.}18$ Profit Margin $0\mathrm{.}1860\mathrm{.}2920\mathrm{.}255$ Worksheet tab name: Financial Ratios $($PG$-7)$ Location What to Enter$/$Do Column A Width: $20($PG$-8$a$)$ Range B$1$:F$1$ In order, no commas: $2028,2027,2026,2025,2024($PG$-8$b$)$ Range A$2$:$44$ In order, no commas: Current Ratio, Debt$-$to$-$Equity Ratio, Profit Margin $($PG$-8$c$)$ Range B$2$:$04$ Formulas to calculate ratios for $2028$ and $2027($PG$-8$d$)$ Range D$2$:F$4$ Enter the provided ratios $($PG$-8$e$)$ Line Sparklines that display all five years of ratio data $($PG$-8$f$)$ Range G$2$:$34$ 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 current and debit$-$to$-$equity ratios: Comma Style $($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 profit margin and the smallest debt$-$to$-$equity ratio to indicate that further investigation is required. Respond to the comment for the largest profit margin, indicating that a single, large client led to inflated 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 current ratio trend over the fixexear period. Make sure to use an appropriate chart title! $($PG$-10$b$)$ Dollar Change Percent Change $20282027$ $ $247,600$ $ $286,3001,5201,600249,120287,900$ Revenues: Service Revenue Interest Revenue Total Revenue Expenses: Supplies Expense Rent Expense Salaries Expense Utilities Expense Insurance Expense Auto Expense Computer Expense Repair & Maintenance Expense Total Expenses Net Income $74,60060,00045,3003,8003,2502,9001,140800191,79057,330101,80060,00051,2007,5003,6702,0801,800410228,46059,440$ $ $ $2028$ Dollar $2027$ Dollar Amount Amount $20282027$ Percentage Percentage Assets: Cash Notes Receivable $($Short$-$Term$)$ Supplies Land Total Assets Liabilities: Accounts Payable Owner's Equity: Arnold McBride, Capital Total Liabilities & Owner's Equity $ $428,00018,7004,67051,400502,770$ $ $443,20023,20040051,400518,20031,00057,300471,770502,770460,900518,200$