Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
annuity calculation for monthly payments but quarterly compoundin | Excel Worksheet Functions | |||
Annuity Payments From A Present Amount | Excel Worksheet Functions | |||
How to calculate the accumulated payments from an annuity at yr 10 | Excel Worksheet Functions | |||
How do I calculate the accumulated payments from an annuity at yr | New Users to Excel | |||
How do I forecast future payments by analyzing past payments? | Excel Worksheet Functions |