Hi everyone, does anyone know the formulae behind the NPER function in excel
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks