Nper

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I use a financial calculater the Nper function comes out different than when I use the Nper function in Excel
THis can be seen in excel if you calculate for a period using the Nper function. The results will be completly different if you use the the results back into the PMT function. Normaly you would think that the payment is the same as the payment used in the Nper function: its not. anyone know why or how to work around this? thanks
 
When I use a financial calculater the Nper function comes out different than when I use the Nper function in Excel.
THis can be seen in excel if you calculate for a period using the Nper function. The results will be completly different if you use the the results back into the PMT function. Normaly you would think that the payment is the same as the payment used in the Nper function: its not. anyone know why or how to work around this? thanks
Click to expand...


I cannot reproduce your results from your description, so I assume you are
entering one or more parameters incorrectly.

Perhaps if you give some detail of the formula inputs and outputs, as well as
what you expect, we could be of more assistance.


--ron
 
Hi Ken!

Post an example of the formula you are using in Excel and what you
get. Also post details of what you get from your financial calculator.

You must be doing something wrong as they produce the same results for
the same data inputs.

My first guess would be that you are using in advance (BGN; Type = 1)
for one calculation and in arrears (END; Type = 0).

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Thank you for your reply

Yes you were both right, I had not put in the Minus sing preceding the PV, if you do not use a negative number, the results are incorrect

thanks again.. I am relieved, it was driving me batty!
 
Back
Top