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
|