Can you create an amortization schedule using Excel, if so How?

  • Thread starter Thread starter Guest
  • Start date Start date
To lenghty to explain. If you want to contact me directly I have a very nice
template. (e-mail address removed).

Steve
 
most versions of Excel come with an Amortization template. Search your hard
drive for *amortiz*.xls

Bruce
 
Of course you can create one. They are really easy.

Beginning Bal Payment Principal Interest Ending Balance
6/27/2004 10613.00 163.28 116.85 46.43 10496.15

Something like that would be the first row. Beg Bal (in first ro
only) and Payment are hard code, principal =PMT-INT
Int = Beginning * Int rate
Ending bal = Beg-Principal

On next row, Beg bal is no longer hard code- it becomes =Ending balanc
from previous row.

Hope this helps...copying and pasting down needs to be done in correc
order. You'll figure it out. Hopefully this doesn't come out al
weird
 
You must log in or register to reply here.

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

Amortization Schedule 1
Can Excel create an amortization schedule? 1
need a vehicle loan amortization 6
loan amortization schedule 6
Creating Amortization tables in excel 2003? 1
Amortization schedule with periodic payments 1
amortization schedule 1
Mortgage Amortization - Canadian semi annual compounding 1

Back
Top