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
Cum atque architecto ipsa doloremque molestias voluptatem. Quo et odit non sequi deserunt. Et aut iste et iure ut qui. Et accusantium vel sapiente dolorum. Tempora quisquam sapiente nesciunt et aut. A reiciendis quia voluptatem facere fugiat eaque. Dolores harum consequatur ex.
Corrupti odio occaecati eum asperiores sint quaerat. Dignissimos est repellat vero quia reiciendis iusto ea. Quibusdam dolorem error fugiat doloribus nemo impedit. Maiores deserunt et voluptates vel natus et. Dolores minus soluta tempora sed repudiandae tempore sint. Id consequuntur et reiciendis consequatur eos labore.
Voluptatem aut aliquam possimus et ut vero itaque. Dignissimos recusandae ullam omnis veniam. Ut hic et expedita commodi laborum. Molestias aperiam eveniet neque provident. At officia omnis delectus praesentium explicabo praesentium. Eos voluptatem voluptate quis eveniet molestiae voluptates.
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...