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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help to create amortization schedule 0
need a loan payment schedule 3
loan amortization 2
Date function within loan amortization spreadsheets 3
CUMIPMT 0
need a vehicle loan amortization 6
Loan amortization schedule for variable interest rates 5
How do I change the values in loan amortization 2

Back
Top