Help on Financial Functions ??

[SureFireSolutions.com Inc.]

Hello, I have a situation where I'm trying to determine the number of
payment periods remaining with a constant payment and interest rate. It
looks like the NPER funtion should do the trick except I can't seem to get
it to work....so I've gone back to basics and that doesn't work either.

Here's my basic example using both the NPER and PMT functions:
Here is what I've used for the test figures
rate = 20%
pv = $10000.00
fv = $1.00
type = 1
number of periods = 36
PMT(rate,nper,pv,fv,type)

So I first determine the payment = PMT((20/100/12), 36, 10000, 1, 1)

payment = $365.56

Now if I take that payment and put it into the NPER function I would have
thought that I would get the periods = 36

NPER(rate,pmt,pv,fv,type)

periods = ((20/100/12), 365.56, 10000,
1, 1)

periods = 22.42 ??????

I would really appreciate it if someone could shed some light on what I'm
doing wrong .......

 

[John Nurick]

On Fri, 14 Apr 2006 01:49:10 GMT, "SureFireSolutions.com Inc."
You're making the elementary mistake of ignoring the direction of the
cashflows.

?PMT((20/100/12), 36, 10000, 1, 1)

does NOT return 365.563. It returns -365.563. And

? NPER(0.2/12, -365.563, 10000, 1, 1)

returns 36.000 as expected.

 

[SureFireSolutions.com Inc.]

Thank you John !!

You've made my day

Don Garry of SureFireSolutions.com