A percentage change expresses how much a value has increased or decreased relative to its original value. It converts an absolute change into a relative measure so you can compare changes across different magnitudes (for example, a $5 change on a $20 item is very different from a $5 change on a $2,000 item).
Key uses
– Compare performance of investments, stocks or indices over time.
– Show revenue, expense or balance-sheet trends (year over year, quarter to quarter).
– Compare inflation or price changes for goods and services.
– Report changes in rates (interest, unemployment) using percentage points vs percent change.
Basic formula and step-by-step calculation
Step 1 — Identify the original value (Old) and the new value (New).
Step 2 — Compute the change:
– Absolute change = New − Old
Step 3 — Divide that change by the original value:
– Decimal change = (New − Old) / Old
Step 4 — Convert to percent:
– Percentage change = Decimal change × 100
If you prefer a single formula:
– Percentage change (%) = ((New − Old) / Old) × 100
Sign and interpretation
– A positive result means an increase.
– A negative result means a decrease.
– If Old = 0, the percent change is undefined (or requires a special explanation), because you cannot divide by zero.
Worked example (simple)
Grace buys a stock at $35 and it is $45.50 a year later.
– Absolute change = 45.50 − 35 = 10.50
– Decimal change = 10.50 / 35 = 0.30
– Percentage change = 0.30 × 100 = 30%
So the stock rose 30%.
Common real-world examples
– Corporate reporting: A company shows sales moved from $35.98B to $36.20B = (36.20 − 35.98)/35.98 ≈ 0.0061 = 0.61% (commonly rounded to 0.6%).
– COVID impact example: Starbucks reported a roughly 38% decline in Q3 2020 net revenues vs Q3 2019 due to COVID-19 business disruptions.
Practical steps in spreadsheets (Excel / Google Sheets)
– Basic percent change: enter = (New – Old) / Old and format as Percentage.
– Safe formula when Old might be zero: =IF(Old=0, “Undefined”, (New-Old)/Old)
– Show percent point change for rates: =New – Old (do NOT divide by Old).
– Compound annual growth rate (CAGR) across n years: = (New / Old)^(1/n) – 1. Format as Percentage.
Percent change vs percentage points
– Percent change expresses relative change. Example: 2% → 3% is a 50% increase ((3−2)/2 = 0.5).
– Percentage point change expresses absolute difference: 2% → 3% is a 1 percentage point increase. Use percentage points when comparing rates and proportions to avoid confusion.
Multi-period and financial considerations
– For multiple periods, use arithmetic percent changes to see year-by-year changes, but use CAGR to measure an average annual growth rate that compounds.
– For financial returns, especially when returns are volatile or used in portfolio math, consider log returns (continuous returns) or geometric averages rather than summing percent changes.
– Beware of base effects: a large percent change can result from a small original base (e.g., doubling from $1 to $2 = 100% increase).
Common pitfalls and how to avoid them
– Wrong denominator: Always divide by the original (Old) value.
– Confusing percent change and percentage point change for rates.
– Ignoring sign: report decreases as negative percent changes or say “decreased by X%.”
– Division by zero: explicitly handle Old = 0.
– Rounding can hide meaning: keep enough decimal places for clarity when values are small.
How percentage change relates to a balance sheet
– Companies use percent change to show trends in balance-sheet line items: cash, accounts receivable, inventory, debt, equity.
– Practical step: create a column for the previous period, a column for the current period, and a third column that calculates percentage change = (Current − Previous) / Previous. Use this to highlight liquidity trends, debt increases, or asset growth over multiple periods.
How investors and analysts use percent change
– Compare a stock’s percent change to a benchmark index to assess relative performance.
– Compare revenue, EPS or margins year-over-year to detect operational trends.
– Compare currency movements and commodity prices across time.
– Use percent change when screening stocks by growth rate (revenue growth, earnings growth).
Advanced/related measures
– Cumulative percent change: multiply successive period multipliers: (1 + p1) × (1 + p2) − 1.
– CAGR for long-term average growth: (New/Old)^(1/years) − 1.
– Log returns for portfolio math: ln(New/Old).
Practical reporting tips
– Always state the base period and the base value (e.g., “Revenue increased 8% year over year, from $X to $Y”).
– For rates, indicate whether you mean percentage points or percent change.
– When presenting very large or small percentages, show both the percent and the absolute change to avoid misleading impressions.
– Use charts (bars or line charts) with percent-change annotations to show trends visually.
Quick checklist to calculate percentage change correctly
1. Confirm Old and New values and units.
2. Compute New − Old.
3. Divide by Old. If Old = 0, decide on an alternative presentation (absolute change, “infinite” or “not defined”).
4. Multiply by 100 and choose appropriate rounding.
5. Label the result clearly (increase/decrease, time frame, percent vs percentage points).
6. If comparing multiple periods, consider using CAGR or cumulative multipliers.
Bottom line
Percentage change is a simple but powerful way to express how a value moved relative to a starting point. It’s widely used in finance and business reporting, but it must be applied carefully: choose the correct denominator, distinguish percent change from percentage-point changes, handle zero bases explicitly, and use CAGR or log returns when working with multi-period financial returns.
Sources and further reading
– Investopedia — “Percentage Change”
– Starbucks press releases (examples cited in corporate reporting)
– Reed College — “Percentage Change and Percentage Point Change: A Primer”
– Harvard Business School Online — “How to Prepare a Balance Sheet: 5 Steps for Beginners”
Additional sections and examples
Common pitfalls and how to avoid them
– Confusing percentage change with percentage-point change: A shift from 5% to 7% is a 2 percentage-point increase but a 40% percentage change ((7−5)/5 = 0.4). Use “percentage point” when describing absolute differences in percent values (rates, yields, shares). See Reed.edu for a primer on this distinction.
– Zero or near-zero bases: If the original value is zero, the percent change is undefined (division by zero). If the original value is very small, modest absolute changes can produce extremely large percentage changes—always show the absolute change alongside the percentage.
– Base-period choice and signaling: Which period you choose as the “original” matters. Year-over-year (YOY), quarter-over-quarter (QoQ), and month-over-month (MoM) comparisons can tell different stories. Make the base clear.
– Ignoring inflation: Nominal changes don’t reflect purchasing power. For long-term comparisons, adjust for inflation to see the real percentage change.
– Rounding and presentation: Rounding can distort apparent performance for small values—present at least two decimal places if values are small, or show both percent and absolute change.
Multi-period changes and annualized returns
A single percentage change only compares two points. For multiple periods use either:
– Cumulative return (simple product): Multiply period factors and subtract 1.
Example: +10% in year 1, −5% in year 2, +20% in year 3.
Cumulative factor = 1.10 × 0.95 × 1.20 = 1.254 → cumulative change = 25.4%.
– Compound Annual Growth Rate (CAGR) / annualized return: Useful to summarize multi-year growth as a single annual rate.
Formula: CAGR = (Ending Value / Beginning Value)^(1 / n) − 1
Example: Beginning = $100, Ending = $152.10 over 3 years → CAGR = (152.10/100)^(1/3) − 1 = 0.1499 → 14.99% per year.
Worked examples (practical)
1) Simple increase example
– Situation: A stock rises from $35.00 to $45.50.
– Calculation: Increase = 45.50 − 35.00 = 10.50. Percent change = (10.50 / 35.00) × 100 = 30.0%.
– Interpret: The stock’s value increased by 30% relative to the original price.
2) Simple decrease example
– Situation: Price drops from $120 to $90.
– Calculation: Decrease = 120 − 90 = 30. Percent change = (−30 / 120) × 100 = −25%.
(Or use decrease formula: (30/120)×100 = 25% decrease.)
– Interpret: The price declined by 25% relative to the original price.
3) Percentage-point vs percent-change example
– Situation: Interest rate rises from 3% to 4%.
– Percentage-point change = 4% − 3% = 1 percentage point.
– Percentage change = (1% / 3%) × 100 ≈ 33.33% increase.
4) Multi-period and annualized example
– Situation: Investment goes from $10,000 to $13,310 over 3 years.
– Cumulative change = (13,310 / 10,000) − 1 = 33.1%.
– CAGR = (13,310 / 10,000)^(1/3) − 1 ≈ 0.1000 = 10.00% per year.
5) Handling zero base example
– Situation: Company revenue jumps from $0.01M to $0.50M.
– Percent change = (0.50 − 0.01) / 0.01 × 100 = 4,900% — large and valid but potentially misleading without context. Always show absolute amounts too.
Excel and Google Sheets practical formulas
– Percent change (new vs old): =(New−Old)/Old
Format the cell as Percentage.
– If Old might be zero and you want to avoid #DIV/0!:
=IF(Old=0, “undefined”, (New−Old)/Old)
– Percent decrease (always positive magnitude): =ABS((New−Old)/Old)
– CAGR formula:
=(Ending/Beginning)^(1/Years) − 1
– Example with cell refs: =((B2/A2)^(1/C2))−1 where A2=beginning, B2=ending, C2=years.
Practical steps for analysts and investors (actionable checklist)
1. Define the comparison timeframe clearly (YOY, QoQ, MoM).
2. Choose your base/original value and state it explicitly.
3. Calculate absolute change (New − Old); report this first for context.
4. Calculate percent change = (New − Old) / Old × 100. Use sign to show increase/decrease.
5. For multiple periods, compute cumulative return and/or CAGR (use geometric mean).
6. Be mindful of special cases (Old = 0; tiny base values) and note when percent change may mislead.
7. Distinguish percentage-point changes for rates and ratios.
8. Adjust for inflation for long-run comparisons when real purchasing power matters.
9. Visualize trends with charts (line charts for levels, bar charts for percent changes).
10. Provide context: absolute magnitudes, sample sizes, and relevant benchmarks (e.g., compare a stock’s percent change to S&P 500 over the same interval).
How percentage change is used in corporate financial analysis
– Financial statement trend analysis: Companies and analysts report percent changes in revenue, gross profit, operating income, cash, liabilities, etc., to highlight growth rates and identify trends (e.g., Starbucks showing YOY declines during 2020 and a 0.6% increase for fiscal 2024).
– Ratio analysis: Percentage changes in key ratios (current ratio, debt-to-equity) can signal improving or worsening financial health.
– Variance analysis: Finance teams explain budget vs. actual results by percent and absolute variances.
– Performance benchmarking: Compare a company’s percent changes to industry peers and indices.
– Investor communications: Percent changes are commonly used in earnings releases, investor presentations, and press releases to communicate performance succinctly.
Advanced considerations
– Seasonality: When data are seasonal, compare like-to-like periods (e.g., Q1 to Q1 YOY) or use seasonally adjusted series.
– Volatility and outliers: Large percent changes may be driven by one-time events; analyze underlying causes.
– Statistical significance: For small samples or volatile measures, test whether observed percent changes are meaningful, not just noise.
– Real versus nominal: For long-term asset prices, consider inflation adjustment to distinguish nominal gains from real returns.
Additional examples and exercises (practice)
– Exercise 1: A country’s GDP goes from $2.5 trillion to $2.65 trillion in a year. Calculate percent change and interpret.
Solution: Increase = 0.15T. Percent change = (0.15 / 2.5) × 100 = 6%.
– Exercise 2: Stock A: $50 → $65 over 2 years. Stock B: $200 → $260 over 2 years. Calculate percent changes and compare.
Stock A: (15/50) × 100 = 30%. Stock B: (60/200) × 100 = 30%. Both rose 30% despite different dollar gains.
– Exercise 3: You want the equivalent annual rate for a 50% total gain over 4 years. CAGR = (1.50)^(1/4) − 1 ≈ 10.65% annually.
Summary and practical takeaways
– Percentage change measures relative change between two values and is widely used across finance, business, and everyday comparisons.
– Basic formula: Percent change = (New − Old) / Old × 100; for decreases the result is negative.
– Distinguish percent change from percentage-point change (use the latter for differences between percentages).
– For multiple periods use compounded returns and summarize with CAGR when appropriate.
– Always present absolute changes alongside percentages for clarity, watch out for small base effects, and adjust for inflation when needed.
– Use careful framing, clear base periods, and visualization to make percent-change communication both accurate and understandable.
Sources and further reading
– Investopedia, “Percentage Change” (overview and examples)
– Reed College, “Percentage Change and Percentage Point Change: A Primer” (clarifies percent vs percentage-point)
– Harvard Business School Online, “How to Prepare a Balance Sheet” (context on balance sheet use)
– Starbucks investor releases (examples of percent-change reporting in corporate results)