Looking for Compounding Interest Loan Template

W

W

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.
 
D

dhstein

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top