Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Retirement Calculator

  1. Apr 16, 2006 #1
    On this chart:
    http://www.banksite.com/calc/retire?with=30000&lngt=5&lngt=5&pay2=0.0&intr=7.5&outt=HTML+Tables [Broken]
    how did they calculate 130479.79? I know how they got the "Interest" and "End Bal" just not the 130479.79. Anyone have any suggestions?
    Here is the original form:
    http://www.banksite.com/calc/retire [Broken]

    Thank You,
    Last edited by a moderator: May 2, 2017
  2. jcsd
  3. Apr 16, 2006 #2


    User Avatar
    Science Advisor

    In this example, the objective is to be able to withdraw $30,000 per year from savings. It assumes 7.5% interest (it's obviously very old!). The "end balance" is, of course,0 by definition.

    Suppose you had X dollars in the bank, drawing 7.5% simple interest.
    After 1 year, before you withdraw anything, you would have the original X plus interest, (0.075)(30000) or a total of (1+ 0.075)X= 1.075X. Now, you withdraw 30000. You have 1.075X- 30000 left.

    For the second year, repeat that with initial amount 1.075X-30000. Before withdrawing anything, but including interest, you would have
    1.075(1.075X- 30000)= (1.075)2X- (1.075)(30000). After withdrawing your 30000 you will have (1.075)2X- (1.075)(30000)- 30000 left.

    For the third year, you are starting with that amount so, before withdrawal you would have 1.075((1.075)2X- 1.075(30000)- 30000)= 1.0753X- 1.0752300000- 1.075(30000). Now withdraw 30000 from that: 1.0753X- 1.0752300000- (1.075)30000- 30000= 1.0753X- 30000(1+ 1.075+ 1.0752.

    Do you see the pattern? After n years you will have 1.075nX- (30000)(1+ 1.075+ ...+ 1.075n-1. In particular, after 5 years you would have 1.0755X- (30000)(1+ 1.075+ 1.0752+ 1.0753+ 1.0754. Since in this example you are apparently only expecting to die 5 years after retirement, after 5 years, the "final balance" is to be 0. It's not that hard to calculate that 1+ 1.075+ 1.0752+ 1.0753+ 1.0754= 5.808 approximately. Solve the equation 1.0755X= 30000(5.808). I get slightly less than 130480. Try deducting the 30000 before adding the interest. That would be the same as replacing X by X-30000.
  4. Apr 16, 2006 #3
    Thanks for the reply HallsofIvy. For 1.075^5(X)= 30000(5.808), I'm getting X=121368. How am I miscalculating?
  5. Apr 16, 2006 #4


    User Avatar
    Science Advisor
    Homework Helper

    You're not, you've solved for x almost perfectly, actually your missing a few decimal places there, can I assume you are using mathematica?
  6. Apr 17, 2006 #5
    What is mathematica?
  7. Apr 17, 2006 #6
    I'm not sure how you got 130480 from 1.0755X= 30000(5.808).

    Thank You,
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook