Answered step by step
Verified Expert Solution
Link Copied!

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". image text in transcribed

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_Score

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Intelligence For New-Generation ManagersCurrent Avenues Of Development

Authors: Jörg H. Mayer, Reiner Quick

6th Edition

3319156950, 9783319156958

More Books

Students also viewed these Accounting questions

Question

What background experience do you have?

Answered: 1 week ago

Question

Explain the causes of indiscipline.

Answered: 1 week ago

Question

Understand employee mentoring

Answered: 1 week ago

Question

Appreciate the importance of new-employee orientation

Answered: 1 week ago