This afternoon I built a calculator to compute the future value of an investment portfolio based on set of inputs. Those inputs include the initial (present value) amount invested, an annual contribution amount to the portfolio, an annual rate of return and the numbers of years invested.
Below the investment calculator I have also provided a sensitivity table that automatically updates. The sensitivity table computes different future values of the investment portfolio based on combinations of annual rates of returns and number of years invested. This makes it easy to see how the future value of your investment portfolio would change under a different set of assumptions.
Download: Excel Investment Calculator
Tested it out and let me know what you think .