How to Calculate Year-over-Year (YoY) Growth: Formula and Excel
How to calculate year-over-year (YoY) growth: subtract last year from this year and divide by last year. Examples, Excel formulas and YoY vs CAGR.
By Muhammad Awais, Founder and editor-in-chiefPublished
To calculate year-over-year (YoY) growth, subtract last year’s figure from this year’s, divide by last year’s figure and multiply by 100. Revenue that rose from $480,000 to $552,000 grew (552,000 − 480,000) ÷ 480,000 × 100 = 15% year over year.
The percentage increase calculator does this for two numbers. In its List of values mode you can paste several years at once and get every year’s change, the total and the average rate.
Step by step
- Pick the two figures for the same measure and the same length of period, such as revenue for 2024 and 2025.
- Subtract last year from this year. This is the change in dollars (or units, users, orders).
- Divide the change by last year’s figure, not this year’s.
- Multiply by 100 to turn it into a percentage. A positive answer is growth, a negative one is a decline.
Example: a coffee shop sold $42,000 in March 2024 and $46,830 in March 2025. The change is $4,830, and 4,830 ÷ 42,000 × 100 = 11.5% YoY growth.
YoY growth over several years
With more than two years, compare each year with the year just before it. Here is a small business’s revenue over five years:
| Year | Revenue | YoY growth |
|---|---|---|
| 2021 | $200,000 | — |
| 2022 | $230,000 | (230,000 − 200,000) ÷ 200,000 = +15% |
| 2023 | $276,000 | (276,000 − 230,000) ÷ 230,000 = +20% |
| 2024 | $262,200 | (262,200 − 276,000) ÷ 276,000 = −5% |
| 2025 | $301,530 | (301,530 − 262,200) ÷ 262,200 = +15% |
Two things trip people up here:
- You can’t add the yearly rates. 15 + 20 − 5 + 15 = 45%, but revenue actually grew (301,530 − 200,000) ÷ 200,000 = 50.77% from 2021 to 2025. Each year’s growth is worked out on a different base.
- The plain average overstates steady growth. The four rates average 11.25%, but the steady yearly rate that turns $200,000 into $301,530 in four years is 10.81%. That is the compound annual growth rate (CAGR), covered below.
Monthly and quarterly YoY
YoY isn’t only for whole years. You can compare a month or a quarter with the same month or quarter a year earlier: March 2025 against March 2024, or Q3 against last year’s Q3.
This is why businesses report YoY instead of month over month. Many sales are seasonal: a toy shop always sells more in December than in November, so a jump from November to December says little. December against last December shows whether the business is really growing.
Compare like with like. If one year has 53 weeks or an extra trading day, or a store was closed for a week, mention it next to the figure.
YoY growth in Excel and Google Sheets
Put the years in column A and the figures in column B, starting in row 2. In C3 type:
Format column C as a percentage and fill the formula down. Each row now shows the change on the row above. =B3/B2-1 gives the same answer when all the figures are positive.
To skip a year with zero (where growth is undefined), wrap it: =IF(B2=0,"n/a",(B3-B2)/ABS(B2)).
For the total growth from the first year to the last, use =B6/B2-1. For the compound average per year over the four steps from 2021 to 2025, use =(B6/B2)^(1/4)-1. Excel also has a built-in function for this, =RRI(4,B2,B6), which gives the same 10.81%.
When last year was negative
Profits can be negative. If a company lost $50,000 last year and $20,000 this year, it improved. Dividing by the negative figure would show −60%, which reads as a fall. Use the size of last year’s figure instead (that’s what ABS does):
(−20,000 − (−50,000)) ÷ 50,000 × 100 = +60%: the loss shrank by 60%.
A swing from a $50,000 loss to a $30,000 profit works out at +160%. That is mathematically correct but hard to read, so say it in words as well: “from a $50,000 loss to a $30,000 profit.” If last year was exactly zero, there is no percentage at all; give the dollar change instead.
YoY vs CAGR
| YoY growth | CAGR | |
|---|---|---|
| Measures | One year against the year before | The steady yearly rate over several years |
| Formula | (this year − last year) ÷ last year | (last ÷ first)^(1 ÷ years) − 1 |
| Shows | Ups and downs, year by year | The overall trend, smoothed out |
| Example above | +15%, +20%, −5%, +15% | 10.81% a year |
Use YoY to spot a bad year or a sudden jump. Use CAGR to compare the long-run growth of two businesses, products or investments over the same period. The CAGR calculator works it out from a start value, an end value and the number of years.
Common mistakes
- Dividing by this year instead of last year. In the March example, 4,830 ÷ 46,830 gives 10.3%, which is wrong. Always divide by the earlier figure.
- Adding or averaging the yearly rates to get growth over several years. Use the first and last figures, or CAGR.
- Comparing different periods, such as a 13-month year with a 12-month one, or a quarter with a month.
- Mixing percent and percentage points. A profit margin rising from 20% to 25% is up 5 percentage points, which is a 25% increase in the margin. The profit margin calculator shows the margin itself.
- Calling a smaller loss a decline. Divide by the size of last year’s figure, as shown above.
FAQ
How do you calculate YoY growth?
Subtract last year’s value from this year’s value, divide by last year’s value and multiply by 100. Sales of $500 last year and $560 this year are (560 − 500) ÷ 500 × 100 = 12% YoY growth.
What is the YoY growth formula in Excel?
With last year in B2 and this year in B3, use =(B3-B2)/ABS(B2) and format the cell as a percentage. =B3/B2-1 works when both values are positive.
Can YoY growth be negative?
Yes. A negative result means the figure fell. Sales that drop from $276,000 to $262,200 show −5% YoY growth.
How do you calculate YoY growth for multiple years?
Work out each year against the year before it. For growth across the whole period, divide the last year by the first and subtract 1; for the average per year, use CAGR: (last ÷ first)^(1 ÷ number of years) − 1.
What is the difference between YoY and CAGR?
YoY compares one year with the year before. CAGR is the single steady rate that would take the first value to the last value over the whole period. Over 2021–2025 above, the YoY rates were +15%, +20%, −5% and +15%, while the CAGR was 10.81%.
Sources
- Microsoft Support: RRI function, the equivalent interest rate for the growth of an investment (Excel’s built-in CAGR).