Retirement Savings Last

[Paul Ilacqua]

Could someone post the formulas necessary to calculate how long a lump sum
will last if I withdraw X amount with it earning x % interest. I've used a
canned financial calc and it does not seem correct.
Thank You

Paul

[Chip Pearson]

The NPER function should compute this. See help for more info.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Paul Ilacqua" <pilacqu2@twcny.rr.com> wrote in message
news:evRGj%23zgFHA.3216@TK2MSFTNGP10.phx.gbl...
> Could someone post the formulas necessary to calculate how long
> a lump sum will last if I withdraw X amount with it earning x %
> interest. I've used a canned financial calc and it does not
> seem correct.
> Thank You
>
> Paul
>