IRR Targeting Investor Tool
![irr targeting investor tool 1]()
Not many calculators allow the user to enter an IRR input in order to show the amount of total equity distribution needed to attain the rate at a given exit year. IRR is different than ROI and this tool makes it easy to see how they are different.
This investor tool will display the ending cash distribution that is required to be paid out at the end of each year for up to 15 years so that the IRR is achieved. User inputs include:
1. Initial investment
2. Any future investments over the life of the deal per period
3. Any cash distributions received over the life of the deal per period
4. IRR target
The output is a running balance owed as well as a general return summary. The summary lets the user define an exit year and based on the year chosen this template calculates the total return required so the desired rate is achieved while taking time into account.
Also, the summary displays the ROI for the entire period as well as a DCF Analysis.
Note, this is a Google Sheet template and requires a free Gmail account to use. The download link comes in a Microsoft word doc.
This investor tool will display the ending cash distribution that is required to be paid out at the end of each year for up to 15 years so that the IRR is achieved. User inputs include:
1. Initial investment
2. Any future investments over the life of the deal per period
3. Any cash distributions received over the life of the deal per period
4. IRR target
The output is a running balance owed as well as a general return summary. The summary lets the user define an exit year and based on the year chosen this template calculates the total return required so the desired rate is achieved while taking time into account.
Also, the summary displays the ROI for the entire period as well as a DCF Analysis.
Note, this is a Google Sheet template and requires a free Gmail account to use. The download link comes in a Microsoft word doc.
