Forum Moderators: coopster
Their is a base_rate, special_discount, equity_discount, luxury_discount, and other_discount. I have a simple form that a user would type in score, term, year model, loan to value percentage(ltv), amount to finance.
I can list out all of the available discounts no problem. But what I am trying to do is get a net rate base on the information suppled to me. It might take modifying my table and that is fine with me. Their are 4 possible discounts. 1st is the special_discount. This is to be subtracted always, if it is stored in the record it needs to be subtracted from the base_rate. 2nd is the equity discount. This is to only be subtracted from the base rate if the user typed in a lower ltv than the low_ltv in the record. Also, if they are financing over 25k (luxury discount) some will give .25% off. Any ideas on how this newbie can make it work?
Any help is greatly appreciated.
[edited by: jatar_k at 4:10 am (utc) on Nov. 27, 2004]
[edit reason] no personal urls thanks [/edit]
The calculations are simple once you have the associated rates.
What would you recommend that I use to apply the discount only if they meet certain criteria.
For example to receive .25 equity discount you must finance 90% or less ltv otherwise you do not receive it.
Also you only receive the Luxury discount if your amount financed is equal to or exceeds $25000.00. In addition you must score 700 or greater.
The way I am doing it, it is subtracting the discount regardless if they qualify for it.
This is the part that I need help with. Whether it takes going back and re-doing my table layout or inserting the right code. Thanks again.
