ROI Calculator

Calculate your total Return on Investment (ROI), annualized CAGR rate, net post-tax profit, and real purchasing power growth.


₹ 1,00,000
₹ 2,50,000
Quick Benchmark Presets (Based on Duration):
5.0 Years
Rule of 72 Doubling Metric Doubles in ~3.6 Yrs

At an annualized CAGR return of 20.11% p.a., your invested capital doubles in approximately 3.6 years.

Total Return on Investment Multiplier: 2.50x

+150.00%

Net Profit of ₹ 1,50,000 on ₹ 1,00,000 initial capital
Annualized Return (CAGR) 20.11% p.a.
5.0 Years Duration Yearly Compounded Rate
Total Invested ₹ 1,00,000 Initial Capital
Net Wealth Gain +₹ 1,50,000 Absolute Profit
Final Total Value ₹ 2,50,000 Total Proceeds
Invested: 40.0% (₹ 1,00,000) Profit: 60.0% (₹ 1,50,000)

Year-by-Year Investment Growth & Compounding Schedule

Annualized CAGR: 20.11%
Year Beginning Capital (₹) Annual Wealth Gain (₹) Ending Valuation (₹) Cumulative ROI (%) Growth Multiplier

What is Return on Investment (ROI) and Why is it the Universal Financial Metric?


Return on Investment (ROI) is the global gold standard profitability metric used by retail investors, corporate treasuries, private equity firms, and real estate developers to quantify the financial gain or loss generated on an investment relative to its initial capital outlay.

Whether you are evaluating a stock portfolio, an equity mutual fund, commercial real estate, a Sovereign Gold Bond, or a business capital expenditure (CapEx), ROI normalizes the efficiency of capital allocation into a single percentage:

Return on Investment (ROI) = [ ( Final Value − Initial Investment ) ÷ Initial Investment ] × 100

A positive ROI signifies net profitability and capital creation, whereas a negative ROI indicates capital destruction. Because ROI expresses returns in relative percentage terms rather than absolute rupee figures, it allows investors to compare completely dissimilar investment options on an equal footing.

The Mathematical Formulas for Calculating ROI and Annualized Return


Depending on the investment duration and structural complexity, financial analysts employ three primary formulas:

1. Simple Absolute ROI Formula

ROI = ( Net Profit ÷ Cost ) × 100

Measures total point-to-point percentage gain regardless of holding duration. Best for short-term trades and single-period projects.

2. Annualized ROI Formula (CAGR)

CAGR = ( End ÷ Start )(1/n) − 1

Calculates the geometric compound annual growth rate over n years, allowing multi-year comparisons.

3. Comprehensive Net ROI Formula

Net ROI = ( Post-Tax Gain ÷ Total Outlay ) × 100

Adjusts gross proceeds for ongoing dividend/rental inflows, maintenance/brokerage costs, and capital gains taxes.

Step-by-Step Worked Example: ₹1,00,000 Invested $\rightarrow$ ₹2,50,000 in 5 Years

  1. Calculate Absolute Profit: ₹2,50,000 − ₹1,00,000 = ₹1,50,000.
  2. Calculate Simple ROI: ( ₹1,50,000 ÷ ₹1,00,000 ) × 100 = +150.00%.
  3. Calculate Wealth Multiplier: ₹2,50,000 ÷ ₹1,00,000 = 2.50x.
  4. Calculate Annualized CAGR Return: ( 2.50 )(1/5) − 1 = ( 2.50 )0.20 − 1 = 1.20112 − 1 = 20.11% p.a..

The Time Horizon Dilemma: Why Simple ROI is Deceptive for Multi-Year Assets


The single greatest flaw of Simple ROI is that it completely ignores the time value of money. Consider two competing investments that both advertise a 100% Total ROI:

  • Investment Alpha: Doubles your money (100% ROI) in 2 Years → Annualized CAGR = 41.42% p.a..
  • Investment Beta: Doubles your money (100% ROI) in 10 Years → Annualized CAGR = 7.18% p.a..

While both delivered an identical 100% nominal return, Investment Alpha generated nearly 6x the yearly compounding efficiency of Investment Beta. For any investment held longer than 12 months, always evaluate Annualized ROI (CAGR) to assess true financial performance.

Nominal ROI vs Real (Inflation-Adjusted) ROI: The Purchasing Power Reality Check


Nominal ROI measures the rupee increase in your balance sheet, but it tells you nothing about whether you can actually buy more goods and services. To find your true purchasing power growth, you must calculate Real ROI using the Fisher Equation:

Real Annualized ROI = [ ( 1 + Nominal Annualized ROI ) ÷ ( 1 + Annual Inflation Rate ) ] − 1

The Reality Check: If your mutual fund portfolio earns an 8.0% nominal annualized return over a 5-year period where Indian retail CPI inflation averages 6.0%, your true Real Annualized ROI is:

Real ROI = [ ( 1 + 0.08 ) ÷ ( 1 + 0.06 ) ] − 1 = ( 1.08 ÷ 1.06 ) − 1 = 1.89% p.a.

A high nominal return can still lead to financial stagnation if it barely keeps pace with the rising cost of living.

Gross ROI vs Net Post-Tax ROI: Factoring in Brokerage, Maintenance & Indian Taxes


In real-world investing, gross profit rarely equals net cash in your bank account. Significant statutory and operational deductions include:

  • Long-Term Capital Gains Tax (LTCG): Under Budget 2024–2026 guidelines, listed equity shares and equity mutual funds held over 12 months are taxed at 12.5% on capital gains exceeding ₹1.25 Lakh per financial year.
  • Short-Term Capital Gains Tax (STCG): Equity assets held for 12 months or less are taxed at 20.0%.
  • Debt Mutual Funds & Fixed Deposits: Taxed at the investor's applicable income tax slab rate (up to 30% + surcharge and cess).
  • Transaction Friction: Brokerage fees, Securities Transaction Tax (STT), stamp duty, exchange turnover charges, and real estate property maintenance.
Net ROI Golden Rule: Always assess investments based on their Post-Tax, Net-of-Fees Annualized ROI. An asset with a lower gross return but zero taxation (such as Sovereign Gold Bonds held to maturity or PPF) often beats higher-yielding taxable instruments.

Comprehensive Metric Comparison: ROI vs CAGR vs IRR vs ROE vs ROCE vs ROAS


Financial Metric Primary Purpose Best Used For Key Limitation
ROI (Return on Investment) Measures total percentage gain or loss on capital One-time trades, business CapEx, quick comparisons Ignores investment duration and cash flow timing
CAGR (Compound Annual Growth) Measures smoothed yearly compound growth rate Multi-year lump sums, mutual funds, stock holding Assumes constant growth; ignores interim volatility
XIRR / IRR (Internal Rate of Return) Annualized return for irregular multiple cash flows SIPs, SWPs, private equity, real estate drawdowns Requires numerical solver; complex to compute manually
ROE (Return on Equity) Corporate profitability relative to shareholder equity Fundamental stock analysis & corporate health Can be artificially inflated by high corporate debt
ROAS (Return on Ad Spend) Revenue generated per rupee spent on advertising Digital marketing, e-commerce, customer acquisition Measures gross revenue, not net bottom-line profit

Historical ROI Benchmarks Across Indian Asset Classes (10-Year Track Record)


To provide realistic expectations for personal financial planning, below are long-term historical annualized ROI ranges across major Indian asset classes:

Asset Class Historical 10-Yr CAGR Tax Treatment (Budget 2024–2026) Risk & Volatility Profile
Nifty 50 Large-Cap Index 12.0% – 14.0% 12.5% LTCG (above ₹1.25L exemption) Moderate Equity Risk
Mid & Small-Cap Mutual Funds 15.0% – 18.5% 12.5% LTCG (above ₹1.25L exemption) High Equity Volatility
Sovereign Gold Bonds (SGB) 10.5% – 12.5% 100% Tax-Free on RBI Maturity Low / Sovereign Backed
Commercial Real Estate (REITs) 8.0% + 6.5% Yield Dividends & 12.5% Capital Gains Moderate / Real Asset
Public Provident Fund (PPF) 7.1% p.a. 100% Tax-Free (EEE Status) Zero Risk (Government)
Bank Fixed Deposits (FD) 6.5% – 7.2% Taxable at Slab Rate (Net 4.5%–5.0%) Zero Capital Risk

How to Calculate ROI in Microsoft Excel and Google Sheets


You can easily model Simple and Annualized ROI in spreadsheets using built-in arithmetic and financial functions:

Simple ROI Formula: =( Ending_Cell − Starting_Cell ) ÷ Starting_Cell

Method 1 (RRI Function for Annualized Return): In cell C1 enter:

=RRI( Years, Initial_Investment, Final_Value )

Method 2 (Power Exponent Formula): In cell C1 enter:

=( Final_Value / Initial_Investment ) ^ ( 1 / Years ) − 1

Pro Tip: Format the formula cell as a percentage with 2 decimal places (`0.00%`) for crisp visual output.

Strategic Limitations and Common Pitfalls of Relying Exclusively on ROI


While ROI is universally popular, relying on it in isolation can lead to flawed capital allocation decisions:

  • Ignores Risk and Volatility: A 25% ROI in high-risk crypto assets is not equivalent to a 20% ROI in sovereign-backed infrastructure bonds. ROI does not adjust for downside volatility or Sharpe ratio.
  • Scale and Rupee Magnitude Distortion: A 500% ROI on a ₹1,000 investment yields only ₹5,000 profit, whereas a 20% ROI on a ₹50,00,000 investment creates ₹10,00,000 of wealth. Always evaluate absolute rupee profit alongside percentage ROI.
  • Reinvestment Risk: Annualized ROI assumes that all cash flows and interim gains can be continuously reinvested at the identical rate of return, which is rarely possible in volatile market cycles.

Frequently Asked Questions


What is Return on Investment (ROI) and how is it calculated?

Return on Investment (ROI) is a fundamental financial profitability ratio used to evaluate the efficiency and performance of an investment relative to its initial cost. The standard mathematical formula is: ROI = [(Final Value - Initial Investment) / Initial Investment] × 100. For example, if you invest ₹1,00,000 in a stock portfolio and sell it for ₹1,60,000, your net profit is ₹60,000, resulting in a total ROI of 60%.

What is the difference between Simple ROI and Annualized ROI (CAGR)?

Simple ROI measures the absolute percentage gain over the entire holding period without considering how long it took. In contrast, Annualized ROI (also known as Compound Annual Growth Rate or CAGR) calculates the geometric yearly growth rate. For example, a 100% total ROI achieved in 2 years represents a 41.42% annualized return, whereas the same 100% total ROI over 10 years equals just a 7.18% annualized return. Comparing investments across different time horizons requires Annualized ROI.

What is the formula for Annualized ROI?

The mathematical formula for Annualized ROI is: Annualized ROI = [(1 + Total ROI / 100) ^ (1 / n)] - 1, where 'Total ROI' is the overall percentage gain expressed as a percentage, and 'n' is the investment holding period in years. Multiplying the result by 100 converts the decimal into an annual percentage rate (% p.a.).

How do taxes and transaction expenses impact Net ROI in India?

Gross ROI only evaluates capital appreciation, ignoring statutory taxes and transaction friction. Under Indian tax laws (Budget 2024–2026), listed equity investments held over 12 months incur a 12.5% Long-Term Capital Gains (LTCG) tax on profits exceeding ₹1.25 Lakh, while short-term equity gains incur a 20% STCG tax. Additionally, brokerage, Securities Transaction Tax (STT), stamp duty, and property maintenance reduce your take-home returns. Net ROI is calculated by subtracting all transaction costs and taxes from gross profit before dividing by the initial investment.

What is Real ROI and how does inflation affect investment returns?

Real ROI measures the net growth in your actual purchasing power after adjusting nominal returns for inflation. Governed by the Fisher Equation: Real Return = [(1 + Nominal Return) / (1 + Inflation Rate)] - 1. For instance, if an investment yields a 10.0% nominal annualized ROI during a period with 6.0% annual CPI inflation, your Real Annualized ROI is approximately 3.77% p.a. (not 4.0%). If nominal returns fall below the inflation rate, your Real ROI is negative.

How does ROI compare to IRR, CAGR, and ROE?

While ROI evaluates total profitability for point-to-point investments, CAGR normalizes multi-year lump-sum returns into an annual compound rate. Internal Rate of Return (IRR or XIRR) is required when investments involve multiple cash inflows and outflows at irregular intervals (such as SIPs or private equity drawdowns). Return on Equity (ROE) evaluates a corporation's net income relative to shareholders' equity rather than an investor's individual portfolio.

What is a good ROI benchmark for investments in India?

In the Indian economy, benchmark annualized ROIs vary by asset class: Fixed Deposits and Government Bonds offer 6.5% to 7.5% p.a.; Sovereign Gold Bonds (SGB) and Physical Gold historically deliver 10% to 12% p.a. plus 2.5% sovereign interest; Broad-market Equities (Nifty 50) have historically generated 12% to 14% p.a.; Actively managed Mid & Small-Cap funds target 15% to 18% p.a.; and Prime Commercial Real Estate typically yields 8% to 10% capital growth alongside 6% to 8% rental yields.

How can I calculate ROI and Annualized ROI in Microsoft Excel or Google Sheets?

In Microsoft Excel or Google Sheets, you can calculate Simple ROI with the formula: =(Final_Value - Initial_Cost) / Initial_Cost. Format the cell as a percentage. To calculate Annualized ROI, use the RRI function: =RRI(Years, Initial_Cost, Final_Value), or the exponent formula: =(Final_Value / Initial_Cost) ^ (1 / Years) - 1.