ROI Calculator (Return on Investment)
Calculate simple ROI, annualized ROI, real estate cap rate, rental property cash-on-cash return, and marketing ROI in one free tool. No sign-up required.
Financial Disclaimer: ROI results are illustrative estimates only. They do not account for taxes, fees, inflation, or investment risk. Past returns do not guarantee future performance. Consult a qualified financial advisor before making investment decisions. Full disclaimer →
fFormula & How It's Calculated
Frequently Asked Questions (FAQ)
What is Return on Investment (ROI)?
Return on Investment (ROI) measures profitability relative to cost. ROI Formula: ((Final Value – Initial Investment) ÷ Initial Investment) × 100. A 35% ROI on a $10,000 investment means you gained $3,500.
How do I calculate ROI formula in Excel?
In Excel: =((B1-A1)/A1)*100 where A1 is initial investment and B1 is final value. For annualized ROI (CAGR): =((B1/A1)^(1/C1)-1)*100 where C1 is the number of years.
How does a real estate ROI calculator work?
Real estate ROI uses two metrics: Cap Rate = Annual NOI ÷ Property Value × 100, and Cash-on-Cash Return = Annual Cash Flow ÷ Cash Invested × 100. A property generating $18,000 NOI on a $200,000 value has a 9% cap rate.
What is a marketing ROI calculator?
Marketing ROI = ((Revenue Attributed – Campaign Cost) ÷ Campaign Cost) × 100. A $5,000 campaign generating $20,000 revenue = 300% marketing ROI. This also applies to SEO ROI calculations.
What is annualized ROI vs simple ROI?
Simple ROI shows total return for any time period. Annualized ROI (CAGR) normalises it to a yearly figure for fair comparison. Formula: (Final Value ÷ Initial)^(1÷Years) – 1, expressed as a percentage.
What is Return on Investment? Formula and Calculation Methods
Return on investment (ROI) is a key financial performance metric that measures efficiency of an investment relative to its cost. It is used across every industry — from equities and real estate to digital marketing and SEO campaigns.
ROI Formula in Excel — Step-by-Step
- Place your initial investment in cell A1 (e.g., 10000)
- Place your final value in cell B1 (e.g., 13500)
- In C1 enter:
=((B1-A1)/A1)*100 - Result: 35% simple ROI
- For annualized ROI with years in D1:
=((B1/A1)^(1/D1)-1)*100
ROI Benchmark Reference Table
Use these industry benchmarks to contextualise your ROI result. Remember: benchmarks vary significantly by sector, time horizon, market conditions, and risk profile.
| Investment Type | Typical Annual ROI |
|---|---|
| S&P 500 (historical avg.) | ~10% nominal / ~7% real |
| Real Estate (rental) | 4% – 12% |
| High-Yield Savings | 4% – 5.5% |
| Marketing (B2B) | 5:1 ($5 return per $1 spent) |
| SEO / Content Marketing | 200% – 800%+ |
| Bonds (U.S. Treasury) | 4% – 5% |
| Venture Capital | 20% – 25%+ (target) |
Sources: S&P Dow Jones Indices; Statista; HubSpot State of Marketing Report; U.S. Treasury. For informational use only.
Limitations of ROI as a Metric
ROI is a powerful but simplified metric. Before relying on it for major decisions, understand these important limitations:
Ignores Time Value of Money
Simple ROI treats a 35% return over 1 year the same as a 35% return over 10 years. Use annualized ROI (CAGR) for fair time-adjusted comparisons.
Excludes Inflation
A 5% ROI with 4% inflation yields only ~1% real return. Always consider inflation-adjusted (real) returns for long-term investments.
Does Not Reflect Risk
Two investments may show the same ROI but carry vastly different risk levels. Use risk-adjusted metrics like Sharpe Ratio for complete analysis.
Ignores Taxes & Fees
Capital gains tax, management fees, transaction costs, and brokerage commissions can significantly reduce net ROI. Always calculate after-tax, after-fee returns.
Real Estate ROI Calculator & Rental Property ROI Calculator
Real estate investors use two key ROI metrics. The real estate ROI calculator helps evaluate property purchases, while the rental property ROI calculator tracks ongoing cash returns.
Cap Rate (Capitalisation Rate)
Best for comparing properties at purchase.
Cash-on-Cash Return
Best for leveraged (mortgaged) property investments.
Marketing ROI Calculator: B2B Campaigns & SEO ROI Calculator
The marketing ROI calculator quantifies the revenue impact of marketing spend. For digital channels, the SEO ROI calculator uses organic traffic value and conversion rates to estimate return on SEO investment.
SEO ROI example: If SEO brings 1,000 additional monthly visitors converting at 2% with a $500 average order value, monthly revenue = $10,000. If your monthly SEO cost is $2,000, SEO ROI = ((10,000 – 2,000) ÷ 2,000) × 100 = 400% monthly ROI.
Related Financial Calculators
Explore more free calculators
← All Calculators