How to Calculate Percentage Growth
Last updated: 2026-09-06
⚡ Quick Answer
Tracking variance percentage helps analyze revenue growth, budget deviations, and performance metrics.
=(New_Value - Old_Value) / Old_Value📊 Visual Demo
HOME · INSERT · FORMULAS · DATA
fx =(New_Value - Old_Value) / Old_Value
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | 1 | $50,000 | $65,000 | =(C2-B2)/B2 | +30.0% Growth |
| 2 | 2 | $12,000 | $10,500 | — | -12.5% Decline |
| 3 | 3 | Formatting | Percentage | Applied Format | 0.0% View |
🧠 Deep Dive
Tracking variance percentage helps analyze revenue growth, budget deviations, and performance metrics.
Key Insights
- Signed cash flows: outflows are negative, inflows are positive.
- Rates must match the period (annual rate / 12 for monthly).
Common Mistakes
- Passing annual rate directly to PMT.
- Forgetting minus sign on present value.
Pro Tips
- Build a small input block with named cells.
- Format currency after math.
FAQ
What does this formula do in plain English?
Tracking variance percentage helps analyze revenue growth, budget deviations, and performance metrics.
Why is my formula not working?
Passing annual rate directly to PMT.
Does this work in Google Sheets?
Yes, this syntax is fully compatible with Google Sheets.
What is the most common mistake?
Forgetting minus sign on present value.
Related Guides
How to Calculate CAGR in ExcelHow to Calculate IRR in ExcelHow to Calculate NPV in ExcelHow to Calculate Loan Payments (PMT)Excel Error Hub
Need Complete Playbooks?
Download our verified manuals covering ERP Cleanup and Modeling.
Explore Playbook Series (From ₹199)