Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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?
  #2   Report Post  
N Harkawat
 
Posts: n/a
Default

If the expected rate of return is 10% then the first month you will make as
interest 7500 (900K*10%*1/12)

and what you deduct is only 6000

Therefore you will never exhaust you funds infact they will keep growing.

That is why you get an error as period is = infinity

however using a 4% return and using the following formula I get the CORRECT
result of 208 months

=NPER(4%/12,-6000,900000)





"mschumacker" wrote in message
...
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?



  #3   Report Post  
mschumacker
 
Posts: n/a
Default

I should have realized. Thanks for the answer. Sometimes the obvious
answers are the hardest to come by.



"N Harkawat" wrote:

If the expected rate of return is 10% then the first month you will make as
interest 7500 (900K*10%*1/12)

and what you deduct is only 6000

Therefore you will never exhaust you funds infact they will keep growing.

That is why you get an error as period is = infinity

however using a 4% return and using the following formula I get the CORRECT
result of 208 months

=NPER(4%/12,-6000,900000)





"mschumacker" wrote in message
...
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?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Incorrect result using NPER worksheet function KG Old Wolf Excel Worksheet Functions 7 November 3rd 08 03:49 AM
solving for NPer w/o function (algebra question) Karl Excel Worksheet Functions 11 December 29th 04 09:30 PM
Excel: Need Nper PatrickBurg Excel Worksheet Functions 1 October 28th 04 03:26 PM


All times are GMT +1. The time now is 10:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"