Predicting an IRR

[billyshears]

I am trying to solve for IRR.

If I want to achieve an IRR in any year of 9% and I have my cash flows but need to solve for sale equity, what should I use?

So if in year 4 of owning a property, I want to sell it to achieve a 9% IRR and I have my original equity number and my cash flows, how do I solve for the sale equity I need?

 

[joeu2004]

I assume that this is a "duplicate" of https://www.mrexcel.com/forum/excel-questions/1080622-predicting-irr.html, which you entered 30 min later, and you want us to discuss the problem there, not here.