Loan amortization template
 

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

Loan amortization template
 

hi
one here. not sure if it the one you one.
http://office.microsoft.com/en-us/te...197771033.aspx
if not, try here
http://www.vertex42.com/ExcelTemplat...readsheet.html

regards
FSt1

"trap551" wrote:

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

Loan amortization template
 

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" wrote:

hi
one here. not sure if it the one you one.
http://office.microsoft.com/en-us/te...197771033.aspx
if not, try here
http://www.vertex42.com/ExcelTemplat...readsheet.html

regards
FSt1

"trap551" wrote:

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

Loan amortization template
 

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

"trap551" wrote:

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" wrote:

hi
one here. not sure if it the one you one.
http://office.microsoft.com/en-us/te...197771033.aspx
if not, try here
http://www.vertex42.com/ExcelTemplat...readsheet.html

regards
FSt1

"trap551" wrote:

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

Loan amortization template
 

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

"FSt1" wrote in message
...
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

"trap551" wrote:

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" wrote:

hi
one here. not sure if it the one you one.
http://office.microsoft.com/en-us/te...197771033.aspx
if not, try here
http://www.vertex42.com/ExcelTemplat...readsheet.html

regards
FSt1

"trap551" wrote:

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