How do I calculate a several tier IRR waterfall?

G

Guest

Terms change in my transaction after a specific IRR (internal rate of return)
is acheived. I can test for what year that IRR is triggered. How do I
calculated what is the amount in that year to help the step and use the next
tier of the waterfall?
 
I

Ikaabod

Is this close to what you need?
=IF(IRR(F9:F14)<0.095,"1stTier",IF(AND(IRR(F9:F14)>=0.095,IRR(F9:F14)<0.105),"2ndTier","3rdTier"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows 7
IRR Problem 2
IRR 18
Iterative Macro 7
IRR - inflow first, followed by only outflows 4
finding the results of changing 4 variables 3
Textbox - IRR calculation with VBA 0
Unexplainable XIRR #NUM! Error 3

Top