Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Looking for Compounding Interest Loan Template
Can someone refer me to an Excel template for a compounding interest loan.
This is actually for a credit line rather than a pure loan, and I have some specific requirements: 1) I need to be able to specify the compounding period as either monthly or quarterly, in order to be able to quickly estimate the effects on interest payments in the future if the loan gets behind on payments. If I could specify the parameters of the loan and then have the tool create the actual schedule working loan template that would be fine. 2) I need to be able to specify the amount of payment each month, which can be either less or more than the amount due that month. 3) I need to be able to specify how much of each monthly payment is for accumulated interest and how much is for return of capital. 4) I need to be able to add additional amounts to the loan over time (because it is a credit line). I am willing to pay money for this. Please let me know what my options are. -- W |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Looking for Compounding Interest Loan Template
You can do a search on google - there are probably some templates there
already. You can go to www.elance.com - but that might take some time. But for money you can get it very quickly - it isn't too difficult. "W" wrote: Can someone refer me to an Excel template for a compounding interest loan. This is actually for a credit line rather than a pure loan, and I have some specific requirements: 1) I need to be able to specify the compounding period as either monthly or quarterly, in order to be able to quickly estimate the effects on interest payments in the future if the loan gets behind on payments. If I could specify the parameters of the loan and then have the tool create the actual schedule working loan template that would be fine. 2) I need to be able to specify the amount of payment each month, which can be either less or more than the amount due that month. 3) I need to be able to specify how much of each monthly payment is for accumulated interest and how much is for return of capital. 4) I need to be able to add additional amounts to the loan over time (because it is a credit line). I am willing to pay money for this. Please let me know what my options are. -- W |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compounding Interest | Excel Discussion (Misc queries) | |||
Which formula to use for compounding interest for specific # of da | Excel Worksheet Functions | |||
Compounding Interest Formula | Excel Discussion (Misc queries) | |||
How can we use Excel to calculate interest with daily compounding | Excel Discussion (Misc queries) | |||
Compounding Interest | Excel Discussion (Misc queries) |