Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Home Depots cash conversion cycle for the period 2012-2016 follows: Amount in days 2016 2015 2014 2013 2012 Days sales outstanding (DSO) 6.96 6.32 6.47

Home Depot’s cash conversion cycle for the period 2012-2016 follows:

Amount in days

2016

2015

2014

2013

2012

Days sales outstanding (DSO)

6.96

6.32

6.47

6.45

6.04

Days inventory outstanding (DIO)

71.7

73.74

76.55

78.49

82.88

Days payable outstanding (DPO)

-38.76

-38.65

-39.29

-38.18

-37.87

Cash conversion cycle

39.9

41.41

43.73

46.76

51.05

Cost of goods sold in the year 2016 was $58,254 million. 

Based on the above information, answer the following questions.

1. By how many days DIO has changed over the period from 2012 to 2016? What is the change in the year 2016 from 2015? How much additional cash was available as a result in 2016 relative to 2012? How much additional cash was available as a result in 2016 relative to 2015?

2. By how many days DPO has changed over the period from 2012 to 2016? What is the change in the year 2016 from 2015? How much additional cash was available as a result in 2016 relative to 2012? How much additional cash was available as a result in 2016 relative to 2015?

3. What is the potential problem that may occur in case of excessive delay in supplier payment? Explain. What should a company do in this area?

4. What is the implication of shortened cash conversion cycle over time for the company’s overall liquidity? What is the aggregate effect of changes in DIO and DPO on Home Depot’s liquidity position over the five-year period?

Step by Step Solution

3.55 Rating (159 Votes )

There are 3 Steps involved in it

Step: 1

1 To calculate the change in Days Inventory Outstanding DIO over the period from 2012 to 2016 we subtract the DIO for 2012 from the DIO for 2016 DIO change DIO 2016 DIO 2012 717 8288 1118 days The cha... blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

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

Financial Reporting and Analysis

Authors: Lawrence Revsine, Daniel Collins, Bruce Johnson, Fred Mittelstaedt, Leonard Soffer

7th edition

1259722651, 978-1259722653

More Books

Students also viewed these Accounting questions

Question

=+a) What are the factors they are testing?

Answered: 1 week ago

Question

What is an insurable interest? Why is it important?

Answered: 1 week ago