Question

In: Finance

Suppose firm XYZ has AR (Accounts Receivable) = 500, Sales = 3000, Inventory = 300, Cost...

Suppose firm XYZ has AR (Accounts Receivable) = 500, Sales = 3000, Inventory = 300, Cost of Goods Sold = 1200, and AP (Accounts Payable) = 100. How much cash does firm XYZ save if it reduces its Days Sales Outstanding by 10 days? What are specific activities an organization can engage in to accomplish these goals?

Solutions

Expert Solution

Ans Current Receivable turnover ratio = Net credit sales / average receivable
3000 / 500 = 6 times
Current days outstanding of receivables =   No. of days in year / Receivables turnover
365/6
60.83333 days
If X Y Z reduces its day sales outstanding by 10 days then days outstanding receivable would be = 60.83333 - 10 = 50.83333 days
Then new receivable turnover ratio would be 365 / 50.83333 = 7.20
And new AR would be =   Receivable turnover ratio = Net credit sales / average receivable
7.20 = 3000 / average receivable
average receivable = 3000 / 7.20 = 416.6667
1 Cash saved = Current AR - New AR
= 500 - 416.667
$83.33
2 To achieve this target the company should follow below practices :
Company should give the cash discount to it's customers
Company should offer multiple payment methods to customer like cash, checks , E F Ts or credit/debit cards.
Company should impose interest as penalty on overdue payments.

Related Solutions

In 2017, the firm had $500 in Cash, $1,250 in Accounts Receivable, $1,100 in inventory, $3,500...
In 2017, the firm had $500 in Cash, $1,250 in Accounts Receivable, $1,100 in inventory, $3,500 in total fixed assets, $600 in Accounts Payable, $800 in Notes Payable, and $2,500 in total long-term debt. In 2018, the firm had $550 in Cash, $1,380 in Accounts Receivable, $1,120 in inventory, 4,600 in total fixed assets, $700 in Accounts Payable, $820 in Notes Payable, and $3,500 in total long-term debt. What was the change in Net Working Capital from 2017 to 2018?
Snow Man Inc. has accounts receivable of $4,500, inventory of $1,800, sales of $135,000, and cost...
Snow Man Inc. has accounts receivable of $4,500, inventory of $1,800, sales of $135,000, and cost of goods sold of $64,000. How many days does it take the firm to sell its inventory and collect the payment on the sale assuming that all sales are on credit? (i.e. Inventory Holding Period +  Days' sales in receivables) 10.27 days 18.67 days 14.50 days 22.43 days 12.17 days
A company has Cash of $1000, Accounts Receivable of $200, Inventory of $300, Long-Term Assets of...
A company has Cash of $1000, Accounts Receivable of $200, Inventory of $300, Long-Term Assets of $4000, Accounts Payable of $500 and a Long-Term Bank Loan of $5000. Calculate the company's current ratio. Question 1 options: 1 2 3 4 Question 2 Using the following information, calculate the inventory turnover for ABC Retailers: Sales are $4800, Cost of Goods Sold is $2000, operating expenses are $1000, and average inventory is $500. Question 2 options: 4 5 6 7 Question 3...
Sales (all credit): $6,000,000; Cost of Goods Sold: 80% of Sales; Accounts receivable: $350,000; Inventory: $600,000;...
Sales (all credit): $6,000,000; Cost of Goods Sold: 80% of Sales; Accounts receivable: $350,000; Inventory: $600,000; Accounts payable: $150,000 What is the Working Capital Cycle? Use 1 year = 365 days 11 days. 46 days. 22 days 56 days.
Riordan Trucking has sales of $18M and an accounts receivable balance of $1M. The firm has...
Riordan Trucking has sales of $18M and an accounts receivable balance of $1M. The firm has projected next year's sales at $24M and wants to reduce ACP by 2 days. Calculate Riordan's projected accounts receivable balance. (Round to the nearest $ and assume 360 days.) a. $1.0M b. $1.2M c. $1.4M d. $1.6M
A firm has $792 in inventory, $1,565 in fixed assets, $577 in accounts receivable, $339 in...
A firm has $792 in inventory, $1,565 in fixed assets, $577 in accounts receivable, $339 in net working capital, and $189 in cash. What is the amount of current liabilities?
Pasta Shop has sales of $315,000, average accounts receivable of $32,000, average inventory of $28,000 and...
Pasta Shop has sales of $315,000, average accounts receivable of $32,000, average inventory of $28,000 and average accounts payable of $24,000. The cost of goods sold is equivalent to 70 percent of sales. What is the operating cycle? What is the cash cycle?
Firm A has a value of $500 million and Firm B has a value of $300...
Firm A has a value of $500 million and Firm B has a value of $300 million. Firm A has 1000 shares outstanding, and firm B has 1000 shares outstanding. Suppose that the merger would increase cash flows of the combined firm by $5 million in perpetuity. Assuming the cost of capital for the firm is 10% Suppose that instead of paying cash, Firm A acquires B by offering two (new) shares of A for every three shares of B....
XYZ Company has annual sales of $692,584. The cost of goods sold are $444,925. The firm...
XYZ Company has annual sales of $692,584. The cost of goods sold are $444,925. The firm has an accounts receivable balance of $5,685, an accounts payable balance of $18,445 and inventory of $9,946. How many days on average does it take the firm to collect its accounts receivable? That is, what is the average collection period? Assume 365 days.
XYZ Company has annual sales of $518,138. The cost of goods sold are $392,068. The firm...
XYZ Company has annual sales of $518,138. The cost of goods sold are $392,068. The firm has an accounts receivable balance of $16,047, an accounts payable balance of $15,631 and inventory of $18,963. How many days does it take on average for the firm to pay its suppliers? That is, what is the payable period? Assume 365 days
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT