Question

In: Accounting

(Accelerating collections) A company with a 12% cost of capital receives cash inflows from customers throughout...

(Accelerating collections) A company with a 12% cost of capital receives cash inflows from customers throughout the United States and Canada. Checks take 5 days on average to arrive, but a large commercial bank has proposed to implement a lock box concentration banking system for a $250,000 annual fee which would cut the time a check is in receivables float to an average of 11/2 days. The company’s marginal tax rate is 35%. What is the value of the proposed system to the company, and should it be implemented, if the company’s daily cash inflows average:

a. $150,000?

b. $300,000?

c. $450,000?

d. $600,000?

Solutions

Expert Solution

A.150000-Cash inlows
Receivable Receivables
Existing Receivables           750,000.00 (((5/365)*150000)*365)
Reduction in receivables           225,000.00 ((1.5/365)*150000)*365
Difference-Cash Collected Early           525,000.00
Interest in reduced receivables              63,000.00 (525000*12%)
Less:Annual Fee net of tax           187,500.00 (250000 X (1-25%)
Net Benefit          (124,500.00) (63000-187500)
B.300000
Receivable Receivables
Existing Receivables        1,500,000.00 ((5/365)*300000)*365
Reduction in receivables           450,000.00 ((1.5/365)*300000)*365
Difference-Cash Collected Early        1,050,000.00
Interest in reduced receivables           126,000.00 (1050000*12%)
Less:Annual Fee net of tax           187,500.00
Net Benefit            (61,500.00) (126000-187500)
C.450000
Receivables
Existing Receivables        2,250,000.00 ((5/365)*450000)*365
Reduction in receivables           675,000.00 ((1.5/365)*450000)*365
Difference-Cash Collected Early        1,575,000.00
Interest in reduced receivables           189,000.00 (1575000*12%)
Less:Annual Fee net of tax           187,500.00
Net Benefit                1,500.00 (189000-187500)
C.600000
Receivables
Existing Receivables        3,000,000.00 ((5/365)*600000)*365
Reduction in receivables           900,000.00 ((1.5/365)*600000)*365
Difference-Cash Collected Early        2,100,000.00
Interest in reduced receivables           252,000.00 (2100000*12%)
Less:Annual Fee net of tax           187,500.00
Net Benefit              64,500.00 (252000-187500)
Lock box concentration banking systemshould be implemented if daily cash sales average is $600000

Related Solutions

A television cable company receives numerous phone calls throughout the day from customers reporting service troubles...
A television cable company receives numerous phone calls throughout the day from customers reporting service troubles and from would-be subscribers to the cable network. Most of these callers are put “on hold” until a company operator is free to help them. The company has determined that the length of time a caller is on hold is normally distributed with a mean of 3.1 minutes and a standard deviation 0.9 minutes. Company experts have decided that if as many as 5%...
The statement of cash flows provides aggregate data regarding all cash inflows a firm receives from...
The statement of cash flows provides aggregate data regarding all cash inflows a firm receives from its ongoing operations and external investment sources, as well as all cash outflows that pay for company’s capital budgets and investments during a given accounting period. True False
A company estimates the following net cash inflows and outflows for a capital investment project that...
A company estimates the following net cash inflows and outflows for a capital investment project that is currently under consideration. year Cash flow 0 (575,000) 1 45,800 2 99,000 3 104,300 4 118,700 5 130,400 6 129,000 7 116,500 8 77,200 9 55,000 10 12,500 Calculate the ARR and NPV of the project.
Kay Company receives a cash payment of $4,000 on November 12 for services it will perform...
Kay Company receives a cash payment of $4,000 on November 12 for services it will perform in December. Assume that December 31 is Kay Company’s fiscal year end. What adjusting journal entry should Kay record at December 31 related to the payment received in November? Question 3 options: Debit Service Revenue for $4,000, Credit Unearned Service Revenue for $4,000. Debit Service Revenue for $4,000, Credit Cash for $4,000. Debit Cash for $4,000, Credit Service Revenue for $4,000. Debit Unearned Service...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 30% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $121,000 November 151,000 December 221,000...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 30% pay their accounts in the month of sale, while the remaining 70% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $58,000 November 65,000 December 72,000...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 20% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $115,000 November 144,000 December 210,000...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $118,000 November 148,000 December 216,000...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $124,000 November 155,000 December 227,000...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 30% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $108,000 November 135,000 December 198,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT