How to use the ROI calculator
- Enter the amount invested, including fees.
- Enter the final value or the total you received.
- Enter the years held to see the annualised ROI.
- Read the profit, ROI and annualised ROI.
Formulas
- Profit = final value − cost.
- ROI = profit ÷ cost.
- Annualised ROI = (final value ÷ cost)^(1 ÷ years) − 1.
Worked example
You invest $10,000 and three years later it is worth $13,000.
- Profit: $3,000.
- ROI: 30%.
- Annualised ROI: 9.14% a year.
If the same 30% had taken 6 years, the annualised ROI would be about 4.5%.
ROI for business decisions
ROI is often used to compare projects: new equipment, a marketing campaign or software. Include all costs (purchase, installation, training, running costs) and all benefits (extra revenue, savings). For projects with cash flows over several years, the time value of money matters; the CAGR and XIRR calculator handles dated cash flows.
Tips and common mistakes
- Include all costs; leaving out fees overstates ROI.
- Annualise before comparing investments held for different periods.
- Consider risk; a higher ROI may come with higher risk.
- Account for inflation to see the real return.
- Use XIRR if you added or withdrew money during the period.
ROI versus other measures
ROI is simple and widely understood, but it ignores timing within the period and the size of the investment. A 50% ROI on $100 is less useful than a 10% ROI on $100,000. Look at the profit in money as well as the percentage, and use annualised figures to compare across time.
Worked business example
A small business buys equipment for $8,000 and expects it to save $3,000 a year in labour for four years. Total benefit is $12,000, so profit is $4,000 and ROI is 50% over four years, about 10.7% a year when annualised on the same basis. Because the savings arrive gradually rather than all at the end, the true annual return is higher still; enter the cash flows by date in the XIRR calculator for a more accurate figure.
Common ROI pitfalls
- Ignoring opportunity cost: money tied up in one investment can’t earn elsewhere.
- Using gross instead of net figures: subtract taxes and fees where possible.
- Comparing different risk levels: a guaranteed 5% and a risky 8% are not directly comparable.
- Cherry-picking dates: choosing a favourable start or end point can make returns look better than they were.
Limitations
The calculator assumes a single investment at the start and a single value at the end. Interim cash flows, taxes and risk are not included.