Question: I need a formula Set up the necessary formula(s) for calculating the interest rate surcharge for each applicant given below. The rules for calculating the

I need a formula I need a formula Set up the necessary formula(s) for calculating the

Set up the necessary formula(s) for calculating the interest rate surcharge for each applicant given below. The rules for calculating the surcharge are as follows: a. There is no (zero) surcharge if the applicant's credit score is 720 or greater. b. The surcharge is 0.125 if the credit score is less than 720 and the loan amount is less than or equal to 25% of the annual income. c. The surcharge is 0.150 if the credit score is less than 720 and the loan amount is greater than 25% of the annual income. (20 Points) Applicant's Name Annual Income Credit Score Loan Amount Interest Rate Surcharge Lotto Larry Joe Blow Slow Moe Slick Willy Suzie Sharp Ram Rambler $37,000 $42,800 $54,600 $33,000 $94,000 $33,000 640 685 725 590 10,250 12,800 11,000 7,500 14,000 9,000 540

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!