Horizontal Analysis Meaning, Formula, Examples

written by


Mart 21, 2022



what is a horizontal analysis

If you purchased several fixed assets during 2018, the increase is easily explained, but if you didn’t, this would need to be researched. Cost Of SalesThe costs directly attributable to the production of the goods that are sold in the firm or organization are referred to as the cost of sales. what is a horizontal analysis First, we need to take the previous year as the base year and last year as the comparison year. As we see, we can correctly identify the trends and develop relevant areas to target for further analysis. Or investigate to see if this situation is a coincidence based on other factors.

  • Below are the results for the balance sheet and income statement, followed by an interpretation of the results.
  • In this sample comparative income statement, sales increased 20.0% from one year to the next, yet gross profit and income from operations increased quite a bit more at 33.3% and 60.0%, respectively.
  • Horizontal analysis of the balance sheet is also usually in a two-year format, such as the one shown below, with a variance showing the difference between the two years for each line item.
  • It can be done with the company’s Financial Statements or with the use of the Common Size Statements.

In vertical analysis, balance sheet items and income statement items are expressed in percentage. All balance sheet accounts are presented as a percentage of the total assets and all income statement items are presented as a percentage of sales (Ott, Riddiough, & Yi, 2009). Sales is assumed to be equal to 100, for income statement and total assets is assumed to be common based equal to 100 in case of balance sheet. Horizontal analysis is used by companies to see what has been the factors to drive the company’s financial performance over a number of years (Aizenman & Marion, 2004). (Miller & Goidel, 2009) Like in Nepal as well, the demand/sell of clothes and other appliances is higher during special festivals or occasions compared to other normal days. It allows the company to have a detailed look at each of the line item.

Horizontal Analysis: Explanation

Vertical Analysis refers to the analysis of the financial statement in which each item of the statement of a particular financial year is analysed, by comparing it with a common item. I just want to ask if how can we do an income statement if the given data are in ratios and percentage only? Hi , i am supposed to do trend analysis of last 10 years of two companies between them so should i take one year as base year and calculate changes according to that or do it taking 2 2 years. The comparative condensed income statements of SPENCER Corporation are shown below.

For example, the current period’s profits may appear excellent when only compared with those of the previous quarter but are actually quite poor if compared to the results for the same quarter in the preceding year. 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). Horizontal analysis allows financial statement users to easily spot trends and growth patterns. To calculate the percentage change, first select the base year and comparison year. Subsequently, calculate the dollar change by subtracting the value in the base year from that in the comparison year and divide by the base year.

Comparative schedule of current assets:

Though there’s value in this approach, the current period may appear uncommonly good or bad, depending on the choice of the base year and the chosen accounting period the analysis begins with. Given how 2020 was so widely different from years past, it’s hopefully an outlier for many industries as the global economy begins to recover from the pandemic. Let’s assume an investor is looking to invest in Company ABC. The investor wants to determine how the company grew over the past year, to see if his investment decision should provide solid ROI. Let’s say that in the Company ABC base year, they reported a net income of $5 million and retained earnings of $25 million.

Horizontal Analysis can be used to misguide or manipulate the outside parties. Usually, the purpose of such manipulation is to artificially make the results of this year appear good. This can be done by comparing the current period’s performance with that period which will make the current period’s performance look good.

Management Accounting

Conversely, the vertical analysis aims at showing an insight into the relative importance or proportion of various items on a particular year’s financial statement. One of the major criticisms of horizontal analysis is that it can at times produce biased results. This is because the beginning period will determine how the growth and trajectory appear. By selecting a beginning period with particularly inferior performance, analysts can sometimes create the impression that the business is doing better than it is. The most obvious benefit of horizontal analysis is that helps paint a picture of how a business has performed over time. This has several implications, including the ability to identify trends. Trends are used when projecting future performance and analysts use them to identify where they believe the business is within the business cycle.

what is a horizontal analysis

This simplifies the process of comparing the financial statement of the company against another or to even do it across the industry. This analysis also gives a better picture of the performance metrics of the company and if it’s improving or on a decline. That is done by looking at the annual or quarterly figures of the company and comparing it over a number of years.

Income statement

Different ratios, such as earnings per share or current ratio, are also compared for different accounting periods. An absolute comparison involves comparing the amount of the same line of the item to its amounts in the other accounting periods. For example, comparing the accounts receivables of one year to those of the previous https://www.bookstime.com/ year. The key advantage of using horizontal analysis is that it allows for the visual identification of anomalies from long-running trends. By presenting data on a comparative basis, changes in the data are more readily apparent. In addition, the use of horizontal analysis makes it easier to project trends into the future.

  • If the base year amount is zero or negative, percentage change is not calculated.
  • 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.
  • But if sales revenue increases by only 5%, then it needs to be investigated.
  • Because they are turning over their Inventory without the cost of it becoming obsolete.
  • One of the major criticisms of horizontal analysis is that it can at times produce biased results.

This figure compares the difference in accounts from 2014 to 2015, showing each account as a percentage of sales for each year listed. In horizontal analysis, you can compare figures from one time period to figures from a base time period to get an overview of changes over time. Analyzing financial trends over periods or years can help you track how a company’s financial state has changed, find patterns in its data and spot potential problems and opportunities. With horizontal analysis, you look at changes line-by-line, between specific accounting periods – whether it be monthly, quarterly, or annually. Usually, it’s quarterly or annually, and compares at least three years. With horizontal analysis, you use a line-by-line comparison to the totals.