Question

In: Finance

Milberg Manufacturing sells on terms of 2/10, net 30. Total sales for the year are   ...

Milberg Manufacturing sells on terms of 2/10, net 30. Total sales for the year are    $3,500,000. Twenty five percent of customers pay on the 10th day and take discounts; the         other 75% pay, on average, 45 days after their purchases.

a.         What is the days sales outstanding?

b.         What is the average amount of receivables?

c.         What would happen to average receivables if Snider toughened its collection policy with the result that all nondiscount customers paid on the 35th day?

Solutions

Expert Solution

Answer a.

25% of customers pay on the 10th day and 75% of customers pay on the 45th days

Days Sales Outstanding = 25% * 10 + 75% * 45
Days Sales Outstanding = 36.25 days

Answer b.

Days Sales Outstanding = 365 * Accounts Receivable / Total Assets
36.25 = 365 * Accounts Receivable / $3,500,000
Accounts Receivable = $347,602.74

Answer c.

25% of customers pay on the 10th day and 75% of customers pay on the 35th days

Days Sales Outstanding = 25% * 10 + 75% * 35
Days Sales Outstanding = 28.75 days

Days Sales Outstanding = 365 * Accounts Receivable / Total Assets
28.75 = 365 * Accounts Receivable / $3,500,000
Accounts Receivable = $275,684.93

So, average accounts receivables will decrease by $71,917.81 ($347,602.74 - $275,684.93)


Related Solutions

McEwan Industries sells on terms of 3/10, net 30. Total sales for the year are $1,150,000;...
McEwan Industries sells on terms of 3/10, net 30. Total sales for the year are $1,150,000; 40% of the customers pay on the 10th day and take discounts, while the other 60% pay, on average, 90 days after their purchases. Assume 365 days in year for your calculations. What is the days sales outstanding? Round your answer to two decimal places.   days What is the average amount of receivables? Round your answer to the nearest cent. Do not round intermediate...
McEwan Industries sells on terms of 3/10, net 30. Total sales for the year are $794,000;...
McEwan Industries sells on terms of 3/10, net 30. Total sales for the year are $794,000; 40% of the customers pay on the 10th day and take discounts, while the other 60% pay, on average, 90 days after their purchases. Assume 365 days in year for your calculations. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. What is the days sales outstanding? Round...
Morrissey Industries sells on terms of 3/10, net 30. Total sales for the year are $900,000
Morrissey Industries sells on terms of 3/10, net 30. Total sales for the year are $900,000. Forty percent of the customers pay on Day 10 and take discounts; the other 60 percent pay, on average, 40 days after their purchases. What are (a) the days sales outstanding (DSO) and (b) the average amount of receivables? (c) What would happen to average receivables if Morrissey tightened its collection policy with the result that all non-discount customers paid on Day 30?
McEwan Industries sells on terms of 3/10, net 30. Total sales for the year are $1,353,000;...
McEwan Industries sells on terms of 3/10, net 30. Total sales for the year are $1,353,000; 40% of the customers pay on the 10th day and take discounts, while the other 60% pay, on average, 62 days after their purchases. Assume 365 days in year for your calculations. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. What is the days sales outstanding? Round...
Receivables Investment McEwan Industries sells on terms of 3/10, net 30. Total sales for the year...
Receivables Investment McEwan Industries sells on terms of 3/10, net 30. Total sales for the year are $1,921,000; 40% of the customers pay on the 10th day and take discounts, while the other 60% pay, on average, 70 days after their purchases. What is the days sales outstanding? .40 * 10 + .60 * 70 4 + 42 days days sales outstanding = 46 days What is the average amount of receivables? 1,921,000*46/365 $242,098.63 What is the percentage cost of...
Snider Industries sells on terms of 2/10, net 45. Total sales for the year are $1,600,000....
Snider Industries sells on terms of 2/10, net 45. Total sales for the year are $1,600,000. Thirty percent of customers pay on the 10th day and take discounts; the other 70% pay, on average, 50 days after their purchases. Assume a 365-day year. What is the days sales outstanding? Do not round intermediate calculations. Round your answer to the nearest whole number. days What is the average amount of receivables? Do not round intermediate calculations. Round your answer to the...
Trinity Surgical Supplies, Inc. sells on terms of 2/10, net 30. Gross sales for the year...
Trinity Surgical Supplies, Inc. sells on terms of 2/10, net 30. Gross sales for the year are $1.5 million, and the collections department estimates that 25 percent of the customers pay on the tenth day and take discounts; 50 percent pay on the thirtieth day; and the remaining 25 percent pay, on average, 40 days after the purchase. (Assume 360 days per year.) a. What is the firm's average collection period? b. What is the firm's current receivables balance? c....
McEwan Industries sells on terms of 3/10, net 40. Total sales for the year are $1,048,500;...
McEwan Industries sells on terms of 3/10, net 40. Total sales for the year are $1,048,500; 40% of the customers pay on the 10th day and take discounts, while the other 60% pay, on average, 82 days after their purchases. Assume 365 days in year for your calculations. a)What is the days sales outstanding? b)What is the average amount of receivables? c)What is the percentage cost of trade credit to customers who take the discount? d)What is the percentage cost...
McEwan Industries sells on terms of 3/10, net 20. Total sales for the year are $1,643,000;...
McEwan Industries sells on terms of 3/10, net 20. Total sales for the year are $1,643,000; 40% of the customers pay on the 10th day and take discounts, while the other 60% pay, on average, 74 days after their purchases. Assume 365 days in year for your calculations. What is the days sales outstanding? Round your answer to two decimal places. ________ days What is the average amount of receivables? Round your answer to the nearest cent. Do not round...
McEwan Industries sells on terms of 3/10, net 25. Total sales for the year are $1,817,000;...
McEwan Industries sells on terms of 3/10, net 25. Total sales for the year are $1,817,000; 40% of the customers pay on the 10th day and take discounts, while the other 60% pay, on average, 78 days after their purchases. Assume 365 days in year for your calculations. What is the days sales outstanding? Round your answer to two decimal places. days What is the average amount of receivables? Round your answer to the nearest cent. Do not round intermediate...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT