Question: please help with excel step-by-step (detailed) much appreciated **IMPORTANT** PLEASE MAKE SURE TO USE EXCEL WITH FORMULAS JB Hunt Corp. has annual sales of $80,000,000;

please help with excel step-by-step (detailed) much appreciated **IMPORTANT** PLEASE MAKE SURE TO USE EXCEL WITH FORMULAS

JB Hunt Corp. has annual sales of $80,000,000; its average inventory is $20,000,000; and its average accounts receivable is $16,000,000. The firm buys all raw materials on terms of net 35 days with cost of the good sold $180,000 per day. The firm is searching for ways to shorten the cash conversion cycle. If sales and cost of the good sold can be maintained at existing levels while lowering inventory conversion cycle by 20 days, lowering average collection period by 10 days and postponing its payable to 40 days, calculate the Exodus increase in its free cash flow after the change in its cash conversion cycle

PLEASE HELP WITH EXCEL STEP-BY-STEP (IN FULL detail) much appreciated **IMPORTANT** I WANT TO LEARN

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!