Reverse XIRR to find price

This might be a simple answer but I can't get my head around it at the moment. XIRR is fantastic but I am trying to work out the initial price for something based on the XIRR. i.e. if I want to achieve 9% XIRR and I have a series of known irregular payments in the meantime how can I calculate the initial price? I have attached a sample spreadsheet which outlines it in more detail.

Thanks again in advance!

Is this even possible? I have looked at what the actual XIRR formula is and it is crazy!

If you were to use solver would this mean manually altering/adjusting it each time. I have hundreds of these and ideally its a case of saying 10% XIRR and it says cost = 100 or 9% XIRR cost = 110. And then you just change the XIRR figure for all one hundred of them

Thanks anyway, your feedback is appreciated

You could use VBA to go down your list and have it apply Solver (or wouldn't it be GoalSeek) to each line. Then you hit the button once and it updates all your calculations.

That could work! The only issue though would be that you when you use Solver or GoalSeek it doesn't seem to allow you to have the target value as a variable running from another cell. You have to actually input the target value into the Solver Parameters. Is that right?

That's true. But if you use VBA, you make the target CELL equal to the calculated value minus your target value, and then the inputted "target" is zero.

What about just discounting your cash flows by your required return? Wouldn't that be the easiest?