IRR Calculator (Internal Rate of Return)
Calculate the internal rate of return (IRR) of any investment with several payments in or out: yearly cash flows, a savings insurance or endowment policy, or dated cash flows (XIRR) for monthly and irregular investing. IRR is the annualized compound return that accounts for when each amount goes in and comes out.
How to use the IRR calculator
Pick an option under Calculate by, fill in the amounts and press Calculate or Enter. The results show the IRR, total invested, total received and net profit. If you change any input afterwards, the result fades and reminds you to calculate again.
- Yearly cash flows: enter money you put in under Invested and money you get back under Received. Year 0 is the day you start and year 1 is one year later; add or remove years as needed. Good for rental property, bonds or business projects with yearly cash flows.
- Savings insurance: enter the annual premium, the number of years you pay, the year of the payout and the payout amount. Premiums are paid at the start of each policy year and the payout arrives at the end of the payout year.
- Cash flows by date: enter every purchase, dividend and sale with its date. For an investment you still hold, enter its current value under Received with today’s date. Good for monthly investing and irregular top-ups.
If there is only one amount in and one amount out, the CAGR calculator is simpler and gives the same result as IRR.
What is IRR?
IRR (internal rate of return) is the rate that makes the net present value (NPV) of all cash flows equal to zero.
In plain terms, IRR is the average yearly compound return of an investment after taking into account when each amount goes in and comes out. It extends the idea of the annualized return (CAGR): CAGR handles one amount at the start and one at the end, while IRR handles any number of payments in between.
IRR formula
- : the cash flow in period t; money invested is negative and money received is positive
- t: the period (year); period 0 is the start
- IRR: the rate that makes the equation true
There is no formula you can solve directly for IRR; it has to be found by trial: guess a rate, calculate the NPV, then raise or lower the rate until the NPV is close to zero. This calculator first finds where the NPV changes sign between −99% and 10,000%, then narrows it down. The results match the IRR and XIRR functions in Excel.
Example 1: IRR of a savings insurance policy
You pay 10,000 a year for 6 years (60,000 in all) and receive 66,000 at the end of year 6:
| Time | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | End of year 6 |
|---|---|---|---|---|---|---|---|
| Cash flow | −10,000 | −10,000 | −10,000 | −10,000 | −10,000 | −10,000 | +66,000 |
The total return looks like 10%, but the IRR is only 2.73%, because the last premium is invested for just one year. If the payout were 72,000 at the end of year 10 instead, the total return would be 20% but the IRR would fall to 2.45%.
The guaranteed or illustrated rate of a policy is not its real return; IRR lets you compare it fairly with a savings account or a bond. Also remember that surrendering a policy early usually pays back less, so the IRR can turn negative.
Example 2: a fixed payout every year
You invest 100,000 and receive 30,000 at the end of each of the next 5 years (150,000 in all):
| Time | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|---|
| Cash flow | −100,000 | +30,000 | +30,000 | +30,000 | +30,000 | +30,000 |
The IRR is about 15.24%. Dividing the 50% total return by 5 years gives 10%, which understates it, because part of the money comes back early every year.
Example 3: XIRR for monthly or irregular investing
You invest 10,000 each on Jan 2, 2024, Jul 1, 2024 and Jan 2, 2025 (30,000 in all), and the holding is worth 36,000 on Jan 2, 2026:
- XIRR by date: IRR ≈ 12.80%
- Treating the whole 30,000 as invested on day one and using CAGR over 2 years gives only 9.54%, which understates the return because the later payments were invested for a shorter time
In the calculator, choose Cash flows by date and enter the date of each payment.
How to calculate IRR and XIRR in Excel
| Situation | Excel / Google Sheets formula |
|---|---|
| Equal periods (yearly, monthly) | =IRR(values) |
| Irregular dates | =XIRR(values, dates) |
| Monthly cash flows to an annual rate | =(1+IRR(values))^12-1 |
Notes:
- Enter money invested as negative numbers and money received as positive numbers; you need at least one of each.
IRRreturns the rate per period. With monthly cash flows, convert it to an annual rate with the formula above. For example, investing 1,000 a month for 12 months with a value of 13,000 at the end gives a monthly IRR of about 1.23%, or about 15.74% a year.XIRRalready returns an annual rate, using a 365-day year.
IRR vs CAGR: which should you use?
| IRR (internal rate of return) | CAGR (annualized return) | |
|---|---|---|
| What you need | The amount and timing of every payment in and out | Starting value, ending value and years |
| Money in or out in between | Handled | Not handled |
| How it is calculated | By trial, until NPV = 0 | Directly from a formula |
| Best for | Insurance policies, monthly investing, rental property, projects | Lump-sum investments, indexes, revenue growth |
With one amount in and one amount out, IRR and CAGR give the same result; when money goes in or comes out in between, use IRR.
Limitations of IRR
- There can be more than one answer: when the cash flows change sign more than once (for example, a top-up partway through), there may be two or more IRRs. This calculator shows the one closest to zero, so read it with care.
- It assumes payouts are reinvested at the same rate: with a high-IRR investment, the money you get back along the way may not find an equally good home, so the real return can be lower.
- It ignores size: a small investment with a high IRR does not necessarily earn more money than a large one with a slightly lower IRR, so look at the net profit as well.
- It depends on the timing you enter: yearly cash flows assume every amount moves at the start or end of a year; when the real dates differ a lot, XIRR is more accurate.
Frequently asked questions
What is IRR?
IRR (internal rate of return) is the rate that makes the net present value (NPV) of all of an investment’s cash flows equal to zero. Think of it as the average yearly compound return after taking into account when each amount goes in and comes out. It works for investments with several payments in and out, such as savings insurance and monthly investing.
How do you calculate IRR?
There is no direct formula; IRR is found by trial as the rate that makes the sum of cash flow ÷ (1 + IRR)^t equal to zero. In practice use an IRR calculator, or =IRR(values) or =XIRR(values, dates) in Excel, with money invested as negative numbers and money received as positive numbers.
How do you calculate the IRR of a savings insurance policy?
Record each premium as a negative amount and the payout as a positive amount, then find the IRR. For example, paying 10,000 a year for 6 years and receiving 66,000 at the end of year 6 is a 10% total return but an IRR of only about 2.73%. The Savings insurance mode of this calculator does this from the premium, years of payments, payout year and payout amount.
What is the difference between IRR and CAGR?
CAGR only uses the starting and ending values and suits a single lump sum. IRR takes into account the size and timing of every payment in and out and suits investments with contributions or withdrawals in between. With one amount in and one amount out, they give the same result.
Should I use IRR or XIRR for monthly investing?
With equal intervals you can use IRR, but it returns the rate per period (for example per month), which you convert to an annual rate with (1 + monthly IRR)^12 − 1. When the dates are irregular or you make extra top-ups, XIRR is more accurate because it uses the actual dates, and it already returns an annual rate.
What is a good IRR?
At the very least it should beat the risk-free return you could get elsewhere, such as a savings account or government bonds. For stocks and funds, compare it with the annualized return of a market index over the same period. For insurance policies, also consider the loss if you surrender early and how long your money is locked up.
- CAGR Calculator: annualized return from a starting value, an ending value and years or dates.
- Compound Interest Calculator: see how money grows at a given rate, with monthly contributions.