How do I change the values in loan amortization

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am wanting to use the loan amortization spread sheet, and was wondering how
you change the values as I want to change Loan period in Years to calculate
Loan period in Months?? I have tried several things but not having a great
knowledge on using Excel im failing miserably! PLEASE HELP!!! :O)


Thank you!
 
Hello:

There are several different loan amortization templates on MS's website
Try using 01056620.xlt. This is a monthly one. You can find it in
the real estate subsection. Or try the following link.

http://office.microsoft.com/en-us/templates/TC010566201033.aspx

Pieter Vandenberg


: I am wanting to use the loan amortization spread sheet, and was wondering how
: you change the values as I want to change Loan period in Years to calculate
: Loan period in Months?? I have tried several things but not having a great
: knowledge on using Excel im failing miserably! PLEASE HELP!!! :O)


: Thank you!
 
Back
Top