Author Topic: Calculator for Investments w/ Increasing Contributions?  (Read 430 times)

lcerrito

  • 5 O'Clock Shadow
  • *
  • Posts: 26
Calculator for Investments w/ Increasing Contributions?
« on: December 18, 2016, 07:51:24 AM »
So I've been using an online calculator for figuring out how long it will take to reach my investment goals based on contributions, return rates, etc. (http://www.bankrate.com/calculators/retirement/investment-goal-calculator.aspx)

The problem is that I am still early in my career and expect my pay to go up over the course of the next decade. Does anybody know of a calculator where I can plug in different contributions per year? Or increase contributions at a set percentage?

Alternatively, I tried doing it myself in Excel with the what I expect my contributions to be increased to (at 5 yr marks for simplicity), but the resulting figures seemed a little too generous. Any mathematicians able to point out where I went wrong in my Excel formula?

MDM

  • Walrus Stache
  • *******
  • Posts: 6947
Re: Calculator for Investments w/ Increasing Contributions?
« Reply #1 on: December 18, 2016, 10:17:56 AM »
You might look at the specific post linked here: FIRE in 8 years? and links therein for a start.

Your question is a little different from the one posed there, but with some algebra.... 

If you start working with growth in taxable accounts, see the calculations near cell A126 in the case study spreadsheet.  Again, perhaps not exactly what you would need, but a start.

Good luck!