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?

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"))

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

--
Ikaabo
-----------------------------------------------------------------------
Ikaabod's Profile: http://www.excelforum.com/member.php...fo&userid=3337
View this thread: http://www.excelforum.com/showthread.php?threadid=54428