second IRR root

Hi,
How do I produce the second IRR root when given a series of cash flows (more than 1 negative cash flow) in excel?

Thanks!
maudetteAsked:
Who is Participating?
 
byundtConnect With a Mentor Commented:
Excel only gives you one root with the IRR function.

You can tabulate the discounted cash flow with different interest rate assumptions, however, and see which interest rates drive the sum of cash flows to zero. A one variable Data Table is convenient for this purpose, as shown in the attached workbook.

Brad
SecondRootOfIRR-Q26844775.xlsx
0
All Courses

From novice to tech pro — start learning today.