Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Incorrect result using NPER worksheet function | Excel Worksheet Functions | |||
solving for NPer w/o function (algebra question) | Excel Worksheet Functions | |||
Excel: Need Nper | Excel Worksheet Functions |