Paul,

Use
=NPER(0.07/12,-200,11731.39,0)

Think about it in terms of you holding a 7.0% mortgage note with a balance
of $11,731.39 and the borrower having to pay you $200 a month until the
mortgage was paid off. You would receive $200 each month for 72 months or 6
years.

Don



"Paul Ilacqua" wrote in message
...
I'm sick and tired of looking at canned Financial Calculators differing
results.
I want to calculate how long a fixed value of money will last based on a
"Current Value", "Interest rate", "withdrawl". I also want to do a month
by month table of the above can someone tell me if this is possible?

Paul