Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 (detailed) much appreciated **IMPORTANT** PLEASE MAKE SURE TO USE EXCEL WITH FORMULAS

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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Finance

Authors: Stephen Ross, Randolph Westerfield, Jeffrey Jaffe

13th International Edition

1265533199, 978-1265533199

Students also viewed these Finance questions