Revenue (Year On Year Growth)
Returns the year-over-year (YoY) revenue growth, comparing the most recent annual revenue to the prior year.
Calculation
YoY Growth = (Current Year Revenue - Prior Year Revenue) / Prior Year Revenue
Interpretation
| YoY Growth | Interpretation |
|---|---|
| > 20% | High growth |
| 10-20% | Strong growth |
| 5-10% | Moderate growth |
| 0-5% | Slow growth |
| < 0% | Declining revenue |
Notes
- Returns value as a decimal (0.12 = 12%)
- Based on trailing twelve months vs prior period
- Most recent annual comparison
Syntax
=YoYGrowth()Parameters
Returns
Year-over-year revenue growth as a decimal
Examples
When to Use
- Evaluate recent revenue trends
- Compare annual performance
- Identify growth acceleration/deceleration
- Quick growth screening
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Quarter-over-quarter growth | QoQGrowth() |
| Long-term CAGR | RevenueGrowthFiveYearCAGR() |
| EPS growth | EPS growth functions |
| YoY quarterly comparison | QuarterlyRevenueGrowthYOY() |
Common Issues & FAQ
Why is the value less than 1?
Growth is returned as a decimal. Multiply by 100 to get percentage (e.g., 0.12 = 12%).
How does this differ from CAGR?
YoY is a simple one-year comparison. CAGR compounds over multiple years and smooths volatility.
Can this be negative?
Yes, negative values indicate revenue declined compared to the prior year.
Excel Templates Using Revenue (Year On Year Growth)
These ready-made MarketXLS templates call YoYGrowth() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS Growth formulas you can use in the same worksheet:
- Shares Outstanding (1 Year - Growth)
- Shares Outstanding (3 Year - Growth)
- Total Cash On Hand (1-Year Growth)
- Book Value Per Share (1-Year Growth)
- CAGR
- Cash Flow (1-Year Growth)
- Dividend (1-Year Growth)
- EBITDA (1-Year Growth)
See YoYGrowth used in a complete workbook: MarketXLS New Release 9.3.4.5
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today