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).
|