Year‑over‑year (YOY), also written year‑on‑year, is a method of measuring change by comparing a metric for one period with the same period one year earlier. It’s widely used to remove seasonality and show whether a company’s (or economy’s) performance is improving, declining, or stable over an annual interval.
Key takeaways
– YOY compares identical periods separated by 12 months (e.g., Q1 2025 vs Q1 2024).
– It’s usually expressed as a percentage change: (This period ÷ Prior period) − 1.
– YOY helps control for seasonality and allows consistent comparisons across years.
– Limitations: base effects, one‑time items, currency moves, inflation, and accounting changes can distort YOY interpretations.
Sources: Investopedia; Apple Inc. Q1 2025 financials.
How YOY works
– Select the period to compare (monthly, quarterly, annual).
– Use the same calendar period one year earlier so seasonal patterns don’t bias the comparison.
– Express the change as a percent to make different sized entities and periods comparable.
– Common uses: revenue, net income, same‑store sales, GDP, money supply, and portfolio returns.
Benefits of YOY
– Controls for seasonality (e.g., retail’s holiday sales spike).
– Simple and intuitive—easy to communicate to stakeholders.
– Facilitates trend detection across comparable intervals.
– Works for financial statements, economic data and operational metrics.
Uses of YOY
– Corporate reporting: quarterly or annual revenue and profit trends.
– Macroeconomics: GDP growth, inflation, money supply.
– Investment analysis: portfolio performance and company fundamentals.
– Operational metrics: monthly active users, churn, same‑store sales.
How YOY is calculated (practical steps)
Step 1 — Choose comparable periods
– Pick the same period one year apart (e.g., March 2025 vs March 2024; Q1 2025 vs Q1 2024).
Step 2 — Gather the raw figures
– Use reported figures (e.g., revenue, net income) for the two periods.
Step 3 — Apply the formula
– Formula: YOY change = (Value_this_period ÷ Value_prior_period) − 1
– To express as percentage: multiply result by 100.
Step 4 — Present and interpret
– Show both absolute change and percentage change. Note one‑time items, acquisitions, divestments, currency effects or accounting changes that might require adjustment.
Example calculations (real numbers)
– Apple Q1 example (from Apple Q1 2025 condensed statements):
• Net sales: Q1 2025 = $124.3 billion; Q1 2024 = $119.6 billion
• YOY = (124.3 ÷ 119.6) − 1 = 0.039 → 3.9% YOY increase.
• Net income: Q1 2025 = $36.3 billion; Q1 2024 = $33.9 billion
• YOY = (36.3 ÷ 33.9) − 1 = 0.0707 → 7.07% YOY increase.
• Source: Apple Inc., “Condensed Consolidated Statements of Operations Q1 2025.”
Excel and calculator tips
– Excel formula for percentages: =(ThisPeriod / PriorPeriod) – 1
– To format as percent in Excel: wrap with TEXT or use Percentage cell format.
– Show absolute change too: =ThisPeriod – PriorPeriod.
What YOY is used for (summary)
– Measuring business growth in comparable seasonal windows.
– Comparing quarterly results across years (e.g., multiple years of Q4 results).
– Evaluating economic indicators that are reported monthly or quarterly.
– Communicating trends to investors and management.
YOY vs YTD vs sequential (difference)
– YOY (year‑over‑year): compares the same period year apart (e.g., Q1 2025 vs Q1 2024). Good for seasonal control.
– YTD (year‑to‑date): compares performance from the start of the year to the current date versus the same range in the prior year (e.g., Jan 1–Sep 30 this year vs Jan 1–Sep 30 last year). YTD gives a running tally for the current year.
– Sequential (period‑to‑period): compares one period directly to the immediately prior period (e.g., Q2 vs Q1). Useful to see short‑term momentum but sensitive to seasonality.
Use each depending on what you want to learn: trend across comparable seasons (YOY), cumulative year performance (YTD), or short‑run momentum (sequential).
What if I want comparisons of less than a year?
Options and considerations:
– Month‑over‑month (MoM) or quarter‑over‑quarter (QoQ): calculate the same as YOY but using adjacent periods. These are more volatile and more affected by seasonality.
– Annualize a shorter‑period growth rate: if you observe growth over n months, annualized rate = (1 + growth)^(12/n) − 1 (use with caution—assumes the short‑term rate continues).
– Rolling 12‑month (R12 or L12M) sum/average: for smoother trend that still reflects recent 12‑month performance (e.g., sum of last 12 months’ sales vs prior 12 months).
– Use seasonally adjusted series when available (economic data) to remove predictable seasonal effects for shorter period comparisons.
Practical interpretation steps and caveats
– Check the base: a small base (very low prior period) makes percentage changes look large (base effect). Note absolute differences alongside percentages.
– Adjust for one‑time items and structural changes: acquisitions, divestitures, large tax items, or accounting changes can mislead. Provide adjusted YOY where meaningful.
– Consider inflation and currency translation: for multinational firms, FX movements can distort YOY; convert to constant currency when relevant. For nominal economic series, remove inflation (real terms) if you need purchasing‑power comparisons.
– Use multi‑period analysis: rather than one YOY point, look at several years or compute CAGR to spot consistent trends. CAGR = (EndingValue ÷ StartingValue)^(1/years) − 1.
– Watch for statistical noise: small companies or thinly traded stocks produce noisy YOY changes—use smoothing or longer windows.
Practical checklist for producing a reliable YOY comparison
1. Define the metric and period (monthly, quarterly, annual).
2. Confirm accounting and reporting consistency across periods.
3. Adjust for one‑offs, acquisitions, FX and inflation as appropriate.
4. Calculate absolute and percentage change.
5. Present context: multiple years, CAGR, and relevant notes or adjustments.
6. Interpret: ask whether change is structural, cyclical, seasonal, or temporary.
When to use YOY vs other measures
– Use YOY when seasonality matters and you want like‑for‑like comparisons.
– Use sequential (QoQ, MoM) for momentum and short‑run swings.
– Use YTD when you want cumulative performance for the year so far.
– Use rolling 12‑month totals for smoother trends that still reflect the last 12 months.
The bottom line
YOY is a straightforward, widely used tool to compare a metric to its value in the same period a year earlier. It’s especially useful to control for seasonality and communicate growth or decline in a simple percent format. To produce meaningful YOY analysis, pick comparable periods, check for distortions (base effects, one‑time items, currency and inflation), and complement single‑point YOY numbers with multi‑period views and context.
Sources
– Investopedia. “Year‑Over‑Year (YOY).” Retrieved from
– Apple Inc. “Condensed Consolidated Statements of Operations Q1 2025.” (Apple Q1 2025 figures cited above)
Editor’s note: The following topics are reserved for upcoming updates and will be expanded with detailed examples and datasets.