: How to calculate how long my money would last I want to calculate how much money I'll need in retirement. For that I want to calculate how long my money will last. I'm not sure if there is a formula for that. Lets say we

Vote Up Vote Down   0 Reactions

Login to give Reaction!

Your principal will last indefinitely if your interest rate (or equivalent) is at least 10%. Otherwise, spreadsheets come in very handy for these sorts of questions.

Here are some formulae you can use, assuming your interest comes in at the end of the year as a lump sum and you draw your expenses immediately upon receiving the interest:

First row: Year (Y=2018 or current year), Principal amount (P=100,000), Rate of change (R=1.05 for 5% interest), Amount Drawn (D=10,000), Balance (B=PR-D).

Subsequent rows (referencing the variables in the row before it): Y+1, P’=B, R, D, P’R-D.

Look down to the row where the Balance column is first negative. The first column (year) tells you the year that the funds run out.

Once you’ve set up your spreadsheet, you can change the interest rates or drawings for particular years or year ranges.

Here's a snapshot of the above spreadsheet using the given parameters (0k principal, 5%pa interest, k drawn each year), showing the funds lasting for 14 years and running out in the 15th year:

Vote Up Vote Down   0 Reactions

Login to give Reaction!

Using the summation for the present value of an ordinary annuity, with

p = principal
w = withdrawal amount
n = number of periods
m = periodic interest rate

? n = -(Log[1 - (m p)/w]/Log[1 + m])

Applying your figures

m = 0.05
p = 100000
w = 10000

n = -(Log[1 - (m p)/w]/Log[1 + m]) = 14.2067

You would be able to withdraw 10k for 14 years.

Note, in an ordinary annuity the cash flow is at the end of each period, so if retirement starts at the beginning of year 1 with 100k, the first payment happens at the end of year 1.
www.investopedia.com/retirement/calculating-present-and-future-value-of-annuities/
To calculate the balance in year 14, after the last 10k payment, this formula can be used.

with n = 14

balance = ((1 + m)^n (m p - w) + w)/m = 2006.84