I am working on a database with interest rates for over 50 different automotive lenders. A user would type in : Credit score (ex: 689). Year of car (ex: 2003), loan term (ex: 72 mos.), Amount financed (ex: $24500), loan to value (ex: 103%).
My dilemna is this. Bank "A" has the same rate for credit score between 999 - 730 for year model 2003 - 2005. for terms 24 - 60 months. The same rate for 729 - 730 year model 2003 - 2005 for terms 24 -60, etc. They also give .25% discount for fincnacing over $25000 if your score is over 700 and .25 off if your loan to value is less than 90% regardles of score.
I originally started listing this out one by one. I had over 10,000 entries for just my first bank, and updating this would be a nightmare. Any ideas on a better way to do this??
Any help would be greatly appreciated.
