LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?
 
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 02:49 AM
solving for NPer w/o function (algebra question) Karl Excel Worksheet Functions 11 December 29th 04 08: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 08:55 AM.

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

About Us

"It's about Microsoft Excel"