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.