Question

uiek ratio to exceed the current ratio? iy moou the current ratio? 15. Interpret a working capital requirement of S0. PROBLEMS For the problems, CCC-cash conversion cycle, DSo days sales outstanding, DIH ld, and DPO days payable outstanding. 1.) Suppose that a firm has a 30-day DSO. Determine the firms DIlH if the operating cycle is days inventory a. 30 days b. 60 days c. 80 days 2. Suppose that a firm has a 50-day DIH and a 30-day DPO. Determine the firms DSO if the CCc is: a. 90 days b. 60 days c. 20 days Suppose that a firm has a 60-day operating cycle. Determine the firms DPO if the CCCis: a. 40 days b. 0 days c. 20 days 3. COGS-45% of revenues. Receivables-$1,100,000, payable: $700,000 and inventory is $800,000. a. Calculate the operating cycle. b. Calculate the CCC c. With all else constant, what level of payables will llow the firm to have a CCC of o days? d. With all else constant, what level of inventory will llow the firm to have a CCC of 0 days? e. With all else constant, what level of receivables will allow the firm to have a CCC of 0 days? 4. Use the following financial values to answer the questions below. Revenues $4,200,000 and Is your answer feasible? page no
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer 1:

a. DIH = 0 days

b. DIH = 30 days

c. DIH = 50 days

Workings:

DIH = Operating cycle - DSO

a. DIH = 30 - 30 = 0 days

b. DIH = 60 - 30 = 30

C. DIH =80- 30 = 50

Answer 2:

a. DSO = 70 days

b. DSO = 40 days

c. DSO = 0 days

Workings:

DSO = CCC - DIH + DPO

a. DSO = 90 - 50 + 30 = 70

b. DSO = 60- 50 + 30 = 40

c. DSO = 20- 50 + 30 = 0

Answer 3:

a. DPO = 20 days

b. DPO = 60 days

c. DPO = 40 days

Workings:

DPO = Operating cycle - CCC

a. DPO = 60 - 40 = 20 days

b. DPO = 60 - 0 = 60

C. DPO = 60- 20 = 40

Answer 4:

DSO = Receivable / (sales / 365) = 1100000 / (4200000 / 365) = 96 days

DIH = Inventory/ (COGS /365) = 800000 /(45% * 4200000 / 365) = 154 days

DPO = 700000 / (45% * 4200000 / 365) = 135 days

a. Operating cycle = DSO +DIH = 96 + 154 = 250 days

b. CCC = Operating cycle - DPO = 250 - 135 = 115 days

c. CCC will be 0 days if DPO = Operating cycle = 250 days

Payables = 250 * (45% * 4200000 / 365) =$1,294,521

d. CCC will be 0 when:

DIH = CCC - DSO + DPO = 0 - 96 + 135 =39 days

Inventory =39 * (45% * 4200000 / 365) = $201,945

e. CCC will be 0 when:

DSO = CCC - DIH + DPO = 0 - 154 + 135 = -19 days

DSO has to be negative to have CCC = 0 (all else remaining same). This is not feasible.

Add a comment
Know the answer?
Add Answer to:
uiek ratio to exceed the current ratio? iy moou the current ratio? 15. Interpret a working...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 3. Calculate the Cash Conversion Cycle (use end-of-period amounts rather than average of receivables, inventory, and...

    3. Calculate the Cash Conversion Cycle (use end-of-period amounts rather than average of receivables, inventory, and payables): • Days Sales Outstanding (DSO) = Receivables / (Sales/365) • Days Inventory Held (DIH) = Inventory / (CGS/365) • Days Payable Outstanding (DPO) = Payables/(CGS/365) • Operating Cycle = DSO + DIH • Cash Conversion Cycle (CCC) = Operating Cycle - DPO 2017 2016 2015 2014 2013 DIH 152.08 106.46 101.39 DSO 121.67 73.00 64.89 DPO 121.67 76.04 70.97 Operating Cycle 273.75 179.46...

  • Instructions For 2017 and 2018, calculate current ratio, quick (acid-test) ratio, inventory turnover and days' inventory...

    Instructions For 2017 and 2018, calculate current ratio, quick (acid-test) ratio, inventory turnover and days' inventory outstanding (DIO), accounts receivable turnover, days' sales in average receivables or days' sales outstanding (DSO), accounts payable turnover, days' payable outstanding (DPO), and cash conversion cycle (in days). a. Use the cost of goods sold in the formula for accounts payable turnover. b. Use a 365-day year for calculations as needed. c. Use cell references from prior calculations, if applicable. (Always use cell references...

  • Instructions For 2017 and 2018, calculate current ratio, quick (acid-test) ratio, inventory turnover and days' inventory...

    Instructions For 2017 and 2018, calculate current ratio, quick (acid-test) ratio, inventory turnover and days' inventory outstanding (DIO), accounts receivable turnover, days' sales in average receivables or days' sales outstanding (DSO), accounts payable turnover, days' payable outstanding (DPO), and cash conversion cycle (in days). a. Use the cost of goods sold in the formula for accounts payable turnover. b. Use a 365-day year for calculations as needed. c. Use cell references from prior calculations, if applicable. (Always use cell references...

  • What is Chutes' interest coverage ratio? The interest coverage ratio istimes. (Round to one decimal place.)...

    What is Chutes' interest coverage ratio? The interest coverage ratio istimes. (Round to one decimal place.) Suppose your firm receives a $4.62 million order on the last day of the year. You fill the order with $1.95 million worth of inventory. The customer picks up the entire order the same day and pays $1.22 million up front in cash; you also issue a bill for the customer to pay the remaining balance of $3.40 million within 40 days. Suppose your...

  • Quantitative Problem: Winston Inc. is trying to determine the effect of its inventory turnover ratio and...

    Quantitative Problem: Winston Inc. is trying to determine the effect of its inventory turnover ratio and days sales outstanding on its cash conversion cycle. Winston's 2017 sales (all on credit) were $117,000 and its cost of goods sold was 75% of sales. It turned over its inventory 8.77 times during the year. Its receivables balance at the end of the year was $13,148.72 and its payables balance at the end of the year was $7,407.63. Using this information calculate the...

  • Question 3. The Timber Ridge Company has the following relationships: Sales/Total assets = 3.80; ROA =...

    Question 3. The Timber Ridge Company has the following relationships: Sales/Total assets = 3.80; ROA = 0.0980 What is Timber Ridge’s net profit margin? Round to 3 decimal places. Question 5 Archware Systems has total assets of $35.594 billion, total debt of $9.678 billion, and net sales of $23.720 billion. Their net profit margin for the year was 0.22, while the operating profit margin was 30 percent. What is Archware’s net income? (Answer needs to be stated in billions. For...

  • CASH CONVERSION CYCLE Chastain Corporation is trying to determine the effect of its inventory turnover ratio...

    CASH CONVERSION CYCLE Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales outstanding (DSO) on its cash conversion cycle. Chastain's 2016 sales (all on credit) were $183,000; its cost of goods sold is 80% of sales, and it earned a net profit of 4%, or $7,320. It turned over its inventory 4 times during the year, and its DSO was 39 days. The firm had fixed assets totaling $34,000. Chastain's payables deferral period...

  • CASH CONVERSION CYCLE Chastain Corporation is trying to determine the effect of its inventory turnover ratio...

    CASH CONVERSION CYCLE Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales outstanding (DSO) on its cash conversion cycle. Chastain's 2016 sales (all on credit) were $183,000; its cost of goods sold is 80% of sales, and it earned a net profit of 4%, or $7,320. It turned over its inventory 4 times during the year, and its DSO was 39 days. The firm had fixed assets totaling $34,000. Chastain's payables deferral period...

  • CASH CONVERSION CYCLE Chastain Corporation is trying to determine the effect of its inventory turnover ratio...

    CASH CONVERSION CYCLE Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales outstanding (DSO) on its cash conversion cycle. Chastain's 2016 sales (all on credit) were $272,000; its cost of goods sold is 80% of sales; and it earned a net profit of 3%, or $8,160. It turned over its inventory 4 times during the year, and its DSO was 35 days. The firm had fixed assets totaling $32,000. Chastain's payables deferral period...

  • CASH CONVERSION CYCLE Chastain Corporation is trying to determine the effect of its inventory turnover ratio...

    CASH CONVERSION CYCLE Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales outstanding (DSO) on its cash conversion cycle. Chastain's 2016 sales (all on credit) were $240,000; its cost of goods sold is 80% of sales; and it earned a net profit of 2%, or $4,800. It turned over its inventory 5 times during the year, and its DSO was 31.5 days. The firm had fixed assets totaling $40,000. Chastain's payables deferral period...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT