2) A firm is evaluating the following sales opportunity for a new customer: . . S($175,000) - Projected invoice amount VCR (65% of Sales) - Variable production costs EXP (1% of Sales for each CP after the first one) - Credit and collection costs . 1(10%)(0.70/365) - Annual; daily interest rate Credit Period (Net 45 days) 1. Calculate the NPV for the potential sale assuming the new customer pays on time. Should the firm extend trade credit for this sale? 113,750 = 57,390.05 NPV = S-EXP(S) - VCR(S) 1 + {CP (175,000 -1750) I.10/545)(45) 2. Given the uncertainly of payment timing, assume the new customer is expected to mirror the firm's historical collection experience (shown below) COLLECTIEDOT PAYMENT POLITY 4 38 1 130 100 After 90 days, the invoice is turned over to a collection agency that collects, on average. 50% of the invoice one month after the referral and charges a 30% commission on the invoice amount (not the amount collected). Re-calculate the NPV and determine if trade credit should still be offered Collection PV of Payment Collection Cath How at Collection at Probaby Corts EXPL DSO Collection Period VOR Expected NPV Probabile NPY Lapeyrobi 1 38 SOX 2 53 30% 3 81 120 5 4 Expected NPV of Credit Extension 100% Re-calculate the NPV using a probability distribution that reflects more uncertainty and risk and determine if trade credit should still be offered. Use 10%, 30%, 25%, and 35% respectively, for the four CPs. Should trade credit still be offered? Collection PV of Payment Collection Cash Flow at Collection at Probably costs (20 050 Collection Period OSO Expected NN Probable NPV lace 1 10N 2 30% 81 120 4 Expected NPV of Credit Etension 100% 2) A firm is evaluating the following sales opportunity for a new customer: S($175,000) = Projected invoice amount VCR (65% of Sales) - Variable production costs EXP (1% of Sales for each CP after the first one) - Credit and collection costs . (10%): 0.10/365) - Annual; daily interest rate Credit Period (Net 45 days) 1. Calculate the NPV for the potential sale assuming the new customer pays on time. Should the firm extend trade credit for this sale? NPV = S- EXP(S) - VCR(S) 1+ ICP 2. Given the uncertainly of payment timing, assume the new customer is expected to mirror the firm's historical collection experience (shown below). COLLECTION PRO PAYMENT POLITY After 90 days, the invoice is tumed over to a collection agency that collects, on average, 50% of the invoice one month after the referral and charges a 30% commission on the invoice amount (not the amount collected). Re-calculate the NPV and determine if trade credit should still be offered. 2) A firm is evaluating the following sales opportunity for a new customer: . . S($175,000) - Projected invoice amount VCR (65% of Sales) - Variable production costs EXP (1% of Sales for each CP after the first one) - Credit and collection costs . 1(10%)(0.70/365) - Annual; daily interest rate Credit Period (Net 45 days) 1. Calculate the NPV for the potential sale assuming the new customer pays on time. Should the firm extend trade credit for this sale? 113,750 = 57,390.05 NPV = S-EXP(S) - VCR(S) 1 + {CP (175,000 -1750) I.10/545)(45) 2. Given the uncertainly of payment timing, assume the new customer is expected to mirror the firm's historical collection experience (shown below) COLLECTIEDOT PAYMENT POLITY 4 38 1 130 100 After 90 days, the invoice is turned over to a collection agency that collects, on average. 50% of the invoice one month after the referral and charges a 30% commission on the invoice amount (not the amount collected). Re-calculate the NPV and determine if trade credit should still be offered Collection PV of Payment Collection Cath How at Collection at Probaby Corts EXPL DSO Collection Period VOR Expected NPV Probabile NPY Lapeyrobi 1 38 SOX 2 53 30% 3 81 120 5 4 Expected NPV of Credit Extension 100% Re-calculate the NPV using a probability distribution that reflects more uncertainty and risk and determine if trade credit should still be offered. Use 10%, 30%, 25%, and 35% respectively, for the four CPs. Should trade credit still be offered? Collection PV of Payment Collection Cash Flow at Collection at Probably costs (20 050 Collection Period OSO Expected NN Probable NPV lace 1 10N 2 30% 81 120 4 Expected NPV of Credit Etension 100% 2) A firm is evaluating the following sales opportunity for a new customer: S($175,000) = Projected invoice amount VCR (65% of Sales) - Variable production costs EXP (1% of Sales for each CP after the first one) - Credit and collection costs . (10%): 0.10/365) - Annual; daily interest rate Credit Period (Net 45 days) 1. Calculate the NPV for the potential sale assuming the new customer pays on time. Should the firm extend trade credit for this sale? NPV = S- EXP(S) - VCR(S) 1+ ICP 2. Given the uncertainly of payment timing, assume the new customer is expected to mirror the firm's historical collection experience (shown below). COLLECTION PRO PAYMENT POLITY After 90 days, the invoice is tumed over to a collection agency that collects, on average, 50% of the invoice one month after the referral and charges a 30% commission on the invoice amount (not the amount collected). Re-calculate the NPV and determine if trade credit should still be offered
