View Single Post
  #1   Report Post  
mschumacker
 
Posts: n/a
Default NPER - Retirement Example

All,

I'm trying to calculate how many months I could draw on my retirement funds.
Here's the example:

Present Value of Fund: 900,000
Amount deducted each month: 6,000
Expected rate of return on investment: 10%

I tried to use NPER = (.10/12, -6000, 900000) but get an error. If I make
both signs negative, I get 111, which I know the answer should be bigger.

Thoughts?