First YoY occurs after the first two rows.
| Year | Value | Remove |
|---|
Tip: Enter years in ascending order for correct CAGR.
Results
| Year | Value | Abs Change | YoY % |
|---|---|---|---|
| No results yet. Click Calculate. | |||
| Summary | |||
| First Year | — | First Value | — |
| Last Year | — | Last Value | — |
| Periods (years - 1) | — | Total Increase % | — |
| AAGR (mean YoY) | — | CAGR | — |
Example Data
These values illustrate calculations. Use “Load Example” to populate inputs.
| Year | Value | YoY % |
|---|---|---|
| 2020 | 1,000 | — |
| 2021 | 1,120 | 12.00% |
| 2022 | 1,150 | 2.68% |
| 2023 | 1,380 | 20.00% |
| 2024 | 1,449 | 5.00% |
CAGR (2020→2024) ≈ (1449/1000)^(1/4) − 1 ≈ 9.63%.
Formulas Used
YoY % = ((Vt − Vt−1) / Vt−1) × 100
Total % Increase = ((Vlast − Vfirst) / Vfirst) × 100
AAGR (Arithmetic Average Growth Rate) = mean of YoY % values
CAGR (Compound Annual Growth Rate) = (Vlast / Vfirst)1/n − 1, where n = periods (years − 1)
If Vt−1 = 0, YoY is not defined. If negatives occur and the option is enabled, those rows are excluded from YoY and averages.
How to Use This Calculator
- Enter each Year and corresponding Value in the input table.
- Use “Add Row” to extend the series; keep chronological order.
- Adjust Decimals, Show % sign, and averaging options if needed.
- Click Calculate to compute YoY %, totals, AAGR, and CAGR.
- Download a CSV of inputs and results or a PDF report.
For CAGR, ensure at least two rows and nonzero first value. AAGR equals the arithmetic average of available year-over-year percentages.
Notes & Edge Cases
- Duplicate years are ignored in calculations; ensure unique years.
- If previous value is zero and the option is on, YoY shows “—”.
- Negative values can distort growth; enable the exclusion option to skip them.
- Empty or invalid rows are ignored automatically.
- Rounding is applied only to display; internal math uses full precision.
What is Yearly Percentage Increase?
The yearly percentage increase compares the current year to the prior year to show relative growth.
YoY% = ((Current − Previous) / Previous) × 100
- Positive values indicate growth relative to last year.
- Negative values indicate decline from the previous year.
- Undefined when the previous year equals zero.
AAGR vs CAGR: Which should you report?
AAGR is the simple average of YoY percentages. It is sensitive to volatility and outliers.
CAGR is the constant annual rate that links first and last values across periods.
- Use AAGR for descriptive annual movements.
- Use CAGR for long‑horizon performance and forecasting.
- Report both when variability matters to stakeholders.
Worked Example: Step‑by‑Step Calculation
Suppose values are 500, 575, 632 for 2022, 2023, 2024 respectively.
- YoY% (2023) = (575 − 500) / 500 = 0.15 → 15%.
- YoY% (2024) = (632 − 575) / 575 ≈ 0.0991 → 9.91%.
- AAGR = mean(15%, 9.91%) ≈ 12.46%.
- CAGR (2022→2024) = (632/500)^(1/2) − 1 ≈ 12.31%.
Small deviations between AAGR and CAGR arise from compounding effects.