these go together please help!!
U.S. BANKING INFORMATION Monthly average ledger balance at U.S. Bank Monthly average deposit float Monthly Service Charge_US Bank Earnings Credit Rate_US Bank Required Reserves Ratio 30/365 Wire Transfer Cost ACH cost $3,500,000.00 $750,000.00 $1,000.00 0.007 0.03 0.0822 $15 50 50 9000 $25,000.00 2 2 2 INFO ON COLLECTIONS FROM CUSTOMERS Number of remittances per month Average face value of monthly remittances Mallfloat - in house processing Processing float - in house processing Availability float - in house processing Days float Per check Variable cost of in-house Processing Fixed Cost of in-house check processing Days float with lockbox alternative Per check variable cost of lockbox alternative Fixed Cost of lockbox alternative INFO ON DISBURSEMENTS TO 6 0.4 $2,500.00 4 0.8 $3,000.00 $3,000.00 3500 Fixed Cost of lockbox alternative INFO ON DISBURSEMENTS TO SUPPLIERS Disbursements per year Check cost_per check ACH costs_per check upfront cost to switch fully to ACH system DAILY NET CASH FLOWS (10 days into November) Day $1.50 $0.50 $25,000 Net Cash Flow 18000 1 2 20000 3 23000 4 25000 5 26000 6 35000 32000 7 8 25000 9 26000 27000 10 MONTHLY SALES FORECASTS INFORMATION October sales % of sales collected in month of sale % of sales collected in following month % of sales in Cost of goods sold Monthly lease payment $500,000.00 0.7 0.3 0.75 $125,000.00 $ 350,000.00 MISCELLANEOUS INFO Company's Discount Rate 12% numi QUESTION 15 What is the NPV to Wilson's if it switches to a fully ACH disbursement system? (Assume that discount rate is 12%.] O a. $24,522 b. $36,917 Oc$57,850 O d. $4,167 4 QUESTION 16 a. What is NPV if the firm had as many as 5000 disbursements to process with the ACH disbursement system? [Assume that discount rate is 12%.] O a. $16,667 O b. $57,635 OC -$21,290 O d. -$70,650 U.S. BANKING INFORMATION Monthly average ledger balance at U.S. Bank Monthly average deposit float Monthly Service Charge_US Bank Earnings Credit Rate_US Bank Required Reserves Ratio 30/365 Wire Transfer Cost ACH cost $3,500,000.00 $750,000.00 $1,000.00 0.007 0.03 0.0822 $15 50 50 9000 $25,000.00 2 2 2 INFO ON COLLECTIONS FROM CUSTOMERS Number of remittances per month Average face value of monthly remittances Mallfloat - in house processing Processing float - in house processing Availability float - in house processing Days float Per check Variable cost of in-house Processing Fixed Cost of in-house check processing Days float with lockbox alternative Per check variable cost of lockbox alternative Fixed Cost of lockbox alternative INFO ON DISBURSEMENTS TO 6 0.4 $2,500.00 4 0.8 $3,000.00 $3,000.00 3500 Fixed Cost of lockbox alternative INFO ON DISBURSEMENTS TO SUPPLIERS Disbursements per year Check cost_per check ACH costs_per check upfront cost to switch fully to ACH system DAILY NET CASH FLOWS (10 days into November) Day $1.50 $0.50 $25,000 Net Cash Flow 18000 1 2 20000 3 23000 4 25000 5 26000 6 35000 32000 7 8 25000 9 26000 27000 10 MONTHLY SALES FORECASTS INFORMATION October sales % of sales collected in month of sale % of sales collected in following month % of sales in Cost of goods sold Monthly lease payment $500,000.00 0.7 0.3 0.75 $125,000.00 $ 350,000.00 MISCELLANEOUS INFO Company's Discount Rate 12% numi QUESTION 15 What is the NPV to Wilson's if it switches to a fully ACH disbursement system? (Assume that discount rate is 12%.] O a. $24,522 b. $36,917 Oc$57,850 O d. $4,167 4 QUESTION 16 a. What is NPV if the firm had as many as 5000 disbursements to process with the ACH disbursement system? [Assume that discount rate is 12%.] O a. $16,667 O b. $57,635 OC -$21,290 O d. -$70,650
