Price to Sales (P/S)
since 2005
Difficulty: Beginner
Calculation
Walmart Inc., P/S, long-term trends, calculation
| P/S | = | Share price1, 2, 3 | ÷ | Sales per share1 | Sales per share1 | = | Net sales1 (in millions) |
÷ | No. shares of common stock outstanding2 | |
|---|---|---|---|---|---|---|---|---|---|---|
| Jan 31, 2005 | 0.74 | = | 50.11 | ÷ | 67.38 | 67.38 | = | 285,222 | ÷ | 4,233,002,095 |
| Jan 31, 2006 | 0.64 | = | 48.05 | ÷ | 74.97 | 74.97 | = | 312,427 | ÷ | 4,167,233,525 |
| Jan 31, 2007 | 0.57 | = | 47.49 | ÷ | 83.65 | 83.65 | = | 344,992 | ÷ | 4,124,451,341 |
| Jan 31, 2008 | 0.56 | = | 52.68 | ÷ | 94.71 | 94.71 | = | 374,526 | ÷ | 3,954,458,057 |
| Jan 31, 2009 | 0.52 | = | 52.82 | ÷ | 102.49 | 102.49 | = | 401,244 | ÷ | 3,915,118,871 |
| Jan 31, 2010 | 0.52 | = | 55.91 | ÷ | 107.75 | 107.75 | = | 405,046 | ÷ | 3,759,007,514 |
| Jan 31, 2011 | 0.44 | = | 52.36 | ÷ | 120.00 | 120.00 | = | 418,952 | ÷ | 3,491,198,520 |
| Jan 31, 2012 | 0.47 | = | 61.09 | ÷ | 130.37 | 130.37 | = | 443,854 | ÷ | 3,404,538,468 |
| Jan 31, 2013 | 0.53 | = | 74.77 | ÷ | 141.57 | 141.57 | = | 466,114 | ÷ | 3,292,443,366 |
| Jan 31, 2014 | 0.52 | = | 76.10 | ÷ | 146.50 | 146.50 | = | 473,076 | ÷ | 3,229,175,401 |
| Jan 31, 2015 | 0.54 | = | 80.71 | ÷ | 149.48 | 149.48 | = | 482,229 | ÷ | 3,226,062,652 |
| Jan 31, 2016 | 0.45 | = | 68.80 | ÷ | 152.21 | 152.21 | = | 478,614 | ÷ | 3,144,335,104 |
| Jan 31, 2017 | 0.45 | = | 72.08 | ÷ | 158.69 | 158.69 | = | 481,317 | ÷ | 3,033,009,079 |
| Jan 31, 2018 | 0.53 | = | 88.97 | ÷ | 168.01 | 168.01 | = | 495,761 | ÷ | 2,950,696,818 |
Based on: 10-K (filing date: 2005-03-31), 10-K (filing date: 2006-03-29), 10-K (filing date: 2007-03-27), 10-K (filing date: 2008-03-31), 10-K (filing date: 2009-04-01), 10-K (filing date: 2010-03-30), 10-K (filing date: 2011-03-30), 10-K (filing date: 2012-03-27), 10-K (filing date: 2013-03-26), 10-K (filing date: 2014-03-21), 10-K (filing date: 2015-04-01), 10-K (filing date: 2016-03-30), 10-K (filing date: 2017-03-31), 10-K (filing date: 2018-03-30).
1 USD $
2 Data adjusted for splits and stock dividends.
3 Close price on the filing date of Walmart Inc.'s Annual Report.
Comparison to Competitors
Walmart Inc., P/S, long-term trends, comparison to competitors
| Walmart Inc. | Amazon.com Inc. | Costco Wholesale Corp. | eBay Inc. | Home Depot Inc. | Lowe's Cos. Inc. | Netflix Inc. | Target Corp. | TJX Cos. Inc. | |
|---|---|---|---|---|---|---|---|---|---|
| Jan 31, 2005 | 0.74 | 1.92 | 0.46 | 12.82 | 1.11 | 1.14 | 2.07 | 0.96 | 0.79 |
| Jan 31, 2006 | 0.64 | 1.56 | 0.42 | 7.35 | 1.11 | 1.17 | 1.55 | 0.88 | 0.73 |
| Jan 31, 2007 | 0.57 | 2.11 | 0.45 | 4.56 | 0.80 | 1.02 | 1.60 | 0.88 | 0.69 |
| Jan 31, 2008 | 0.56 | 1.32 | 0.35 | 1.83 | 0.64 | 0.74 | 1.54 | 0.67 | 0.77 |
| Jan 31, 2009 | 0.52 | 2.27 | 0.36 | 3.38 | 0.59 | 0.56 | 2.09 | 0.36 | 0.56 |
| Jan 31, 2010 | 0.52 | 2.26 | 0.36 | 4.30 | 0.83 | 0.74 | 5.76 | 0.62 | 0.87 |
| Jan 31, 2011 | 0.44 | 1.70 | 0.41 | 3.49 | 0.89 | 0.73 | 2.14 | 0.54 | 0.89 |
| Jan 31, 2012 | 0.47 | 2.03 | 0.42 | 5.27 | 1.08 | 0.75 | 2.56 | 0.57 | 1.27 |
| Jan 31, 2013 | 0.53 | 2.21 | 0.50 | 4.29 | 1.39 | 0.82 | 5.53 | 0.61 | 1.33 |
| Jan 31, 2014 | 0.52 | 1.85 | 0.49 | 3.68 | 1.38 | 0.93 | 4.88 | 0.52 | 1.57 |
| Jan 31, 2015 | 0.54 | 2.58 | 0.58 | 3.28 | 1.77 | 1.26 | 5.96 | 0.70 | 1.65 |
| Jan 31, 2016 | 0.45 | 2.90 | 0.57 | 3.88 | 1.85 | 1.15 | 6.94 | 0.67 | 1.68 |
| Jan 31, 2017 | 0.45 | 3.89 | 0.55 | 4.48 | 1.88 | 1.08 | 10.56 | 0.44 | 1.53 |
| Jan 31, 2018 | 0.53 | – | 0.69 | – | 2.01 | 1.02 | – | 0.53 | 1.47 |
Based on: 10-K (filing date: 2005-03-31), 10-K (filing date: 2006-03-29), 10-K (filing date: 2007-03-27), 10-K (filing date: 2008-03-31), 10-K (filing date: 2009-04-01), 10-K (filing date: 2010-03-30), 10-K (filing date: 2011-03-30), 10-K (filing date: 2012-03-27), 10-K (filing date: 2013-03-26), 10-K (filing date: 2014-03-21), 10-K (filing date: 2015-04-01), 10-K (filing date: 2016-03-30), 10-K (filing date: 2017-03-31), 10-K (filing date: 2018-03-30).
Comparison to General Retailers Sector
Walmart Inc., P/S, long-term trends, comparison to General Retailers sector
| Walmart Inc. | General Retailers | |
|---|---|---|
| Jan 31, 2005 | 0.74 | 0.94 |
| Jan 31, 2006 | 0.64 | 0.83 |
| Jan 31, 2007 | 0.57 | 0.74 |
| Jan 31, 2008 | 0.56 | 0.61 |
| Jan 31, 2009 | 0.52 | 0.60 |
| Jan 31, 2010 | 0.52 | 0.71 |
| Jan 31, 2011 | 0.44 | 0.64 |
| Jan 31, 2012 | 0.47 | 0.77 |
| Jan 31, 2013 | 0.53 | 0.88 |
| Jan 31, 2014 | 0.52 | 0.86 |
| Jan 31, 2015 | 0.54 | 1.03 |
| Jan 31, 2016 | 0.45 | 1.10 |
| Jan 31, 2017 | 0.45 | 1.38 |
| Jan 31, 2018 | 0.53 | – |
Based on: 10-K (filing date: 2005-03-31), 10-K (filing date: 2006-03-29), 10-K (filing date: 2007-03-27), 10-K (filing date: 2008-03-31), 10-K (filing date: 2009-04-01), 10-K (filing date: 2010-03-30), 10-K (filing date: 2011-03-30), 10-K (filing date: 2012-03-27), 10-K (filing date: 2013-03-26), 10-K (filing date: 2014-03-21), 10-K (filing date: 2015-04-01), 10-K (filing date: 2016-03-30), 10-K (filing date: 2017-03-31), 10-K (filing date: 2018-03-30).
Comparison to Consumer Services Industry
Walmart Inc., P/S, long-term trends, comparison to Consumer Services industry
| Walmart Inc. | Consumer Services | |
|---|---|---|
| Jan 31, 2005 | 0.74 | 1.12 |
| Jan 31, 2006 | 0.64 | 1.09 |
| Jan 31, 2007 | 0.57 | 0.92 |
| Jan 31, 2008 | 0.56 | 0.66 |
| Jan 31, 2009 | 0.52 | 0.72 |
| Jan 31, 2010 | 0.52 | 0.85 |
| Jan 31, 2011 | 0.44 | 0.82 |
| Jan 31, 2012 | 0.47 | 0.93 |
| Jan 31, 2013 | 0.53 | 1.15 |
| Jan 31, 2014 | 0.52 | 1.17 |
| Jan 31, 2015 | 0.54 | 1.28 |
| Jan 31, 2016 | 0.45 | 1.30 |
| Jan 31, 2017 | 0.45 | 1.47 |
| Jan 31, 2018 | 0.53 | – |
Based on: 10-K (filing date: 2005-03-31), 10-K (filing date: 2006-03-29), 10-K (filing date: 2007-03-27), 10-K (filing date: 2008-03-31), 10-K (filing date: 2009-04-01), 10-K (filing date: 2010-03-30), 10-K (filing date: 2011-03-30), 10-K (filing date: 2012-03-27), 10-K (filing date: 2013-03-26), 10-K (filing date: 2014-03-21), 10-K (filing date: 2015-04-01), 10-K (filing date: 2016-03-30), 10-K (filing date: 2017-03-31), 10-K (filing date: 2018-03-30).