Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You are the Chief Financial Officer (CFO) 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 (CFO) 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. Please use latest information in the internet. 1. Obtain Costco's financial statements for the past four years from moneycentral.com, or yahoo finance or google finance or reuters.com. a. Enter the stock symbol (COST) in the box and click "Get Quote." b. Next click "Income Statement in the left column. C. Select "Annual," and if you are using Internet Explorer, place the cursor in the statement and right-click the mouse. Select "Export to Microsoft Excel" from the menu. If you do not have that option, you can copy and paste the data into Excel d. Go back to the Web page and click "Balance Sheet" at the left of the page: repeat the download procedure for the balance sheets. e. Copy and paste the balance sheet so that it is on the same worksheet as the income statement 2. Obtain Walmart's (WMT) ratios for comparison from moneycentral.com, or yahoo finance or google finance or reuters.com. a. Enter the stock symbol (WMT) in the box, then select "Financials." b. Scroll down to find the efficiency ratios and copy and paste them into your spreadsheet where Costco's financial statements are located. 3. Compute the cash conversion cycle for Walmart 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 the industry average. a. Compute the inventory turnover ratio as cost of revenue/inventory. b. Compute the receivable turnover ratio as total revenueet receivables. c. How do Costco's numbers compare to Walmart's
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