Note: This is a Google Sheet and requires a free Gmail account in order to use it.

Once purchased, simply go to the link in the word doc and then hit File > Make a Copy and follow the instructions.

This tool was designed to help investors see the total amount of equity repayment required at the end of a given period to achieve a desired internal rate of return.

Inputs include:
– Initial Investment
– Any Future Investments per Period
– IRR
– Distributions per Period

Based on the above, this calculator will show the total ending distribution required at the end of each year so that the IRR is achieved. This takes into account all inputs over time. There is also a simulation where the user can pick a defined year to end and display the resulting ROI and distribution.

Finally, there is a DCF Analysis that has NPV and the present value of all future cash flows. This tool gives the investor a greater understanding of general return definitions and mechanics.

A google sheet requires a free Gmail account to use. Hit File and make a Copy once you click through to the file link.

You must log in to submit a review.