nper function calculation

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

you can findout no of period by using this function

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

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" <[email protected]> wrote in message
news:[email protected]...
> Hi everyone, does anyone know the formulae behind the NPER function in
> excel

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" <[email protected]> wrote in message
> news:[email protected]...
> > Hi everyone, does anyone know the formulae behind the NPER function in
> > excel

Hi Dana,

In article <[email protected]>, [email protected]
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