View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Loan Period Calculator Sheet

Try

=NPER(0.05/12,-200,10000,0,0)

Where
0.05 is the annual percent interest
and 10000 is the loan amount

Mike

"garber2007" wrote:

I have a loan with my parents and we are trying to see how long it will take
to pay back the loan. I see a lot of templates that have you insert the
amount of time you want to pay it off in, but none that you enter the amount
that you want to pay each month. I want to pay 200 a month and then see how
long it will take to pay off. I am currently running Microsoft Office 2003
(Excel, Word, & Outlook).