Loan Amortization Schedule Formula
 

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

Loan Amortization Schedule Formula
 

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

Loan Amortization Schedule Formula
 

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.
--
Too old to be in college


"Barb Reinhardt" wrote:

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

Loan Amortization Schedule Formula
 

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.



"Kimmer" wrote:

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.
--
Too old to be in college


"Barb Reinhardt" wrote:

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