Investment Return Calculator

Calculate ROI, CAGR, profit/loss from any investment

Total extra money added after the initial investment
Enter decimal years if needed — e.g. 2.5 for 2 years 6 months
Excel courseLearn Excel from beginner to confident userthe Udemy course by Ajay Anand, 7× Microsoft Excel MVPView the course →
Total ROI
—
—
CAGR (annual return)
—
Net profit / loss
—
Total invested
—
Final value
—
Money multiplied
—
Dividends received
—

ROI vs CAGR

What is ROI?

Return on Investment (ROI) = (Net Profit / Total Invested) × 100. It tells you the total percentage gain or loss, regardless of time. A 50% ROI over 5 years is very different from a 50% ROI over 1 year.

What is CAGR?

Compound Annual Growth Rate (CAGR) smooths out returns over time and gives the equivalent annual rate at which your investment grew. It is more useful than ROI for comparing investments of different durations. CAGR = (Final / Initial)^(1/years) − 1.

What is a good return?

As a benchmark — US S&P 500 has averaged ~10% CAGR historically. Indian Nifty 50 has averaged ~12–13%. Fixed deposits give ~6–7%. Real estate varies widely by location. Inflation (3–6%) is the minimum return you need just to maintain purchasing power.

Free tutorialsFree Excel tips & tutorials at XLnCADstep-by-step guides by a 7× Microsoft Excel MVPVisit xlncad.com →

Master Excel & Google Sheets

These calculators give you quick answers — but building them yourself in a spreadsheet is a real superpower. Learn Excel from the basics to confident, everyday use in my top-rated Udemy course.

Start the Excel course →