Crete an An Account with regular withdrawls with a declining bala.
 

Looking for an Excel program that will calculate from a starting month to end
how long an amount of money will last that accumulates a fixed yearly
interest but has a monthly withdrawl. Like having an IRA with say $100,000
nest egg and you withdrawl $500 a month and the account accumulates say 5% apr

Crete an An Account with regular withdrawls with a declining bala.
 

early1_us

=NPER(0.05/12,500,-100000,0)

gives 431 months.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"early1_us" wrote in message
...
Looking for an Excel program that will calculate from a starting month to
end
how long an amount of money will last that accumulates a fixed yearly
interest but has a monthly withdrawl. Like having an IRA with say $100,000
nest egg and you withdrawl $500 a month and the account accumulates say 5%
apr