Question

In: Finance

Lenders primarily use the Fair Isaac Corporation (FICO) model to determine credit scores. FICO grades consumers...

Lenders primarily use the Fair Isaac Corporation (FICO) model to determine credit scores. FICO grades consumers on a 300- to 850-point range; a higher score indicates less risk to the

lender. A score of 800 or higher is considered exceptional; 740 to 799 is very good; 670 to 739 is good; 580 to 669 is fair; and 579 or lower is poor.

According to MyFICO.com your credit score can impact interest rates available to you as follows:

FICO score

APR

760–850

4.17%

700–759

4.392%

680–699

4.569%

660–679

4.783%

640–659

5.213%

620–639

5.759%

  1. Using the loan rate available to someone with a FICO credit score of 780, calculate the monthly payment and total paid over the life of a $250,000 30-year fixed-rate mortgage for someone with this credit score.
  1. Now, calculate the monthly payment and total paid using the loan rate available to someone with a FICO credit score of 630.
  1. Calculate the difference in monthly payment and the total interest paid for someone with a very good credit rating (780) with someone who has a low credit rating (630).

Solutions

Expert Solution

Hello

To determine the monthly payment, I have used the PMT function of Excel. The inputs for PMT function are - PV, Periods, Rate.

All the three sub-questions are solved in the snapshot below. To avoid repetition, some rows have been hidden.

With formulae -

Hope this helps.

Please provide your feedback!

Thank you!


Related Solutions

A Fair Isaac Corporation (FICO) score is used by credit agencies such as banks to determine...
A Fair Isaac Corporation (FICO) score is used by credit agencies such as banks to determine whether to lend money and the interest rate to charge. Its value ranges from 300 to 850 and if you have a score over 700, you are considered to be a "quality" credit risk. The mean credit score of average income earners in California is estimated by Fair Isaac to be 664. A recent survey of 47 high income earners in California had a...
A Fair Isaac Corporation (FICO) score is used by credit agencies (such as mortgage companies and...
A Fair Isaac Corporation (FICO) score is used by credit agencies (such as mortgage companies and banks) to assess the creditworthiness of individuals. Values range from 300 to 850, with a FICO score over 700 considered to be a quality credit risk. According to Fair Isaac Corporation, the mean FICO score is 703.5. A credit analyst wondered whether high-income individuals (incomes in excess of $100,000 per year) had higher credit scores. He obtained a random sample of 40 high-income individuals...
The following are the FICO credit rating scores of 12 random people.
The following are the FICO credit rating scores of 12 random people. Use the given data values to construct a boxplot graph and identify the Five-Number Summary. Round decimals to two places. 664 693 698 714 751 753 779 789 802 818 834 836 1) Compute the sample mean. 2) Compute the sample standard deviation. 3) Compute the coefficient of variation(CV). 4) Find the Five-Number Summary:
Why do you think lenders use the 5 C's of credit? Is it a fair guide...
Why do you think lenders use the 5 C's of credit? Is it a fair guide on whether to accept or reject a person for a loan? How is borrowing money with a SBA backed lender versus borrowing money backed from a conventional lender.
Here is a list of five individual FICO credit scores. What is their average and standard...
Here is a list of five individual FICO credit scores. What is their average and standard deviation? 671 745 810 778 801 Widget Inc. Stock has the following probabilities of return. What is its mu and sigma? There is a 30% chance for a good economic outlook and the stock will increase by 25% There is a 40% chance for an okay economic outlook and the stock will increase by 5% There is a 30% chance for a bad economic...
Use simulation in SAS. FICO scores nationally have an average of 640 with a standard deviation...
Use simulation in SAS. FICO scores nationally have an average of 640 with a standard deviation of 60. If you simulated the credit scores of 10,000 borrowers, what percent of FICO scores are less than 500? Greater than 850? Find the mean and standard deviation of scores that meet these conditions.
Name and describe the “C’s” of credit that Banks and other lenders use in evaluating loan...
Name and describe the “C’s” of credit that Banks and other lenders use in evaluating loan applicants. Which do you consider the most important and Why?
Name and describe the “C’s” of credit that Banks and other lenders use in evaluating loan...
Name and describe the “C’s” of credit that Banks and other lenders use in evaluating loan applicants. Which do you consider the most important and Why?
Many consumers use checking accounts and credit, often in the form of credit cards. What are...
Many consumers use checking accounts and credit, often in the form of credit cards. What are some of the advantages and disadvantages of having a checking account? What are some of the advantages and disadvantages of having a credit card? What are some strategies you could use to manage credit cards to avoid paying high-interest rates and fees? How can planning to manage your accounts lead you to be more productive and better equipped to reflect on your financial priorities?
Credit scores are used by banks, financial institutions, and retailers to determine one's trustworthiness, and their...
Credit scores are used by banks, financial institutions, and retailers to determine one's trustworthiness, and their ability to pay their credit card, when he/she is given a credit card. The higher the credit score, the better the credit (and the more financially trustworthy) a consumer is. In light of the current economic downturn, an economist claims that the credit score of Canadians between the ages of 25 to 40 has remained the same. Prior to the current economic downturn, the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT