Return-on-Investment

This ROI calculator (return on investment) calculates an annualized rate of return using exact dates. Also known as ROR (rate of return), these financial calculators allow you to compare the results of different investments. More below...»

Original Size

npv and irr calculator. An IRR calculation is an annualized ROI calculation when there are multiple cash flows.

If you have multiple investments or withdrawals on different dates then use thisAs a side benefit of this calculator's date accuracy, you can also use it to do date math calculations. That is, it will find the date that is "X" days from the start date or given two dates, it will calculate the number of days between them.

Calendar Tip: When using the calendar, click on the month at the top to list the months, then, if needed, click on the year at the top to list years. Click to pick a year, pick a month and pick a day. Naturally you can scroll through the months and days too. Or you can click on "Today" to quickly select the current date.

If you prefer not using a calendar, single click on a date or use the [Tab] key (or [Shift][Tab]) to select a date. Then, as mentioned, type 8 digits only - no need to type the date part separators. Also, because the date is selected, you do not need to clear the prior date before typing. If your selected date format equals mm/dd/yyyy, then for March 15, 2016, type 03152016.

ROI or Return on Investment calculates the percentage gained or lost on an investment.

Enter the "Amount Invested" and the date the investment was made ("Start Date"). Enter the total "Amount Returned" and the end date.

You can change the dates by changing the number of days. Enter a negative number of days to adjust the "Start Date". Or as you change a date the "Number of Days" will update.

The results include the percentage gained or loss on the investment as well as the annualized gain or loss also expressed as a percent. The annualized return can be used to compare one investment with another investment.

Example: If you bought $25,000 worth of your favorite stock on January 2nd 2014 and sold it for $33,000 on June 7th 2015, you would have a gain of $8,000 which is 32%. The annualized gain is 21.5%.

Now, lets say you made a second investment on January 2nd, 2015. This time for $10,000 and you sold it for $11,000 on March 1st, 2015. The gain is only $1,000 or 10%. However, annualized the gain is 82.1%. Ignoring risk (which can be very dangerous), one would generally consider the latter investment to be better than the former.

Take 3.5 Extra Years to Save for College

A final word about ROI/ROR financial calculators — because two different calculators may use different equations, don't compare the results from one ROI calculator for one investment with results from another calculator for a different investment. Use the same calculator to compare two different investments.

Please tell me how you use this calculator. Are you using it personally or professionally? What feature is important to you? If it didn't meet your needs, why? Your feedback will help me make improvements. Complete sentences aren't necessary! :)

I have a question (I think I am doing this right, but need confirmation)….

I need to know how much money an annual investment would earn over a period of 6 years. Each annual investment represents a 10% increase. I started with 86,900. The interest rate is 11.5% and it is compounded daily each month. I want to try to calculate what interest should have been earned at the end of each year. Interest is just rolled over to the following year…

86,900.00 Starting year 6 January 2012

95,590.00 Starting year 5 January 2013

105,149.00 Starting year 4 January 2014

115,663.90 Starting year 3 January 2015

127,230.29 Starting year 2 January 2016

139,953.32 Starting year 1 January 2017

670,486.51 = This is the total invested since 2012

You can do what you want on this site, but not with the ROI calculator. Please use the Ultimate Financial Calculator.

One on that page, scroll down the page and look at the tutorials. Everyone should read tutorial #1 to get an overview of who the calculator works. Then tutorial #2 deals with investment cash flows. I think these two should get you started. If after looking at them you have additional questions, please feel free to ask them on that web page.

Heya i want to find out the roi for a project

i have entred this

Amount Invested

£1,034.00

Amount Returned

£80,000.00

Days (-9,999 < # 1969)?:

11/13/2015

End Date (year < 2100)?:

11/12/2016

these are the result i get back

Gain or Loss:

£78,966.00

Percentage Gain or Loss:

7,636.9439%

Annualized Return (ROI):

7,636.9439%

Total Years: 1

what does Annualized Return (ROI):

7,636.9439% mean??

It is a way of expressing the rate-of-return so that different investments for different duration can be compared. It what the rate of return would be if the investment had been invested for one year.

With this example, one day short of a year, it equals the gross return, most likely because the ROI is express to only 4 digits. Perhaps if it were extended out to say 8 or 10 digits there would be a difference between the percentage gain or loss and the annualized return.

Does this answer your question?

sorry am not very good at this

invested amount 1034

gained 80000

so it says my ROI is 7,636.9439% for Total Years: 1

how would i express it

would it make any sense if i say the Return of investment is 7,636.94% for i year

And why is such a high number??

The number is high because the growth is huge.

Let’s make sure you understand what this calculator means. From the numbers in the earlier message you are saying that an amount, 1034, was invested one time, on Nov. 13, 2015. Additionally, this means there were no other amounts invested (or withdrawn). At the end of nearly a year (1 day short) on Nov. 12, 2016, the value of the investment was 80,000.

If this is not what you mean, then the return would not have been over 7,000%.

If you mean something else, please state what it is, and we’ll see what calculator you should be using to calculate the ROI.

Yes, that’s what you would say.

Great tool, just what I need for personal stock investing. Thanks!

Can someone please help me with how this math and logic would work in an excel sheet?

Perhaps someone reading will be able to answer your question. So you know, I limit the support I give to questions about what calculator to use and how to use a particular calculator.

Nice tool. However, no. of days calculation seems to be off. How come?

Thank you.

Please provide an example showing what you think is wrong.

Perhaps I should point out that a year is Jan 1 – Jan 1. NOT Jan 1 – Dec. 31.

The time-of-day is always 12:00am (midnight). And if a user enters Jan 1 – Dec 31, they are missing the entire day of Dec 31 in the calculation.

Does that change things for you?

Yes. If I use, e.g., 1/1/2018 – 12/31/19, the number of days is off by a fairly large number (not just one). If I use 1/1/2018 – 1/1/2028, the number of days is right on the money.

Thanks for the tip.

For 1/1/2018 – 12/31/19, I get 729 days. What do you get?

729 days is correct. Neither year is a leap year. Jan 1, 2018 – Jan. 1, 2020 is 2 years or 2 x 365 = 730. Jan 1, 2018 – Dec. 31, 2019 is one day short, or 729 days.

Please let me know if you are getting something else.

If you see another value for number of days, please make sure you have exited both date inputs. Exiting either date input will cause the number of days to update. If the cursor is in a date field, the number of days are not necessarily updated, since the calculator is not sure the dates have been selected.

How do i calculate an ROI for an investment i want to do, but don’t have an actual return rate

This calculator should do what you need assuming that your investment involves investing a single amount and then selling the investment in one transaction at some point in the future. You don’t need a return rate because ROI is calculated using the investment amount and the amount gained or lost (resulting in a negative ROI).

Or do you have a series of investments and/or withdrawals?

karl,

meant to ask a previous question for this calculator. How do you do this same calculation by hand or in excel? trying to calculate this roi for many investments with various redemption dates. thanks!

Use Excel’s IRR or XIRR builtin functions.