Thread: nper function calculation
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tushar Mehta Tushar Mehta is offline
external usenet poster
  
Posts: 1,071
Default 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
Reply With QuoteReply With Quote