Ratios (Summary)

Wal-Mart Stores Inc., short-term (operating) activity ratios

 
Jan 31, 2014 Jan 31, 2013 Jan 31, 2012 Jan 31, 2011 Jan 31, 2010 Jan 31, 2009
Turnover Ratios
Inventory turnover 7.98 8.05 8.23 8.68 9.19 8.87
Receivables turnover 70.85 68.87 74.76 82.33 97.74 102.75
Payables turnover 9.57 9.26 9.15 9.40 10.00 10.61
Working capital turnover
Average No. of Days
Average inventory processing period 46 45 44 42 40 41
Add: Average receivable collection period 5 5 5 4 4 4
Operating cycle 51 50 49 46 44 45
Less: Average payables payment period 38 39 40 39 36 34
Cash conversion cycle 13 11 9 7 8 11

Source: Based on data from Wal-Mart Stores Inc. Annual Reports

Ratio Description The company
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. Wal-Mart Stores Inc.'s inventory turnover deteriorated from 2012 to 2013 and from 2013 to 2014.
Receivables turnover An activity ratio equal to revenue divided by receivables. Wal-Mart Stores Inc.'s receivables turnover deteriorated from 2012 to 2013 but then slightly improved from 2013 to 2014.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Wal-Mart Stores Inc.'s payables turnover increased from 2012 to 2013 and from 2013 to 2014.
Working capital turnover An activity ratio calculated as revenue divided by working capital.
Average inventory processing period An activity ratio equal to the number of days in the period divided by inventory turnover over the period. Wal-Mart Stores Inc.'s average inventory processing period deteriorated from 2012 to 2013 and from 2013 to 2014.
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnoverd.
Operating cycle Equal to average inventory processing period plus average receivables collection period. Wal-Mart Stores Inc.'s operating cycle deteriorated from 2012 to 2013 and from 2013 to 2014.
Average payables payment period An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. Wal-Mart Stores Inc.'s average payables payment period declined from 2012 to 2013 and from 2013 to 2014.
Cash conversion cycle A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. Wal-Mart Stores Inc.'s cash conversion cycle deteriorated from 2012 to 2013 and from 2013 to 2014.

ADVERTISEMENT

Top


Inventory Turnover

Wal-Mart Stores Inc., inventory turnover calculation, comparison to benchmarks

 
Jan 31, 2014 Jan 31, 2013 Jan 31, 2012 Jan 31, 2011 Jan 31, 2010 Jan 31, 2009
Selected Financial Data (USD $ in millions)
Cost of sales 358,069  352,488  335,127  315,287  304,657  306,158 
Inventories 44,858  43,803  40,714  36,318  33,160  34,511 
Ratio
Inventory turnover1 7.98 8.05 8.23 8.68 9.19 8.87
Benchmarks
Inventory Turnover, Competitors
Amazon.com Inc. 7.31 7.62 7.47 8.30 8.74
Target Corp. 5.84 6.40 6.04 6.02 6.14 6.59
Inventory Turnover, Sector
Broadline Retailers 7.73 7.85 8.14 8.62 8.51
Inventory Turnover, Industry
Consumer Services 8.40 8.51 8.42 8.36 8.31

Source: Based on data from Wal-Mart Stores Inc. Annual Reports

2014 Calculations

1 Inventory turnover = Cost of sales ÷ Inventories
= 358,069 ÷ 44,858 = 7.98

Ratio Description The company
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. Wal-Mart Stores Inc.'s inventory turnover deteriorated from 2012 to 2013 and from 2013 to 2014.

Top


Receivables Turnover

Wal-Mart Stores Inc., receivables turnover calculation, comparison to benchmarks

 
Jan 31, 2014 Jan 31, 2013 Jan 31, 2012 Jan 31, 2011 Jan 31, 2010 Jan 31, 2009
Selected Financial Data (USD $ in millions)
Net sales 473,076  466,114  443,854  418,952  405,046  401,244 
Receivables, net 6,677  6,768  5,937  5,089  4,144  3,905 
Ratio
Receivables turnover1 70.85 68.87 74.76 82.33 97.74 102.75
Benchmarks
Receivables Turnover, Competitors
Amazon.com Inc. 24.82 23.50 22.53 25.83 29.32
Target Corp. 11.55 10.69 9.11 7.78
Receivables Turnover, Sector
Broadline Retailers 62.71 39.64 39.83 40.43 38.10
Receivables Turnover, Industry
Consumer Services 21.83 20.68 20.77 21.87 22.23

Source: Based on data from Wal-Mart Stores Inc. Annual Reports

2014 Calculations

1 Receivables turnover = Net sales ÷ Receivables, net
= 473,076 ÷ 6,677 = 70.85

Ratio Description The company
Receivables turnover An activity ratio equal to revenue divided by receivables. Wal-Mart Stores Inc.'s receivables turnover deteriorated from 2012 to 2013 but then slightly improved from 2013 to 2014.

ADVERTISEMENT

Top


Payables Turnover

Wal-Mart Stores Inc., payables turnover calculation, comparison to benchmarks

 
Jan 31, 2014 Jan 31, 2013 Jan 31, 2012 Jan 31, 2011 Jan 31, 2010 Jan 31, 2009
Selected Financial Data (USD $ in millions)
Cost of sales 358,069  352,488  335,127  315,287  304,657  306,158 
Accounts payable 37,415  38,080  36,608  33,557  30,451  28,849 
Ratio
Payables turnover1 9.57 9.26 9.15 9.40 10.00 10.61
Benchmarks
Payables Turnover, Competitors
Amazon.com Inc. 3.58 3.45 3.35 3.30 3.39
Target Corp. 6.66 7.17 6.98 6.90 6.77 6.97
Payables Turnover, Sector
Broadline Retailers 7.59 7.55 7.76 8.34 9.05
Payables Turnover, Industry
Consumer Services 8.36 8.34 8.35 8.70 9.26

Source: Based on data from Wal-Mart Stores Inc. Annual Reports

2014 Calculations

1 Payables turnover = Cost of sales ÷ Accounts payable
= 358,069 ÷ 37,415 = 9.57

Ratio Description The company
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Wal-Mart Stores Inc.'s payables turnover increased from 2012 to 2013 and from 2013 to 2014.

ADVERTISEMENT

Top


Working Capital Turnover

Wal-Mart Stores Inc., working capital turnover calculation, comparison to benchmarks

 
Jan 31, 2014 Jan 31, 2013 Jan 31, 2012 Jan 31, 2011 Jan 31, 2010 Jan 31, 2009
Selected Financial Data (USD $ in millions)
Current assets 61,185  59,940  54,975  51,893  48,331  48,949 
Less: Current liabilities 69,345  71,818  62,300  58,484  55,561  55,390 
Working capital (8,160) (11,878) (7,325) (6,591) (7,230) (6,441)
Net sales 473,076  466,114  443,854  418,952  405,046  401,244 
Ratio
Working capital turnover1
Benchmarks
Working Capital Turnover, Competitors
Amazon.com Inc. 45.26 26.63 18.53 10.13 10.07
Target Corp. 30.53 31.67 9.21 8.94 9.01
Working Capital Turnover, Sector
Broadline Retailers 169.36 155.05 164.64
Working Capital Turnover, Industry
Consumer Services 32.72 26.19 25.08 21.99 31.76

Source: Based on data from Wal-Mart Stores Inc. Annual Reports

2014 Calculations

1 Working capital turnover = Net sales ÷ Working capital
= 473,076 ÷ -8,160 = –

Ratio Description The company
Working capital turnover An activity ratio calculated as revenue divided by working capital.

ADVERTISEMENT

Top


Average Inventory Processing Period

Wal-Mart Stores Inc., average inventory processing period calculation, comparison to benchmarks

 
Jan 31, 2014 Jan 31, 2013 Jan 31, 2012 Jan 31, 2011 Jan 31, 2010 Jan 31, 2009
Selected Financial Data
Inventory turnover 7.98 8.05 8.23 8.68 9.19 8.87
Ratio (no. of days)
Average inventory processing period1 46 45 44 42 40 41
Benchmarks (no. of days)
Average Inventory Processing Period, Competitors
Amazon.com Inc. 50 48 49 44 42
Target Corp. 63 57 60 61 59 55
Average Inventory Processing Period, Sector
Broadline Retailers 47 47 45 42 43
Average Inventory Processing Period, Industry
Consumer Services 43 43 43 44 44

Source: Based on data from Wal-Mart Stores Inc. Annual Reports

2014 Calculations

1 Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 7.98 = 46

Ratio Description The company
Average inventory processing period An activity ratio equal to the number of days in the period divided by inventory turnover over the period. Wal-Mart Stores Inc.'s average inventory processing period deteriorated from 2012 to 2013 and from 2013 to 2014.

Top


Average Receivable Collection Period

Wal-Mart Stores Inc., average receivable collection period calculation, comparison to benchmarks

 
Jan 31, 2014 Jan 31, 2013 Jan 31, 2012 Jan 31, 2011 Jan 31, 2010 Jan 31, 2009
Selected Financial Data
Receivables turnover 70.85 68.87 74.76 82.33 97.74 102.75
Ratio (no. of days)
Average receivable collection period1 5 5 5 4 4 4
Benchmarks (no. of days)
Average Receivable Collection Period, Competitors
Amazon.com Inc. 15 16 16 14 12
Target Corp. 32 34 40 47
Average Receivable Collection Period, Sector
Broadline Retailers 6 9 9 9 10
Average Receivable Collection Period, Industry
Consumer Services 17 18 18 17 16

Source: Based on data from Wal-Mart Stores Inc. Annual Reports

2014 Calculations

1 Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 70.85 = 5

Ratio Description The company
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnoverd.

ADVERTISEMENT

Top


Operating Cycle

Wal-Mart Stores Inc., operating cycle calculation, comparison to benchmarks

No. of days

 
Jan 31, 2014 Jan 31, 2013 Jan 31, 2012 Jan 31, 2011 Jan 31, 2010 Jan 31, 2009
Selected Financial Data
Average inventory processing period 46 45 44 42 40 41
Average receivable collection period 5 5 5 4 4 4
Ratio
Operating cycle1 51 50 49 46 44 45
Benchmarks
Operating Cycle, Competitors
Amazon.com Inc. 65 64 65 58 54
Target Corp. 92 95 99 102
Operating Cycle, Sector
Broadline Retailers 53 56 54 51 53
Operating Cycle, Industry
Consumer Services 60 61 61 61 60

Source: Based on data from Wal-Mart Stores Inc. Annual Reports

2014 Calculations

1 Operating cycle = Average inventory processing period + Average receivable collection period
= 46 + 5 = 51

Ratio Description The company
Operating cycle Equal to average inventory processing period plus average receivables collection period. Wal-Mart Stores Inc.'s operating cycle deteriorated from 2012 to 2013 and from 2013 to 2014.

Top


Average Payables Payment Period

Wal-Mart Stores Inc., average payables payment period calculation, comparison to benchmarks

 
Jan 31, 2014 Jan 31, 2013 Jan 31, 2012 Jan 31, 2011 Jan 31, 2010 Jan 31, 2009
Selected Financial Data
Payables turnover 9.57 9.26 9.15 9.40 10.00 10.61
Ratio (no. of days)
Average payables payment period1 38 39 40 39 36 34
Benchmarks (no. of days)
Average Payables Payment Period, Competitors
Amazon.com Inc. 102 106 109 111 108
Target Corp. 55 51 52 53 54 52
Average Payables Payment Period, Sector
Broadline Retailers 48 48 47 44 40
Average Payables Payment Period, Industry
Consumer Services 44 44 44 42 39

Source: Based on data from Wal-Mart Stores Inc. Annual Reports

2014 Calculations

1 Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 9.57 = 38

Ratio Description The company
Average payables payment period An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. Wal-Mart Stores Inc.'s average payables payment period declined from 2012 to 2013 and from 2013 to 2014.

ADVERTISEMENT

Top


Cash Conversion Cycle

Wal-Mart Stores Inc., cash conversion cycle calculation, comparison to benchmarks

No. of days

 
Jan 31, 2014 Jan 31, 2013 Jan 31, 2012 Jan 31, 2011 Jan 31, 2010 Jan 31, 2009
Selected Financial Data
Average inventory processing period 46 45 44 42 40 41
Average receivable collection period 5 5 5 4 4 4
Average payables payment period 38 39 40 39 36 34
Ratio
Cash conversion cycle1 13 11 9 7 8 11
Benchmarks
Cash Conversion Cycle, Competitors
Amazon.com Inc. -37 -42 -44 -53 -54
Target Corp. 40 42 45 50
Cash Conversion Cycle, Sector
Broadline Retailers 5 8 7 7 13
Cash Conversion Cycle, Industry
Consumer Services 16 17 17 19 21

Source: Based on data from Wal-Mart Stores Inc. Annual Reports

2014 Calculations

1 Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 46 + 5 – 38 = 13

Ratio Description The company
Cash conversion cycle A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. Wal-Mart Stores Inc.'s cash conversion cycle deteriorated from 2012 to 2013 and from 2013 to 2014.

Top