Take the 2-minute tour ×
Quantitative Finance Stack Exchange is a question and answer site for finance professionals and academics. It's 100% free, no registration required.

Everything I have read about XIRR (e.g., as calculated in Excel) says that there is no closed-form equation and it must be calculated by iterated approximation.

Could someone give a brief mathematical explanation of why there is no closed-form solution?

share|improve this question

1 Answer 1

The internal rate of return is simply the rate at which the net present value is zero. So solve for $r$ in

$$ \sum{\frac{C_n}{(1+r)^n}} = 0 $$

There is no closed-form solution to this.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.