Hi everyone,

I am running a DCF valuation sheet for a number of commercial Real Estate investments and as part of the exit valuation, I want to add a sale price of the asset that achieves a target IRR (then assign a Macro to a button for this function).

Can I use goal seek to achieve this? For example, I have an exit price of EUR10,000,000.00 for a particular asset which given the current cash flows, achieves an IRR of around 15.5%.

What I would like to assign is a button which when clicked, will give me the price I need to sell at to achieve a 20% IRR (and probably some other buttons for +500bps.

Any help would be greatly appreciated!

Thanks,
Chris