Concept explainers
Using Weighted Average Delay A mail-order firm processes 5,450 checks per month. Of these, 70 percent are for $55 and 30 percent are for $80. The $55 checks are delayed two days on average; the $80 checks arc delayed three days on average.
- a. What is the average daily collection float? How do you interpret your answer?
- b. What is the weighted average delay? Use the result to calculate the average daily float
- c. How much should the firm be willing to pay to eliminate the float?
- d. If the interest rate is 7 percent per year, calculate the daily cost of the float.
- e. How much should the firm be willing to pay to reduce the weighted average float by 1.5 days?
a.
To compute: The average daily collections float.
Purchasing Power:
Purchasing power can be referred to the amount of goods and services that can be purchased by one unit of money. It decreases with increase in inflation or decreases with the decrease in inflation.
Float:
Float is defined as the difference between the balance shown in ledger of the company and the balance that is available at the bank. Available balance refers to the balance that is shown by the banks of that particular company.
Explanation of Solution
Solution:
Formula to calculate average collection,
Substitute $419,650 for value of check of $55, $610,400 for value of $80 check and 30 for number of days in a month.
The average collection is $34,335.
Working notes:
Given,
Total checks per month are 5,450.
Percentage is 70%.
Delay days are 2 days.
Computation of number of $55 check,
Total number of $55 checks is 3,815.
Computation of value of check,
Value of check of $55 is $419,650.
Given,
Total checks per month are 5,450.
Percentage is 30%.
Delay days are 2 days.
Computation of number of $80 check,
Total number of $80 checks is 1,635.
Computation of value of check,
Value of $80 check is $610,400.
Hence, the average collection is $34,335.
b.
To compute: The weighted average delay and the average daily float.
Explanation of Solution
Solution:
Formula to calculate weighted average delay,
Substitute $419,650 for value of 70% of checks, $340,625 for total collection, $610,400 for value of 30% check.
Weighted average delay is 3.024.
Formula to calculate average daily float,
Substitute $340,625 for average daily receipt and 3.024 for weighted average delay,
Average daily float is $34,335.
Working note:
Total number of $55 checks is 3,815
Checks are $55.
Total number of $80 checks is 1,635.
Checks are $80.
Computation of total collection,
Hence, the total collection is $340,625.
Hence, the weighted average delay is 3.024 and average daily float is $34,335.
c.
To identify: The firm willingness to pay to eliminate the company’s float.
Answer to Problem 6QP
Solution:
- Interest rate should be paid by the company to eliminate the float.
- Present value of the payment of future interest is to be computed.
Explanation of Solution
- Company’s willingness is to pay the present value on the interest income on the payment that is to be received today.
The firm should pay the interest rate on the present value.
d.
To compute: The Company’s daily float.
Explanation of Solution
Solution:
Given,
Annual interest rate is 7%.
Formula to calculate rate,
Substitute 7% for annual interest rate,
Rate is 0.01854% per day.
Average daily float is $34,335.
Formula to calculate cost of float,
Substitute $34,334.998 for average daily float and 0.01854% for rate per day.
Cost of float is $6.3657.
Hence, the daily cost of float is $6.3657.
e
To compute: The amount the company is willing to pay to reduce the weighted average float.
Explanation of Solution
Solution:
Given,
Company wants to reduce to 1.5 days.
Formula to calculate Net average daily float,
Substitute 1.5 as reduced days and $340,625 for total collection.
Net average daily float is $17,031.2501.
Hence, the amount the company is willing to pay to reduce the weighted average float is $17,031.2501.
Want to see more full solutions like this?
Chapter 27 Solutions
CORPORATE FINANCE(LL)
- Cash & Credit Supermarket Inc. currently asks its credit customers to pay by the end of the month after the month of delivery. In practice, customers take rather longer to pay – on average 70 days. Sales revenue amounts to ₱ 8 million a year and bad debts to ₱ 20,000 a year. The company planned to offer customers a cash discount of 2% for payment within 30 days. Cash & Credit Supermarket estimates that 50% of customers will accept this facility but that the remaining customers, who tend to be slow payers, will not pay until 80 days after the sale. At present the business has an overdraft facility at an interest rate of 12% a year. If the plan goes ahead, bad debts will be reduced to ₱ 10,000 a year and there will be savings in credit administration expenses of ₱ 6,000 a year. (Use 360 days) How much is the net cost/benefit of the proposed policy?Required to answer. Single choice. (Ignore income taxes in this problem.) The Jason Company is considering the purchase of a machine…arrow_forwardLo’s Clothiers has forecast credit sales for the fourth quarter of the year. September $70,00 Forth Quarter October $60,000 November 55,000 December 80,000 Experience has shown that 30 percent of sales are collected in the month of sale, 60 percent are collected in the following month, and 10 percent are never collected. Prepare a schedule of cash receipts for J.Lo’s Clothiers covering the fourth quarter (October through December)arrow_forwardThe Professional Service Company expects 80% of sales for cash and 20% on credit. The company collects 70% of its credit sales in the month following sale, 25% in the second month following sale, and 5% are not collected (that is, they are "bad debts"). Expected sales for June, July, and August are $64,000, $70,000, and $60,000, respectively. What are the company's expected total cash receipts in August? Multiple Choice $61,000. $77,000. $121,200. $65,000. $13,000.arrow_forward
- Stan Inc. currently asks its credit customers to pay by the end of the month after the month of delivery. In practice, customers take rather longer to pay - on average 70 days. Sales revenue amounts to P 8 million a year and bad debts to P 20,000 a year. The company planned to offer customers a cash discount of 2% for payment within 30 days. Stan estimates that 50% of customers will accept this facility but that the remaining customers, who tend to be slow payers, will not pay until 80 days after the sale. At present the business has an overdraft facility at an interest rate of 12% a year. If the plan goes ahead, bad debts will be reduced to P 10,000 a year and there will be savings in credit administration expenses of P 6,000 a year. (Use 360 days) How much is the net cost/benefit of the proposed policy? A.P 24,000B.(P 24,000)C.(P11,370)D.P2,630arrow_forwardAssume that your credit sales for March was $16,288,for April was $33,301 and May was $29,261. If credit sales are collected 55% during the month of sale, 25% the month following the sale, and 15% in the second month following the sale, what is the total expected cash collections to be received in May? Round your answer to one dollar.arrow_forwardA company's past experience indicates that 60% of its credit sales are collected in the month of sale, 30% in the next month, and 5% in the second month after the sale; the remainder is never collected. Budgeted credit sales were: January $450000 February 286000 March 630000 The cash inflow in the month of March is expected to be $378000. $403300. $486300. $463800.arrow_forward
- A proposed relaxation of credit standards of Bulldogs Inc. will increase the balance of accounts receivable by P95,000. The proposed relaxation will also increase the average collection period from 16 days to 3 weeks. How much is the increase in budgeted credit sales of Bulldogs Inc. if the firm increase the average collection period to 3 weeks? Use 360 days. 3,025,00 6,300,000 6,840,000 1,750,000arrow_forwardKamal Co. has an average collection period (ACP) of 30 days and an operating cycle of 170 days. It has a policy of keeping at least RO 15,000 on hand as a minimum cash balance, and has a beginning cash balance for the first quarter of RO 20,000. Beginning receivables for the first quarter amount to RO 30,000 Sales for the first second and the third quarters are expected respectively to be RO 100,000; RO120,000; and RO 150,000. The purchases amount represents 50% of the next quarter's forecasted sales. The quarterly wages and other expenses is RO 7,000. The capital spending occurs in the second quarter and equals to RO 15,000. The accounts payable period is 45 days. The beginning accounts payable is RO 10,000. A. What are cash collections in the first and second quarters? B. What are cash disbursements for the first and second quarters ? C. What is the cumulative surplus (deficit) at the end of the first and second quarters ?arrow_forwardFrom past experience, the company has learned that 20% of a month’s sales are collected in the month of sale, another 75% are collected in the month following sale, and the remaining 5% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $270,000, and March sales totaled $300,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th?arrow_forward
- Bruno Industries expects credit sales for January, February, and March to be $200,000, $260,000, and $300,000, respectively. It is expected that 55% of the sales will be collected in the month of sale, 35% will be collected in the following month, and 10% will be collected in the second month after the sales. How much will the closing balance of Accounts Receivable at the end of March be? 3. In the beginning of the period, XYZ Ltd. expects to sell 15,000 units for $10 each. Its standard cost card shows the total cost of production per unit is $8. At the end of the period, the company reported actual sales revenue at $120,000 for 16,000 units sold. What was the sale price variance?arrow_forwardToshiba Company is considering offering a cash discount to speed up the collection of account receivable, currently the firm has an average collection period of 56 days, annual sales are 50,000 units, and the sales unit price is $40 with per unit variable cost is $30. A 2% discount estimates that 80% of its customers will take, if sales are expected to rise by 12%, and the average collection period increased to 60 days. The additional profit contribution from sales isarrow_forwardGrahm Potato company has a projected sales of $13,200 in September, $16,000 in October, $23,200 in November, and $19,200 in December. Of the company's sales, 25 percent are paod for by cash and 75 percent are sold on credit. Expereice shows that 40 percent of accounts recievable are paid in the month after the sale, while the remaining 60 percent are paod two months after. Determine collections for November and December.arrow_forward
- EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENTIntermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning