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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 said:
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%
Click to expand...
apr
 
Back
Top