Question

1 Approved Answer

Posted on Jul 30, 2024

Rule 4 : applicant can receive up to $400,000 loan If credit score is above 780, ready for a down payment of at least 3.5%,

Rule 4: applicant can receive up to $400,000 loan If credit score is above 780, ready for a down payment of at least 3.5%, job category is 1, there is a steady employment during the past eight years, annual income is at least $100,000, and debt to income ratio is less than 20%

Use logical operators to find applicant qualifications based on the above rules. Use a function to show the maximum amount of loan in column L.

image text in transcribed

620 680 780 Rule 1-2 Min. Credit Employed yrs Down payment Rule 4 Min. Credit Employed yrs Down payment 3 730 5 3.5 2 5 8 Job category 1 Rule 1-1 2 Min. Credit 3 Employed yrs 4 Down payment 5 Job category 6 debt ratio 7 Annual income 8 Loan 9 10 620 3 8 31 0.31 45000 Rule 2 Min. Credit Employed yrs Down payment Job category debt ratio Annual income Loan Rule 3 Min. Credit Employed yrs Down payment Job category debt ratio Annual income Loan Job category 2 0.4 1 0.5 40000 100000 8 3.5 1 0.2 100000 2 0.5 55000 200000 debt ratio Annual income 65000 300000 debt ratio Annual income Loan 400000 Credit score Max. Loan 2 11 First 12 Betty 13 Vickey 14 Nakisha 15 Keeley 16 Elizabet 17 Walter 18 Miranda 19 Oda 20 Pamelia 21 Shasta 22 Jackqueline 23 Vernice 24 Jamar 25 Isadora 26 Corie 27 Tana 28 Cheryl 29 Renaldo 30 Kareen 31 Cathrine 32 Shannon 33 Cristina 34 Ehtel 35 Francina 36 37 7 Job Employment yrs Down payment % category Debt Annual income Rule 1 Rule 2 Rule 3 732 23 12 1 5647 130182 Eligible Eligible Eligible 850 21 9 1 800 109735 Eligible Eligible Eligible 709 10 11 2 3756 77242 Not Eligible Eligible Not Eligible 850 15 7 1 6288 97509 Eligible Not Eligible Eligible 716 1 4 1 2841 207749 Not Eligible Not Eligible Not Eligible 850 15 4 1 7212 244172 Not Eligible Not Eligible Eligible 816 17 5 4 5675 55135 Not Eligible Not Eligible Not Eligible 710 3 6 1 1423 211491 Eligible Not Eligible Not Eligible 850 13 11 1 3268 205927 Eligible Eligible Eligible 708 9 4 1 6763 153394 Not Eligible Not Eligible Not Eligible 850 5 9 2 3 7152 79084 Eligible Not Eligible Not Eligible 782 8 8 6 1 6043 223836 Eligible Not Eligible Eligible 748 4 9 2 6193 144917 Not Eligible Eligible Not Eligible 850 24 6 1 6404 160724 Eligible Not Eligible Eligible 732 7 6 2 3926 242447 Not Eligible Not Eligible Eligible 738 14 4 1 404 220653 Not Eligible Not Eligible Eligible 850 6 5 1 5285 108291 Eligible Not Eligible Eligible 720 20 4 3 6047 177198 Not Eligible Not Eligible Not Eligible 850 10 10 1 4053 135194 Eligible Eligible Eligible 676 6 8 1 3459 122911 Eligible Not Eligible Not Eligible 850 15 4 2 1857 243816 Not Eligible Not Eligible Eligible 819 13 4 2 6909 216486 Not Eligible Not Eligible Eligible 735 18 10 1 2059 153941 Eligible Eligible 850 9 11 1 5824 231845 Eligible Eligible Eligible Rule 4 Not Eligible Eligible Not Eligible Not Eligible Not Eligible Eligible Not Eligible Not Eligible Eligible Not Eligible Not Eligible Eligible Not Eligible Eligible Not Eligible Not Eligible Not Eligible Not Eligible Eligible Not Eligible Not Eligible Not Eligible Not Eligible Eligible Eligible 620 680 780 Rule 1-2 Min. Credit Employed yrs Down payment Rule 4 Min. Credit Employed yrs Down payment 3 730 5 3.5 2 5 8 Job category 1 Rule 1-1 2 Min. Credit 3 Employed yrs 4 Down payment 5 Job category 6 debt ratio 7 Annual income 8 Loan 9 10 620 3 8 31 0.31 45000 Rule 2 Min. Credit Employed yrs Down payment Job category debt ratio Annual income Loan Rule 3 Min. Credit Employed yrs Down payment Job category debt ratio Annual income Loan Job category 2 0.4 1 0.5 40000 100000 8 3.5 1 0.2 100000 2 0.5 55000 200000 debt ratio Annual income 65000 300000 debt ratio Annual income Loan 400000 Credit score Max. Loan 2 11 First 12 Betty 13 Vickey 14 Nakisha 15 Keeley 16 Elizabet 17 Walter 18 Miranda 19 Oda 20 Pamelia 21 Shasta 22 Jackqueline 23 Vernice 24 Jamar 25 Isadora 26 Corie 27 Tana 28 Cheryl 29 Renaldo 30 Kareen 31 Cathrine 32 Shannon 33 Cristina 34 Ehtel 35 Francina 36 37 7 Job Employment yrs Down payment % category Debt Annual income Rule 1 Rule 2 Rule 3 732 23 12 1 5647 130182 Eligible Eligible Eligible 850 21 9 1 800 109735 Eligible Eligible Eligible 709 10 11 2 3756 77242 Not Eligible Eligible Not Eligible 850 15 7 1 6288 97509 Eligible Not Eligible Eligible 716 1 4 1 2841 207749 Not Eligible Not Eligible Not Eligible 850 15 4 1 7212 244172 Not Eligible Not Eligible Eligible 816 17 5 4 5675 55135 Not Eligible Not Eligible Not Eligible 710 3 6 1 1423 211491 Eligible Not Eligible Not Eligible 850 13 11 1 3268 205927 Eligible Eligible Eligible 708 9 4 1 6763 153394 Not Eligible Not Eligible Not Eligible 850 5 9 2 3 7152 79084 Eligible Not Eligible Not Eligible 782 8 8 6 1 6043 223836 Eligible Not Eligible Eligible 748 4 9 2 6193 144917 Not Eligible Eligible Not Eligible 850 24 6 1 6404 160724 Eligible Not Eligible Eligible 732 7 6 2 3926 242447 Not Eligible Not Eligible Eligible 738 14 4 1 404 220653 Not Eligible Not Eligible Eligible 850 6 5 1 5285 108291 Eligible Not Eligible Eligible 720 20 4 3 6047 177198 Not Eligible Not Eligible Not Eligible 850 10 10 1 4053 135194 Eligible Eligible Eligible 676 6 8 1 3459 122911 Eligible Not Eligible Not Eligible 850 15 4 2 1857 243816 Not Eligible Not Eligible Eligible 819 13 4 2 6909 216486 Not Eligible Not Eligible Eligible 735 18 10 1 2059 153941 Eligible Eligible 850 9 11 1 5824 231845 Eligible Eligible Eligible Rule 4 Not Eligible Eligible Not Eligible Not Eligible Not Eligible Eligible Not Eligible Not Eligible Eligible Not Eligible Not Eligible Eligible Not Eligible Eligible Not Eligible Not Eligible Not Eligible Not Eligible Eligible Not Eligible Not Eligible Not Eligible Not Eligible Eligible Eligible