Loan Amortization Schedule Formula

  • Thread starter Thread starter Kimmer
  • Start date Start date
K

Kimmer

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.
 
Have you looked at the loan amortization template that's generally supplied
with Excel?
 
Yes, I have the template on my computer with excel. I would rather be able
to do it by hand with the formula. I know that sounds stupid but I am just
learning excel and would rather do it the hard way I guess.
Thanks.
 
Why not open the Loan Amortization template and unprotect it and look at
what's used there?
--
HTH,
Barb Reinhardt

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