Get the YOY Growth Practice Workbook
Want the file without building it from scratch? Download the ready-to-use workbook and follow along with every method in this tutorial.
- Practice calculating year-over-year growth with real financial data
- See both YOY formulas already set up and ready to test
- Includes percentage formatting and data bar examples to visualize change
Enter your email below for instant access.
What Is Year-Over-Year (YOY) Growth?
Year-over-year (YOY), also called year-on-year, compares a specific metric from one period to the identical period 12 months earlier. This method is standard in financial reporting because it removes seasonal effects and reveals whether a company’s performance is genuinely improving, staying flat, or declining.
For example, comparing Q4 2025 revenue to Q4 2024 revenue shows growth that is not distorted by holiday shopping spikes or summer slowdowns. That is why earnings reports from companies like Alphabet, Apple, and Amazon always highlight YOY changes.
Why YOY Analysis Matters
YOY analysis is useful across multiple roles and situations:
Financial reporting: Public companies report YOY changes for revenue, net income, and earnings per share in every quarterly earnings release.
Investor analysis: Investors use YOY growth to compare companies within the same industry and assess whether growth is accelerating or decelerating.
Marketing and operations: Teams track YOY changes in customer acquisition, website traffic, conversion rates, and cost metrics to evaluate strategy effectiveness.
Budgeting and forecasting: Historical YOY growth rates serve as a foundation for realistic revenue projections and expense planning.
Real-World YOY Example: Alphabet Q4 2025
In Q4 2025, Alphabet (Google’s parent company) reported revenue of $113.8 billion, an 18% increase compared to $96.5 billion in Q4 2024.
Net income rose roughly 30% YOY to $34.5 billion. This single comparison tells investors more about Google’s growth trajectory than any single-quarter number could on its own.
YOY Growth Formula
There are two common ways to express the YOY growth formula. Both return the same result.
The Standard YOY Formula
The most widely used version:
YOY Growth = New Value / Old Value - 1
Where:
- New Value = the metric for the current period (e.g., Q4 2025 revenue)
- Old Value = the same metric for the identical period one year earlier (e.g., Q4 2024 revenue)
Using the Alphabet example: ($113.8B / $96.5B) – 1 = 0.179, or approximately 18% YOY growth.
Alternative Formula
Some analysts prefer the subtraction-first version:
YOY Growth = (New Value - Old Value) / Old ValueBoth formulas produce identical results. Use whichever feels more intuitive. The first version has fewer parentheses in Excel, which makes it slightly easier to read in formulas.
Tip: This same formula works identically in Google Sheets. No modifications needed.
For a detailed explanation about percentages, check out our post about How to Calculate Percentage in Excel.
How to Calculate YOY Growth in Excel (Step by Step)
Suppose you are given this set of financial data.
Your task is to calculate the YOY growth in Excel for each of the financial metrics.
Step 1: Enter the YOY Formula
In the case of revenue, it would be this Excel formula:
=D4 / C4 - 1
Press enter and drag the formula down to the cells below it.
Step 2: Format as Percentage
Highlight the YOY Change column, right-click, select “Format Cells,” choose “Percentage,” and set the number of decimal places.
Your table should now look like this:
Visualize Year-Over-Year Changes
To better visualize the results, we’ll use conditional formatting to add data bars.
Step 1: Add Formulas
- Next to the cell with the YOY change, add the formula (e.g., F4):
=E4- Drag the formula down to the other cells.
Step 2: Apply Conditional Formatting Data Bars
- Select YOY Change Column: Highlight the cells containing the YOY changes (e.g., E4).
- Go to Conditional Formatting: Click on the “Home” tab in the Excel ribbon, then select “Conditional Formatting.”
- Choose Data Bars: Select “Data Bars” and choose “More Rules…”
- Show Bar Only: Check the box to only show the bar without the values
- Select fill color for positive deviation: Use the drop down to select a color indicating positive change
- Select fill color for negative deviation: Click on “Negative Value and Axis…” and select a color indicating negative change
- Confirm: click on OK to confirm the changes
This will highlight the percentage change. If a value had negative change, it will be highlighted in red.
Year-Over-Year analysis helps track growth and make better decisions. Using Excel to calculate YOY growth is easy and gives you clear insights into your data trends.
Try it out with our practice workbook and see the difference!
Common YOY Metrics in Financial Analysis
While you can apply YOY analysis to virtually any numeric metric, certain financial measures are analyzed this way more than others. Here are the most common:
- Sales Revenue: The top-line number. YOY revenue growth shows whether a company is selling more goods or services compared to the prior year. This is typically the first metric investors look at.
- Net Income: Revenue growth means little if profits are not following. YOY net income growth reveals whether the company is actually becoming more profitable, not just bigger.
- Earnings Per Share (EPS): EPS accounts for share buybacks and dilution. YOY EPS growth is the metric most directly tied to stock valuation and is highlighted in every earnings report.
- Cost of Goods Sold (COGS): Rising COGS on a YOY basis can signal supply chain issues, input cost inflation, or declining supplier terms.
- Selling, General & Administrative Expenses (SG&A): YOY SG&A growth that outpaces revenue growth can indicate operational inefficiency or over-hiring.
- Earnings Before Interest and Taxes (EBIT): Also called operating income. YOY EBIT growth strips out financing decisions and tax strategies to show core operational performance.
Expert Tip: Track 3-5 of these metrics together, not just one. Revenue growing 20% YOY sounds great until you realize COGS grew 35% YOY. The full picture matters.
YOY vs. MoM, QoQ, CAGR, and YTD
YOY is one of several growth comparison methods. Each serves a different purpose. Here is how they compare:
| Metric | What It Compares | Best For | Removes Seasonality? |
|---|---|---|---|
| YOY | Same period, prior year | Annual trends, earnings reports | Yes |
| MoM | Month vs. prior month | Short-term shifts, early signals | No |
| QoQ | Quarter vs. prior quarter | Mid-term trends, quarterly reviews | Partially |
| CAGR | Multi-year annualized rate | Long-term growth, investor decks | Yes |
| YTD | Start of year to current date | Progress tracking vs. annual goals | No |
When to Use Each Metric
- Use YOY when you need to compare annual performance while eliminating seasonal noise. This is the standard for earnings calls, annual reports, and investor presentations.
- Use MoM when you need to spot short-term changes quickly. Useful for SaaS startups tracking monthly recurring revenue (MRR) or marketing teams watching campaign performance week to week.
- Use QoQ for mid-range analysis, especially in industries with quarterly business cycles. Useful alongside YOY to see if growth is accelerating within the current year.
- Use CAGR when comparing growth over 3+ years. CAGR smooths out volatility and gives a single annualized growth rate, which is ideal for long-range planning and investment analysis.
- Use YTD to measure how you are tracking against annual targets. It answers the question: Are we on pace to hit this year’s goals?
Pro Tip: Do not rely on just one metric. A company might show strong YOY growth but declining QoQ growth, which could signal momentum is slowing. Use multiple metrics together for the full picture.
Limitations of YOY Analysis
YOY is powerful but not perfect. Understanding its blind spots will help you avoid drawing wrong conclusions from your data.
The Base Effect
If last year’s numbers were unusually high or low due to a one-time event, YOY growth can be misleading. For example, a company that had a massive product recall in Q3 2024 will likely show inflated YOY revenue growth in Q3 2025, even if the business only returned to normal levels. This is called the “base effect” and it is one of the most common pitfalls in YOY analysis.
Similarly, companies that benefited from an unusual event (like a pandemic-driven demand surge) may show negative YOY growth simply because the comparison period was abnormally strong.
Missing Short-Term Trends
Because YOY compares 12-month intervals, it cannot tell you what happened between those two data points. A company might show 15% YOY revenue growth, but if most of that growth happened in Q1 and revenue has been declining every quarter since, the YOY number hides a critical trend.
For fast-moving businesses or volatile markets, combine YOY with QoQ or MoM analysis to catch momentum shifts early.
External Factors and Context
YOY numbers do not explain causation. Revenue could grow 25% YOY because of a strong sales strategy or because the entire industry grew 30% (meaning you actually underperformed the market).
Always pair YOY analysis with context: industry benchmarks, macroeconomic conditions, competitor performance, and any structural changes (mergers, product launches, pricing changes) that could affect the numbers.
Bottom line: YOY tells you WHAT changed. It does not tell you WHY. Always dig deeper before making decisions based on a single YOY number.
Using Excel Copilot for YOY Analysis (2026)
Microsoft has added several AI-powered features to Excel that are relevant to YOY calculations. Here is what you need to know.
Formula AI Auto-Completion
If you have a Microsoft 365 Copilot license, Excel now suggests formulas as you type based on surrounding context. When your column header is something like “YOY%” or “YOY Change,” Copilot recognizes the pattern and auto-suggests the correct percentage change formula. You can accept the suggestion with one click and drag it down.
This is especially helpful if you are less familiar with formula syntax. Copilot also shows a plain-language explanation of what the formula does before you accept it.
Edit with Copilot (Formerly Agent Mode)
The editing experience in Copilot goes further than formula suggestions. Give it a prompt like “Analyze YOY growth for all metrics in this table” and it will create the formulas, format the results as percentages, and generate a chart. Copilot plans, executes, and validates multi-step tasks directly inside your workbook.
Microsoft renamed this from “Agent Mode” to “Edit with Copilot” in early 2026, and it went generally available in Word, Excel, and PowerPoint in April 2026. It now works on local files too. No need to save to OneDrive or SharePoint first.
Useful for quick exploratory analysis or building a dashboard from scratch. Always review the output. Copilot can make mistakes, especially with complex layouts or unusual data structures.
When to Use Traditional Formulas vs. Copilot
Microsoft explicitly recommends using native Excel formulas (like SUM, AVERAGE, and the YOY formula covered above) for any task that requires numerical accuracy and reproducibility.
The =COPILOT() function is designed for text classification, sentiment analysis, and content generation. It is not reliable for math.
For YOY calculations, stick with the traditional formula: =D4/C4-1. It is deterministic (same input always gives the same output), auditable, and does not require a Copilot license.
Use Formula AI and Edit with Copilot as productivity boosters for setup, formatting, and chart creation, but keep the core math in standard Excel formulas.
Frequently Asked Questions
What is a good YOY growth rate?
It depends on the industry and the metric. As a general benchmark, 15-25% annual revenue growth is considered strong for established companies. High-growth startups may target 50-100%+ YOY growth, while mature industries like utilities or consumer staples may consider 3-5% to be solid.
The most important comparison is against your own historical trend and your direct competitors, not an arbitrary number.
Can I calculate YOY in Google Sheets?
Yes. The formula is identical. Use =B2/A2-1 (where B2 is the current year value and A2 is the prior year value), then format the cell as a percentage.
Google Sheets handles this exactly the same way as Excel.
What is the difference between YOY and CAGR?
YOY measures growth between two specific periods (e.g., Q4 2025 vs. Q4 2024). CAGR (Compound Annual Growth Rate) smooths growth across multiple years into a single annualized rate.
Use YOY for period-specific analysis. Use CAGR when you need one number to represent growth over 3, 5, or 10 years.
How do I calculate YOY for quarterly data?
Use the same formula, but compare the same quarter across years. For example, to calculate Q2 YOY growth, compare Q2 2025 to Q2 2024.
Do not compare Q2 2025 to Q1 2025. That is QoQ (Quarter-over-Quarter), which is a different metric.
What if my base year value is zero or negative?
If the base value is zero, the formula returns a division error. Wrap it in IFERROR: =IFERROR(D4/C4-1, “N/A”). If comparing a loss to a profit (or vice versa), the percentage result can be confusing.
In those cases, report the absolute dollar change instead of (or alongside) the percentage.
Download the Workbook
Enhance your learning experience by downloading our workbook. Practice the techniques discussed in real-time and master YOY growth calculation in Excel with hands-on examples.
Download the workbook here and start applying what you’ve learned directly in Excel.
Featured Bundle
Black Belt Excel Bundle
Leila Gharani
Founder of XelPlus and ten-time Microsoft MVP. Leila helps over 500,000 professionals master Excel, Power BI, and data automation through practical, real-world training.
