B
bigfella
Hi everyone, does anyone know the formulae behind the NPER function in excel
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Muhammed Rafeek M
you can findout no of period by using this function
M
Mike Middleton
bigfella -
See the Remarks section of Excel's built-in Help for the "PV function."
- Mike
www.mikemiddleton.com
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
D
Dana DeLouis
Hi. Given the equation for PV, and assuming type=0, then NPER equals:
=LN((pmt - fv*r_)/(pmt + pv*r_))/LN(1 + r_)
=LN((pmt - fv*r_)/(pmt + pv*r_))/LN(1 + r_)
T
Tushar Mehta
Hi Dana,
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
Sure it is pmt + pv*r_? I get pmt - pv*r_Hi. Given the equation for PV, and assuming type=0, then NPER equals:
=LN((pmt - fv*r_)/(pmt + pv*r_))/LN(1 + r_)
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions