Finance & metrics

Year over year growth calculator

This free year over year growth calculator — also called a YoY growth calculator or year-on-year growth tool — compares matching periods for revenue, sales, traffic, customers, or any KPI. Get YoY %, absolute change, and growth factor in Calculate YoY growth mode (with a prior vs current chart), plan targets in Project current value, work backward in Find prior value, or review a short series in Multi-year YoY table. Results update as you type; export CSV or PDF with no sign-up.

What is year-over-year growth?

YoY (year-over-year)

MoM / QoQ

Four ways to use this YoY calculator

Calculate YoY growth

Project current value

Find prior value

Multi-year YoY table

Year-on-year growth percentage formula

YoY growth rate

Planning and reporting only

Worked examples: calculate, project, reverse, and decline

Sales and revenue YoY growth

YoY vs CAGR vs ROI

YoY growth

CAGR

ROI

When to use which

YoY growth in Excel and Google Sheets

Basic YoY formula in Excel or Sheets
Monthly data — compare 12 rows above
Project next year from a target YoY %
Find prior value (reverse YoY)
Three or five years — YoY vs CAGR

What is a good YoY growth rate?

Established businesses

High-growth stage

Nominal vs inflation-adjusted growth

How to use this calculator

  1. Pick a mode

    Choose Calculate YoY, Project current value, Find prior value, or Multi-year YoY table — each mode matches a different planning question.

  2. Enter values for that mode

    Calculate: prior + current for the same period. Project: prior + target YoY %. Find prior: target current + target YoY %. Multi-year: 3 consecutive values (oldest first).

  3. Read YoY %, change, and factor

    Review YoY percentage, absolute change, growth factor, and (in calculate mode) the prior vs current chart or multi-year step table.

  4. Export or copy to Excel

    Export CSV or PDF for sharing, or copy the spreadsheet formulas from the Excel and Google Sheets section on this page.

Discover more calculators for time tracking, payroll, and HR.

Frequently asked questions about year over year growth calculator

How do you calculate year-over-year (YoY) growth?

Subtract the prior period from the current period, divide by the prior value, and multiply by 100. That is the year on year growth percentage formula in one line: ((Current − Prior) ÷ Prior) × 100 (same as (Current ÷ Prior − 1) × 100).

Use matching periods — for example this February vs last February. To find the prior value from a known current value and YoY %: Prior = Current ÷ (1 + YoY% ÷ 100) (Find prior value mode).

How can I calculate year-over-year growth in Excel?

Put the prior-year value in B1 and the current-year value in B2, then use =(B2-B1)/B1 and format the cell as a percentage. The same formula works in Google Sheets.

For monthly data, compare each month to the cell 12 rows above (same month last year). To project from a target rate use =B1*(1+C1) with YoY as a decimal in C1; to find prior use =B2/(1+C2).

What is the difference between YoY and CAGR?

YoY compares two same-period values one year apart and can change sharply each year. CAGR is the smoothed average annual rate over multiple years — one number for a whole span.

Use YoY for board KPIs by period; use our CAGR calculator when you need a single annualized rate across several years.

What is a good year-over-year growth rate?

It depends on industry and company stage — there is no single correct rate. Many established businesses aim for about 5–15% YoY revenue growth; high-growth companies may plan higher early on; e-commerce often lands near 10–25% when healthy.

Compare to your own history and peers. Check absolute change, not only the percentage, when the prior base was small (a large % can still be a modest dollar move).

How do I calculate YoY growth for 3 or more years?

Use Multi-year YoY table mode with three consecutive values (oldest first), or calculate YoY separately for each year pair in a spreadsheet. For one average rate across the full span, use CAGR on our CAGR calculator.

Can year-over-year growth be negative?

Yes. When the current value is lower than the prior value, YoY is negative — a year-over-year decline. Example: prior $120,000, current $100,000 gives YoY of about −16.67%.

The calculator still shows absolute change and growth factor so you can report the drop in dollars, not only the percentage.

What is the difference between YoY and month-over-month growth?

Month-over-month (MoM) and period-over-period views compare consecutive months or quarters; they can swing with seasonality and holidays. YoY compares the same month or quarter across years and is common in board and investor updates.

Does YoY growth account for inflation?

No — standard YoY is nominal (not inflation-adjusted). Deflate both values with a price index such as the US CPI before applying the formula if you need real growth.

Example: about 3% nominal YoY with similar inflation over the same span can mean flat real volume. See Nominal vs inflation-adjusted growth on this page.

How do I find last year's value from YoY growth?

Divide the current value by (1 + YoY rate as a decimal). Example: $100,000 current at 25% YoY implies prior = 100,000 ÷ 1.25 = $80,000.

In Excel or Sheets: current in B2, YoY in C2 as a decimal (0.25 for 25%): =B2/(1+C2).

Is YoY the same as percentage increase?

The math is the same as percent change between two values. YoY adds one rule: both values must come from matching periods one year apart (not any two dates). For general percent math, use our percentage calculator.

What does 25% YoY mean?

The current period is 25% higher than the same period last year. Example: $100,000 this year vs $80,000 last year is 25% YoY (and a $20,000 absolute increase).

When should I use YoY vs quarter-over-quarter?

Use quarter-over-quarter (QoQ) for near-term operational reviews. Use YoY when seasonality would distort back-to-back quarters and for annual planning comparisons.

What is the difference between YoY and YTD growth?

Year-to-date (YTD) compares cumulative results from the start of the calendar year through today versus the same calendar span last year. YoY can apply to any aligned period (a month, quarter, or custom window).

Use YTD for fiscal pacing; use YoY for seasonally aligned KPIs (for example March this year vs March last year).

Does this calculator show how $100 grows with compound interest?

No. That is compound interest or future value over many periods — not YoY between two business metrics (such as revenue this February vs last February).

For investment growth over time, use our compound interest calculator or future value calculator.