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

ekkarill92 answered 1 year ago
Next > < Previous

Related Solutions

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.
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...
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, 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 $127,000 November 159,000 December 232,000...
Schedule of Cash Collections of Accounts Receivable Office World Inc. has "cash and carry" customers and...
Schedule of Cash Collections of Accounts Receivable Office World Inc. has "cash and carry" customers and credit customers. Office World 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 of 2016 are as follows: August $114,000...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT