This is what I am tryign to do:
I have a database of about 20,000 loans and need to amoritize all of them based on certain criteria. Each loan has aunique ID, Term, Interest Rate, balance and scheduled payment.
What I need to do if it is possible is amoritize each loan based on the age of it. For example, I have one loan that is 30 months old and another that is 120 months I need to be able to calculate them seperatly.
I know the calculations to do it, but I don't know how to input it into access so access will recognize the age and amoritize over teh life of the loan.
Please be gentle
Thanks.
I have a database of about 20,000 loans and need to amoritize all of them based on certain criteria. Each loan has aunique ID, Term, Interest Rate, balance and scheduled payment.
What I need to do if it is possible is amoritize each loan based on the age of it. For example, I have one loan that is 30 months old and another that is 120 months I need to be able to calculate them seperatly.
I know the calculations to do it, but I don't know how to input it into access so access will recognize the age and amoritize over teh life of the loan.
Please be gentle
Thanks.
