Hello,
I need to calculate a commission based on following rates for different bank. Rates are as follows: Please help me calculate the commission based on below conditions:
Conditions:
Wells Fargo: 70% of total reserve below (column F)
Ally Bank : 75% of total reserve below (column F)
Gateway One Lending: 80% of total reserve below (column F)
Unity One: Based on Tier (Column C), if Tier A, then 2% of amount financed, if B, then 1.5% of amount Financed (column B)
NASA FCU-Indirect Lending: Based on Tier (Column C), if Tier A, then 2% of amount financed, if B, then 1.5% of amount Financed (Column B)
All other Banks: Show Value " None"
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I need to calculate a commission based on following rates for different bank. Rates are as follows: Please help me calculate the commission based on below conditions:
Conditions:
Wells Fargo: 70% of total reserve below (column F)
Ally Bank : 75% of total reserve below (column F)
Gateway One Lending: 80% of total reserve below (column F)
Unity One: Based on Tier (Column C), if Tier A, then 2% of amount financed, if B, then 1.5% of amount Financed (column B)
NASA FCU-Indirect Lending: Based on Tier (Column C), if Tier A, then 2% of amount financed, if B, then 1.5% of amount Financed (Column B)
All other Banks: Show Value " None"
Lender Name | Amount Financed | Tier | Interest Sell Rate | Interest Buy Rate | Total Reserve | Commission |
WELLS FARGO DEALER SERVICES | 40240.79 | 5738.30 | 3122.47 | 2615.84 | ||
ALLY BANK | 37918.17 | 4406.50 | 4410.34 | -3.83 | ||
WELLS FARGO DEALER SERVICES | 34173.9 | 5733.89 | 3486.29 | 2247.60 | | |
WELLS FARGO DEALER SERVICES | 18090.81 | 4743.28 | 4746.91 | -3.63 | | |
Net Direct Auto Sales | 27403.75 | 0.00 | 0.00 | 0.00 | | |
ALLY BANK | 38609.17 | 9942.23 | 7170.96 | 2771.27 | | |
Westlake Financial Services | 34235.91 | 12913.54 | 12913.54 | 0.00 | ||
NASA FCU-INDIRECT LENDING | 31335.81 | A | 5117.79 | 5117.79 | 0.00 |
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>