Microsoft Excel LibreOffice Calc

Walmart Inc. (NYSE:WMT)

Price to Sales (P/S)
since 2005

Beginner level

Calculation

Walmart Inc., P/S, long-term trends, calculation

Microsoft Excel LibreOffice Calc
P/S = Share price1, 2, 3 ÷ Sales per share1 Sales per share1 = Net sales1
(in millions)		 ÷ No. shares of common stock outstanding2
Jan 31, 2020 0.62 = 113.97 ÷ 183.57 183.57 = 519,926 ÷ 2,832,277,220
Jan 31, 2019 0.55 = 97.13 ÷ 177.83 177.83 = 510,329 ÷ 2,869,684,230
Jan 31, 2018 0.53 = 88.97 ÷ 168.01 168.01 = 495,761 ÷ 2,950,696,818
Jan 31, 2017 0.45 = 72.08 ÷ 158.69 158.69 = 481,317 ÷ 3,033,009,079
Jan 31, 2016 0.45 = 68.80 ÷ 152.21 152.21 = 478,614 ÷ 3,144,335,104
Jan 31, 2015 0.54 = 80.71 ÷ 149.48 149.48 = 482,229 ÷ 3,226,062,652
Jan 31, 2014 0.52 = 76.10 ÷ 146.50 146.50 = 473,076 ÷ 3,229,175,401
Jan 31, 2013 0.53 = 74.77 ÷ 141.57 141.57 = 466,114 ÷ 3,292,443,366
Jan 31, 2012 0.47 = 61.09 ÷ 130.37 130.37 = 443,854 ÷ 3,404,538,468
Jan 31, 2011 0.44 = 52.36 ÷ 120.00 120.00 = 418,952 ÷ 3,491,198,520
Jan 31, 2010 0.52 = 55.91 ÷ 107.75 107.75 = 405,046 ÷ 3,759,007,514
Jan 31, 2009 0.52 = 52.82 ÷ 102.49 102.49 = 401,244 ÷ 3,915,118,871
Jan 31, 2008 0.56 = 52.68 ÷ 94.71 94.71 = 374,526 ÷ 3,954,458,057
Jan 31, 2007 0.57 = 47.49 ÷ 83.65 83.65 = 344,992 ÷ 4,124,451,341
Jan 31, 2006 0.64 = 48.05 ÷ 74.97 74.97 = 312,427 ÷ 4,167,233,525
Jan 31, 2005 0.74 = 50.11 ÷ 67.38 67.38 = 285,222 ÷ 4,233,002,095

Based on: 10-K (filing date: 2020-03-20), 10-K (filing date: 2019-03-28), 10-K (filing date: 2018-03-30), 10-K (filing date: 2017-03-31), 10-K (filing date: 2016-03-30), 10-K (filing date: 2015-04-01), 10-K (filing date: 2014-03-21), 10-K (filing date: 2013-03-26), 10-K (filing date: 2012-03-27), 10-K (filing date: 2011-03-30), 10-K (filing date: 2010-03-30), 10-K (filing date: 2009-04-01), 10-K (filing date: 2008-03-31), 10-K (filing date: 2007-03-27), 10-K (filing date: 2006-03-29), 10-K (filing date: 2005-03-31).

1 US$

2 Data adjusted for splits and stock dividends.

3 Closing price as at the filing date of Walmart Inc.’s Annual Report.

Comparison to Competitors

Walmart Inc., P/S, long-term trends, comparison to competitors

Microsoft Excel LibreOffice Calc
Walmart Inc. Amazon.com Inc. Costco Wholesale Corp. Dollar General Corp. Home Depot Inc. Lowe’s Cos. Inc. Target Corp. TJX Cos. Inc.
Jan 31, 2020 0.62 — — 1.30 1.77 0.71 0.69 1.34
Jan 31, 2019 0.55 3.56 0.88 1.19 1.94 1.23 0.53 1.66
Jan 31, 2018 0.53 3.43 0.69 1.03 2.01 1.02 0.53 1.47
Jan 31, 2017 0.45 3.89 0.55 0.87 1.88 1.08 0.44 1.53
Jan 31, 2016 0.45 2.90 0.57 1.18 1.85 1.15 0.67 1.68
Jan 31, 2015 0.54 2.58 0.58 1.22 1.77 1.26 0.70 1.65
Jan 31, 2014 0.52 1.85 0.49 1.03 1.38 0.93 0.52 1.57
Jan 31, 2013 0.53 2.21 0.50 1.04 1.39 0.82 0.61 1.33
Jan 31, 2012 0.47 2.03 0.42 1.05 1.08 0.75 0.57 1.27
Jan 31, 2011 0.44 1.70 0.41 0.81 0.89 0.73 0.54 0.89
Jan 31, 2010 0.52 2.26 0.36 0.73 0.83 0.74 0.62 0.87
Jan 31, 2009 0.52 2.27 0.36 — 0.59 0.56 0.36 0.56
Jan 31, 2008 0.56 1.32 0.35 — 0.64 0.74 0.67 0.77
Jan 31, 2007 0.57 2.11 0.45 — 0.80 1.02 0.88 0.69
Jan 31, 2006 0.64 1.56 0.42 — 1.11 1.17 0.88 0.73
Jan 31, 2005 0.74 1.92 0.46 — 1.11 1.14 0.96 0.79

Based on: 10-K (filing date: 2020-03-20), 10-K (filing date: 2019-03-28), 10-K (filing date: 2018-03-30), 10-K (filing date: 2017-03-31), 10-K (filing date: 2016-03-30), 10-K (filing date: 2015-04-01), 10-K (filing date: 2014-03-21), 10-K (filing date: 2013-03-26), 10-K (filing date: 2012-03-27), 10-K (filing date: 2011-03-30), 10-K (filing date: 2010-03-30), 10-K (filing date: 2009-04-01), 10-K (filing date: 2008-03-31), 10-K (filing date: 2007-03-27), 10-K (filing date: 2006-03-29), 10-K (filing date: 2005-03-31).

Comparison to Sector (General Retailers)

Walmart Inc., P/S, long-term trends, comparison to sector (general retailers)

Microsoft Excel LibreOffice Calc
Walmart Inc. General Retailers
Jan 31, 2020 0.62 —
Jan 31, 2019 0.55 1.46
Jan 31, 2018 0.53 1.32
Jan 31, 2017 0.45 1.24
Jan 31, 2016 0.45 1.03
Jan 31, 2015 0.54 0.98
Jan 31, 2014 0.52 0.78
Jan 31, 2013 0.53 0.80
Jan 31, 2012 0.47 0.69
Jan 31, 2011 0.44 0.60
Jan 31, 2010 0.52 0.65
Jan 31, 2009 0.52 0.56
Jan 31, 2008 0.56 0.60
Jan 31, 2007 0.57 0.69
Jan 31, 2006 0.64 0.77
Jan 31, 2005 0.74 0.84

Based on: 10-K (filing date: 2020-03-20), 10-K (filing date: 2019-03-28), 10-K (filing date: 2018-03-30), 10-K (filing date: 2017-03-31), 10-K (filing date: 2016-03-30), 10-K (filing date: 2015-04-01), 10-K (filing date: 2014-03-21), 10-K (filing date: 2013-03-26), 10-K (filing date: 2012-03-27), 10-K (filing date: 2011-03-30), 10-K (filing date: 2010-03-30), 10-K (filing date: 2009-04-01), 10-K (filing date: 2008-03-31), 10-K (filing date: 2007-03-27), 10-K (filing date: 2006-03-29), 10-K (filing date: 2005-03-31).

Comparison to Industry (Consumer Services)

Walmart Inc., P/S, long-term trends, comparison to industry (consumer services)

Microsoft Excel LibreOffice Calc
Walmart Inc. Consumer Services
Jan 31, 2020 0.62 —
Jan 31, 2019 0.55 1.55
Jan 31, 2018 0.53 1.44
Jan 31, 2017 0.45 1.44
Jan 31, 2016 0.45 1.28
Jan 31, 2015 0.54 1.26
Jan 31, 2014 0.52 1.10
Jan 31, 2013 0.53 1.09
Jan 31, 2012 0.47 0.88
Jan 31, 2011 0.44 0.79
Jan 31, 2010 0.52 0.82
Jan 31, 2009 0.52 0.70
Jan 31, 2008 0.56 0.65
Jan 31, 2007 0.57 0.86
Jan 31, 2006 0.64 0.99
Jan 31, 2005 0.74 1.00

Based on: 10-K (filing date: 2020-03-20), 10-K (filing date: 2019-03-28), 10-K (filing date: 2018-03-30), 10-K (filing date: 2017-03-31), 10-K (filing date: 2016-03-30), 10-K (filing date: 2015-04-01), 10-K (filing date: 2014-03-21), 10-K (filing date: 2013-03-26), 10-K (filing date: 2012-03-27), 10-K (filing date: 2011-03-30), 10-K (filing date: 2010-03-30), 10-K (filing date: 2009-04-01), 10-K (filing date: 2008-03-31), 10-K (filing date: 2007-03-27), 10-K (filing date: 2006-03-29), 10-K (filing date: 2005-03-31).