Question

In: Finance

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?

Solutions

Expert Solution

(a)- Days sales outstanding (DSO)

Days sales outstanding (DSO) = [Number of days in discount period x percent of the customers pay] + [Non-discount period x percent of the customers pay]

= [10 Days x 40%] + [40 Days x 60%]

= 4 Days + 24 Days

= 28 Days

(b)- Average amount of receivables

Sales per day = $2,465.75 per day [$900,000 / 365 Days]

Average amount of receivables = Sales per day x Days sales outstanding (DSO)

= $2,465.75 per day x 28 Days

= $69,041

(c)-Change in average receivables if Morrissey tightened its collection policy with the result that all non-discount customers paid on Day 30

Days sales outstanding (DSO) = [Number of days in discount period x percent of the customers pay] + [Non-discount period x percent of the customers pay]

= [10 Days x 40%] + [30 Days x 60%]

= 4 Days + 18 Days

= 22 Days

Sales per day = $2,465.75 per day [$900,000 / 365 Days]

Average amount of receivables = Sales per day x Days sales outstanding (DSO)

= $2,465.75 per day x 22 Days

= $54,246.50

“If Morrissey tightened its collection policy with the result that all non-discount customers paid on Day 30, then the average receivables would reduce to $54,246.50 from $69,041”


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...
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...
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...
McEwan Industries sells on terms of 3/10, net 40. Total sales for the year are $575,000;...
McEwan Industries sells on terms of 3/10, net 40. Total sales for the year are $575,000; 40% of the customers pay on the 10th day and take discounts, while the other 60% pay, on average, 52 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. b. What is the average amount of...
Snider Industries sells on terms of 3/10 net 35. Total sales for the year are $1500000....
Snider Industries sells on terms of 3/10 net 35. Total sales for the year are $1500000. Thirty percent of customers pay in the 10th day and take discounts. the other day 70% pay on average 40 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 if receivables? c. What would happen to average receivables if Snider toughened its collection policy with the result...
Snider Industries sells on terms of 3/10, net 45. Total sales for the year are $1,770,000....
Snider Industries sells on terms of 3/10, net 45. Total sales for the year are $1,770,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 365 days in year for your calculations. What is the days sales outstanding? Round your answer to one decimal place. days What is the average amount of receivables? Round your answer to the nearest dollar. Do not round intermediate calculations....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT