Year on Year Growth Calculator

Year-Over-Year Growth Formula

The YoY growth formula is one of the most useful metrics in business, and it’s dead simple:

YoY Growth Rate = ((Current Year Value – Previous Year Value) / Previous Year Value) x 100

That’s it. You’re measuring the percentage change between the same period in two consecutive years.

Why “same period” matters: YoY strips out seasonality. If you compare Q4 revenue to Q3 revenue, you might think your business is booming because of holiday sales. Compare Q4 2025 to Q4 2024, and you see actual growth independent of seasonal patterns.

A worked example: Your SaaS product had Rs 42 lakh ARR in January 2025 and Rs 58 lakh ARR in January 2026.

YoY Growth = ((58 – 42) / 42) x 100 = 38.1%

That 38.1% is your year-over-year growth rate. Clean, comparable, and not distorted by which month you’re measuring.

How to Calculate YoY Growth: Step-by-Step

Step 1: Pick your metric. Revenue, users, traffic, profit, whatever you’re measuring. The metric needs to be available for both periods.

Step 2: Get the same-period values. Pull the number for the current period AND the identical period from the previous year. January to January. Q3 to Q3. Full year to full year. Mixing periods defeats the purpose of YoY.

Step 3: Plug into the formula. YoY Growth = ((New – Old) / Old) x 100

Step 4: Interpret the result. Positive number = growth. Negative number = decline. Zero = flat.

Common mistake: Using ending values instead of same-period values. If someone asks “what’s our YoY growth?”, they want the year-over-year change for a consistent period, not just the difference between your latest number and a year ago. The distinction matters when you’re looking at monthly or quarterly snapshots.

YoY Growth Formula in Excel and Google Sheets

For a single calculation: =(B2-B1)/B1 where B1 is last year’s value and B2 is this year’s value. Format the cell as percentage.

For a column of YoY calculations with monthly data, assuming your dates are in column A and values in column B:

=(B13-B1)/B1 — This compares month 13 (January next year) to month 1 (January this year).

Dynamic YoY formula (auto-match periods): =IF(ROW()-12>=1,(B2-INDEX(B:B,ROW()-12))/INDEX(B:B,ROW()-12),””)

This formula automatically looks back 12 rows to find the same month from the prior year. Works when your data is in monthly rows.

For quarterly data, change 12 to 4: =IF(ROW()-4>=1,(B2-INDEX(B:B,ROW()-4))/INDEX(B:B,ROW()-4),””)

CAGR vs YoY: If you need growth rate across multiple years, use CAGR (Compound Annual Growth Rate): =(Ending Value/Beginning Value)^(1/Number of Years) – 1

CAGR smooths the rate across years. YoY shows the actual change each individual year. Use YoY for diagnostics. Use CAGR for presentations and benchmarking.

YoY Growth Benchmarks by Industry

These are median YoY growth rates for funded Indian companies (2024-2025 data from industry reports):

SaaS B2B Seed to Series A: 80-150% YoY is expected. Series A to B: 60-100%. Series B+: 40-70%. Below 40% YoY at Series B and the “growth” label starts to slip. The T2D3 framework (triple, triple, double, double, double) maps out ideal SaaS growth trajectories.

D2C / E-commerce Year 1-2: 100-300% YoY (low base effect). Year 3-5: 40-80%. Mature D2C brands: 15-30% YoY is considered healthy. Profitability matters more than top-line growth after Year 3.

Fintech Revenue growth: 50-120% YoY for growth-stage. User growth: 80-200% YoY. Lending fintechs track book size growth separately from revenue growth. Payment fintechs track TPV (Total Payment Volume) growth.

Digital Marketing Agencies 15-30% YoY revenue growth is strong for agencies above Rs 3 crore ARR. Below 15% signals stagnation. Above 50% usually means you’re scaling too fast and margins are getting crushed by hiring ahead of revenue.

Overall Benchmark GDP growth in India is approximately 6-7% YoY. Any business growing below GDP rate is effectively shrinking relative to the economy. Minimum viable growth rate for any business: beat inflation + GDP growth, which means 10-12% YoY as the absolute floor.

YoY vs Other Growth Metrics

YoY vs MoM (Month-over-Month) MoM shows short-term momentum. YoY shows sustainable trends. A company growing 5% MoM is growing ~80% YoY (compounded). MoM is noisy because of seasonality. YoY corrects for that noise. Use MoM for operational decisions. Use YoY for strategic planning and investor reporting.

YoY vs QoQ (Quarter-over-Quarter) QoQ sits between MoM and YoY. Useful for quarterly business reviews. Still affected by seasonality (Q4 vs Q1 will always look different in retail). YoY is the cleaner comparison for most purposes.

YoY vs CAGR YoY is one year’s change. CAGR averages growth across multiple years. CAGR hides volatility. If you grew 100% in Year 1 and 0% in Year 2, CAGR says ~41% annual growth. That’s mathematically correct but misses the fact that growth stalled. Report both: CAGR for the trajectory, YoY for each year’s reality.