Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

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

Step: 3

blur-text-image

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

International financial management

Authors: Jeff Madura

9th Edition

978-0324593495, 324568207, 324568193, 032459349X, 9780324568202, 9780324568196, 978-0324593471

More Books

Students also viewed these Finance questions

Question

=+ a. What happens to the labor demand curve?

Answered: 1 week ago