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.

Given the following information, calculate the cash cycle

Finance Oct 30, 2020

Given the following information, calculate the cash cycle. Use average inventory, receivables, and payables in your calculations.

Credit sales = $1,000,000

Cost of goods sold = $750,000

Beginning balances:

Inventory = $300,000

Accounts Receivable = $280,000

Accounts Payable = $260,000

 

Ending balances:

Inventory = $280,000

Accounts Receivable = $250,000

Accounts Payable = $240,000

 

Multiple choice:

a: 238days

b 141days

c 261days

d 116days

e 97days

Expert Solution

Computation of Cash Cyle:

Inventory Turnover = Cost of Goods sold / Average Inventory

Here,

Average Inventory = ($300,000 + $280,000)/ 2 = $290,000

 

Inventory Turnover = $750,000 / $290,000 = 2.59 times

 

 

Days Inventory Outstanding = Average Inventory * 365 / Cost of Goods sold = $290,000 * 365 / $750,000 = 141.13 days

 

Days Sales Outstanding = Average Accounts Receivable * 365 / Net Credit Sales

Here,

Average Accounts Receivable = ($280,000 + $250,000) / 2 = $265,000

Net Credit Sales = $1,000,000

 

Days Sales Outstanding = $265,000 * 365 / $1,000,000 = 96.73 days

 

Days Payable Outstanding = Average Accounts Payable * 365 / Cost of Goods sold

Here,

Average Accounts Payable = ($260,000 + $240,000) / 2 = $250,000

Days Payable Outstanding = $250,000 * 365 / $750,000 = 121.67 days

 

Cash Conversion Cycle = Days Inventory Outstanding + Days Sales Outstanding - Days Payable Outstanding

Cash Conversion Cycle = 141.13 days + 96.73 days - 121.67 days

Cash Conversion Cycle = 116.19 days or 116 days

So, the correct option is D "116 days".

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