CAGR formula: how to calculate compound annual growth rate, with Excel methods
Learn how to calculate CAGR by hand and in Excel with RRI, RATE and POWER. Includes negative CAGR, CAGR vs AAGR, reverse CAGR and a quick lookup table.
✍ Data Scientist & Financial Analyst · CFA
Kyaw Htoon ✓ Verified expert
Kyaw Htoon is a Data Scientist based in New York with experience in data acquisition, data modeling, and statistical analysis. He also holds a Chartered Financial Analyst (CFA) credential and has a background in finance and technology.
Experience
Kyaw currently works at Gen II Fund Services. He has experience in data science projects, machine learning, and previously worked on financial systems and tax compliance projects (including FATCA-related work). He is also a volunteer English and Mathematics tutor for blind students in Yangon, Myanmar.
Education
- Data Science Immersive Program – Flatiron School
- Global Student Certificate – Weissman Center for International Business, Baruch College
- Chartered Financial Analyst (CFA) – CFA Institute
1Articles
11Tools reviewed
Finance Calculators
Annual income calculator: hourly and monthly pay to yearly pay
Free annual income calculator. Turn hourly, daily, weekly or monthly pay into your yearly income. See the full breakdown and formula.
Finance Calculators
Overtime Calculator: Time and a Half & Double Time Pay
Free overtime calculator. Enter your hourly rate and hours to see time and a half or double time pay, with a full breakdown and the exact formula.
Finance Calculators
Commission Calculator: Flat, Tiered & Base Pay Rates
Free commission calculator. Work out flat, tiered, or base-plus-commission pay from your sales and rate. See the formula and a commission rate chart.
Math Calculators
Ratio Calculator: Solve, Simplify & Scale Ratios
Ratio calculator to solve A:B=C:D, simplify ratios, check equivalents, and scale by total. Free step-by-step answers with worked examples.
Finance Calculators
Cash App Fee Calculator: Business, Instant & Card Fees
Cash App fee calculator for business (2.75%), instant deposit, and credit card fees. See your exact net and what to charge. Free 2026 US rates, with steps.
Finance Calculators
Venmo Fee Calculator: Goods & Services + Net Payout
Venmo fee calculator for Goods & Services (1.9% + $0.10), instant transfer, and credit card fees. See your exact net payout and what to charge. 2026 rates.
Math Calculators
Scatter Plot Maker with Line of Best Fit & Correlation
Free scatter plot maker. Paste your X and Y data to plot points, add a line of best fit, and get the correlation r and R squared instantly.
Math Calculators
Outlier Calculator – Find Outliers with the 1.5 IQR Rule
Outlier calculator finds Q1, Q3, IQR and the upper and lower boundaries using the 1.5 IQR rule. Enter your data set and detect outliers in seconds.
Math Calculators
Pie Chart Maker: Free Online Generator with Percentages
Free pie chart generator. Enter your labels and values to make a pie or donut chart with percentages, then download it as a PNG. No sign up, no skills needed.
Finance Calculators
PayPal Fee Calculator: Goods & Services + Net Payout
PayPal fee calculator for Goods & Services fees and your exact net payout. Reverse mode shows what to charge to receive a set amount. 2026 US rates.
Finance Calculators
ROI Calculator: Return on Investment & Annualized Rate
Free ROI calculator with the annualized rate of return (CAGR). Enter your investment, final value, and years to get total ROI and yearly return, with steps.