I just need part E the rest has been answered
Mississippi Delta, Inc. has been selling switching equipment to computer companies on net-30 terms, in which payment is expected by 30 days from the invoice date. Concerned about deteriorating collection patterns, the credit manager has divided customers into two groups for examination purposes: Prompt payors and laggards. Prompt payors (80 percent of Mississippi Deltaâs customers) pay, on average, in 35 days, versus a 72-day average for the laggards. The manager wonders if the credit terms should be modified to include a 2 percent cash discount on invoices paid within 10 days. The average invoice is the same for both groups, roughly $4,000. The manager expects 50% of the prompt payors to pay in exactly 10 days and the average on the other half to slip to 40 days. He thinks that 20% of the laggards will pay in 10 days and the average on the others will slip to 80 days. Given these forecasts, he is not sure that the lost revenue from discount takes (who would then pay only 98% of the invoiced dollar amount) justifies the improved collection. The companyâs annual cost of capital is 11%. A.) Using NPV calculations, show the PV of the present collection experience. B.) Calculate the NPV of the proposed 2/10, net-30 terms. C.) Based on your NPV analysis, should Mississipi Delta Inc. adopt the cash discount? D.) What other factors should be taken into account before Mississippi Delta Inc. makes a switch, assuming such is justifiable on an NPV basis? E.) Sensivity analysis involves varying the key assumptions, one at a time, and observing the effect on the key decision criterion-such as profits or NPV. In the NPV analysis above, how could could one carry out sensitivity analysis? (If you have a financial spreadsheet available, conduct a sensitivity analysis that varies the number of prompt payors who will pay in exactly 10 days and report your findings.) *** Answer in an Excel document and give explanation as to how and why you got to your answer View comments (1) Expert Answer snarulatutor snarulatutor answered this 48 minutes later Was this answer helpful? 1 0 1,896 answers Since, there are multiple questions, the first four have been answered. ___________ Part A) To calculate the NPV, we need to determine the values of cash flows. Cash Flow on the 35th Day = Invoice Value*Customer Percentage Making the Payment on 35th Day = 4,000*80% = 3,200 Cash Flow on the 72th Day = Invoice Value*Customer Percentage Making the Payment on 72th Day = 4,000*20% = 800 The net present value of these 2 cash flows can be calculated as follows: Net Present Value = 3,200/(1+11%/365)^35 + 800/(1+11%/365)^72 = $3,949.26 ___________ Part B) To calculate the NPV, we need to determine the values of cash flows. Cash Flow on 10th Day = Invoice Value*Customer Percentage Taking Discount*(1-Discount Percentage) = 4,000*80%*50%*(1-2%) + 4,000*20%*20%*(1-2%) = $1,724.80 Cash Flow on 40th Day = Invoice Value*Customer Percentage Making Payment on 40th Day = 4,000*40% = $1,600 Cash Flow on 70th Day = Invoice Value*Customer Percentage Making Payment on 40th Day = 4,000*20%*80% = $640 The net present value of these 3 cash flows can be calculated as follows: Net Present Value = 1,724.80/(1+11%/365)^10 + 1,600/(1+11%/365)^40 + 640/(1+11%/365)^70 = $3,927.08 ___________ Part C) The net present value of cash flows with discount ($3,927.08) is less than the net present value of cash flows without discount ($3,949.26). Therefore, the company should not adopt the cash discount. ___________ Part D) Some of the other factors that should be taken into consideration include the possibility of default risk (as the credit period in case of laggards has increased to 80 resulting in higher probability of default). Another factor to be considered is the payment terms available from the suppliers. The company can adopt a cash discount policy, if it is also getting a discount on early payments to its suppliers. Credit policies used within the industry or by other companies of the same nature and size can be used as reference points while devising a credit policy.
I just need part E) and it explained
I just need part E the rest has been answered
Mississippi Delta, Inc. has been selling switching equipment to computer companies on net-30 terms, in which payment is expected by 30 days from the invoice date. Concerned about deteriorating collection patterns, the credit manager has divided customers into two groups for examination purposes: Prompt payors and laggards. Prompt payors (80 percent of Mississippi Deltaâs customers) pay, on average, in 35 days, versus a 72-day average for the laggards. The manager wonders if the credit terms should be modified to include a 2 percent cash discount on invoices paid within 10 days. The average invoice is the same for both groups, roughly $4,000. The manager expects 50% of the prompt payors to pay in exactly 10 days and the average on the other half to slip to 40 days. He thinks that 20% of the laggards will pay in 10 days and the average on the others will slip to 80 days. Given these forecasts, he is not sure that the lost revenue from discount takes (who would then pay only 98% of the invoiced dollar amount) justifies the improved collection. The companyâs annual cost of capital is 11%. A.) Using NPV calculations, show the PV of the present collection experience. B.) Calculate the NPV of the proposed 2/10, net-30 terms. C.) Based on your NPV analysis, should Mississipi Delta Inc. adopt the cash discount? D.) What other factors should be taken into account before Mississippi Delta Inc. makes a switch, assuming such is justifiable on an NPV basis? E.) Sensivity analysis involves varying the key assumptions, one at a time, and observing the effect on the key decision criterion-such as profits or NPV. In the NPV analysis above, how could could one carry out sensitivity analysis? (If you have a financial spreadsheet available, conduct a sensitivity analysis that varies the number of prompt payors who will pay in exactly 10 days and report your findings.) *** Answer in an Excel document and give explanation as to how and why you got to your answer View comments (1) Expert Answer snarulatutor snarulatutor answered this 48 minutes later Was this answer helpful? 1 0 1,896 answers Since, there are multiple questions, the first four have been answered. ___________ Part A) To calculate the NPV, we need to determine the values of cash flows. Cash Flow on the 35th Day = Invoice Value*Customer Percentage Making the Payment on 35th Day = 4,000*80% = 3,200 Cash Flow on the 72th Day = Invoice Value*Customer Percentage Making the Payment on 72th Day = 4,000*20% = 800 The net present value of these 2 cash flows can be calculated as follows: Net Present Value = 3,200/(1+11%/365)^35 + 800/(1+11%/365)^72 = $3,949.26 ___________ Part B) To calculate the NPV, we need to determine the values of cash flows. Cash Flow on 10th Day = Invoice Value*Customer Percentage Taking Discount*(1-Discount Percentage) = 4,000*80%*50%*(1-2%) + 4,000*20%*20%*(1-2%) = $1,724.80 Cash Flow on 40th Day = Invoice Value*Customer Percentage Making Payment on 40th Day = 4,000*40% = $1,600 Cash Flow on 70th Day = Invoice Value*Customer Percentage Making Payment on 40th Day = 4,000*20%*80% = $640 The net present value of these 3 cash flows can be calculated as follows: Net Present Value = 1,724.80/(1+11%/365)^10 + 1,600/(1+11%/365)^40 + 640/(1+11%/365)^70 = $3,927.08 ___________ Part C) The net present value of cash flows with discount ($3,927.08) is less than the net present value of cash flows without discount ($3,949.26). Therefore, the company should not adopt the cash discount. ___________ Part D) Some of the other factors that should be taken into consideration include the possibility of default risk (as the credit period in case of laggards has increased to 80 resulting in higher probability of default). Another factor to be considered is the payment terms available from the suppliers. The company can adopt a cash discount policy, if it is also getting a discount on early payments to its suppliers. Credit policies used within the industry or by other companies of the same nature and size can be used as reference points while devising a credit policy.
I just need part E) and it explained
