Loan amortization template

[trap551]

I am looking for a fixed principal declining interest loan template for Excel
03. Any ideas? Thanks.

 

[FSt1]

hi
one here. not sure if it the one you one.
http://office.microsoft.com/en-us/templates/TC010197771033.aspx
if not, try here
http://www.vertex42.com/ExcelTemplates/excel-amortization-spreadsheet.html

regards
FSt1

 

[trap551]

FSt1, Thanks, but these are all normally amortizing templates. I am looking
for a fixed principal declining interest template. Principal payments stay
unchanged for life of the loan. No luck so far.

 

[FSt1]

hi
i gave you want i had. sorry.
do a post in templates at the bottom of decussion group catagory.far left
this page.
also in the search box(top right), search microsoft for templates. they have
tons.

Regards
FSt2

 

[Fred Smith]

I gather you are saying that you are paying a fixed amount plus interest
every period. So if, for example, you have a $100,000 loan, you pay $1000
plus interest every month. Is that correct?

If so, your amortization term is simply Principal/Payment.

If what you are asking for is a schedule of interest charges each period,
the easiet is to build it your self. Interest amount each period is:

=AmountOutstanding*IntRate/PaymentsPerYear

Regards,
Fred