ANNUITY PAYMENTS
 

Given: $x amount of money in a savings account
Given: %y amount of interest per year earned
Given: $z withdrawn each month

Question: How many months before an account is depleated

ANNUITY PAYMENTS
 

How often is the interest compounded

--
crispb
-----------------------------------------------------------------------
crispbd's Profile: http://www.excelforum.com/member.php...fo&userid=1088
View this thread: http://www.excelforum.com/showthread.php?threadid=27660

ANNUITY PAYMENTS
 

START $ 10,480.05
INT % 10
MONTH WITHDRAW 1,000.00

END YR BAL (1,519.95)
.+ INT (1,671.94)

YEARS 14
MONTHS 10.5


STARTS IN RAGE A1

cell B5 =B1-(B3*12) END YR BAL
cell B7 =B5/100*(100+B2) .+ INT

this is based that your interest is paid at the end of the year

Sub YEARS()

Range("B8").Value = 0
Do Until Range("B5").Value < Range("B3").Value
Range("B1").Value = Range("B6").Value
Range("B8").Value = Range("B8").Value + 1
Loop
End Sub

Pretty crude and hope it is what u wanted , there probably is a better way,
the example started with 100K
r
Pete

--
(][ This Email has been scanned by Norton AntiVirus. ][)
"early1_us" wrote in message
...
Given: $x amount of money in a savings account
Given: %y amount of interest per year earned
Given: $z withdrawn each month

Question: How many months before an account is depleated