nper function calculation
 

Hi everyone, does anyone know the formulae behind the NPER function in excel

nper function calculation
 

you can findout no of period by using this function

nper function calculation
 

bigfella -

Hi everyone, does anyone know the formulae behind the NPER function in
excel <

See the Remarks section of Excel's built-in Help for the "PV function."

- Mike
www.mikemiddleton.com

nper function calculation
 

Hi. Given the equation for PV, and assuming type=0, then NPER equals:

=LN((pmt - fv*r_)/(pmt + pv*r_))/LN(1 + r_)

--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"bigfella" wrote in message
...
Hi everyone, does anyone know the formulae behind the NPER function in
excel

nper function calculation
 

http://groups.google.com/group/micro...fc88f222?hl=en



Dana DeLouis wrote:
Hi. Given the equation for PV, and assuming type=0, then NPER equals:

=LN((pmt - fv*r_)/(pmt + pv*r_))/LN(1 + r_)

--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"bigfella" wrote in message
...
Hi everyone, does anyone know the formulae behind the NPER function in
excel

nper function calculation
 

Hi Dana,

In article ,
says...
Hi. Given the equation for PV, and assuming type=0, then NPER equals:

=LN((pmt - fv*r_)/(pmt + pv*r_))/LN(1 + r_)


Sure it is pmt + pv*r_? I get pmt - pv*r_

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions