ANNUITY PAYMENTS

[Guest]

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

 

[crispbd]

How often is the interest compounded

 

[OZDOC1050]

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