# Year-Over-Year Growth Calculator, Formula & Examples

Nikita Shrivastava

Updated on: April 28th, 2026⋅Published on: April 28th, 2026⋅7 mins read

> TL;DR Year-over-year growth measures how a metric changes compared to the same period last year, removing seasonality. Use a simple formula to calculate it, compare trends accurately, and pair it with MoM, QoQ, or CAGR for a complete view.

Year-over-year growth tells you how a metric changed compared to the same period one year ago. Revenue this Q2 versus last Q2. Users this March versus last March. It's the simplest way to calculate growth over last year while stripping out seasonality, something monthly numbers can't do.

If you're here, you probably need the formula. Here it is.

## The Year Over Year Growth Formula

_YoY Growth Rate (%) = ((Current Period Value − Prior Period Value) / Prior Period Value) × 100_

That's it. Subtract last year from this year, divide by last year, and multiply by 100. You can calculate year-over-year growth for any metric (revenue, sales, headcount, page views, churn rate) as long as you have two comparable data points exactly one year apart. This is why it shows up so often in [reporting workflows across teams](/content/blogs/ai-agent-use-cases/index.html).

### Year-Over-Year Growth In Excel or Google Sheets

Use =((B2-B1)/B1)*100 where B1 is last year's value and B2 is this year's. Or use =(B2/B1)-1 and format the cell as a percentage. Same result, cleaner output. In Tableau, create a calculated field with (ZN(SUM([Metric])) - LOOKUP(ZN(SUM([Metric])), -1)) / ABS(LOOKUP(ZN(SUM([Metric])), -1)) using a table calculation on the year dimension.

## Year Over Year Growth Calculator

Don't want to do the math? Our free YoY growth calculator lets you get your growth rate in seconds. Just type in your numbers, or connect a data source and let it pull the figures for you.

[YoY Growth Calculator](https://console.thesys.dev/app/PKf1ENJXpHslsvKs56OKb)

You can calculate YoY growth for revenue, expenses, churn, or any metric you track. Compare growth across business segments. Ask it to explain what a negative growth rate means in context, and much more.

Now let's walk through the formula with real numbers.

## Worked Examples

### Example 1: Revenue and Sales Growth

Your company did $800,000 in revenue in Q3 2024 and $920,000 in Q3 2025.

> YoY Growth = (($920,000 − $800,000) / $800,000) × 100 = 15%

Revenue grew 15% year over year. Straightforward. This is the most common use case: calculating sales growth year-over-year for board decks, investor updates, and earnings reports. The same formula works whether you're measuring total revenue, sales by region, or growth percentage over last year for a specific product line.

### Example 2: Monthly Active Users

Your product had 12,000 monthly active users in January 2025 and 18,600 in January 2026.

> YoY Growth = ((18,600 − 12,000) / 12,000) × 100 = 55%

User base grew 55% YoY. Note that we're comparing January to January, same month, different year. That's the whole point of year-over-year growth. It neutralizes seasonal patterns that would skew a month-over-month comparison.

### Example 3: MRR (Monthly Recurring Revenue)

Your SaaS product had $45,000 MRR in June 2024 and $63,000 MRR in June 2025.

> YoY Growth = (($63,000 − $45,000) / $45,000) × 100 = 40%

MRR grew 40% year over year. For SaaS companies, this is one of the most-watched metrics. Investors use it to benchmark you against peers and assess whether your growth rate justifies your valuation.

### Example 4: Churn Rate (When Growth Is Negative)

Your monthly churn rate was 2.1% in March 2025 and 3.4% in March 2026.

> YoY Growth = ((3.4 − 2.1) / 2.1) × 100 = 61.9%

Churn grew 61.9% year over year. This is a case where year over year growth going up is bad news. A rising churn rate means you're losing customers faster than before. Always interpret the direction of change in context. Growth in a cost or loss metric is not something to celebrate.

## Common Mistakes to Avoid

**Mixing time periods.** Comparing Q3 to Q4 instead of Q3 to Q3 defeats the purpose. Year over year means same period, different year. If you compare revenue from a holiday quarter to a non-holiday quarter, you're measuring seasonality, not growth.

**Using the wrong denominator.** The denominator is always the prior period value. A surprising number of spreadsheet errors come from accidentally dividing by the current period instead. If your revenue went from $500K to $750K, you divide by $500K (the old number), not $750K.

**Ignoring one-time events.** If last year's Q2 included a massive one-off contract or a product launch spike, your YoY number will look artificially low this year. Call out anomalies when reporting. Raw year over year growth without context can mislead.

**Confusing percentage points with percentages.** If your conversion rate went from 4% to 5%, that's a 1 percentage point increase but a 25% year over year increase. These are very different numbers. Be explicit about which one you're reporting.

**Starting from zero or near-zero.** If your prior period value is $0 or close to it, the formula breaks. Going from $500 to $50,000 is technically 9,900% growth, which is mathematically correct but practically meaningless. In early-stage scenarios where you're measuring from a near-zero base, absolute numbers tell a more honest story than percentages.

**Not adjusting for calendar differences.** February has 28 days (or 29). March has 31. If you're comparing monthly metrics year over year, the day count difference alone can swing your results by 5 to 10%. Normalize to a per-day or per-business-day rate when precision matters.

## When to Use YoY vs. Other Growth Metrics

Year over year growth is not the only way to measure change. Here's when each metric makes sense.

**Year over year (YoY)** is best for annual planning, board reporting, investor updates, and any context where you need to remove seasonality. It's the default for most external communications.

**Month over month (MoM)** is useful for tracking short-term momentum, catching problems early, and internal dashboards where these [metrics are tracked side by side](/content/blogs/embedded-analytics/index.html). The downside is that it's noisy. A strong December followed by a normal January will always look like a decline.

**Quarter over quarter (QoQ)** splits the difference. It's smoother than MoM and more responsive than YoY. Good for sales teams and operational reviews where you need to see trends within the year.

**Compound annual growth rate (CAGR)** measures average year over year growth across multiple years. Use it when you need to smooth out volatility across a 3, 5, or 10-year window.

**The formula:**

> CAGR = ((Ending Value / Beginning Value) ^ (1/n)) − 1

where n is the number of years. So if revenue went from $1M to $4M over 5 years, your CAGR is (($4M / $1M) ^ (1/5)) − 1 = 32%.

It's the metric investors use to compare companies at different stages. CAGR won't tell you what happened in any single year, but it gives you the average growth rate year-over-year for the entire period.

As a rule of thumb: use MoM to operate, QoQ to manage, YoY to report, and CAGR to fundraise.

## What Counts as "Good" Year-Over-Year Growth?

It depends on your stage, your industry, and what you're measuring.

For early-stage startups, investors generally expect revenue growth of 100% or more year over year. The T2D3 framework (triple, triple, double, double, double) that many VCs reference implies 200% YoY in the earliest years, tapering to 100% as the company scales.

For mid-stage SaaS companies doing $10M to $50M ARR, 40 to 80% YoY revenue growth is considered strong. The "Rule of 40," where growth rate plus profit margin should exceed 40%, is a common benchmark at this stage.

For mature public companies, 10 to 25% YoY growth is solid. At scale, sustaining even 15% annual growth requires significant operational execution.

For non-revenue metrics like users, traffic, or engagement, benchmarks vary too widely by industry to generalize. Compare against your own historical performance and direct competitors rather than looking for universal standards.

Context also matters when growth decelerates. Going from 150% YoY to 80% YoY might look alarming in a board slide, but it's perfectly normal as a company scales. Growth rates naturally compress as the denominator gets larger. A $2M company doubling to $4M is a different challenge than a $50M company trying to hit $100M. Investors and operators who understand this focus on growth efficiency (how much does each point of growth cost) rather than the raw percentage.

One more thing: always report the absolute numbers alongside the percentage. "Revenue grew 200% year over year" sounds impressive until you learn it went from $10,000 to $30,000. Percentages without context are a common source of misleading narratives, especially in early-stage reporting.

## Start Calculating

The year-over-year growth formula is simple. The hard part is applying it consistently, choosing the right time periods, and interpreting the results in context.

If you need a quick answer, use the [YoY growth calculator](https://console.thesys.dev/app/PKf1ENJXpHslsvKs56OKb) at the top of this post. It won't just give you the growth rate. You can drill down further: ask what's driving the change, compare growth across segments, interpret negative results, or break down the math for a specific metric like expenses or churn, and [get all this as interactive, actionable insights powered by Generative UI](/content/blogs/generative-ui/index.html) instead of walls of text or static dashboards.