• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to Calculate the Future Value of Investment with Graduated Deposits

I am trying to build an Excel calculator that will show the future value of an investment based on regular monthly deposits, but I want the deposits to increase each year slightly. For example, start with $100/month for the first year, then increase that by 5% for the next 12 months, $105/month, etc..., for a certain variable number of months, at an input interest rate. I will enter any starting investment, the starting amount per month, the percent to increment each year, the number of months, the rate of return, and the compounding frequency, although I could just use monthly if adding this variable makes the calculations too complicated.

Thank You!

Gary
 
Back
Top