ROI Calculator: How to Calculate Return on Investment
Investing

ROI Calculator: How to Calculate Return on Investment

Back to Blog12/28/20257 min readBy AllProCalculator Team

ROI Calculator: How to Calculate Return on Investment

!Investment returns and growth

ROI (Return on Investment) is the fundamental metric for evaluating any investment's performance. Whether you're comparing stocks, real estate, business investments, or marketing campaigns, ROI tells you how effectively your money is working.

In this guide, we'll cover ROI formulas, worked examples, and practical applications. Use our ROI Calculator for instant calculations.

The Basic ROI Formula

`` ROI = (Gain from Investment - Cost of Investment) / Cost of Investment × 100 `

Or simplified: ` ROI = (Final Value - Initial Investment) / Initial Investment × 100 `

Example

You invested ₹1,00,000 and it's now worth ₹1,35,000.

` ROI = (1,35,000 - 1,00,000) / 1,00,000 × 100 ROI = 35,000 / 1,00,000 × 100 ROI = 35% `

ROI for Different Investment Types

Stock Investment

Investment: ₹50,000 in stock Sale price: ₹62,500 Time held: 2 years

Simple ROI: ` ROI = (62,500 - 50,000) / 50,000 × 100 = 25% `

Including dividends (₹2,000 received): ` ROI = (62,500 + 2,000 - 50,000) / 50,000 × 100 = 29% `

Real Estate Investment

Purchase price: ₹50,00,000 Selling price: ₹70,00,000 Renovation costs: ₹5,00,000 Transaction costs: ₹3,00,000
` Total Cost = 50,00,000 + 5,00,000 + 3,00,000 = 58,00,000 Gain = 70,00,000 - 58,00,000 = 12,00,000 ROI = 12,00,000 / 58,00,000 × 100 = 20.7% `

Marketing Campaign

Ad spend: ₹10,000 Revenue generated: ₹45,000
` ROI = (45,000 - 10,000) / 10,000 × 100 = 350% `

This is also called ROAS (Return on Ad Spend) in marketing.

Annualized ROI

Simple ROI doesn't account for time. A 50% return in 1 year is better than 50% in 5 years.

Annualized ROI Formula

` Annualized ROI = ((Final Value / Initial Value)^(1/Years) - 1) × 100 `

This is the same as CAGR (Compound Annual Growth Rate).

Example: Comparing Two Investments

Investment A: 50% total return in 2 years
` Annualized = ((1.50)^(1/2) - 1) × 100 = 22.5% per year ` Investment B: 50% total return in 5 years ` Annualized = ((1.50)^(1/5) - 1) × 100 = 8.4% per year ` Investment A is clearly better when time is factored in.

Learn more: CAGR vs Absolute Returns

ROI vs Other Metrics

ROI vs IRR (Internal Rate of Return)

MetricUse CaseAccounts for Time Value?
ROISimple comparisonNo
IRRComplex cash flowsYes
IRR is more accurate for investments with multiple cash flows over time.

ROI vs NPV (Net Present Value)

MetricWhat It Shows
ROIPercentage return
NPVDollar/rupee value created
NPV shows absolute value, ROI shows efficiency.

ROI vs CAGR

MetricBest For
Simple ROIQuick comparison, single period
CAGRMulti-year investments

ROI with Recurring Investments

For SIPs or regular investments, use XIRR (Extended IRR) instead of simple ROI.

Example: Monthly SIP
  • Invested ₹10,000/month for 3 years
  • Total invested: ₹3,60,000
  • Final value: ₹4,50,000
Simple ROI: 25%

But XIRR (accounting for when each payment was made): ~14% annualized

Use our SIP Calculator for accurate SIP returns.

Total Return vs ROI

Total Return

Includes all sources of return:

  • Capital appreciation
  • Dividends
  • Interest income
  • Other distributions
` Total Return = (Ending Value + Total Income - Initial Investment) / Initial Investment × 100 `

Price Return (Simple ROI)

Only considers price change: ` Price Return = (Ending Price - Starting Price) / Starting Price × 100 `

Always use total return for accurate investment comparison.

Negative ROI

A negative ROI means you lost money.

Example:
  • Invested: ₹1,00,000
  • Current value: ₹85,000
` ROI = (85,000 - 1,00,000) / 1,00,000 × 100 = -15% `

You've lost 15% of your investment.

ROI Limitations

1. Doesn't Account for Time

30% in 1 year ≠ 30% in 10 years Use annualized ROI for proper comparison.

2. Doesn't Account for Risk

A 15% return from volatile stocks isn't the same as 15% from stable bonds.

3. Ignores Cash Flow Timing

Getting ₹10,000 today is worth more than ₹10,000 in 5 years.

4. Can Be Manipulated

How you define "investment" and "return" affects results.

Business ROI Applications

ROI on Equipment

  • Cost: ₹5,00,000
  • Annual savings: ₹1,25,000
  • Annual ROI: 25%
  • Payback period: 4 years

ROI on Employee Training

  • Training cost: ₹50,000
  • Productivity increase value: ₹2,00,000/year
  • First-year ROI: 300%

ROI on Software

Total cost (including implementation):

  • License: ₹2,00,000
  • Implementation: ₹1,00,000
  • Training: ₹50,000
  • Total: ₹3,50,000
Annual benefit: ₹2,00,000

` Payback: 1.75 years Annual ROI: 57% `

Excel ROI Formulas

Simple ROI

`excel =(B1-A1)/A1*100 ` Where A1 = Initial investment, B1 = Final value

Annualized ROI

`excel =((B1/A1)^(1/C1)-1)*100 ` Where C1 = Years

IRR (for multiple cash flows)

`excel =IRR(A1:A10) `` Where A1:A10 contains cash flows (negative for investments, positive for returns)

Frequently Asked Questions

What is a good ROI?

Depends on the investment type and risk:

  • Bank FD: 6-7% is normal
  • Stock market: 10-12% long-term is good
  • Business investment: >20% often expected
  • Marketing: >100% typically required

How do I calculate ROI on a house?

Include:

  • Purchase price
  • Closing costs
  • Renovations
  • Ongoing costs (taxes, maintenance)
  • Rental income (if applicable)
  • Selling price minus fees
ROI = (Net Profit / Total Investment) × 100

Is higher ROI always better?

Not necessarily. Consider:

  • Time period
  • Risk taken
  • Effort required
  • Opportunity cost
See: Risk-adjusted returns


Related Articles

Advertisement

Share this article