Question

In: Finance

Read each question carefully, make sure to answer all questions are answered and show your work:...

Read each question carefully, make sure to answer all questions are answered and show your work:

5. 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)

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?).

6. Firm X is evaluating a proposal to extend credit to a group of new customers. The new customers will generate an average of $30,000 per day in new sales. On average, they will pay in 60 days. The variable cost ratio (i.e., COGS) is 98% of sales, collection expenses are 1% of sales, and the discount rate is 5%. Assume that the variable costs occur upfront, while the collection costs occur on the date in which the customer’s payment is received. What is the NPV of one day's sales if Firm J grants credit? Assume that there is no bad debt loss.

A. $57.88 B. $1,043.56 C. -$239.67 D. -$319.57

Solutions

Expert Solution

5.

a) Janice credit score according to the model is

Y=(0.20 x Employment) + (0.4 x Homeowner) + (0.3 x Cards)

Janice is employed part-time, so employment score is 1

Janice is a homeowner, so homeownership status is 1

and has six credit cards so Cards score is 0

Y=(0.20 x 1) + (0.4 x 1) + (0.3 x 0) = 0.60

Since the score is less than 0.7, Janice shall not receive the Credit

b) Janice just got a full-time job and closed two of her credit card accounts

Fulltime job and part time job score is same but closing her credit cards below 5 has an impact

Y=(0.20 x 1) + (0.4 x 1) + (0.3 x 1) = 0.90

Janice creditworthiness improves and eligible for Credit now

c) Homesownership status can be reviewed in terms of mortgage status

0 stands for not owning home

, 1 stands for owning home with debt

2 stands for owning debt free home

d) Other variables that could be included includes

- Age of the individual to determine the number of years of employment available ( Above 60 years should be "0", below 60 shall be "1")

- Percentage of credit limit utilised in the credit card ( More than 90% of credit limit utilised shall be "0" and less than that shall be "1")

6. NPV of one day's sales

Given information

Average Sales per day = $30,000

COGS ( 98% of Sales) = $29,400

Collection cost (1% of Sales) = $ 300

Discount Rate = 5%

Credit period = 60 days

Solution

The Sales shall be realised after 60 days and the collection cost shall also be incurred after 60 days.

Lets find out the Present value of Sales Collection and the Collection Cost

In order to find the present value

First step - Find out the periodic rate, that shall be applied to calculate the present value

Periodic rate =

no of months refers to credit period

credit period is 2 months

Thus periodic rate = ((1+0.05)2/12)-1 = (((1+0.05)^0.166)-1

=0.81%

Second Step - Find out the present value of Sales

Sales value per day - $30,000

Present value of Sales to be collected after 60 days = 30000/(1+0.0081)= $29759

Third Step - Find out the Collection cost

Collection cost = 1% of Sales = $300

Present value of Collection cost to be incurred after 60 days = 300/(1+0.0081)= $297.59

Fourth Step - NPV of one day's sales

NPV of One Day's Sales = Present Value of Sales - (COGS + Collection Cost)

= 29759 - ( 29400 + 297.59)

NPV of One Day's Sales = $ 61.41

The Closest match is $57.88, so we shall select OPTION A


Related Solutions

Please answer the following questions and show all work and make sure I can read your...
Please answer the following questions and show all work and make sure I can read your writing please. 1) Ethan went on a 10 day fishing trip. The number of small mouth bass caught and released by Ethan each day was as follows. Day 1 2 3 4 5 6 7 8 9 10 # of Fish 9 24 8 9 5 8 9 10 8 10 A. Find the mean, median, and mode B. Find the range, variance, and...
Show all of your work in each question. In parts (d), (e), and (g) make sure...
Show all of your work in each question. In parts (d), (e), and (g) make sure to set up your null and alternative hypotheses and write your conclusions. Also, please round your numbers to 2 decimal points. Write legibly and neatly. You can use p-value approach or critical-value approach in writing the conclusions of your hypotheses. A large firm employing tens of thousands of workers has been accused of discriminating against its female managers. The accusation is based on a...
Please read carefully. You must show all of your work for full credit. A correct answer...
Please read carefully. You must show all of your work for full credit. A correct answer with no work shown is worth no points, but an incorrect or partial answer with some work shown may be worth partial credit. Include explanations in each step. Correct format for writing answers (using symbols and letters). Question: What is the probability that fewer than 120 agreed? Answer: P (x < 120) I. An orange juice producer buys oranges from a large orange grove...
Please answer the questions in the space provided below each question. Show all of your work...
Please answer the questions in the space provided below each question. Show all of your work and circle your final answer. You forecast there are three potential scenarios for the economy: a bull, flat, and bear market. You also estimate the returns for a stock and bond mutual fund as follows: Economic Scenario Stock Fund Bond Fund Probability of Scenario Recession -18% 6% 0.3 Flat 8% 4% 0.45 Boom 20% -8% 0.25 Using this information, you find for the stock...
Applications of the Normal Distribution Read each question carefully and show your work (ie, what you...
Applications of the Normal Distribution Read each question carefully and show your work (ie, what you put into the calculator)!! 1. Cherry trees in a certain orchard have heights that are normally distributed with a mean of 110 inches and a standard deviation of 13 inches. What is the probability that a randomly selected tree is: a) More than 115 inches tall?           (round to 4 decimals) b) Less than 95 inches tall?            (round to 4 decimals) c) Between...
The Common Requirements Of All Questions Are The Same. Read Each Question Carefully And Submit ......
The Common Requirements Of All Questions Are The Same. Read Each Question Carefully And Submit ... Question: The common requirements of all questions are the same. Read each question carefully and submit a ... The common requirements of all questions are the same. Read each question carefully and submit a query to fulfill for each question. Also, students need to submit the result of the corresponding query under the query. The query result should be copied and pasted as it...
Please make sure to complete all parts of the question and to show all work used...
Please make sure to complete all parts of the question and to show all work used to compute the answer so I can see how the answer was found. A five-year annuity of 10 $5,230 semiannual payments will begin nine years from now, with the first payment coming nine and a half years from now. If the discount rate is 10 percent compounded monthly, what is the value of this annuity five years from now? What is the value three...
Please explain each step very carefully and make sure your handwriting is easy to read. Thank...
Please explain each step very carefully and make sure your handwriting is easy to read. Thank you Question: Suppose p(x) is a polynomial of degree n with coefficients in R and suppose p(x) has exactly n real roots. Show that p'(x) has exactly n-1 real roots.
Questions Nursing related questions answer 'em all read question carefully I'll rate thanks It is 11...
Questions Nursing related questions answer 'em all read question carefully I'll rate thanks It is 11 AM, and you have a patient seated for a restorative procedure. You notice that you have depleted the supply of clean handpieces while caring for the emergency patients seen earlier in the day. What do you do? A patient received her new dentures yesterday and has returned to the office with discomfort. The dentist tells the patient that the denture must be adjusted to...
C++ Please read the question carefully and make sure that the function prototypes given are used...
C++ Please read the question carefully and make sure that the function prototypes given are used correctly for both parts. This is one whole programming assignment so please make sure that it;s answered entirely not just one part. The output example is provided at the end of the question. First , write a program to create an array and fill it up with 20 randomly generated integers between 0 to 10 and output the array. Part 1: Write a function...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT