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?
Year-over-year (YoY), also written year-on-year, measures how a metric changed between the same period in two consecutive years — for example Q2 this year vs Q2 last year, or February vs February.
That alignment reduces seasonality that can skew month-over-month or quarter-over-quarter views. Finance teams, operators, and investors often use YoY for revenue, expenses, headcount, web traffic, and similar KPIs.
YoY answers whether a metric is up or down versus the same period last year — not how much you have accumulated year-to-date (see YTD in the FAQ). Pick a calculator mode in the next section once you know which inputs you have.
YoY (year-over-year)
Same month or quarter, one year apart. Common in board packs and investor updates when you need an apples-to-apples read.
MoM / QoQ
Month-over-month or quarter-over-quarter compares consecutive periods. Useful for operations; can swing with holidays and seasonality.
Four ways to use this YoY calculator
Each mode updates live as you type — no submit button.
Use Calculate YoY growth when you have last period and this period actuals. Use Project current value for planning from a baseline and target rate. Use Find prior value when this period’s goal is fixed and you need the implied prior number. Use Multi-year YoY table when you have at least three consecutive totals and want YoY for each step (not one blended CAGR).
Calculate YoY growth
Enter prior and current for the same window (for example last February vs this February). You get YoY %, dollar change, growth factor, and a prior vs current chart.
Project current value
Enter last period’s value and a target YoY % to see the implied current value — for example 20% sales growth from a known baseline.
Find prior value
Enter a target current value and target YoY % to work backward to the prior period value that would produce that outcome.
Multi-year YoY table
Enter three consecutive period values (oldest first) to see YoY % for each step in a table. For longer histories, use a spreadsheet or our CAGR calculator for one smoothed rate.
Year-on-year growth percentage formula
YoY growth rate
YoY % = ((Current − Prior) ÷ Prior) × 100
This is the standard year on year growth percentage formula: subtract the prior period, divide by the prior period, multiply by 100. The same result as (Current ÷ Prior − 1) × 100, often written as growth factor minus 1.
Negative values mean a year-over-year decline. A growth factor of 1.25 equals 25% YoY.
In words: subtract prior from current, divide by prior, multiply by 100. The calculator applies this formula automatically as you type.
Planning and reporting only
Results are for education and internal planning, not tax, audit, or investment advice. Match your company’s accounting period definitions when reporting official metrics.
Worked examples: calculate, project, reverse, and decline
Calculate YoY: Last February revenue was $80,000; this February is $100,000. YoY = ((100,000 − 80,000) ÷ 80,000) × 100 = 25%, absolute change $20,000, growth factor 1.25.
Project current value: Prior period $850,000 with a 20% YoY target gives current = 850,000 × 1.20 = $1,020,000 (Project current value mode).
Find prior value: Target current $100,000 at 25% YoY implies prior = 100,000 ÷ 1.25 = $80,000 (Find prior value mode).
Multi-year steps: Totals $90,000 → $100,000 → $111,111 (oldest first) give 11.11% YoY on the latest step (Multi-year YoY table presets).
Decline: Prior $120,000, current $100,000 → YoY ≈ −16.67% — a valid year-over-year drop, not an error.
Sales and revenue YoY growth
For sales growth, YoY uses the same math when you compare this year’s sales to the same period last year: last year in the prior field, this year in the current field. The YoY % is your headline sales growth rate.
You can apply the same approach to units sold, active customers, or average order value if both periods use the same definition. Strong order growth with flat average order value usually points to demand, not price mix alone.
Modeling runway alongside top-line growth? Pair YoY revenue with our break-even calculator or burn rate calculator.
YoY vs CAGR vs ROI
These metrics answer different questions. YoY is the change between two matching periods — it can jump when one year included a promotion, outage, or one-off deal. CAGR is one average annual rate across a span, which smooths volatility in between. ROI compares gain to cost for a specific investment, not calendar-aligned operating KPIs.
Example: revenue moves from $50,000 to $100,000 (100% YoY), then to $130,000 (30% YoY). YoY tells the story each year; CAGR from $50k to $130k over two years is about 61% per year — one figure for long-range comparisons.
YoY growth
Best for: two same-period values one year apart.
Formula idea: (Current − Prior) ÷ Prior
CAGR
Best for: smoothed rate over multiple years.
Formula idea: (End ÷ Start)^(1/n) − 1
ROI
Best for: return on money invested.
Formula idea: (Gain ÷ Cost) × 100
When to use which
Headline period-over-period change → YoY. Long-run average growth → CAGR. Spend vs return on a project → ROI.
Need headline YoY for a single period pair? Stay on this page. Need a smoothed multi-year rate? Try the CAGR calculator. Need return on spend for a project? Use the ROI calculator.
YoY growth in Excel and Google Sheets
Basic YoY formula in Excel or Sheets
With prior-year value in cell B1 and current-year value in B2, use =(B2-B1)/B1 and format the cell as a percentage. The same formula works in Google Sheets.
Subtract prior from current, divide by prior, multiply by 100 if you are not using percentage formatting.
Monthly data — compare 12 rows above
For a column of monthly revenue (or any KPI), put each month in row 2, 3, 4… and compare to the cell 12 rows above (same month last year). In row 14 for February 2026, for example: =(B14-B2)/B2 if February 2025 lives in B2.
That pattern keeps seasonality out of the comparison — unlike month-over-month formulas that compare January to December.
Project next year from a target YoY %
With prior-year value in B1 and target YoY rate in C1 (as a decimal, 0.20 for 20%): =B1*(1+C1).
Matches Project current value mode in the calculator above.
Find prior value (reverse YoY)
With current value in B2 and YoY rate in C2 (decimal): =B2/(1+C2). Example: 100,000 at 25% YoY → prior = 80,000.
Three or five years — YoY vs CAGR
Chain YoY for each year pair in a sheet, or use Multi-year YoY table mode for three consecutive totals. For one smoothed average across the full span, use the CAGR calculator instead of many separate YoY formulas.
What is a good YoY growth rate?
There is no single “good” YoY rate — it depends on industry, stage, and the metric you track. Compare against your own history and comparable peers. In recent US cycles, nominal GDP growth has often been near 2–3% annually — a rough economy-wide reference, not inflation-adjusted and not a target for every company.
Eye-catching YoY percentages often come from a small prior base (for example $10k to $30k is 200% YoY but only $20k in absolute terms). Report absolute change alongside the rate.
The ranges below are illustrative planning benchmarks, not forecasts or guarantees.
Established businesses
Often target about 5–15% revenue YoY when mature; e-commerce and retail frequently land near 10–25% when healthy.
High-growth stage
VC-backed SaaS and similar models may plan 30–50%+ YoY early on — then normalize as the base grows.
Use YoY for operating KPIs by period. When investors ask for one blended rate across several years, the CAGR calculator is usually the better fit than stacking many YoY cells.
Nominal vs inflation-adjusted growth
This calculator shows nominal YoY change — it does not adjust for inflation. If economy-wide prices rose about 3% but your revenue also grew 3% YoY, real volume may be flat even though the headline rate looks positive.
Example: prior-year revenue $100,000, current $103,000 → 3% nominal YoY. If CPI inflation was also about 3% over that span, purchasing-power growth is roughly flat.
For real growth, deflate both values with a price index (such as the US Consumer Price Index (CPI) from the Bureau of Labor Statistics) before applying the YoY formula, or use our inflation calculator for context. Many external reports still quote nominal YoY so periods stay comparable.
How to use this calculator
Pick a mode
Choose Calculate YoY, Project current value, Find prior value, or Multi-year YoY table — each mode matches a different planning question.
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).
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.
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.
More free tools
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.