-
+1 - 312-224-1615
Get in touch with us
-
support@helpwithassignment.com
Send us an e-mail
Solution Library
Dollar Tree Inc. (DLTR) and Wal-Mart (WMT) to calculate their cash conversion cycles
Question
Go to finance.yahoo.com and collect data for Dollar Tree Inc. (DLTR) and Wal-Mart (WMT) to calculate their cash conversion cycles.
You can enter the ticker symbol (DLTR for example) in the “quote lookup” box toward the right side to search for each firm individually. Once the company comes up, you can click on the “financials” tab. The income statement will pop up and you can click on the balance sheet button to access that financial statement. Use the current year’s annual data to find: Sales (Revenue), Cost of Revenue (Cost of Goods Sold), Inventory, Accounts Receivable, and Accounts Payable.
a.Calculate the cash conversion cycle for both firms.
b.Which store has the better cash conversion cycle?
c. What impact would it have on the cash conversion cycle if Wal-Mart decided to offer an in-store credit card and customers on average took 30 days to pay?
Solution
Wal Mart for the year 2017
Sales (Revenue) = 485,873,000
Cost of Revenue (Cost of Goods Sold) = 361,256,000
Inventory = 485,873,000
Average Inventory = (Beginning Inventory + Ending Inventory) / 2 = (44,469,000 + 43,046,000) / 2
= 4,37,57,500
Accounts Receivable = 5,835,000
Average Accounts Receivables = (5,835,000 + 5,624,000) / 2 = 57,29,500
Accounts Payable = 63,008,000
Average Accounts Payable = (63,008,000 + 58,615,000) / 2 = 6,08,11,500
Dollar Tree Inc.
For the year 2017
Sales(Revenue) = 20,719,200
Cost of Revenue (Cost of Goods Sold) = 14,324,500
Inventory = 2,865,800
Average Inventory = (Beginning Inventory + Ending Inventory) / 2 = (2,865,800 + 2,885,500) / 2
= 28,75,650
Accounts Receivable = 0
Average Accounts Receivables = 0
Accounts Payable = 1,209,600
Average Accounts Payable = (1,209,600 + 1,264,800) / 2 = 12,37,200
A)
Here we consider average inventory, average accounts receivable and average accounts payable.
Wal Mart
Cash Conversion cycle = [( 43757500 / 361256000 ) + ( 5729500 / 485873000 ) - ( 60811500 / 361256000) ] * 365
= -12.93 days
Dollar Tree Inc.
Cash Conversion Cycle = [( 2875650 / 14324500) + ( 0 ) - ( 1237200 / 14324500 )] * 365
= 41.75 days
B)
The lower the cash conversion cycle(CCC) the better. It means that the company can convert cash in hand into much more cash very quickly thereby increasing the firm's profitability. A negative CCC is more desirable. It means that the firm does not pay for raw materials until the final product is sold. The firm's working capital is used efficiently and the cash can be used for other activities.
Thus WalMart has a better CCC as it is negative.
C)
If WalMart introduced a credit facility and customers would take an average of 30 days to pay, WalMart's days sales outstanding would increase by 30 days.
Therefore we add 30 to Walmart's CCC = -12.93 + 30 = 17.07 days
We see that the CCC of WalMart is still better than Dollar Tree Inc.
DownloadWHAT OUR STUDENTS SAY
I chose civil engineering for my graduate studies because I am fascinated with the concepts of municipal and urban engineering. Since it has been my area of interest from high school and I had done some research on the topic I thought the graduate program would be a breeze. But I was soon proved wrong and found myself struggling from the very first semester. At TheReliableTutor.com my online civil engineering assignment tutor helped walk me through the different concepts and with in-depth quality research that was missing from my work.
Jeffrey Scholes Student
Material provided by the online mechanical engineering tutor at HwA was absolutely fantastic and just the thing I needed to write my mechanical engineering term paper on Fluid Mechanics. The online mechanical engineering tutor assigned to me helped me understand the crucial details of the topic and that along with the reference material and notes provided helped me to write my term paper and get an A in it!
Miriam Huang Student
I was totally unaware of what exactly needed to be written in the marketing plan assignment, based on the . I needed to first get an approval from my professor about the hypothetical business and a region where it needs to be promoted. When I approached TheReliableTutor I got relieved as they provided me with certain alternatives, as they are well aware of the regions of Singapore and assured me that their marketing assignment experts can care of anything my professor approves. It is needless to say that I got an A+ in the marketing plan assignment and many other assignments going forward.
Jun Hao Student
Higher order simultaneous equation where I needed to find out values for 5 or 6 variables forming appropriate equations from a given problem, was really my weak area. However, when I came across HwA they helped me and also assisted me to understand how exactly from a problem statement, the equations can be formed and how they can be evaluated.
Bobby Thatcher Student
I was really struggling with the effect of current and magnetism assignments in undergraduate class when I came across TheReliableTutor and they really have brilliant Physics electricity Online Experts. The experts have worked on my Physics electricity solution and helped me get good grades.
Liam McDevitt Student
Comments
this is a very good website
I have 50 questions for the same test your page is showing only 28
hi can you please help or guide me to answer my assignments. thanks
hi can anyone help or guide me to my assignments. thanks
This solution is perfect ...thanks
Hello Allison,I love the 2nd image that you did! I also, had never heard of SumoPaint, is something that I will have to exolpre a bit! I understand completely the 52 (or so) youtube videos that you probably watched. Sometimes they have what you want, sometimes they don't! However, it is always satisfying when you are able to produce something that you have taught yourself. Great job!Debra 0 likes
Perfect bank of solution.
great !
thanks for the quick response. the solution looks good. :)
thnx for the answer. it was perfect. just the way i wanted it.
works fine.