I inherited a database for the company I work for and since I am an amateur access programmer I am the goto guy. I am looking to create a formula to amortize a loan. I found some code that does this but It is way above my knowledge to change it for my needs. Any help would be greatly appreciated. This has to be done in Access not in Excel!
Here is what I'm trying to do:
I want to enter a number of months to calculate a payoff on a loan and if possible a payment amount to calculate the number of months to payoff a loan.
Payment amount must be > than Minimum Payment of loan
A loan term is 30 days, not a month, because a month can have differing days in each month.
Important Equations that factor in to figuring this formula out:
((Amount*rate)+Amount)=Total Loan Amount for a 30 day period
Month(Time Increment)=30 days
Minimum Payment=Amount * Rate
As I mentioned any help or pointers would be greatly appreciated. I found an access amortization calculator for a mortgage online but I was unable to configure it for my needs for a different type of loan amortization.
Thanks in advance for any help or pointers!
Last edited by Bmw; 01-18-11 at 22:38.
First of all Thank your for your reply.
I looked at your formula I believe I need to provide some additional details.
A Loan term is 30 days
My loan is based on a 30 day Period
A customer borrows money 1/21/11 the due date for repayment would be 02/20/11.
Therefore Interest :$10
Total Due Back on 02/20/11 :$110
The terms of the loan is 30 days. So 2 things that can happen is:
1. On 02/20/11 or sooner they can pay the loan off for $110
2. On 02/20/11 Pay the interest of $10 and "reborrow" the $100 for another 30 days under the same terms.
I want to provide an amortization schedule in which I can say enter a term of let say 12 months, maybe more or maybe less and it will provide me an amount they need to pay to achieve this goal.
I tested Your formula. It is Spot on correct on a yearly basis but unfortunately I do not know how to modify it to suit my needs as described above.
Any further help would be greatly appreciated.