Free songs
Home / Bookkeeping / Horizontal Analysis Definition, Formula, Example in Excel

Horizontal Analysis Definition, Formula, Example in Excel

For example, the vertical analysis of an income statement results in every income statement amount being restated as a percent of net sales. If a company’s net sales were $2 million, they will be presented as 100% ($2 million divided by $2 million). If the cost of goods sold amount is $1 million, it will be presented as 50% ($1 million divided by sales of $2 million).

  1. Perhaps, the most important aim of financial analysis is identifying your company prospects through trends for both the near future and long-term periods.
  2. When it comes to management, it determines the actions to take in order to improve the future performance of the firm.
  3. However, these expenses don’t, at first glance, appear large enough to account for the decline in net income.
  4. Horizontal analysis can also be used to benchmark a company with competitors in the same industry.
  5. Appointment Scheduling 10to8 10to8 is a cloud-based appointment scheduling software that simplifies and automates the process of scheduling, managing, and following up with appointments.

In other words, vertical analysis can technically be completed with one column of data, but performing horizontal analysis is not practical unless there is enough historical data to have a useful point of reference. If you’re looking to invest in a company, horizontal analysis can be a helpful tool in your decision-making process. Understanding how the company has changed over time can better comprehend its potential future performance. However, always consider other factors, as no single tool can give you a perfect prediction of what will happen in the future. The percentage change is determined by dividing the dollar difference between the comparison year and the base year by the line item value in the base year, then multiplying the result by 100.

Vertical analysis expresses each line item on a company’s financial statements as a percentage of a base figure, whereas horizontal analysis is more about measuring the percentage change over a specified period. Horizontal Analysis measures a company’s operating performance by comparing its reported financial statements, i.e. the income statement and balance sheet, to the financial results filed in a base period. Vertical analysis makes it easier to understand the correlation between single items on a balance sheet and the bottom line, expressed in a percentage.

Horizontal Analysis: What It Is vs. Vertical Analysis

For the balance sheet, the total assets of the company will show as 100%, with all the other accounts on both the assets and liabilities sides showing as a percentage of the total assets number. Secondly, in the second type of horizontal analysis, we are interested in knowing about the underlying trends in the line items of the income statement. For this, we compare the absolute change ($) and percentage change (%) in all the line items from one period to the other. One should ideally take three or more accounting periods/years to identify trends and how a company is performing from one year/accounting period to the next year/accounting period. Financial statement analysis can be used to evaluate a company’s liquidity, solvency, profitability, and overall financial position.

Analyzing a company’s financial statements investors and comparing company performance with other companies in the same industry helps analysts to make informed decisions about whether or not to invest in the company. The percentages on a common-size balance sheet allow you to compare a small company’s balance sheets to that of a very large company’s balance sheet. A common-size balance sheet can also be compared to the average percentages for the industry. A useful way to analyze these financial statements is by performing both a vertical analysis and a horizontal analysis. This type of analysis allows companies of varying sizes whose dollar amounts are vastly different to be compared. Indeed, sometimes companies change the way they break down their business segments to make the horizontal analysis of growth and profitability trends more difficult to detect.

How to Do Horizontal Analysis?

The analysis is usually just a basic grouping of data ordered by period, but the numbers in each consecutive period can also be stated as a percentage of the amount in the baseline year, with the baseline amount indicated as 100%. Over 1.8 million professionals use CFI to learn accounting, financial analysis, modeling and more. Start with a free account to explore 20+ always-free courses and hundreds of finance templates and cheat sheets. Horizontal analysis should therefore be used in conjunction with other analytical tools like vertical (common-size) analysis and financial ratios to get a more comprehensive picture of the situation at hand and its likely trajectory. As in the prior step, we must calculate the dollar value of the year-over-year (YoY) variance and then divide the difference by the base year metric. The priority here should be to identify the company’s areas of strengths and weaknesses to create an actionable plan to drive value creation and implement operating improvements.

S-Corps and Female Entrepreneurs: Encouraging Financial Independence

Such comparisons help identify problems for which you can find the underlying cause and take corrective action. As business owners, we are so busy with the day-to-day operations of running a business that we may forget to take a look at our business as a whole and ignore any company financial statement analysis. In the above table, it can be seen that the gross profit margin, operating income margin, and net income margin of Apple Inc. have remained quite stable during the last three years.

Compared to horizontal analysis, the changes are not strictly presented as percentages and are also presented as variance (money amount). It can assess whether sufficient liquidity can service the company using indicators such as the cash flow to debt ratio, coverage ratios, interest coverage ratio, and other financial ratios. This type of analysis in the balance sheet is typically done in a two-year manner, as illustrated below, with a variance indicating the difference between the two years for each line item.

Solvency Ratios – Just as the name implies, these ratios reveal how solvent a company is, most specifically, how capable of paying its long-term debts. This means that, in 2021, revenue increased by $14,779, which is 33.17% higher than in 2020. This website is using a security service to protect itself from online attacks. There are several actions that could trigger this block https://intuit-payroll.org/ including submitting a certain word or phrase, a SQL command or malformed data. This insights and his love for researching SaaS products enables him to provide in-depth, fact-based software reviews to enable software buyers make better decisions. The 50% still represents a positive outcome from 2018 even though it still represents an overall decline in the growth of revenue.

However, investors should combine horizontal analysis with vertical analysis and other techniques to get a true picture of a company’s financial health and trajectory. It helps you understand how your company is performing over time to make more informed decisions about allocating your resources. By comparing data sets side-by-side, you can identify upward or downward trends in revenue, expenses, and net sales. This information can be used to make strategic decisions about pricing, budgeting, and product development. For more detailed representations of how horizontal analysis really works, here are a few examples with balance sheets, income statements, and retained earnings. For instance, instead of creating a balance sheet or income statement for one specific period of time, you would also create a comparative income statement or balance sheet that covers quarterly or annual activity for your business.

However, more than two financial statements need to be compared to obtain more reliable results for proper financial analysis. Horizontal analysis is an approach used to analyze financial statements by comparing specific financial information for a certain accounting period oregon tax rate with information from other periods. Horizontal Analysis in Reporting Standards The Generally Accepted Accounting Principles (GAAP) define a financial analysis approach that lets you compare different data sets over a given accounting period to spot trends and patterns.

We take the actual assets for year 2 and divide by actual assets for year 1 ($15,201/$12,012). My boss, Patty, welcomes the new hires and asks, ‘What is horizontal analysis? She said she was a little surprised that no one knew what horizontal analysis was, or maybe we were just shy.

Free Financial Modeling Lessons

Mary Girsch-Bock is the expert on accounting software and payroll software for The Ascent. If you purchased several fixed assets during 2018, the increase is easily explained, but if you didn’t, this would need to be researched. Adding a third year to the analysis will be even more helpful, as you’ll be able to see if there is a definite trend. Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI’s full course catalog and accredited Certification Programs. Access and download collection of free Templates to help power your productivity and performance. Liquidity Ratios – Determine how quickly a company could pay its current, short-term, obligations, if they were due right away.

Scroll To Top