Dynamic IRR - Modeling
Here is the scenario I want to create a dynamic IRR box - So basically if I change the IRR in the box it will tell me what amount I have to pay in Year 5 (disposition year)
Is this possible?
Yes.
It's called a floating array.
But It's honestly just easier to have a line below the irr with white text with an If statement. If cash flow hold year then "copy" down, if false, "".
If(Year=5,NCF,"") Then have the IRR pull from this new line
Tenetur aperiam aut et hic. Quo voluptate maxime amet maxime nisi consequatur. Saepe cupiditate voluptas sint quia. Recusandae eius autem omnis aut. Dolor soluta modi minima et autem. Ea repellat ipsum eos nobis aut sunt.
Animi porro asperiores illo impedit omnis qui. Officiis sint asperiores quisquam sequi.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...