Exploring Horizontal Analysis for Better Financial Insights
Horizontal analysis is a method used to evaluate financial data over multiple periods, allowing businesses to spot trends and patterns. This analysis provides a side-by-side comparison of financial statements, focusing on value changes over time. Typically, companies compare figures like revenue, expenses, or profit from a recent year to a base year. This approach helps identify whether a business is growing, stagnating, or declining.
The method is also called trend analysis because it shows a business’s performance trajectory. Companies can use horizontal analysis to track any financial data consistently over time. For example, companies may track annual sales revenue or quarterly operating expenses to determine growth patterns. By calculating dollar and percentage changes, organisations gain a clearer view of performance trends, helping them make informed decisions.
Types of Horizontal Analysis
Horizontal analysis can be approached in two distinct ways: dollar change and percentage change. Both methods help track the difference in financial data between periods, but they provide different insights. Below are the two types explained:
Dollar Change Horizontal Analysis
Dollar change horizontal analysis calculates the absolute difference between the values in two periods. It shows the exact monetary change, helping businesses and analysts see how much a financial figure has increased or decreased. This method is useful when you want to understand the real numerical change in line items like revenue, expenses, or net income.
Percentage Change Horizontal Analysis
Percentage change horizontal analysis calculates the relative change by dividing the dollar change by the base period value and multiplying by 100. This method is valuable when you want to understand the proportional growth or decline of financial figures in comparison to the size of the base period. It makes it easier to compare performance across companies of different sizes and helps in assessing how significant the change is relative to the business’s scale.
Both types of analysis provide valuable insights, but the choice between dollar change and percentage change depends on what you’re trying to evaluate—whether you want to see the exact increase or assess the proportional growth. Using both types together often gives the most comprehensive view of a company’s performance over time.
How to Perform Horizontal Analysis?
Performing horizontal analysis involves a few simple steps. The primary goal is to calculate the difference between financial data from a base period and a subsequent period and express this change in dollar and percentage terms. This process helps understand whether a company’s performance improves, declines, or remains steady.
Step 1: Identify the Periods to Compare
Start by selecting the base period and the period you want to analyse. For example, compare financial figures from 2022 to 2021. This step is crucial because the choice of periods will influence the insights derived from the analysis.
Step 2: Calculate the Dollar Change
The formula for calculating the dollar change is simple:
Dollar Change = Year of Analysis Amount – Base Year Amount
For example, if a company’s revenue in 2022 was £500,000 and £450,000 in 2021, the dollar change is:
£500,000 – £450,000 = £50,000 increase in revenue.
This gives a clear picture of the increase in monetary terms.
Step 3: Calculate the Percentage Change
Once you have the dollar change, calculate the percentage change using this formula:
Percentage Change = (Dollar Change / Base Year Amount) × 100
Using the same example, the percentage change would be:
(£50,000 / £450,000) × 100 = 11.11% increase.
This shows a relative increase of 11.11%, giving more context to the monetary change.
Step 4: Analyse and Interpret the Results
The percentage change provides a more standardised way to assess growth or decline. For example, a 50% increase in revenue is more meaningful than just knowing that revenue increased by £100,000, especially when comparing companies of different sizes.
When interpreting the results, it’s essential to consider the context. A positive change in revenue might indicate business growth, while a decline in expenses could suggest improved cost management. However, it is also essential to evaluate external factors that might influence the results, such as economic trends or changes in market conditions.
Applications of Horizontal Analysis
Horizontal analysis is an essential tool for businesses, investors, and analysts to evaluate financial performance over multiple periods. It can be applied to various financial statements such as the income statement, balance sheet, and other financial documents to uncover valuable insights. Below is how horizontal analysis can be applied to different financial statements:
Horizontal Analysis of the Income Statement
When applying horizontal analysis to the income statement, businesses can track key figures like revenue, cost of goods sold (COGS), and net income across multiple periods. By comparing these figures over time, it is easier to identify trends in profitability. For example, a consistent rise in revenue over several periods might indicate successful business expansion or increased product demand, while rising COGS in proportion to revenue could signal inefficiencies or higher production costs.
Changes in gross profit and operating income can further provide insights into a company’s ability to generate profit from core operations. Additionally, examining net income helps evaluate the company’s overall financial health, indicating whether profitability increases or declines over time.
Horizontal Analysis of the Balance Sheet
Horizontal analysis can also be applied to the balance sheet to evaluate changes in assets, liabilities, and shareholders’ equity over multiple periods. You can assess the company’s financial position and overall health by comparing these items. For instance, an increase in total assets suggests that the company is investing or expanding, while a decrease might signal asset disposals or financial difficulties.
In addition, analysing liabilities helps to determine whether the company is accumulating more debt or reducing its obligations. Changes in equity also reveal whether the company’s net worth is increasing or whether it needs to raise capital. This approach gives valuable insights into a company’s financial structure over time.
Horizontal Analysis of Financial Statements
Beyond just the income statement and balance sheet, horizontal analysis can be applied to other financial statements to track various economic indicators. You can better understand the company’s performance and financial trajectory by comparing figures like cash flow, retained earnings, or total liabilities over several periods. This approach is constructive when making projections for future performance based on historical trends.
The key to practical horizontal analysis is consistency and the ability to interpret long-term trends. Whether for internal use by management or external stakeholders like investors, horizontal analysis provides a valuable method for identifying patterns and forecasting future performance.
Horizontal Analysis Interpretation Example
To better understand how horizontal analysis works, consider the following example using the income statement of Goldman Sachs for two consecutive years:
Goldman Sachs Income Statement
- Revenue for 2021: £59,339 million
- Revenue for 2020: £44,560 million
Dollar Change Calculation:
£59,339 – £44,560 = £14,779 million increase
Percentage Change Calculation:
(£14,779 / £44,560) × 100 = 33.17%
This example shows that revenue increased by 33.17% from 2020 to 2021. Such information is valuable for understanding how quickly the company is growing. A similar analysis can be done for other line items such as gross profit, net income, or operating expenses.
Horizontal Analysis Formula in Excel
To perform the horizontal analysis calculation in Excel using the given Goldman Sachs example, follow these steps:
Step 1: Prepare Your Data
In your Excel sheet, input the revenue data for both years.
| Year | Revenue (£ Million) |
|---|---|
| 2020 | 44,560 |
| 2021 | 59,339 |
Step 2: Calculate Dollar Change
In Excel, use the following formula to calculate the Dollar Change:
Formula:
=B3-B2
Where B3 is the revenue for 2021, and B2 is the revenue for 2020.
For this example:
In cell C3 (next to the 2021 revenue), input:
=B3-B2
This will give you the dollar change, which is £14,779 million.
| Year | Revenue (£ Million) | Dollar Change (£ Million) |
|---|---|---|
| 2020 | 44,560 | |
| 2021 | 59,339 | 14,779 |
Step 3: Calculate Percentage Change
Next, calculate the Percentage Change by using the following formula:
Formula:
=(B3-B2)/B2*100
Where B3 is the revenue for 2021, and B2 is the revenue for 2020.
In cell D3 (next to the dollar change), input:
=(B3-B2)/B2*100
This will give you the percentage change, which is 33.17%.
| Year | Revenue (£ Million) | Dollar Change (£ Million) | Percentage Change (%) |
|---|---|---|---|
| 2020 | 44,560 | ||
| 2021 | 59,339 | 14,779 | 33.17% |
You can apply this same method to other line items in the income statement (such as COGS, gross profit, or operating expenses) by simply changing the reference cells in the formulas. For example, if you are analysing COGS, input the data for each year in the corresponding column and then apply the same formula for dollar and percentage change.
Horizontal vs Vertical Analysis
Horizontal and vertical analysis are complementary tools in financial analysis. While horizontal analysis focuses on changes over time, vertical analysis looks at financial statements in a single period, expressing each item as a percentage of a base amount.
Horizontal analysis compares the same line item across multiple periods. For example, analysing revenue growth over five years helps track a company’s performance and predict future trends. This approach highlights patterns and long-term shifts in financial health.
Vertical analysis, on the other hand, is used to assess the structure of financial statements. It expresses each line item as a percentage of a key figure, such as total revenue or total assets. For instance, on the income statement, cost of goods sold might be expressed as a percentage of total sales, revealing how much of the company’s revenue is consumed by production costs.
Example:
- In horizontal analysis, you might discover that a company’s operating expenses have increased by 15% over the past three years.
- In vertical analysis, operating expenses consistently represent 30% of total revenue.
Both methods provide valuable insights, but they serve different purposes. Horizontal analysis is best for identifying trends and tracking growth, while vertical analysis helps evaluate a company’s financial structure and efficiency within a single period.
Benefits of Horizontal Analysis
- Track Performance Trends Over Time – One of the key benefits of horizontal analysis is the ability to identify trends across multiple periods. By comparing financial data from different years, businesses can see growth patterns, helping them make informed decisions about future planning.
- Reveals Growth Opportunities for Businesses – For companies, horizontal analysis can uncover areas of growth. For example, if a retail business consistently sees increasing revenue, it may expand its operations. On the other hand, a decline in revenue could prompt management to investigate potential problems and take corrective actions.
- Assists Investors in Making Better Decisions – Investors rely on horizontal analysis to evaluate if a company is a good investment. By comparing financial performance over time, they can determine if the business is growing steadily or facing challenges. Consistent increases in net income might signal a healthy company, while fluctuating figures could suggest instability.
- Supports Financial Analysts in Forecasting – Financial analysts often use horizontal analysis to predict future trends. By examining past performance, they can create forecasts and financial projections, allowing businesses to allocate resources more effectively and set achievable goals.
- Valuable Tool for Benchmarking – Horizontal analysis also helps businesses benchmark their performance against competitors. For example, a tech company may compare its revenue growth to that of industry leaders like Apple or Google to assess its standing in the market. This can inform strategic decisions and highlight areas for improvement.
Limitations and Challenges
Despite the benefits, horizontal analysis has some limitations and challenges:
- Reliance on Consistent and Accurate Data – One of the primary challenges is the reliance on consistent and accurate data. The results can be misleading if the financial data used in the analysis is incomplete or inconsistent, such as when a company changes its accounting policies. For example, switching from a cash-based accounting system to an accrual-based system can make year-over-year comparisons less reliable.
- One-off Events Can Distort the Horizontal Analysis – One-off events like mergers, significant lawsuits, or economic downturns can significantly affect financial results, skewing the analysis. For instance, a company may see a sudden increase in operating expenses due to the acquisition of another company, which may not reflect the long-term trend. Analysts should review footnotes in financial statements to avoid misinterpretation to detect such anomalies.
- External Factors Impact Horizontal Analysis Results – External factors, such as economic conditions, industry regulations, or technological changes, can influence a company’s performance. For example, during a global recession, declining revenue may not be due to poor management but instead reflect broader economic challenges. Horizontal analysis should be used alongside other tools that consider these factors.
- Choosing the Right Periods for Comparison is Crucial – It is important to select the right periods when conducting horizontal analysis. Comparing only a few quarters may not provide a complete picture, while analysing longer periods gives a more accurate view of trends. For example, comparing only two years might show significant growth, but adding data from previous years could reveal a cyclical pattern or temporary recovery.
FAQs
What is the difference between horizontal and vertical analysis?
Horizontal analysis compares financial data across multiple periods to identify trends. In contrast, vertical analysis expresses each item in a financial statement as a percentage of a base figure within the same period. Horizontal analysis focuses on change over time, whereas vertical analysis focuses on structure.
What is the difference between horizontal analysis and trend analysis?
Horizontal analysis and trend analysis are closely related. Horizontal analysis focuses on changes between consecutive periods, whereas trend analysis often spans a more extended period to show patterns. Trend analysis uses percentage changes to reveal growth or decline trends over time.
What is horizontal analysis also known as?
Horizontal analysis is also known as trend analysis. It helps businesses monitor changes in financial performance by comparing multiple periods and calculating dollar and percentage differences to track growth patterns.
How to calculate the current ratio?
The formula for the current ratio is: Current Ratio = Current Assets / Current Liabilities. It measures a company’s ability to pay its short-term obligations. A higher ratio indicates better liquidity, while a lower ratio may signal financial difficulty.
What is the formula for trend?
The formula for trend percentage is: Trend Percentage = ((Current Period Value – Base Period Value) / Base Period Value) × 100. This calculation shows the percentage change from the base period, helping identify long-term growth or decline patterns.
