Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Loan amortization template

I am looking for a fixed principal declining interest loan template for Excel
03. Any ideas? Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default 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.

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,389
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Loan Amortization template Brian Excel Discussion (Misc queries) 7 July 14th 07 12:01 PM
loan amortization template with loan start date AND first payment Lisa W Excel Discussion (Misc queries) 0 January 30th 06 11:27 PM
Variable rate loan amortization template ColoAvsPuckhead Excel Discussion (Misc queries) 0 April 7th 05 05:29 PM
Variable rate loan amortization template ColoAvsPuckhead Excel Discussion (Misc queries) 0 April 7th 05 05:29 PM
Loan Amortization Template in Excel [email protected] Excel Worksheet Functions 3 January 29th 05 04:50 AM


All times are GMT +1. The time now is 08:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"