View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 866
Default How do I calculate a several tier IRR waterfall?

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?