Stock investing often feels like diving into an ocean without a map.
Numbers fly past – revenue, expenses, margins.
But how do you know what really matters?
What if you could zoom out and see the bigger picture?
Identify patterns, spot trends, and connect the dots that others miss?
That's exactly what horizontal analysis offers.
A simple yet powerful tool that doesn’t just show you numbers but tells you a story.
A story about growth, struggles, and potential.
And the best part? It’s not reserved for financial gurus or Wall Street elites.
Anyone can use the horizontal analysis formula to uncover insights that go beyond surface-level stats.
Want to know if a company is growing steadily or just riding out a lucky streak? Curious whether expenses are under control or spiraling out of hand?
With horizontal analysis, you can answer these questions confidently.
What is Horizontal Analysis?
Think of horizontal analysis as a time machine for financial data. It is a method that looks at a company’s performance over time, helping you measure how key metrics (like revenue, expenses, or net income) have changed from one period to the next. By calculating the percentage or dollar changes year over year, it reveals trends that can guide smarter investing decisions.
At its core, horizontal analysis is about spotting movement. Are revenues steadily climbing, or are they flatlining? Are operating expenses spiraling out of control, or is the company tightening its belt? This approach not only looks at the numbers but also tracks their evolution. As a result, you get a clearer picture of where a company has been and where it might be headed.
This is an incredibly useful tool for investors. It helps you:
- Track trends: See how revenue, profit margins, or operating expenses have shifted over time.
- Understand context: Are these changes normal, or do they hint at deeper issues?
- Evaluate competitiveness: Compare a company’s progress with its industry peers.
Learn how to analyze revenue segments breakdown for public companies to gain deeper insights into performance across different business areas.
Let’s take a simple example: Imagine a company’s revenue was $100,000 in 2020 and $120,000 in 2021. Using horizontal analysis, you’d calculate the percentage increase like this:
(120,000 – 100,000) / 100,000 x 100 = 20%
That 20% increase tells a story. Maybe the company launched a new product, entered a new market, or benefited from a favorable economic shift.
In the end, horizontal analysis turns financial data into actionable insights. It allows you to understand what the past says about the future.
How to Perform Horizontal Analysis (Step-by-Step Guide)
Step 1: Choose the Metrics to Analyze
Decide which financial data you want to examine. Common choices include:
- Revenue (to measure growth)
- Gross Margin (to track profitability)
- Operating Expenses (to assess cost control)
- Net Income (to evaluate overall performance)
For companies in specific industries, you might focus on unique metrics like inventory levels for retail or R&D spending for tech.
Step 2: Apply the Horizontal Analysis Formula
Using the formula described above, calculate the horizontal analysis formula for each item you selected.
This will give you an understanding of how each item has changed from the base year to the current year.
The base year can be any period you choose; typically, this is year to year, quarter to quarter, or past trailing twelve months.
Step 3: Analyze the Results
Once you’ve calculated the horizontal analysis, it’s time to interpret what the numbers are telling you. Here’s how you can analyze results:
What to Look For
- Identify Patterns: Are there consistent trends across the years? For example, is ROE stable or declining?
- Spot Red Flags: Metrics like a high P/E ratio combined with high debt-to-equity might indicate overvaluation or excessive risk.
- Classify Performance: Use Excel's logical functions to automatically categorize results as "good" or "bad."
How Horizontal Analysis Fits Here
Horizontal analysis allows you to dig deeper:
- Compare P/E ratios across years to see if valuation is increasing disproportionately to performance.
- Track how ROE changes over time to assess management efficiency.
- Monitor trends in Debt-to-Equity to determine if a company’s financial leverage is improving or worsening.
Apple in Action: Real-World Example
To see how the formula works in a real-world scenario, let’s look at Apple.
In 2019, Apple’s revenue was $260.174 billion, and in 2020, it rose to $274.515 billion, resulting in:
(274.515 – 260.174) / 260.174 x 100 = 5.51%
Meanwhile, its gross profit margin increased from 37.82% in 2019 to 38.23% in 2020:
(38.23 – 37.82) / 37.82 x 100 = 1.1%
These metrics reveal consistent growth and profitability, which are key insights for investors evaluating Apple's performance over time.
Use Cases: Applying the Horizontal Analysis Formula
Horizontal analysis isn’t limited to a single part of financial statements; it can be applied across the Income Statement, Balance Sheet, and Cash Flow Statement to uncover valuable insights. Here’s how you can use it:
Pair horizontal analysis with these free DCF templates for stocks in Google Sheets to discover powerful valuation insights.
1. Income Statement: Analyzing Revenue, Expenses, and Net Income
The income statement is where horizontal analysis truly shines. By comparing revenue, operating expenses, and net income over time, you can measure growth and efficiency.
Example: Revenue Growth Calculation
Let’s say a company’s revenue in:
- 2021: $100,000,000
- 2022: $120,000,000
Using the horizontal analysis formula:
(120,000,000 – 100,000,000) / 100,000,000 x 100 = 20%
Takeaway: A 20% revenue growth suggests the company is expanding, but this should be analyzed alongside expenses and net income to ensure profitability is also improving.
What to Watch For:
- Revenue Growth: Consistent increases suggest business expansion.
- Operating Expenses: Watch if they grow faster than revenue (a warning sign).
- Net Income: Check if profits are increasing proportionally to revenue.
2. Balance Sheet: Evaluating Financial Stability
Horizontal analysis of the balance sheet tracks changes in assets, liabilities, and equity, giving you a picture of financial health over time.
Why It’s Important:
- Growth in assets like cash or inventory can signal business expansion.
- Rising liabilities (e.g., debt) might indicate risk if they outpace asset growth.
- Changes in equity reflect how well a company is retaining earnings.
Example: Asset and Liability Growth
- 2021 Assets: $500,000,000
- 2022 Assets: $550,000,000
Asset Growth:
(550,000,000 – 500,000,000) / 500,000,000 x 100 = 10%
- 2021 Liabilities: $200,000,000
- 2022 Liabilities: $250,000,000
Liability Growth:
(250,000,000 – 200,000,000) / 200,000,000 x 100 = 25%
Takeaway: Liabilities grew faster than assets, suggesting financial leverage is increasing. This could be risky if it’s not tied to growth in revenue or equity.
3. Cash Flow Statement: Tracking Inflows and Outflows
Horizontal analysis of the cash flow statement helps you see how cash is being managed year over year. It reveals trends in operating, investing, and financing activities.
Explore 13 essential cash flow metrics and their formulas to complement your horizontal analysis of cash flow.
What to Look For:
- Operating Cash Flow: Growth suggests the core business is generating more cash.
- Investing Cash Flow: Persistent outflows might indicate heavy investments in growth or acquisitions.
- Financing Cash Flow: Changes in debt repayments or dividend payouts can signal shifts in financial strategy.
Example: Operating Cash Flow Trend
- 2021 Operating Cash Flow: $50,000,000
- 2022 Operating Cash Flow: $60,000,000
Cash Flow Growth:
(60,000,000 – 50,000,000) / 50,000,000 x 100 = 20%
Takeaway: A 20% increase in operating cash flow indicates the business is generating more cash, which is a positive sign of operational efficiency.
Why Use Horizontal Analysis Across These Statements?
By applying horizontal analysis to the income statement, balance sheet, and cash flow statement, you can:
- Identify growth opportunities.
- Detect red flags like excessive debt or declining cash flow.
- Evaluate the company’s overall financial trajectory with greater confidence.
When combined, these insights provide a comprehensive view of a company’s financial health and potential for future success.
Automating Data Retrieval with Wisesheets
While Excel simplifies calculations, manually inputting data can still be time-consuming. That’s where Wisesheets comes in.
With Wisesheets, you can:
- Automatically pull historical financial data for any public company directly into Excel or Google Sheets.
- Save hours on data entry and focus on analyzing trends instead of hunting for numbers.
Explore the best Yahoo Finance API and its alternatives for automating financial data retrieval seamlessly.
How It Works:
- Enter a company’s ticker symbol in Wisesheets.
- Instantly retrieve income statements, balance sheets, and cash flow statements for multiple years.
- Use the preformatted Wisesheets template to calculate horizontal analysis automatically.
Download Our Free Horizontal Analysis Template
Get started with your own horizontal analysis in minutes! Download our free template and see how easy it is to track financial trends like a pro.
Note: You’ll need a Wisesheets account to access the template. Don’t have one yet? No problem – sign up for your free account here.
Common Mistakes and How to Avoid Them
Even with a powerful tool like horizontal analysis, it’s easy to fall into a few traps that can skew your insights or lead to poor decisions.
Here are the most common mistakes (and how to avoid them):
1. Overlooking Anomalies in Financial Data
Not all changes are part of a trend. One-time events like legal settlements, asset sales, or restructuring costs can create temporary spikes or dips in financial metrics.
Example: A company’s net income doubles in one year due to selling a large asset. If you treat this as sustainable growth, you’re missing the bigger picture.
How to Avoid It:
- Review financial notes or disclosures to understand what caused major changes.
- Separate recurring performance from one-time events to get a clearer view of the company’s trajectory.
2. Relying Solely on Percentage Changes Without Context
Percentage changes can be misleading when the base numbers are very small or if the changes don’t reflect meaningful growth.
Example: A 200% increase in operating cash flow sounds impressive, but if it’s growing from $1 million to $3 million in a billion-dollar company, it’s less impactful.
How to Avoid It:
- Always look at the raw numbers alongside percentage changes to understand scale and significance.
- Compare changes across multiple years to identify consistent trends.
3. Ignoring Industry Benchmarks
A company’s financial performance might look good in isolation, but it could still lag behind its competitors or industry standards.
Example: A retail company reports 5% revenue growth, but its competitors are growing at 15%. Without context, you might overestimate its performance.
How to Avoid It:
- Research industry averages or competitor data to benchmark your findings.
- Use tools like Wisesheets to pull competitor financials for easy comparisons.
4. Failing to Double-Check Data Accuracy
Even small errors in input data can lead to big mistakes in your analysis. Typos, incorrect formulas, or outdated information can skew your results.
Example: Using revenue data from different time periods (e.g., quarterly vs. annual) can distort percentage changes.
How to Avoid It:
- Cross-check all data with reliable sources like SEC filings or Wisesheets.
- Verify that formulas in Excel are applied correctly and consistently across your dataset.
FAQs About the Horizontal Analysis Formula
What is the formula for horizontal analysis?
The formula for horizontal analysis calculates the percentage change between two periods for a specific financial metric:
(Current Year – Base Year) / Base Year x 100 = Percentage Change
This formula helps track growth or decline over time. For example, if revenue grows from $100,000 to $120,000, the calculation would be:
(120,000 – 100,000) / 100,000 x 100 = 20%
How do you calculate horizontal analysis in Excel?
Excel makes horizontal analysis easy with its built-in formulas.
Learn how to use the Stockhistory function in Excel to retrieve historical data quickly for horizontal analysis.
Follow these steps:
Step 1: Enter your data for the base year and current year into columns.
step2: Use this formula in a new column to calculate the percentage change:
(Current Year – Base Year) / Base Year x 100 = Percentage Change
Step 3: Drag the formula down to apply it across multiple rows.
Step 4: Format the column as percentages for better readability.
Tip: Use conditional formatting in Excel to highlight significant changes.
3. Can horizontal analysis work for multiple years?
Absolutely! Horizontal analysis isn’t limited to just two periods. You can track financial changes over multiple years to identify long-term trends.
For example, if you’re analyzing revenue from 2020, 2021, and 2022, you can calculate the percentage change year-over-year:
- 2020 to 2021: (2021 – 2020) / 2020 x 100
- 2021 to 2022: (2022 – 2021) x 2021 x 100
This allows you to see how growth is accelerating, decelerating, or stabilizing.
What are the key benefits of using horizontal analysis?
Horizontal analysis provides several critical advantages:
- Trend Identification: Easily track financial performance over time.
- Better Decision-Making: Spot areas of growth or concern before making investment decisions.
- Competitor Benchmarking: Compare a company’s performance to industry peers.
- Clear Visualization: Transform raw data into actionable insights.
How does it differ from vertical analysis?
While horizontal analysis looks at changes over time, vertical analysis focuses on the relative size of components within a single financial statement.
- Horizontal Analysis: Compares year-over-year performance for the same metric (e.g., revenue growth).
- Vertical Analysis: Expresses each line item as a percentage of a base figure (e.g., gross profit as a percentage of revenue).
Both methods are complementary and offer unique insights into a company’s financial health.
Conclusion: Why Horizontal Analysis is a Must for Investors
Investing isn’t about throwing darts at a stock chart.
It's about seeing the big picture, understanding the story behind the numbers, and making smarter decisions.
Horizontal analysis gives you that edge. It's the flashlight that cuts through the fog of financial data, showing you where the real opportunities (and risks) lie.
With horizontal analysis, you uncover trends, spot red flags, and track progress like a pro. Revenue growth? Expense control? Profitability trends? They’re all laid bare, right in front of you.
But digging through financial reports and doing the math manually is a grind. It’s tedious, it’s time-consuming, and, let’s face it, mistakes happen.
That’s why tools like Wisesheets are a lifesaver. Why waste hours pulling data when you can have it all in seconds? Why risk mistakes when you can automate accuracy?
Discover the best Excel stock add-in for stock fundamentals and live data to simplify and enhance your analysis process.
If you’re serious about taking control of your investing strategy, don’t just sit on the sidelines. Download our free Horizontal Analysis Template and see how easy it is to track financial trends. Not signed up for Wisesheets yet? Get your free account here and make your analysis faster and stress-free.
The tools are here. The method is proven. Now it’s up to you. Take the guesswork out of investing and start making decisions backed by data – and confidence. Let’s go.
Hello! I'm a finance enthusiast who fell in love with the world of finance at 15, devouring Warren Buffet's books and streaming Berkshire Hathaway meetings like a true fan.
After completing my BBA degree in Finance at the Schulich Program in Toronto, Canada. I started my career in the industry at one of Canada's largest REITs, where I honed my skills analyzing and facilitating over a billion dollars in commercial real estate deals.
My passion led me to the stock market, but I quickly found myself spending more time gathering data than analyzing companies.
That's when my team and I created Wisesheets, a tool designed to automate the stock data gathering process, with the ultimate goal of helping anyone quickly find good investment opportunities.
Today, I juggle improving Wisesheets and tending to my stock portfolio, which I like to think of as a garden of assets and dividends. My journey from a finance-loving teenager to a tech entrepreneur has been a thrilling ride, full of surprises and lessons.
I'm excited for what's next and look forward to sharing my passion for finance and investing with others!
