Trusted by Students Everywhere
Why Choose Us?
0% AI Guarantee

Human-written only.

24/7 Support

Anytime, anywhere.

Plagiarism Free

100% Original.

Expert Tutors

Masters & PhDs.

100% Confidential

Your privacy matters.

On-Time Delivery

Never miss a deadline.

Margetis Inc

Finance Dec 17, 2020

Margetis Inc. carries an average inventory of $750,000. Its annual sales are $10 million, its cost of goods sold is 75% of annual sales, and its average collection period is twice as long as its inventory conversion period. The firm buys on terms of net 30 days, and it pays on time. Its new CFO wants to decrease the cash conversion cycle by 10 days, based on a 365-day year. He believes he can reduce the average inventory to $647,260 with no effect on sales. By how much must the firm also reduce its accounts receivable to meet its goal in the reduction of the cash conversion cycle? 

Expert Solution

Cost of goods sold = 75% *($10,000,000)

= $7,500,000

 

Inventory turnover ratio = Cost of goods sold / Average inventory

= $7,500,000 / $750,000

= 10 times

 

Days sales inventory = 365 / Inventory turnover ratio

= 365/ 10

= 36.5 days

 

Average collection period = 2 *(36.5 days)

= 73 days

 

Average collection period = (Accounts receivables * 365) / Credit sales

73days = (AR * 365) / $10,000,000

$730,000,000 = AR * 365

AR = $2,000,000

 

Cash conversion cycle = DSO + DIO - DPO

here,

DSO = Days sales outstanding

DIO = Days inventory outstanding

DPO = Days payable outstanding

 

Cash conversion cycle = 73 days + 36.5 days - 30days

= 79.5 days

 

Days inventory outstanding = (365 / Inventory turnover)

= 365 / (Cost of goods sold / Average inventory)

= 365 / ($7,500,000 / $647,260)

= 365 / 11.59

= 31.5 days

 

DSO =(Accounts receivables * 365) / Credit sales

68 = (AR * 365) / $10,000,000

$680,000,000 = AR * 365

AR= $680,000,000 / 365

= $1,863,014

 

So,

Accounts receivable reduced by =$2,000,000 - $1,863,014

= $136,986

Archived Solution
Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In
Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution
Get Custom Quote
Secure Payment