Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please modify the loan decision model (see the file attached) so that it would differentiate loan rejection messages for people with low credit score and
Please modify the loan decision model (see the file attached) so that it would differentiate loan rejection messages for people with low credit score and people with negative net worth (heavy in debtors).
*If the credit score is between ..., we will show this message ...
You can see the example messages below. If "NO" Loan, if "YES LOAN".
A B D E F G H 1 J 650 EIFERROR(FORMULATEXT(B11),B11) 300000 EIFERROR(FORMULATEXT(B12),B12) 5000000 =IFERROR(FORMULATEXT(B13),B13) 1 2 Credit Rating Income - Loan Table 3 Score Quality Interest offered Income Loan amount 4 O Poor No loan $0.00 $10,000.00 5 500 Bad 12.00% $24,000.00 $25,000.00 6 600 Fair 8.00% $48,000.00 $50,000.00 7 700 Average 3.00% $100,000.00 $75,000.00 8 750 Good 2.50% $200,000.00 $150,000.00 9 800 Excellent 2.00% 10 11 your credit score 650 12 Your annual income $300,000 13 Your Net Worth $5,000,000 14 15 System response Congratulations! You qualify for a loan up to $1,000,000 at the rate of 8.00% 16 17 =IF(OR(Credit_ScoreStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started