Horizontal Analysis Formula & Methods What is Horizontal Analysis? Video & Lesson Transcript


Natalie Tan

Natalie Tan

Lorem ipsum dolor sit amet consectetur adipiscing elit dolor

how to do horizontal analysis

For example, an investor can use the horizontal analysis of the balance sheet to track the earnings per share ratio on a company he is thinking about investing in. If the ratio continues to grow year over year, the investor’s horizontal analysis analysis would show a positive trend and he would probably choose to invest in the company granted other metrics are equally as positive. In above analysis, 2007 is the base year and 2008 is the comparison year.

how to do horizontal analysis

Then, the dollar change is divided into the base amount to obtain the % change. It is the same principle as if you have your first raise in your first job. You made https://www.bookstime.com/ $10 an hour and now your boss gives you a raise and pays you $12. When you go home and share the good news with your parents, they ask, “What is the raise?

Horizontal analysis helps you spot trends

Vertical analysis restates each amount in the income statement as a percentage of sales. This analysis gives the company a heads up if cost of goods sold or any other expense appears to be too high when compared to sales. Reviewing these comparisons allows management and accounting staff at the company to isolate the reasons and take action to fix the problem. A horizontal analysis is most useful when the underlying financial information is consistently reported, based on the applicable financial reporting framework. Examples of these frameworks are generally accepted accounting principles and international financial reporting standards.

how to do horizontal analysis

On the other hand, comparability constraint dictates that a company’s financial statements and other documentation be such that they can be evaluated against other similar companies within the same industry. Horizontal analysis is used to improve and enhance these constraints during financial reporting. The Comparative Income Statement is drawn on the same principle as the Horizontal Balance Sheet. There are columns, as in a comparative balance sheet, to show the amount of income and expenditure for two years in or more along with the increase or decrease in amounts as also percentage increases or decreases. The percentages reflects the changes that have occurred over successive periods.

Horizontal Analysis Drawbacks

This type of presentation makes it easier to spot declining margins and/or liquidity problems early and make corrections before they can become serious concerns. Vertical analysis, also called common-size analysis, focuses on the relative size of different line items so that you can easily compare the income statements and balance sheets of different-sized companies. If you want to see both variances and percentages, you can add columns to your spreadsheet to see the changes in both. Though this format does take longer to create, it makes it much easier to spot trends and get a look at business performance compared to the previous year or previous quarter. You need at least two accounting periods for a valid comparison, but if you want to really spot trends, you should have at least three, if not more accounting periods of data available for calculating horizontal analysis. As a result, some companies maneuver the growth and profitability trends reported in their financial horizontal analysis report using a combination of methods to break down business segments. Regardless, accounting changes and one-off events can be used to correct such an anomaly and enhance horizontal analysis accuracy.

  • All items on the balance sheet and income statement for the year 2008 have been compared with the items of balance sheet and income statement for the year 2007.
  • From the analysis, we can make out that both cash and prepaid expenses increased in 2017 compared to 2016.
  • Reviewing these comparisons allows management and accounting staff at the company to isolate the reasons and take action to fix the problem.
  • Structured Query Language is a specialized programming language designed for interacting with a database….
  • Comparability means that a company’s financial statements can be compared to those of another company in the same industry.

Learning how to read and understand an income statement can enable you to make more informed decisions about a company, whether it’s your own, your employer, or a potential investment. As a working professional, business owner, entrepreneur, or investor, knowing how to read and analyze data from an income statement—one of the most important financial documents that companies produce—is a critical skill to have. It depicts the amount of change as a percentage to show the difference over time as well as the dollar amount. It also compares a company’s performance from one period to another (current year vs. last year). Horizontal Analysis – analyzes the trend of the company’s financials over a period of time. Business owners can use company financial analysis both internally and externally. They can use them internally to examine issues such as employee performance, the efficiency of operations and credit policies.

Comparative income statement with horizontal analysis:

A closer look into vertical analysis in fig shows the distribution pattern of liabilities among current liabilities, long – terms liabilities and equity capital. Similarly, it shows the distribution pattern of total asserts among current asserts, fixed assets and other asserts. Vertical analysis is the financial statement in which all items of a financial statement are presented in percentages. 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).

  • I’ve actually invested in stocks that reported better than average revenue, and the moment the quarterly report came out, the stock took a nosedive.
  • In percentage comparison, the increase or decrease in amounts is expressed as a percentage of the amount in the base year.
  • Several interesting balance sheet changes are apparent in the tables below.
  • For example, a $1 million increase in General Motors’ cash balance is likely to represent a much smaller percentage increase than a corresponding $1 million increase in American Motors’ cash balance.
  • If a company’s net sales were $2 million, they will be presented as 100% ($2 million divided by $2 million).

Latest Article


Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

A creative digital agency which focuses on design, development, and digital marketing, thus helping our clients to improve their business.