Find the exit value based on a target IRR
The spreadsheet below enables you to calculate the selling price (or exit value) of any investment based on a specific IRR. You will need the following inputs:
The initial investment outlay (or purchase price)
Holding period of the investment
Any cash flows received during the holding period
The target IRR