IRR calculator
IRR is the yearly rate of return that makes all of an investment's cash flows, in and out, net to zero in today's money. Enter money in as negative and money back as positive, and the calculator solves for the rate.
Money in as a negative number, money back as a positive one.
- Multiple on the money
- 1.5x
- Net profit
- $50,000
- Net present value at 10%
- $8,053
How it works
IRR accounts for when cash moves, which ROI does not. Money that comes back in year two beats the same money in year eight, and IRR reflects that. There is no direct formula, so the calculator searches for the rate that brings the net present value to zero.
0 = sum of (cash flow ÷ (1 + IRR)^year)
It assumes one cash flow per year, with the first today. If your dates are irregular, XIRR in a spreadsheet handles exact dates.
Worked example
You invest $100,000 today and get $400,000 back at the end of year five.
IRR = 32%
Multiple on the money = 4x
Net profit = $300K
Where this goes wrong
Questions founders ask
What is a good IRR?
It depends on risk. Venture funds aim for high returns on individual deals because many fail, and a fund-level net IRR above 20% is generally considered strong. Compare with your other options at the same risk.
What is the difference between IRR and NPV?
NPV gives a dollar value at a rate you choose. IRR gives the rate at which the NPV is zero. If the IRR is above your required return, the NPV at that return is positive.
What is the difference between IRR and MOIC?
MOIC tells you how many times your money came back, ignoring time. IRR tells you the yearly rate. Investors look at both.
