ROI Calculator - Return on Investment

How to use the ROI calculator

What this calculator does

This calculator estimates the total return on investment from one initial invested amount and one final returned amount. It shows the dollar gain or loss, simple ROI as a percentage, the ending-value multiple, the exact holding period between two dates, and an annualized compounded equivalent return. It is useful for a quick first-pass comparison, but it does not determine whether an investment is suitable, safe, tax-efficient, or fairly valued.

When to use it

Use it to review a completed investment, compare projects with similar cash-flow patterns, translate a multi-year total return into an annual rate, or test a target exit value before committing funds. For investments with several deposits, distributions, or irregular cash flows, a cash-flow-based measure such as IRR is usually more appropriate.

How to calculate

1. The calculator opens with a ready-to-use example: $600,000 invested, $900,000 returned, and a three-year holding period. Its example XLSX workbook is immediately available.
2. Replace the Invested amount and Returned amount using U.S. decimal notation. Enter dates in the browser's date control.
3. Read Return on investment first, then use Gain or loss, Value multiple, and Annualized ROI to understand scale and time.
4. Select Download Excel to export the current validated inputs and results. Reset clears the demonstration data, results, and workbook state; export stays disabled until a complete valid state is entered again.

Input guide

Invested amount is required currency greater than zero, such as 600,000.00. It represents the initial cost basis used in the ROI denominator. A higher invested amount lowers ROI when returned proceeds stay unchanged. Do not enter a percentage or scientific notation. Returned amount is required nonnegative currency, such as 900,000.00. It is the total ending proceeds, not merely the profit; entering profit instead of proceeds overstates or understates the result. Start date and End date are required valid dates, for example January 1, 2023 and January 1, 2026. The end must be later than the start. Dates do not change simple ROI, but they determine the holding period and annualized ROI.

Output guide

Return on investment is the gain or loss divided by invested amount. Zero means the returned amount equals the investment; a negative value means a loss. Gain or loss is an exact dollar difference. Annualized ROI converts the beginning-to-ending value ratio into a compounded yearly rate; it is unavailable when the returned amount is zero because a positive growth factor is required. Value multiple is returned amount divided by invested amount, so 1.50× means the ending value is one and a half times the starting value. Holding period is the elapsed time in years based on actual days divided by 365.2425. The summary pills repeat profitability, ROI, and time, while the calculation-detail table shows the same canonical values and formula basis.

Worked example

With $600,000 invested and $900,000 returned, gain equals $900,000 – $600,000 = $300,000. Simple ROI is $300,000 ÷ $600,000 = 0.50, or 50.00%. Over exactly three years, annualized ROI is (900,000 ÷ 600,000)^1/3 – 1 = 14.47%. These values match the first-open results and the workbook checkpoints.

Learn more

The U.S. Securities and Exchange Commission explains why investors should consider investment risk alongside return. For comparing money received at different times, review the Federal Reserve Bank of St. Louis explanation of the time value of money.