Question

In: Finance

Nast stores has derived the following consumer credit-scoring model after years of data collect Y=(0.20 x...

Nast stores has derived the following consumer credit-scoring model after years of data collect Y=(0.20 x Employment) + (0.4 x Homeowner) + (0.3 x Cards)

Employment = 1 if employed part-time, and 0 if unemployed

Cards= 1 if presently has 1-5 credit cards, 0 otherwise

Nast determines that a score of at least 0.70 indicates a very good credit risk, and it extends credit to these individuals. (each letter below is a separate question, answer a-d)

PLEASE SHOW ALL WORK

A. If Janice is employed part-time, is a homeowner, and has six credit cards at present, does the model indicate she should receive credit?

B. Janice just got a full-time job and closed two of her credit card accounts. Should she receive credit? Has her credit worthiness increased or decreased, according to model?

C. Your boss mentions that he just returned from a trade-association conference, at which one of the speakers recommended that length of time at present residence (regardless of homeownership status) be include in credit-scoring models. If the weight turns out to be 0.25, how do you think the variable would be coded (i.e., 0 stands for what, 1 stands for what, etc)?

D. Suggest other variables that associated might have left out of the model, and tell how you would code them (i.e., 0,1,2 are assigned to what conditions or variables?).

Solutions

Expert Solution

A.

Employment = Part - time i.e. 1

Homeowner = Yes i.e. 1

Credit Cards = 6 i.e. 0

Y = 0.2 * Employment + 0.4 * Homeowner + 0.3 * Cards

Y = 0.2 * 1 + 0.4 * 1 + 0.3 * 0 = 0.6

Since, it is less than threshhold of 0.7, it indicates that it is not so very good credit risk and Jannice should not be given loan as per this credit scoring model.

B.

Employment = Full - time i.e. 1 (Since for Full Time employment, information is missing, we are assuming that full time is better than part time so, it should also be given 1 for Employment)

Homeowner = Yes i.e. 1

Credit Cards = 4 i.e. 1

Y = 0.2 * Employment + 0.4 * Homeowner + 0.3 * Cards

Y = 0.2 * 1 + 0.4 * 1 + 0.3 * 1 = 0.9

Since, it is greater than threshhold of 0.7, it indicates that it is very good credit risk and Jannice should be given loan as per this credit scoring model. Her credit worthiness has improved as a result of closing down of 2 credit cards, now she hold only 4 credit cards which is treated better than having 6 cards. For full time it is even better than part time but we have treated that equally. So, Jannice creditworthiness has improved and now we can provide loan to her.

C.

Since having stayed on a particular residence for more than particular threshold is good for a lender as he can trace that customer easily in case the borrower defaults, we should code

1 for having stayed on a particular residence for a specific period of time

0 for not having stayed on a particular residence for a specific period of time.

This specific period of time can be analysed with the help of data collected already.

D.

1. First of all, Full time job is missed out of employment status. It also needs to be coded and given higher weight than part time because it give more confidence to lender. Thus, it can be coded as:

2 for Full Time Job

1 for Part Time Job

0 for No Job

2. Other Variables that can be included are:

Present Monthly Income (0 for less than $20,000 and 1 otherwise as higher monthly income is better for lenders.)

Checking Balance (0 for less than $2000 and 1 otherwise as higher checking balance is better for lenders.)

Security Provided for Loan (0 for No Security and 1 for Security Provided) etc....


Related Solutions

The following data lists age (x, in years) and FICO credit score (y) for 15 random...
The following data lists age (x, in years) and FICO credit score (y) for 15 random credit card customers. At the 10% significance level, use Excel to test the claim that age and credit score are linearly related by specifying the slope estimate, p-value and final conclusion below. Do not round any intermediate calculations. Round your slope estimate answer to 2 decimal places. Round your p-value to 4 decimal places. Enter a "−" sign in front of any negative answer....
Consider a consumer with the utility function U(X, Y) = X^2 Y^2 . This consumer has...
Consider a consumer with the utility function U(X, Y) = X^2 Y^2 . This consumer has an income denoted by I which is devoted to goods X and Y. The prices of goods X and Y are denoted PX and PY. a. Find the consumer’s marginal utility of X (MUX) and marginal utility of Y (MUY). b. Find the consumer’s marginal rate of substitution (MRS). c. Derive the consumer's demand equations for both goods as functions of the variables PX,...
A sales manager collected the following data on x = years of experience and y =...
A sales manager collected the following data on x = years of experience and y = annual sales ($1,000s). The estimated regression equation for these data is ŷ = 83 + 4x. Salesperson Years of Experience Annual Sales ($1,000s) 1 1 80 2 3 97 3 4 102 4 4 107 5 6 103 6 8 116 7 10 119 8 10 123 9 11 127 10 13 136 (a) Compute SST, SSR, and SSE. SST=SSR=SSE= (b) Compute the coefficient...
A sales manager collected the following data on x = years of experience and y =...
A sales manager collected the following data on x = years of experience and y = annual sales ($1,000s). The estimated regression equation for these data is ŷ = 82 + 4x. Salesperson Years of Experience Annual Sales ($1,000s) 1 1 80 2 3 97 3 4 102 4 4 107 5 6 103 6 8 101 7 10 119 8 10 128 9 11 127 10 13 136 (a) Compute SST, SSR, and SSE. SST=SSR=SSE= (b) Compute the coefficient...
Suppose a consumer has a utility function given by u(x, y) = x + y, so...
Suppose a consumer has a utility function given by u(x, y) = x + y, so that the two goods are perfect substitutes. Use the Lagrangian method to fully characterize the solution to max(x,y) u(x, y) s.t. x + py ≤ m, x ≥ 0, y ≥ 0, where m > 0 and p < 1. Evaluate and interpret each of the multipliers in this case. What happens to your solution when p > 1? What about when p =...
Suppose a consumer has a utility function u(x, y) = 2x + 3y. The consumer has...
Suppose a consumer has a utility function u(x, y) = 2x + 3y. The consumer has an income $40 and the price of x is $1 and the price of y is $2. Which bundle will the consumer choose to consume? Determine the demand functions for x and for y. Repeat the exercise if, instead, the consumer’s utility function is u(x, y) = min{x, 2y}.
A consumer purchases two goods, x and y and has utility function U(x; y) = ln(x)...
A consumer purchases two goods, x and y and has utility function U(x; y) = ln(x) + 3y. For this utility function MUx =1/x and MUy = 3. The price of x is px = 4 and the price of y is py = 2. The consumer has M units of income to spend on the two goods and wishes to maximize utility, given the budget. Draw the budget line for this consumer when M=50 and the budget line when...
Use the following data to develop a quadratic model to predict y from x. Develop a...
Use the following data to develop a quadratic model to predict y from x. Develop a simple regression model from the data and compare the results of the two models. Does the quadratic model seem to provide any better predictability? Why or why not? x y x y 15 229 15 247 9 74 8 82 6 29 5 21 21 456 10 94 17 320
Collect data on one response (dependent or y) variable and two different explanatory (independent or x)...
Collect data on one response (dependent or y) variable and two different explanatory (independent or x) variables. This will require a survey with three questions. For example: To predict a student’s GPA (y), you might collect data on two x variables: SAT score and age. So we would be trying to determine if there was a linear correlation between someone’s SAT score and their GPA, as well as their age and their GPA. (Note: students may not choose GPA as...
Collect data on one response (dependent or y) variable and two different explanatory (independent or x)...
Collect data on one response (dependent or y) variable and two different explanatory (independent or x) variables. This will require a survey with three questions. For example: To predict a student’s GPA (y), you might collect data on two x variables: SAT score and age. So we would be trying to determine if there was a linear correlation between someone’s SAT score and their GPA, as well as their age and their GPA. (Note: students may not choose GPA as...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT