A Beginner’s Guide to Horizontal Analysis


A Beginner’s Guide to Horizontal Analysis

Sebarkan artikel ini

horizontal analysis formula

For example, a statement that says revenues have increased by 10% this past quarter is based on horizontal analysis. The percentage change is calculated by first dividing the dollar change between the comparison year and the base year by the line item value in the base year, then multiplying the quotient by 100. Developing your interpersonal skills and improving in Ways of Knowing you can better understand financial statement analysis. 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. Keep in mind that the comparative income statements and balance sheets for Banyan Goods are simplified for our calculations and do not fully represent all the accounts a company could maintain. When considering the outcomes from analysis, it is important for a company to understand that data produced needs to be compared to others within industry and close competitors.

banner 970x250
banner 970x250

Select the base and comparison periods and the values for your chosen variable, then calculate the percentage change between them. Calculating this involves subtracting the base period’s value from the comparison period‘s value, dividing the result by the base period’s value, then multiplying by 100. Depending on which accounting period an analyst starts from and how many accounting periods are chosen, the current period can be made to appear unusually good or bad. 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. All of the amounts on the balance sheets and the income statements for analysis will be expressed as a percentage of the base year amounts. The amounts from the most recent years will be divided by the base year amounts.


With different bits of calculated information now embedded into the financial statements, it’s time to analyze the results. The identification of trends and patterns is driven by asking specific, guided questions. For example, upper management may ask “how well did each geographical region manage COGS over the past four quarters?”. This type of question guides itself to selecting certain horizontal analysis methods and specific trends or patterns to seek out. Last, a horizontal analysis can encompass calculating percentage changes from one period to the next. As a company grows, it often becomes more difficult to sustain the same rate of growth, even if the company grows in pure dollar size.

horizontal analysis formula

The analysis of critical measures of business performance, such as profit margins, inventory turnover, and return on equity, can detect emerging problems and strengths. For example, earnings per share (EPS) may have been rising because the cost of goods sold (COGS) has been falling or because sales have been growing steadily. Begin by accumulating financial statements Accounting for a Non-Profit Organization from different quarters or years, as horizontal analysis is performed on financial statements throughout time. Suppose we’re tasked with performing horizontal analysis on a company’s financial performance from fiscal years ending 2020 to 2021. Average total assets are found by dividing the sum of beginning and ending total assets balances found on the balance sheet.

Overview: What is horizontal analysis?

Horizontal income statement analysis is typically done in a two-year manner, as shown below, with a variance that shows the difference between the two years for each line item. This may mean the company is maintaining too high an inventory supply to meet a low demand from customers. They may want to decrease their on-hand inventory to free up more liquid assets to use in other ways. The outcome of 0.53 means that for every $1 of assets, $0.53 of net sales are generated. An accounts receivable turnover of four times per year may be low for Banyan Goods. Given this outcome, they may want to consider stricter credit lending practices to make sure credit customers are of a higher quality.

  • By comparing financial data across periods, it helps identify patterns, variations, and potential areas of concern or improvement.
  • As the name suggests, trend analysis involves identifying trends and predicting outcomes, which requires analyzing data from multiple consecutive periods.
  • Depending on their expectations, Mistborn Trading could make decisions to alter operations to produce expected outcomes.
  • For example, upper management may ask “how well did each geographical region manage COGS over the past four quarters?”.

Google Sheets offers plenty of Data Analysis features that we can use to make sense of large data sets. Another option is to add as many years as would fit on the page without providing a variance, allowing you to view overall changes by account over time. Another option is to simply add as many years as would fit on the screen without presenting a variance, allowing you to monitor overall changes by account over time. Now we are going to explain what Financial Analysis is in general, so we can understand more about this specific type of analysis. We will apply this formula to each line item to calculate its absolute change. 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.

Relevance and Use of Horizontal Analysis Formula

Using Wisesheets, you can set up a template that automatically retrieves the data of any company/s you are looking for automatically by changing the ticker. The $43,000 is the operating income, representing earnings before interest and taxes. The 21.5 times outcome suggests that Banyan Goods can easily repay interest on an outstanding loan and creditors would have little risk that Banyan Goods would be unable to pay. If you purchased several fixed assets during 2018, the increase is easily explained, but if you didn’t, this would need to be researched. A further advantage is that it requires little skill to spot anomalies in a trend, while other forms of analysis may require extensive experience to discern whether the numbers in a presentation are indicative of problems.

horizontal analysis formula

Lenders, for example, may consider the outcomes of liquidity ratios when deciding whether to extend a loan to a company. A company would like to be liquid enough to manage any currently due obligations but not too liquid where they may not be effectively investing in growth opportunities. Three common liquidity measurements are working capital, current ratio, and quick ratio. When using the Horizontal Analysis Calculator, ensure accurate input of the financial data amounts for the current and base periods to obtain reliable results.

Terms Similar to Horizontal Analysis

Financial statement analysis reviews financial information found on financial statements to make informed decisions about the business. The income statement, statement of retained earnings, balance sheet, and statement of cash flows, among other financial information, can be analyzed. The information obtained from this analysis can benefit decision-making for internal and external stakeholders and can give a company valuable information on overall performance and specific areas for improvement. The analysis can help them with budgeting, deciding where to cut costs, how to increase revenues, and future capital investments opportunities. Cash in the current year is $110,000 and total assets equal $250,000, giving a common-size percentage of 44%. If the company had an expected cash balance of 40% of total assets, they would be exceeding expectations.

  • For example, a business may want to know how much inventory contributes to total assets.
  • An accounts receivable turnover of four times per year may be low for Banyan Goods.
  • Most horizontal analysis entail pulling quarterly or annual financial statements, though specific account balances can be pulled if you’re looking for a specific type of analysis.
  • These percentages are considered common-size because they make businesses within industry comparable by taking out fluctuations for size.
banner 970x250