Loan Amortization Schedule Formula

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.
 
B

Barb Reinhardt

Have you looked at the loan amortization template that's generally supplied
with Excel?
 
K

Kimmer

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.
 
B

Barb Reinhardt

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

need a loan payment schedule 3
Help to create amortization schedule 0
loan amortization 2
Loan amortization schedule for variable interest rates 5
Date function within loan amortization spreadsheets 3
How do I change the values in loan amortization 2
Is there a loan amortization schedule with balloon at final pmt? 4
Amortization Schedule 11

Top