Help required! Data table and goal seek table combined.

[jsth]

Hi all - firstly, many thanks in advance for any assistance.

I just need some help in what I hope is a very simple excel question. The attached excel file has a very straight forward cash flow with only a few variables in order to generate an IRR.

What I would like to show is goal seek and data table combined which essentially says "how much do I need to pay as my Day 1 equity in order to sustain the target base case IRR of x% (in this case it's c. 44%)"

Any questions let me know.

Thank you.

 

[Hui]

I used a macro and a table of inputs, but it gets the results you want

See attached file

 

[jsth]

I used a macro and a table of inputs, but it gets the results you want

See attached file

This is perfect - many thanks!