Question
=== You are the chief financial officer of Walmart. This afternoon you played golf with a member of the company's board of directors. Somewhere during
===
You are the chief financial officer of Walmart. This afternoon you played golf with a member of the company's board of directors. Somewhere during the back nine, the board member enthusiastically described a recent article she had read in a leading management journal. This article noted several companies that had improved their stock price performance through effective working capital management, and the board member was intrigued. Even though Walmart was known for working capital management, she wondered if it could do even better. How was Walmart managing its working capital, and how does it compare to Costco, another company well known for working capital management? Upon returning home, you decide to do a quick preliminary investigation using information freely available on the internet.
1. Obtain Costco's financial statements for the past four years.
2. Obtain Walmart's financial statements for the last four years.
3. Compute the cash conversion cycle for Walmart and Costco for each of the last four years.
a. Compute the inventory days using "Cost of Revenue" as cost of goods sold and a 365-day year.
b. Compute accounts receivable days using a 365-day year.
c. Compute accounts payable days using a 365-day year.
d. Compute the cash conversion cycle for each year.
4. How has Walmart's CCC changed over the last few years?
5. Compare Walmart's inventory and receivables turnover ratios for the most recent year to Costco's.
a. Compute the inventory turnover ratio as cost of revenue/inventory
b. Compute the receivable turnover ratio as total revenue/net receivables.
6. Now assume Walmart matches Costco's inventory and receivables turnover ratios without changing its payable days.
a. How much would Walmart's free-cash-flow change relative to its current situation?
b. What would Walmart's CCC be in this case?
7. What are your impressions regarding Walmart's working capital management based on this preliminary analysis? Discuss any advantages and disadvantages of attempting to match Costco's cash conversion cycle.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started