Loan amortization template

T

trap551

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

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

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
 
F

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
 
Top