Horizontal Analysis Definition, Formula, Example in Excel

We can use horizontal analysis on income statements, balance sheets, on any kind of account here, alright? Horizontal analysis of Wipro’s financial statements over two years provides insights into the company’s changing financial performance. While revenues declined slightly, Wipro improved gross profit margins and operational cash flows, indicating effective financial management the ugly truth about lying on your taxes despite a marginal drop in overall profitability. The cash flow statement is also beneficial for horizontal analysis, in addition to the income statement and balance sheet.

At least two accounting periods are required for a valid comparison, though in order to spot actual trends, it’s better to include three or more accounting periods when calculating horizontal analysis. Conceptually, the premise of horizontal analysis is that tracking a company’s financial performance in real time and comparing those figures to its past performance (and that of industry peers) can be very practical. A company’s financial statements – such as the balance sheet, cash flow statement, and income statement – can reveal operational results and give a clear picture of business performance.

What are the steps to perform a horizontal analysis on a balance sheet?

This setting allows for an objectively tax preparer mistakes reflecting on the relationships between different policies. Using −α reduces the influence of high provincial policy counts on central government policy pressure, ensuring that the significance of the latter is not diminished owing to an increase in the denominator. In terms of political forces, central government organizations, national organizations, and policy promoters drive the diffusion of public policies 31.

Example: Horizontal Analysis of a Cash Flow Statement

Since we do not have any further information about the segments, we will project the future sales of Colgate based on this available data. First, we noted that Colgate had not provided segmental information in the income statement. However, as additional information, Colgate has provided some details of segments on page 87.

Excel formulas simplify this process by performing calculations, filtering data, and providing summaries without the need for complex programming knowledge. The ability to manipulate datasets effectively is crucial for professionals working in business analytics, financial modeling, and performance tracking. If certain historical eras of underperformance are chosen as a comparison, horizontal analysis can be used to make the current period appear better. Having identified a trend, the next step is to try and understand the reasons behind it by carrying out a more detailed investigation.

In this second example, I will do a horizontal analysis of Company B’s current assets based on the annual balance sheets.
Subscription-based bookkeeping services are transforming the way businesses manage their finances, offering predictable pricing, scalability, and automation-driven efficiency.
If it changes its practice, it must disclose it in its financial statement notes.
The cash flow statement is also beneficial for horizontal analysis, in addition to the income statement and balance sheet.
With the widespread adoption of global sports governance principles, nations are actively developing and implementing public sports policies to facilitate their diffusion and achieve specific policy objectives.
Within China’s pressure-driven system, the process follows a “focus–motivation–execution” logic, in which factors of varying degrees of correlation affect the allocation of intergovernmental attention.

It’s going to be the 2161, the negative 2161 divided by the old gross profit of 12,704, and it gives us a negative 17%, right? That’s really good information for an investor, a creditor, and even the company itself, right? So let’s go ahead and pause here and now you guys try a horizontal analysis on an entire balance sheet, right?

Percentage Comparison

The method also enables the analysis of relative changes in different product lines and projections into the future. Looking at and comparing the financial performance of your business from period to period can help you spot positive trends, such as an increase in sales, as well as red flags that need to be addressed. Yes, horizontal analysis can be used on all financial statements, including income statements, balance sheets, and cash flow statements. This method allows for the evaluation of percentage changes in various account balances over different periods, providing a comprehensive view of a company’s financial performance and trends. By applying horizontal analysis to different financial statements, stakeholders can gain what is the cost principle and why is it important a deeper understanding of the company’s overall financial health and operational efficiency.

ROUND, ROUNDUP, ROUNDDOWN: Precision in Numerical Data

Learn how to use the Stockhistory function in Excel to retrieve historical data quickly for horizontal analysis. One-time events like legal settlements, asset sales, or restructuring costs can create temporary spikes or dips in financial metrics. Download our free template and see how easy it is to track financial trends like a pro. This will give you an understanding of how each item has changed from the base year to the current year. Using the formula described above, calculate the horizontal analysis formula for each item you selected.

You would need to have data for at least two periods to be able to do the horizontal analysis.
By contrast, regression analysis typically requires a complete dataset and assumes a normal distribution, emphasizing causal relationships but facing limitations in handling complex dynamic interactions 55.
Combining horizontal analysis with fundamental analysis provides a more comprehensive understanding of performance trends over time.
At least two accounting periods are required for a valid comparison, though in order to spot actual trends, it’s better to include three or more accounting periods when calculating horizontal analysis.
The period from 2016 to 2021 marks a pivotal transition in Chinese sports policy, from focusing on public health to enhancing international athletic competitiveness, aligning with the dual goals set in the Healthy China 2030 Planning Outline.
The consistency guidelines mean a company must use the same accounting principles across different accounting periods.

Step 1: Choose the Metrics to Analyze

Take the guesswork out of investing and start making decisions backed by data – and confidence. Discover the best Excel stock add-in for stock fundamentals and live data to simplify and enhance your analysis process. While Excel simplifies calculations, manually inputting data can still be time-consuming.

These formulas are used to evaluate trends which can either be quarter-on-quarter or year-on-year depending on the accounting period from which the data is sourced. For horizontal analysis, it’s best to take several years of historical data to gain useful insights into how a company is performing. Horizontal analysis, or “time series analysis”, is oriented around identifying trends and patterns in the revenue growth profile, profit margins, and/or cyclicality (or seasonality) over a predetermined period. Per usual, the importance of completing sufficient industry research cannot be overstated here. The comparability guidelines here mean that financial statement items must be reported to make them easier for comparison across multiple accounting periods. Industry benchmarking involves comparing a company’s financial performance to industry peers or standards.

However, when a province innovates and achieves favorable policy outcomes, it triggers a learning mechanism that significantly influences policy reproduction in other provinces. For instance, after Jiangsu’s “River Chief System” pilot policy gained central attention 52, a bottom-up diffusion mechanism emerged, prompting national policy adoption 75. The study designates economic level (annual GDP) and population size (end-of-year population total) as secondary indicators under the primary indicator of “policy actor”. Population size reflects the scope of public service demand and the extent of resource allocation pressures on local governments. Using year-end population totals enables tracking dynamic changes over time, thus showing the pressures faced by local governments in terms of resource distribution, infrastructure, and policy execution 64. Policy diffusion emerged as a field of research in the 1960s, with American scholars initially focusing on policy adoption, exploring why particular states adopt certain policies and not others 20.

Time Value of Money

If you are an investor considering investing in a company, only a year-end balance sheet or income statement would not be enough to judge how a company is doing. Better yet, you can see many years of balance sheets and income statements and compare them. With the widespread adoption of global sports governance principles, nations are actively developing and implementing public sports policies to facilitate their diffusion and achieve specific policy objectives. The following analysis will examines the specific impacts of primary and secondary indicators on the diffusion and reproduction of public sports policies, exploring the underlying decision-making mechanisms at work. Modern bookkeeping services go beyond basic record-keeping, offering CFO-level insights that help businesses improve cash flow, optimize expenses, and make data-driven financial decisions. Strategic bookkeepers provide real-time financial intelligence, track key performance indicators (KPIs), and ensure businesses remain audit-ready and investor-friendly.

It allows you to evaluate how effectively a company is converting its revenue into profits. By examining the changes in profitability over time, you can assess the company’s overall financial health. The final step in horizontal analysis is interpreting the results of your analysis.

Conceptualization of policy diffusion

Horizontal analysis can also be used to compare growth rates and profitability over a specific period across firms in the same industry. Consistency constraint here means that the same accounting methods and principles must be used each year since they remain constant over the years. Comparative financial statements serve as the cornerstone of horizontal analysis. These statements present financial data from different periods, often two or more years, side by side. This visual comparison enables you to identify patterns, changes, and trends in a company’s financial performance. Horizontal analysis is a financial analysis technique used to assess changes in a company’s financial statements over multiple periods, typically comparing current and past years.

Analysts are interested in assets that are utilised efficiently and have balances that are consistent with sales levels. The research determined that horizontal analysis offers substantial insights into financial trends, which facilitates the development of more informed strategic decisions. Additionally, the investigation demonstrated that organisations that implemented this approach experienced a 15% decrease in unforeseen financial discrepancies, which improved their overall financial stability and stakeholder confidence.

📆 Date: May 3-4, 2025🕛 Time: 8:30-11:30 AM EST📍 Venue: OnlineInstructor: Dheeraj Vaidya, CFA, FRM

When variety of innovative policies are adopted and diffusion occurs, policy diffusion mechanisms emerge. These effects are summarized by the terms “learning,” “competition,” “coercion,” and “imitation,” respectively 34. Learning, competition, coercion, and constructivist theories provide the theoretical basis for policy diffusion 12. Horizontal analysis evaluates percentage changes in account balances from one year to the next, aiding investors and creditors in financial statement analysis.

Owing to the inherently strong goal-orientation of central government policies, provincial governments often adopt a passive compliance strategy in the policy adoption process. This means prioritizing the adoption of policies that are highly emphasized by the central government, ensuring alignment with the central policy direction. This aligns with the top-down characteristics of policy diffusion theory 69, where legitimacy pressure from higher levels prioritizes compliance, limiting provincial innovation. Additionally, sports organizations (0.39) and learning effects (0.36) significantly influence policy text reproduction. Sports organizations provide localized information, distribution channels, and resources, enabling provincial governments to better understand and respond to regional needs.