1. WalMart\'s Annual sales 2013 468,651, 2012 446,509; Cost of goods sold 2013 3
ID: 2627946 • Letter: 1
Question
1. WalMart's Annual sales 2013 468,651, 2012 446,509; Cost of goods sold 2013 352,297, 2012 334,993 So not sure if I have this right.
2. Select the firm's Balance Sheet. Write down the balances shown for the firm's inventories, accounts receivable, and accounts payable. Inventory 2014 44,858,000, 2013 43,803,000 2012 40,714,000 Accounts receivable 2014 6,677,000 2013 6,778,000 2012 5,937,00 Accounts payable 2014 57,174,000 2013 59,099,000 55,952,000
3. Using the information from parts 1 and 2, calculate its inventory turnover, accounts receivable turnover, and accounts payable turnover. You should show your work
4. Calculate production cycle, collection cycle, and accounts payable cycle. You should show your work!
5. What is the company
Explanation / Answer
1. Inventory turnover FY13 = cost of goods sold/average inventory
= 352,297 / ((43,803,000+40,714,000)/2)
= 8.34%
2. Accounts receivable turnover FY13 = Net credit sales / average accounts receivable
= 468,651 / ((6,677+6,778)/2)
= 69.66%
3. Accounts payable turnover FY13 = cost of goods sold / average accounts payable
=352,297 / ((59,099+55,952)/2)
=6.12%
4. Production cycle
= 365 * inventory turnover ratio = 365 * 8.34% = 30.44 days
5. Collection cycle = 365 *accounts receivable turnover = 365 * 69.66% = 254 days
6. Accounts payable cycle = 365 * accounts payable turnover = 365 * 6.12% = 22.33 days
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.