In truth, the template doesn't know what period length you are entering. So
enter the monthly data (ie, monthly interest rate and term in months), and say
you have 1 payment per year. That way the template will properly calculate your,
for example, 37 payments.

The only problem is the payment date will be wrong, but it's not too hard to
change after unprotecting the sheet.

--
Regards,
Fred


wrote in message
oups.com...
I downloaded the MS Loan Amortiztion template. I'm having a problem
because it only allows me to enter years for the length of the loan.
Some of the loans I have are not even years (37 months, for example),
but the template won't allow me to enter this. Can you please tell me
how to make changes to accommodate this? Thanks.