How do you calculate the rate of return?
Take what the investment is worth now, add any dividends or interest it paid you, subtract what you paid, and divide by what you paid. $10,000 put into SPY on 2 January 2020 was worth $23,559 on 26 October 2026 and had paid $1,305 in dividends: (23,559 + 1,305 − 10,000) ÷ 10,000 = 148.65%.
How do you calculate an annualized rate of return?
Add 1 to the total return, raise it to the power of 365 divided by the number of days you held it, and subtract 1. The SPY example is 2,489 days: 2.4865 to the power of 365 ÷ 2,489, minus 1, is 14.29% a year. Under a year, leave the return as it is: annualizing a few weeks gives silly numbers.
What is a good rate of return on investments?
One that beats what you could have earned in a simple index fund over the same dates, for the risk you took. SPY, an S&P 500 fund, returned 15.41% a year with dividends over the 10 years to 26 October 2026, but only 8.27% a year from January 2000, because that start sits just before two big crashes. The dates you pick change the answer a lot.
How do I calculate my return if I added money along the way?
The simple formula stops working, because money added late had less time to grow. Use the money-weighted return (XIRR in Excel or Google Sheets) to see what your money earned a year, or the time-weighted return to compare with an index. Two $10,000 deposits into SPY, in January 2020 and January 2022, earned 13.90% a year money-weighted, while the fund itself did 14.99% a year.
Is rate of return the same as ROI?
For an investment, yes: both are the gain divided by what you put in, and neither says how long it took. ROI is the word businesses use for projects and marketing spend. To compare investments held for different lengths of time, use the annualized figure.
What is the difference between annualized return and CAGR?
For one amount in and one amount out they are the same number: the yearly rate that turns the start value into the end value. People say CAGR when they talk about growth between two values, such as revenue, and annualized return when they talk about an investment. Average annual return is different: it adds up each year's return and divides, which overstates what you earned whenever returns swing.
How do I calculate rate of return in Excel or Google Sheets?
With the amount paid in B1, the value now in B2 and income in B3, the total return is =(B2+B3-B1)/B1. With the buy date in B4 and today in B5, the yearly rate is =(1+B6)^(365/(B5-B4))-1, where B6 holds the total return. For deposits on different dates, list each one as a negative number with its date, put the value now as a positive number, and use =XIRR(values, dates).
What is the real rate of return?
Your return after inflation. Divide 1 plus your return by 1 plus inflation and subtract 1: an 8% year with 3% inflation is 1.08 ÷ 1.03 − 1 = 4.85% in real terms, a little less than the 5% you get by subtracting.