ROI Calculator
Total and annualized return on an investment, counting income, costs and the dates held.
Results
Return on investment (ROI)
27.50%
A net gain of $2,750.00 on $10,000 invested from March 15, 2023 to September 15, 2026
- Net gain
- $2,750.00Net value minus the $10,000 invested
- Annualized return
- 7.18% a yearCompounded yearly over 3.5044 years
- Holding period
- 1,280 days3 years 6 months; 3.5044 years at 365.25 days a year
- Net value
- $12,750.00$12,500 final + $400 income − $150 costs
- Multiple of money
- 1.28×Net value ÷ amount invested
- Break-even final value
- $9,750.00The final value that gives 0% ROI after your income and costs
How this was calculated
- Net value = final value + income − costs = $12,500 + $400 − $150 = $12,750.00
- Net gain = net value − amount invested = $12,750.00 − $10,000 = $2,750.00
- ROI = net gain ÷ amount invested = $2,750.00 ÷ $10,000 = 0.275 = 27.50%
- Multiple of money = net value ÷ amount invested = $12,750.00 ÷ $10,000 = 1.28×
- Break-even final value = amount invested + costs − income = $10,000 + $150 − $400 = $9,750.00
- Holding period: March 15, 2023 to September 15, 2026 is 1,280 days, so t = 1,280 ÷ 365.25 = 3.5044 years
- Annualized return = (1 + ROI)1 ÷ t − 1 = (1.275)1 ÷ 3.5044 − 1 = 0.071785 = 7.18% a year
- The same answers in a spreadsheet, ROI then annualized return:
=(12500+400-150-10000)/10000=((12500+400-150)/10000)^(365.25/(DATE(2026,9,15)-DATE(2023,3,15)))-1
| Holding period | Annualized return | ROI ÷ years |
|---|---|---|
| 1 month | 1,745.53% | 330.00% |
| 3 months | 164.27% | 110.00% |
| 6 months | 62.56% | 55.00% |
| 1 year | 27.50% | 27.50% |
| 2 years | 12.92% | 13.75% |
| 3 years | 8.44% | 9.17% |
| 3.5044 years (your input) | 7.18% | 7.85% |
| 5 years | 4.98% | 5.50% |
| 10 years | 2.46% | 2.75% |
| 20 years | 1.22% | 1.38% |
| 30 years | 0.81% | 0.92% |
The amounts stay as you entered them, a 27.50% ROI ($2,750.00 on $10,000); only the time changes. Under a year, the annualized figure assumes the pace lasts a whole year.
Assumptions
- The whole amount invested counts as going in on the start date, and the final value, income and costs as arriving on the end date.
- Years are days ÷ 365.25, an average year with a leap day every four years (1,280 days = 3.5044 years). So a 365-day calendar year counts as 0.9993 years.
- Costs lower the gain but are not added to the amount invested. Include any tax paid in costs for an after-tax ROI.
- Income counts at face value, with nothing earned on it after it arrived. Dividends that were reinvested are already in the final value.
- With no income or costs, the annualized return is the Compound annual growth rate: The steady yearly rate that would grow a starting value into an ending value over a number of years: (end ÷ start)^(1 ÷ years) − 1. It smooths out the ups and downs along the way. Also called the geometric average return. It is lower than the simple average of the yearly returns unless every year’s return is the same. Source: OpenStax, Principles of Finance of the investment’s value.
- Deposits and withdrawals during the period are not modeled; for those, the Internal rate of return: The discount rate that makes a project’s net present value exactly zero. It has no direct formula, so it is found by trial or with a solver, and it reads as the project’s yearly rate of return. Source: OpenStax, Principles of Finance is the measure to use.
- Amounts are rounded for display; the calculation keeps full precision.
Calculated in your browser. This site doesn't send or store the numbers you enter.
What this calculator answers
How much an investment gained or lost compared with what you put in, and the steady yearly rate that would have produced the same result over the time you held it. It counts the income the investment paid you in cash and the costs you paid along the way, so the answer is your net return, not just the change in price. It suits one purchase held to a sale or to today: shares, a fund, a collectible, a piece of equipment or a small business stake.
How to use it
- Amount invested: what you paid at the start, in dollars.
10,000,$10,000and10kall work. - Final value: what you sold it for, or what it is worth today. Enter
0if nothing is left. - Cash income (optional): money the investment paid out to you while you held it, such as dividends, interest or rent. Leave out dividends that were reinvested, because they bought more shares and are already in the final value.
- Costs and fees (optional): commissions, account or advisory fees billed to you, and any tax you want the result to account for.
- Holding period: the start and end dates, or years and months. Leave the years and months blank if you only want the total ROI.
- Inflation rate (optional): the average yearly inflation over the period, in percent, for the return after inflation, measured in what the money could buy.
- I added or withdrew money along the way: tick it if the amount invested changed during the period (see “ROI vs CAGR vs IRR” below).
Results update as you type. The Try buttons load a total loss, costs larger than what was left, a 10% gain in one month, and the example after 3% inflation. To compare investments held for different lengths of time, press Save for comparison, change the inputs and save again: each saved scenario shows its difference from the first, and a higher annualized return is marked as better. An investment held for less than a year isn’t ranked this way, because its annualized figure is only a pace (see why short holding periods exaggerate annualized returns, below).
How to calculate ROI
Add the income to the final value, subtract the costs, subtract what you invested, and divide by what you invested. To annualize it, add 1, raise it to the power of 1 divided by the years held, and subtract 1.
- is the amount invested.
- is the final value, the income received and the costs and fees, so is the net value.
- is the holding period in years: the days between the dates divided by 365.25, or months divided by 12.
- is the annualized return, the rate that, compounded once a year for years, turns 1 into .
Worked example: $10,000 held for 3½ years
You invest $10,000 on March 15, 2023. By September 15, 2026 the holding is worth $12,500. Along the way it paid $400 of dividends in cash, and you paid $150 in fees.
- Net value: $12,500 + $400 − $150 = $12,750.00.
- Net gain: $12,750.00 − $10,000 = $2,750.00.
- ROI: $2,750.00 ÷ $10,000 = 0.275, or 27.50%. The multiple of money is 1.275, shown as 1.28×.
- Holding period: March 15, 2023 to September 15, 2026 is 1,280 days, so t = 1,280 ÷ 365.25 = 3.5044 years.
- Annualized return: 1.275^(1 ÷ 3.5044) − 1 = 0.0718, or 7.18% a year.
A final value of $9,750.00 would have broken even: $10,000 invested plus $150 of fees, less the $400 of income. Entered as 3 years and 6 months instead of dates, the period is exactly 3.5 years and the annualized return is 7.19%.
Total ROI vs annualized ROI
ROI is the total return over however long you held the investment; the annualized return is the same result spread into an equal rate for each year. A 27.50% ROI over the example’s 1,280 days and a 27.50% ROI over one year are very different results: 7.18% a year against 27.50% a year. To compare investments held for different lengths of time, compare their annualized returns.
The annualized return compounds: each year’s return builds on the last. Dividing the ROI by the years instead gives a simple average, 27.50% ÷ 3.5044 = 7.85% for the example. For a gain held longer than a year, the simple average is always the higher of the two, because it ignores that later growth came on top of earlier growth.
Why short holding periods exaggerate annualized returns
Annualizing assumes the pace you saw would continue for a whole year, compounding as it went. Over a few weeks or months that assumption turns ordinary moves into huge yearly rates: a 10% gain in one month becomes 1.1¹² − 1 = 213.84% a year. The table shows the example’s 27.50% ROI spread over other lengths of time.
| Holding period | Annualized return | ROI ÷ years |
|---|---|---|
| 1 month | 1,745.53% | 330.00% |
| 3 months | 164.27% | 110.00% |
| 6 months | 62.56% | 55.00% |
| 1 year | 27.50% | 27.50% |
| 2 years | 12.92% | 13.75% |
| 5 years | 4.98% | 5.50% |
| 10 years | 2.46% | 2.75% |
Under a year, the calculator still shows the annualized figure but says it holds only if the pace lasted a whole year. Under 30 days it shows the total ROI as the answer and puts the annualized figure in the small print. The GIPS standards that investment firms follow when they report performance go further and don’t allow returns for periods shorter than a year to be annualized at all.
Dates and the 365.25-day year
Years are the days between your dates divided by 365.25, the average length of a year with a leap day every fourth year. Over several years this matches the calendar closely: 1,461 days, four years that include one leap day, is exactly 4 years. A single calendar year is 365 or 366 days, so it counts as 0.9993 or 1.0021 years, and a 10% gain over one calendar year shows as 10.01% or 9.98% a year. Entering 12 months under years and months gives exactly 10.00%.
Can ROI be negative? Losses, total loss and fees
Yes. ROI is negative whenever the net value is below the amount invested. $10,000 that falls to $7,000 over 2 years is a −30.00% ROI, or −16.33% a year.
A total loss, with nothing left and no income or costs, is −100%, and the annualized return is also −100% however long you held it. ROI goes below −100% only when costs are larger than what was left: $10,000 invested with a final value of $0 and $500 of closing costs is (0 − 500 − 10,000) ÷ 10,000 = −105.00%. You lost more than you put in. There is no annualized return in that case, because no yearly rate turns a positive amount into a negative one, and the calculator says so instead of showing an error.
Should ROI include dividends, fees and taxes?
Include what actually changed the money you ended up with. Dividends and interest paid to you in cash are part of the return; leave them out and a stock that paid a large dividend can look like a loss. Fees and commissions you paid reduce the return. Taxes are optional: leave them out for a pre-tax ROI, or add the tax you paid on the gain and the income to the costs for an after-tax ROI.
Two amounts are already inside the final value and should not be entered again. A fund’s operating expenses are taken from the fund’s assets, so they are reflected in its value. Dividends that were reinvested bought more shares, so they are part of the final value too.
This calculator subtracts costs from the gain; it doesn’t add them to the amount invested. If you would rather treat a purchase commission as part of what you invested, add it to the amount invested and leave it out of costs. The results differ slightly because the divisor changes.
ROI vs CAGR vs IRR: which one to use
- ROI is the total gain or loss as a percentage of what you put in, for one amount invested at the start.
- Annualized ROI spreads that over the years held. For one amount with no income or costs it is the same number as the CAGR of the investment’s value; a CAGR calculator works on any two values, such as revenue or prices.
- IRR (internal rate of return) is the measure to use when money went in or came out more than once, because it counts when each amount moved.
Money added part way through makes ROI misleading. Say you invest $10,000, add another $10,000 a year later, and have $22,000 at the end of year 2. Treating all $20,000 as invested from the start gives a 10.00% ROI and 4.88% a year, but half the money was invested for only one year. The IRR of those cash flows is 6.52% a year. When you tick “I added or withdrew money along the way”, the calculator says this and, for a holding period of whole months, offers to carry your start and end amounts to an NPV and IRR calculator as yearly, quarterly or monthly cash flows, so you can fill in the rest.
ROI on a rental property
Rent, mortgage payments, repairs and a sale price turn a property into many cash flows over many years. A rental property calculator works through those, with cash flow, cap rate and cash-on-cash return; this page suits the simple case of a purchase price, net rent received and a sale.
Reading the result
- ROI (the headline) is the net gain as a percentage of the amount invested, with the dollar gain or loss and the dates under it.
- Annualized return is the yearly rate. Under a year it is marked as holding only if the pace lasted; under 30 days it is replaced by “Not meaningful” with the figure in the small print. With an inflation rate, the rate after inflation is shown under it.
- Holding period shows the days and the calendar years, months and days between your dates, and the years used in the formula.
- Net value, multiple of money and break-even final value are what you ended up with after income and costs, that amount as a multiple of what you put in, and the final value that would have given 0%.
- How this was calculated repeats each step with your numbers and ends with the same formulas for a spreadsheet.
- The same ROI over other holding periods keeps your amounts and changes only the time, with the simple average beside the annualized return; Download CSV saves its rows.
Assumptions and limitations
- The whole amount invested counts as going in on the start date, and the final value, income and costs as arriving on the end date. Income received early and costs paid early are not given any extra weight.
- Deposits and withdrawals in between are not modeled. Use an IRR for those.
- The inflation-adjusted return uses (1 + return) ÷ (1 + inflation) − 1, which is the return of the net value measured in start-date dollars, and treats the rate you enter as the average for every year. Subtracting the inflation rate from the return gives a close but slightly different figure.
- Taxes are counted only if you add them to costs. What is taxed depends on the investment and the kind of account; fund distributions in a taxable account can be taxed even when they are reinvested.
- ROI measures what happened; it doesn’t measure risk, and a past return says nothing certain about future ones.
- Results are rounded for display, and the whole page is an educational estimate, not investment or tax advice.
Common mistakes
- Annualizing a few weeks. A 10% gain in one month is not a 213.84% investment. Quote the total ROI for short periods.
- Comparing total ROI across different holding periods. 40% over ten years is a lower yearly return than 15% over one year. Compare annualized returns.
- Counting reinvested dividends twice. If dividends bought more shares, they are in the final value already; income is only cash paid out to you.
- Leaving out fees and commissions. Commissions on the purchase and on the sale come out of your gain, as do account and advisory fees you paid.
- Using ROI when you added money over time. Regular contributions to an account make the ending balance larger without being a return. Use an IRR, or XIRR in a spreadsheet, with the date of each amount.
- Entering the gain as the final value. The final value is the whole amount at the end, $12,500 in the example, not the $2,500 increase.
Questions
How do I calculate ROI in Excel or Google Sheets?
With the amount invested in B1, the final value in B2, income in B3 and costs in B4, the ROI is =(B2+B3-B4-B1)/B1, formatted as a percentage. With the start date in B5 and the end date in B6, the annualized return is =((B2+B3-B4)/B1)^(365.25/(B6-B5))-1, because subtracting two dates gives the days between them. The last step of the calculator writes both formulas with your own numbers. If you added money along the way, list every amount with its date and use XIRR instead.
What does a 30% ROI mean?
You got back your money plus 30 cents for every dollar invested, after income and costs, over the whole holding period. It says nothing about how long that took. Earned over 5 years, 30% is 5.39% a year; earned over 1 year, it is 30% a year.
What is a good ROI?
There is no single number. Compare the annualized return, not the total ROI, with what you could have earned elsewhere over the same dates at a similar risk, such as the rate a savings account or a certificate of deposit paid then, and look at it after inflation. Riskier investments generally have to offer higher returns to attract investors, so a higher return is not simply better if it came with a much bigger chance of loss.
Sources
- Principles of Finance, 15.1 Risk and Return to an Individual Asset OpenStax (Rice University) Total dollar return as dividend income plus capital gain; total percent return as that return divided by the amount paid; the holding-period return over the whole time held, converted to an annual rate with (1 + HPR)^(1/n) − 1; the geometric average is below the arithmetic average unless every year’s return is the same.
- Global Investment Performance Standards (GIPS) for Firms 2020, provisions 2.A.12 and 2.A.13 CFA Institute Returns for periods of less than one year must not be annualized (2.A.12), and returns are calculated after transaction costs (2.A.13).
- How Fees and Expenses Affect Your Investment Portfolio (Investor Bulletin) U.S. Securities and Exchange Commission, Investor.gov Fees and expenses reduce the money earning a return; transaction fees such as commissions and ongoing fees; fund operating expenses are deducted from the fund’s assets.
- Fund Distributions (Investor Bulletin) U.S. Securities and Exchange Commission, Investor.gov Reinvested distributions buy more shares instead of paying cash; taxes can be due on distributions even when they are reinvested; distributions are not the same as performance.
- What is Risk? U.S. Securities and Exchange Commission, Investor.gov All investments involve some risk, and as investment risks rise, investors generally seek higher returns to compensate for them.
- Principles of Finance, 16.3 Internal Rate of Return (IRR) Method OpenStax (Rice University) The IRR is the discount rate that sets the present value of the cash inflows equal to that of the outflows.
- Principles of Finance, 3.4 Interest Rates OpenStax (Rice University) The real interest rate is the nominal rate minus the inflation rate (the approximation the exact division refines).
- Consumer Price Index Frequently Asked Questions U.S. Bureau of Labor Statistics The CPI is used to deflate other series into inflation-free dollars and to measure the purchasing power of the dollar.
- DATE function Microsoft Support Excel stores dates as sequential serial numbers so they can be used in calculations, which is why subtracting two dates gives the days between them.
- XIRR function Microsoft Support XIRR returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.
Smart Financial Calc: https://smartfinancialcalc.com/finance/roi-calculator/