ROI
ROI = ((Final Value − Initial Cost) / Initial Cost) × 100 Annualized ROI = ((1 + ROI/100)^(1/Years) − 1) × 100

ROI measures total percentage return. Annualized ROI converts any multi-year return into an equivalent annual rate so you can compare investments with different time horizons fairly.

ROI % (initial A1, final B1)
=((B1-A1)/A1)*100
Annualized ROI (years C1)
=((B1/A1)^(1/C1)-1)*100

Understanding ROI and Its Limits

Return on Investment (ROI) is the simplest measure of investment performance — what percentage did you gain (or lose) relative to what you put in. It is universally applicable: evaluating a stock, a real estate purchase, a marketing campaign, or a business equipment purchase all use the same formula.

ROI ignores time, which is its biggest limitation. A 50% ROI over 10 years is fundamentally less impressive than a 50% ROI over 2 years, but simple ROI treats them identically. Annualized ROI (also called CAGR — Compound Annual Growth Rate) solves this by converting any return to an equivalent annual rate. A 50% ROI over 10 years annualizes to 4.1%; over 2 years it annualizes to 22.5%.

ROI also ignores risk. Two investments might have identical ROIs, but one could be extremely volatile while the other is stable. Risk-adjusted metrics like the Sharpe ratio attempt to account for this, but for basic analysis, ROI combined with your own assessment of risk is a reasonable starting point.

Benchmarking Your ROI

The most useful context for any ROI figure is comparison. The S&P 500 has historically returned approximately 7% annually after inflation (10% before inflation), making it a common benchmark for investment decisions. Real estate averages 4-8% annually depending on location and period. High-yield savings accounts currently offer around 4-5%.

Any investment should be evaluated against what else you could do with the same money. This is opportunity cost — if you can reliably earn 7% in index funds, an investment returning 5% over the same period actually represents a negative decision relative to alternatives, even though the absolute return is positive.

Frequently Asked Questions

It depends on asset class, risk, and time horizon. Stock market: 7-10% annualized is historically strong. Real estate: 6-12%. Business investments: varies widely. For marketing spend, businesses often target 3:1 to 5:1 return (200-400% ROI). Any ROI should be compared against your best risk-adjusted alternative.
ROI measures profit return relative to total investment cost — it accounts for all costs. ROAS (Return on Ad Spend) measures revenue per advertising dollar — it ignores product costs. A campaign with 5x ROAS might have only 50% ROI once product costs are factored in. Use ROAS for campaign optimization, ROI for overall profitability decisions.
Marketing ROI = (Revenue Attributed to Campaign - Campaign Cost) / Campaign Cost × 100. Attribution is the hard part — was the sale driven by this specific campaign? Multi-touch attribution models distribute credit across multiple marketing touchpoints. For simplicity, last-click attribution credits the final touchpoint before purchase.
Yes — if your investment lost value, ROI is negative. A $10,000 investment worth $7,000 has ROI = ($7,000 - $10,000) / $10,000 × 100 = -30%. Understanding why an investment generated negative ROI — market conditions, execution, or a flawed thesis — is essential for improving future decisions.