Answers » Categories » Venture Capital and IPOs

How do I calculate the IRR

What is the correct formula for calculating IRR?

1 Answer

IRR measures the profitability of an investment by making the net present value of all cash flows from the investments equal to zero. IRR is in fact the interest rate at which the net present value of costs equal the net present value of the gains.

Its formula is the following

NPV = C(0) + C(1)/(1+r) + C(2)/(1+r)2 + … + C(n)/(1+r)n = 0

where C(n) is the cash flow for each period.
The formula needs to be solved for “r”.
Bulit-in IRR functions run iterations for “r”.

Answer this question

by Anonymous - Already have an account? Login now!
Your Name:  

Your Answer:  
Source(s): (optional)

Enter the text you see in the image below
What do you see?
Can't read the image? View a new one.
Your answer will appear after being approved.

Ask your own question