Asjust price automatically until IRR is hit

[img4747]

Hello,

I am building a discounted cash flow model, which calculates my IRR at on a yearly stream of flows. I need a 25% IRR, so I have to manually change the purchase price until it hits. (Goal seek will not work on this model). Is it possible to create a circular reference so the purchase price will adjust up or down until the IRR is hit -- assuming I round the matching IRR to 25.00% even.

If so, any tips?

Thanks!

 

[tusharm]

Not sure why Goalseek is not an option but you should be able to use iterative calculation to seek the correct result.

 

[northwolves]

You can calculating IRR by dichotomy too.