Have you looked at the loan amortization template that's generally supplied
with Excel?
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Kimmer" wrote:

Does anyone know how I can set up a loan amortization for $15,000 at 5% for
10 years with monthly payments? I have tried a couple different things and
keep getting NAME? in columns for to interest and to principal. I have a
template but I would really like to know how to do the formula for this.
Formulas are my worst problem with excel.
Thanks.
--
Too old to be in college