Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Loan amortization template
I am looking for a fixed principal declining interest loan template for Excel
03. Any ideas? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loan Amortization template | Excel Discussion (Misc queries) | |||
loan amortization template with loan start date AND first payment | Excel Discussion (Misc queries) | |||
Variable rate loan amortization template | Excel Discussion (Misc queries) | |||
Variable rate loan amortization template | Excel Discussion (Misc queries) | |||
Loan Amortization Template in Excel | Excel Worksheet Functions |