Concept explainers
Lockboxes and Collections [LO2] It takes Cookie Cutter Modular Homes, Inc., about six days to receive and deposit checks from customers. Cookie Cutter’s management is considering a lockbox system to reduce the firm’s collection times. It is expected that the lockbox system will reduce receipt and deposit times to three days total. Average daily collections are $145,000, and the required
a. What is the reduction in outstanding cash balances as a result of implementing the lockbox system?
b. What is the dollar return that could be earned on these savings?
c. What is the maximum monthly charge Cookie Cutter should pay for this lockbox system if the payment is due at the end of the month? What if the payment is due at the beginning of the month?
a)
To compute: The decrease in the outstanding balances of cash due to the implementation of lockboxes.
Introduction:
A lockbox is a distinct post office box that the companies use to speed up the collection of accounts receivable. The purpose of the lockbox is to reduce the collection time of accounts receivable.
Answer to Problem 8QP
The reduction in the cash balance is $435,000.
Explanation of Solution
Given information:
The time taken to receive and deposit the checks from the customer by Company C is 6 days. In order to reduce its collection time, the management is planning for a lockbox system, which will reduce the collection time to 3 days. The average daily collections are $145,000 and the required rate of return is 5% per year.
Explanation:
Formula to compute the reduction in the cash balance:
Compute the reduction in the cash balance:
Hence, the reduction in the cash balance is $435,000.
b)
To compute: The return on dollar on the savings.
Introduction:
A lockbox is a distinct post office box that the companies use to speed up the collection of accounts receivable. The purpose of the lockbox is to reduce the collection time of accounts receivable.
Answer to Problem 8QP
The daily return on dollar on the savings is $58.15.
Explanation of Solution
Formula to compute the average daily rate:
Compute the average daily rate:
Hence, the average daily rate is 0.000134% per day.
Formula to compute the daily return on dollar:
Compute the daily return on dollar:
Hence, the daily return on dollar is $58.15.
c)
To compute: The maximum charge that Company C must pay for the lockbox system monthly and the maximum charge if it is due at the starting of the month.
Introduction:
A lockbox is a distinct post office box that the companies use to speed up the collection of accounts receivable. The purpose of the lockbox is to reduce the collection time of accounts receivable.
Answer to Problem 8QP
The monthly charge, if the payment happens at the end of the month is $1,722.24 and the monthly charge, if the payment happens at the beginning of the month is $1,765.05.
Explanation of Solution
If the company adopts the lockbox, it will obtain three payments early. Hence, the savings are the reduction in the cash balance of $435,000.
Formula to compute the monthly rate of interest:
Compute the monthly rate of interest, if the payment happens at the end of the year:
Hence, the monthly rate of interest is 0.4074%.
Equation of PV (Present Value) for perpetuity to compute the monthly charge, if the payment happens at the end of the month:
Compute the monthly charge, if the payment happens at the end of the month:
Hence, the monthly charge, if the payment happens at the end of the month is $1,722.24.
Equation of PV (Present Value) for perpetuity to compute the monthly charge, if the payment happens at the starting of the month:
Compute the monthly charge, if the payment happens at the starting of the month:
Hence, the monthly charge, if the payment happens at the beginning of the month is $1,765.05.
Want to see more full solutions like this?
Chapter 19 Solutions
Fundamentals of Corporate Finance
- Bird's Eye Treehouses, Incorporated, a Kentucky company, has determined that a majority of its customers are located in the Pennsylvania area. It therefore is considering using a lockbox system offered by a bank located in Pittsburgh. The bank has estimated that use of the system will reduce collection time by 1.5 days. Assume 365 days a year. Average number of payments per day Average value of payment Variable lockbox fee (per transaction) Annual interest rate on money market securities 850 $ 800 $.10 a. NPV b. NPV 3.2% a. What is the NPV of the new lockbox system? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. Suppose in addition to the variable charge that there is an annual fixed charge of $3,000 to be paid at the end of each year. What is the NPV now? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)arrow_forwardBird's Eye Treehouses, Incorporated, a Kentucky company, has determined that a majority of its customers are located in the Pennsylvania area. It therefore is considering using a lockbox system offered by a bank located in Pittsburgh. The bank has estimated that use of the system will reduce collection time by 1.5 days. Assume 365 days a year. Average number of payments per day Average value of payment Variable lockbox fee (per transaction) Annual interest rate on money market securities 880 $830 $.10 3.2% a. What is the NPV of the new lockbox system? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. Suppose in addition to the variable charge that there is an annual fixed charge of $3,000 to be paid at the end of each year. What is the NPV now? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Answer is complete but not entirely…arrow_forwardYour firm has an average receipt size of $65. A bank has approached you concerning a lockbox service that will decrease your total collection time by 2 days. You typically receive 8,700 checks per day. The daily interest rate is 0.016 percent. If the bank charges a fee of $190 per day, what is the NPV of the lockbox project? NPV What would the net annual savings be if the service were adopted? Net annual savingsarrow_forward
- Sherman’s Sherbet currently takes about 6 days to collect and deposit checks from customers. A lock-box system could reduce this time to 3 days. Collections average $15,000 daily. The interest rate is 0.02% per day. a. By how much will the lock-box system reduce float? b. What is the daily interest savings of the system? c. Suppose the lock-box service is offered for a fixed monthly fee instead of payment per check. What is the maximum monthly fee that Sherman’s should be willing to pay for this service? (Assume a 30-day month.)arrow_forward4. ABC Co. has received proposals from several banks to establish a lockbox system to speed up receipts. The firm receives an average of 700 checks per day averaging P1, 800 each and its cost of short term funds is 7% per year. If all proposals will produce equivalent processing results, which bank proposed charges is best 2 be adopted? A. A fee of .03% of the amount collected B. P.50 fee per check C. a compensating balance of P1, 750, 000 D. a flat fee of P125, 000 a yeararrow_forwardBird's Eye Treehouses, Incorporated, a Kentucky company, has determined that a majority of its customers are located in the Pennsylvania area. Therefore, it is considering using a lockbox system offered by a bank located in Pittsburgh. The bank has estimated that use of the system will reduce collection time by 1.5 days. Average number of payments per day Average value of payment Variable lockbox fee (per transaction) Effective annual rate on money market securities 825 $745 $.15 a. NPV b. NPV 5.5% The total collection time will be reduced by three days if the lockbox system is adopted. a. What is the NPV of the new lockbox system? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. Suppose in addition to the variable charge, there is an annual fixed charge of $5,000 to be paid at the end of each year. What is the NPV now? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer…arrow_forward
- 2. Your firm processes 50,000 checks each year with an average face value of $50 per check. Collecting on these checks takes 2 days of mail float, 3 days of processing float, and 1 day of availability float. At an opportunity cost rate of 4%, what is the opportunity cost of collection float? What would the opportunity cost of collection float be in you achieved check collection efficiencies that lowered mail float to 1 day, processing float to 2 days, and availability float to 0 days?arrow_forward7. You borrow $100,000 for the purchase of an automation system in your company. The payments at 6% is $7,265 per year for 30 years. You decide that you can afford to pay $9,000 every year instead of $7,265. How long will it take to pay off this loan? Do not use excel, please work the problem out, and include cashflow diagram if possible.arrow_forwardProposal #1 would extend trade credit to some customers that previously have been denied credit because they were considered poor risks. Sales are projected to increase by $200,000 per year if credit is extended to these new customers. Of the new accounts receivable generated, 7% are projected to be uncollectible. Additional collection costs are projected to be 3% of incremental sales (whether they actually end up collected or not), and production and selling costs are projected to be 80% of sales. Your firm expects to pay a total of 40% of its income after expenses in taxes. 1.Compute the incremental income after taxes that would result from these projections: 2.Compute the incremental Return on Sales if these new credit customers are accepted: If the receivable turnover ratio is expected to be 4 to 1 and no other asset buildup is needed to serve the new customers… 3.Compute the additional investment in Accounts Receivable 4.Compute the incremental Return on New Investment…arrow_forward
- If Merilee Industries installs a lockbox system it should reduce its average collection time by 2.2 days at a cost of $.75 per check. On an average day, 594 checks with an average value of $4,618 each are received. The daily interest rate on Treasury bills is .009 percent. What is the net present value of this lockbox arrangement?arrow_forwardProposal #2 would establish local collection centers throughout the region to decrease the time it takes to convert credit payments that are mailed in by check to cash. It is estimated that establishing these collection centers would reduce the average collection time by 2 days. 1.If the company currently averages $50,000 in collections per day, how many dollars will this suggested cash management system free up? 2.If all freed up dollars would be used to pay down debt that has an interest rate of 8%, how much money could be saved each year in interest expense? 3 Do the numbers suggest that this new system should be implemented if its total annual cost is $7000? Explain.arrow_forwardYour firm has an average receipt size of $60. A bank has approached you concerning a lockbox service that will decrease your total collection time by 2 days. You typically receive 8,500 checks per day. The daily interest rate is 0.02 percent. If the bank charges a fee of $190 per day, what is the NPV of the lockbox project? What would the net annual savings be if the service were adopted?arrow_forward