Change is absolutely necessary within organizations. An organization cannot compete in today’s competitive environment unless it is continuously changing and developing. For example, consider the company Blockbuster. At one point in time, Blockbuster was a leader in terms of video rentals. However, Blockbuster has closed all but one of its locations and has been taken over by companies like Hulu, Netflix, and Amazon.Select an industry that none of your other classmates have written about. Do not duplicate industries from post to post. Then, do the following:Choose a specific business within that industry that you believe is falling behind.Then, pretend that the leader of this organization asked you what changes are necessary. Based upon your knowledge of the industry and some additional research, what recommendations do you believe the industry/business needs to make in order to stay competitive.Finally, pretend that the organizational leader likes the status quo. How would you convince the organizational leader, who is fine with things the way they are, to reconsider his/her approach?

 perform a financial statement analysis for Legal Services Co. You will perform horizontal/vertical analyses and create charts to highlight key information from these analyses. You will also calculate financial ratios and insert cell comments. Access the proper file. Using Project Grader: Download EA9-A1-FSA-eStart. Not using Project Grader: Open EA9-A1-FSA. Horizontal Analysis Tab Range K8:K17: Create formulas to calculate the dollar change where appropriate. (PG-1a) Range M8:M17: Create formulas to calculate the percent change where appropriate. (PG-1b) Create an embedded Clustered Column chart. (PG-2) Based on: Percent change in each asset account Position: To the right of and top-aligned with the balance sheet Chart Title: Enter an appropriate name, centered above the column chart. Resize the chart 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 income statement for 2028 and 2027. (PG-3) Create a Clustered Column Chart. (PG-4) Placement: On its own tab named: Expense Chart - 2028 Based on: 2028 expense account percentages and including the Total Expenses and Net Income cells Chart Title: Enter an appropriate name, centered above the column chart. Change the chart type to 3-D Pie. (PG-5) Filter out: Total Expenses (PG-5a) Layout and style: Layout 2, Style 3 (PG-5b) Legend: Display it to the right of the 3-D Pie chart. (PG-5c) Data labels: Display Percentages, two decimals; Best Fit (PG-5d) Y-axis: Rotate to 40 degrees. (PG-5e) Chart title background: Solid, standard yellow fill (PG-5f) Explode the largest pie slice. (PG-5g) Display Column Sparklines to the right of each revenue and expense account (hint: column N; based on percentages; exclude totals) in the income statement and adjust the border around the income statement to include them. (PG-6a) Use the header Sparkline Trends and make its formatting consistent with that of the adjacent headers. (PG-6b) Calculate Ratios and Insert Cell Comments You will create a new worksheet on which to calculate the ratios, some of the data for which is shown here: Ratio 2026 2025 2024 Quick Ratio 3.72 4.51 3.90 Debt Ratio 0.072 0.061 0.052 Profit Margin 0.342 0.294 0.206 Worksheet tab name: Financial Ratios (PG-7) Location What to Enter/Do Column A Width: 14 (PG-8a) Range B1:F1 In order, no commas: 2028, 2027, 2026, 2025, 2024 (PG-8b) Range A2:A4  In order, no commas: Quick Ratio, Debt Ratio, Profit Margin (PG-8c) Range B2:C4 Formulas to calculate ratios for 2028 and 2027 (PG-8d) Range D2:F4 Enter the provided ratios (PG-8e) Range G2:G4 Line Sparklines that display all five years of ratio data (PG-8f) Formatting: Range B1:F1: Bottom Border, Bold formatting, Center (horizontal) alignment (PG-9a) Range A2:A4: Bold formatting (PG-9a) All quick and debt ratios: Comma Style (PG-9b) All debt ratios: Show three decimal places (PG-9b) All profit margins: Percent Style, one decimal (PG-9b) 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 reduced earnings for the year. Make sure the response is distinct from the original comment. (PG-10a) Embed a Line chart below the ratio data that displays the profit margin trend over the five-year period.