Bookkeeping
Posted in

Horizontal Analysis of Financial Statements

what is a horizontal analysis

If you work in finance or accounting cost behavior analysis and want to save time, avoid mistakes, and impress your boss, then you have come to the right place. I’ll help automate your work and unstick your career with straightforward guides and case studies. Likewise, we can do the same for all the other entries in the income statement. As we see, we can correctly identify the trends and develop relevant areas to target for further analysis. You do not need special financial skills to ascertain the difference between the previous and last year’s data.

In this case, if management compares direct sales between 2007 and 2006 (the base year), it is clear that there is an increase of 3.2%. You can also use horizontal analysis in conjunction with both the balance sheet and the income statement. For example, if the base year amount of cash is $100, a 10% increase would make the current accounting period’s amount $110, whereas a 10% decrease my home is in foreclosure and i have a $100,000 gain! would be $90. To illustrate, consider an investor who wishes to determine Company ABC’s performance over the past year before investing. Assume that ABC reported a net income of $15 million in the base year, and total earnings of $65 million were retained. The company reported a net income of $25 million and retained total earnings of $67 million in the current year.

what is a horizontal analysis

Horizontal analysis is an approach used to analyze financial statements by comparing specific financial information for a certain accounting period with information from other periods. These examples demonstrate how horizontal analysis enables us to identify trends and patterns in various financial metrics. By analyzing changes in revenue, expenses, and assets over time, companies can make informed decisions and better understand their financial performance. Just like horizontal analysis, vertical analysis shows useful information and insights about the health of your finances.

Through horizontal analysis, we observe that Company A has experienced consistent revenue growth over the five-year period. The growth rates of 20%, 25%, 20%, and 11.11% indicate a positive trend in the company’s revenue generation. For more detailed representations of how horizontal analysis really works, here are a few examples with balance sheets, income statements, and retained earnings. The first step in horizontal analysis is grabbing the company’s financial statements. We’re talking about the Income Statement and Balance Sheet—the bread and butter of financial reporting. Through horizontal analysis of financial statements, you would be able to see two actual data for consecutive years and would be able to compare every item.

Step 1 of 3

Finance Strategists has an advertising relationship with some of the companies included on this website. We may earn a commission when you click on a link or make a purchase through the links on our site. All of our content is based on objective analysis, and the opinions are our own. Ratios such as asset turnover, inventory turnover, and receivables turnover are also important because they help analysts to fully gauge the performance of a business. Consistency and comparability are generally accepted accounting principles (GAAP).

For example, in Safeway Stores’ balance sheets, both sales and the cost of sales increased from 2018 to 2019. Horizontal analysis of income statements also produces worthwhile information. You can choose whatever interval (month-over-month, year-over-year, etc.), but each iterative financial statement should be equal distance away regarding when it was issued compared to other bits of financial information. Compared to horizontal analysis, the changes are not strictly presented as percentages and are also presented as variance (money amount). The percentage change approach is where the full force of the horizontal analysis formula comes in and changes are fully represented in percentage.

  1. You also need to reliably understand how your business is fairing and this is where financial statement analysis comes in.
  2. On the other hand, horizontal analysis looks at amounts from the financial statements over a horizon of many years.
  3. A trend is then determined and the level and quality of details you obtain from your financial statements depend on the software or accounting technique you use.
  4. Horizontal analysis looks at certain line items, ratios, or factors over several periods to determine the extent of changes and their trends.
  5. The 50% still represents a positive outcome from 2018 even though it still represents an overall decline in the growth of revenue.

Compound Annual Growth Rate (CAGR)

For instance, Horizontal Analysis through direct comparison involves comparing your $4.5 million 2019 revenue with your 2020 revenue of $6 million. With this method, the difference ($1.5 million) is taken note of and you quickly spot the change between the two periods. For this technique to be used, at least two financial statements (of the same type) need to be in existence. To get a more valid analysis, however, at least three financial statements are used. The more statements available and used for analysis, the greater the results obtained. In this GKSR example above, we can identify the YoY growth rate using a horizontal income statement analysis.

Free Financial Modeling Lessons

what is a horizontal analysis

A horizontal analysis of Jonick’s 2018 and 2019 income statements appears above. The first two columns show income statement amounts for two consecutive years. The amount and percentage differences for each line are listed in the final two columns, respectively. To further illustrate the practical application of horizontal analysis, let’s explore a few more examples that showcase its effectiveness in assessing financial performance and identifying trends. As seen from the above example, every ratio is given in relation to the revenue in the case of income statement. Companies and business owners like you make use of financial analysis techniques like horizontal analysis for both internal and external purposes.

One common method is using an inflation index or Consumer Price Index (CPI) to calculate the inflation-adjusted values. Martin loves entrepreneurship and has helped dozens of entrepreneurs by validating the business idea, finding scalable customer acquisition channels, and building a data-driven organization. During his time working in investment banking, tech startups, and industry-leading companies he gained extensive knowledge in using different software tools to optimize business processes. Rather than comparing revenues from 2019, Horizontal Analysis still compares the revenues of 2020 to 2018 (the base year). We’re diving into some real-life examples that’ll make horizontal analysis as easy as pie—or at least easier than understanding your phone bill.

The vertical analysis involves comparing financial data within a single period by expressing each line item as a percentage of a base figure, typically sales or revenue. It helps assess the composition and proportion of different components within financial statements. Horizontal analysis, on the other hand, compares financial data across multiple periods to analyze trends, changes, and growth rates.

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. Second, a variance analysis determines not only the dollar amount but the direction of change for a given general ledger account. Generally accepted accounting principles (GAAP) are based on the consistency and comparability of financial statements. Using consistent accounting principles like GAAP ensures consistency and the ability to accurately review a company’s financial statements over time.

This can be useful in identifying areas of concern for a business, as well as improving the performance of companies that are struggling. Horizontal analysis is the use of financial information over time to compare specific data between periods to spot trends. This can be useful because it allows you to make comparisons across different sets of numbers. Trends or changes are measured by comparing the current year’s values against those of the base year.

Determining the percentage change is important because it links the degree of change to the actual amounts involved. In this way, percentage changes are better for comparative purposes with other firms than are actual dollar changes. With the financial information in hand, it’s time to decide how to analyze the information. Carefully examine the percentage changes to understand the magnitude and significance of variations. Look for major fluctuations that may indicate critical events or shifts in the company’s operations. If inflation has influenced the financial data, it is essential to adjust the figures to account for its impact.

Horizontal Analysis of Financial Statements – Overview & Examples

Say goodbye to the hassle of building a financial model from scratch and get started right away with one of our premium templates. You can change your settings at any time, including withdrawing your consent, by using the toggles on the Cookie Policy, or by clicking on the manage consent button at the bottom of the screen. Finance and accounting experts with real-world experience write our articles. Prior to publication, articles are checked thoroughly for quality and accuracy.

However, it would be best if you had diligence, attention to detail, and a logical mind to decipher why the change happens. Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts. 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. The latter two tend to go hand-in-hand because the most useful benchmark against which to compare recent performance is most often the preceding period. For information pertaining to the registration status of 11 Financial, please contact the state securities regulators for those states in which 11 Financial maintains a registration filing.

Register / Login
WISHLIST
Login
Create an account

Password Recovery

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

SHOPPING BAG 0