Microsoft Excel LibreOffice Calc

Lowe’s Cos. Inc. (NYSE:LOW)

Price to Earnings (P/E)
since 2005

Beginner level

Calculation

Lowe’s Cos. Inc., P/E, long-term trends, calculation

Microsoft Excel LibreOffice Calc
P/E = Share price1, 2, 3 ÷ Earnings per share1 (EPS) EPS1 = Net earnings1
(in millions)		 ÷ No. shares of common stock outstanding2
Jan 31, 2020 11.96 = 67.80 ÷ 5.67 5.67 = 4,281 ÷ 754,948,648
Feb 1, 2019 37.80 = 109.91 ÷ 2.91 2.91 = 2,314 ÷ 795,922,717
Feb 2, 2018 20.26 = 84.59 ÷ 4.17 4.17 = 3,447 ÷ 825,766,281
Feb 3, 2017 22.62 = 81.59 ÷ 3.61 3.61 = 3,093 ÷ 857,332,918
Jan 29, 2016 26.67 = 75.67 ÷ 2.84 2.84 = 2,546 ÷ 897,438,629
Jan 30, 2015 26.24 = 74.39 ÷ 2.83 2.83 = 2,698 ÷ 951,704,640
Jan 31, 2014 21.79 = 48.90 ÷ 2.24 2.24 = 2,286 ÷ 1,018,776,409
Feb 1, 2013 21.13 = 38.02 ÷ 1.80 1.80 = 1,959 ÷ 1,088,511,808
Feb 3, 2012 20.46 = 31.38 ÷ 1.53 1.53 = 1,839 ÷ 1,198,910,882
Jan 28, 2011 17.66 = 26.93 ÷ 1.52 1.52 = 2,010 ÷ 1,318,320,422
Jan 29, 2010 19.70 = 24.34 ÷ 1.24 1.24 = 1,783 ÷ 1,443,389,268
Jan 30, 2009 12.26 = 18.25 ÷ 1.49 1.49 = 2,195 ÷ 1,474,239,704
Feb 1, 2008 12.74 = 24.49 ÷ 1.92 1.92 = 2,809 ÷ 1,461,815,744
Feb 2, 2007 15.42 = 31.70 ÷ 2.06 2.06 = 3,105 ÷ 1,510,309,351
Feb 3, 2006 18.31 = 32.70 ÷ 1.79 1.79 = 2,771 ÷ 1,551,613,794
Jan 28, 2005 19.15 = 26.91 ÷ 1.40 1.40 = 2,176 ÷ 1,548,843,626

Based on: 10-K (filing date: 2020-03-23), 10-K (filing date: 2019-04-02), 10-K (filing date: 2018-04-02), 10-K (filing date: 2017-04-04), 10-K (filing date: 2016-03-29), 10-K (filing date: 2015-03-31), 10-K (filing date: 2014-03-31), 10-K (filing date: 2013-04-02), 10-K (filing date: 2012-04-02), 10-K (filing date: 2011-03-29), 10-K (filing date: 2010-03-30), 10-K (filing date: 2009-03-31), 10-K (filing date: 2008-04-01), 10-K (filing date: 2007-04-03), 10-K (filing date: 2006-04-07), 10-K (filing date: 2005-04-13).

1 US$

2 Data adjusted for splits and stock dividends.

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

Comparison to Competitors

Lowe’s Cos. Inc., P/E, long-term trends, comparison to competitors

Microsoft Excel LibreOffice Calc
Lowe’s Cos. Inc. Amazon.com Inc. Costco Wholesale Corp. Dollar General Corp. Home Depot Inc. Target Corp. TJX Cos. Inc. Walmart Inc.
Jan 31, 2020 11.96 — — 21.04 17.38 16.12 17.13 21.69
Feb 1, 2019 37.80 86.29 35.76 19.18 18.87 13.56 21.11 41.79
Feb 2, 2018 20.26 79.30 30.51 15.73 23.51 12.97 20.19 26.62
Feb 3, 2017 22.62 228.24 25.70 15.28 22.37 11.11 22.11 16.02
Jan 29, 2016 26.67 166.53 27.99 20.63 23.32 14.61 22.87 14.72
Jan 30, 2015 26.24 463.73 27.57 21.58 23.15 — 21.62 15.91
Jan 31, 2014 21.79 — 26.44 17.61 20.18 19.07 20.15 15.34
Feb 1, 2013 21.13 601.22 25.15 17.54 22.86 14.65 17.99 14.48
Feb 3, 2012 20.46 — 23.98 20.35 19.49 13.41 19.73 13.25
Jan 28, 2011 17.66 129.42 24.24 16.78 18.15 12.23 14.54 11.15
Jan 29, 2010 19.70 67.00 20.97 25.35 20.76 15.77 14.57 14.66
Jan 30, 2009 12.26 61.81 23.48 — 18.59 10.19 12.02 15.43
Feb 1, 2008 12.74 39.08 19.45 — 11.24 14.43 18.61 16.36
Feb 2, 2007 15.42 65.84 25.99 — 12.59 18.35 16.30 17.36
Feb 3, 2006 18.31 88.02 22.18 — 15.57 18.67 16.91 17.83
Jan 28, 2005 19.15 45.51 22.23 — 16.29 13.78 17.81 20.66

Based on: 10-K (filing date: 2020-03-23), 10-K (filing date: 2019-04-02), 10-K (filing date: 2018-04-02), 10-K (filing date: 2017-04-04), 10-K (filing date: 2016-03-29), 10-K (filing date: 2015-03-31), 10-K (filing date: 2014-03-31), 10-K (filing date: 2013-04-02), 10-K (filing date: 2012-04-02), 10-K (filing date: 2011-03-29), 10-K (filing date: 2010-03-30), 10-K (filing date: 2009-03-31), 10-K (filing date: 2008-04-01), 10-K (filing date: 2007-04-03), 10-K (filing date: 2006-04-07), 10-K (filing date: 2005-04-13).

Comparison to Sector (General Retailers)

Lowe’s Cos. Inc., P/E, long-term trends, comparison to sector (general retailers)

Microsoft Excel LibreOffice Calc
Lowe’s Cos. Inc. General Retailers
Jan 31, 2020 11.96 —
Feb 1, 2019 37.80 42.89
Feb 2, 2018 20.26 36.58
Feb 3, 2017 22.62 36.19
Jan 29, 2016 26.67 28.89
Jan 30, 2015 26.24 31.37
Jan 31, 2014 21.79 23.56
Feb 1, 2013 21.13 22.18
Feb 3, 2012 20.46 20.18
Jan 28, 2011 17.66 16.08
Jan 29, 2010 19.70 18.62
Jan 30, 2009 12.26 17.01
Feb 1, 2008 12.74 15.66
Feb 2, 2007 15.42 17.39
Feb 3, 2006 18.31 18.14
Jan 28, 2005 19.15 18.97

Based on: 10-K (filing date: 2020-03-23), 10-K (filing date: 2019-04-02), 10-K (filing date: 2018-04-02), 10-K (filing date: 2017-04-04), 10-K (filing date: 2016-03-29), 10-K (filing date: 2015-03-31), 10-K (filing date: 2014-03-31), 10-K (filing date: 2013-04-02), 10-K (filing date: 2012-04-02), 10-K (filing date: 2011-03-29), 10-K (filing date: 2010-03-30), 10-K (filing date: 2009-03-31), 10-K (filing date: 2008-04-01), 10-K (filing date: 2007-04-03), 10-K (filing date: 2006-04-07), 10-K (filing date: 2005-04-13).

Comparison to Industry (Consumer Services)

Lowe’s Cos. Inc., P/E, long-term trends, comparison to industry (consumer services)

Microsoft Excel LibreOffice Calc
Lowe’s Cos. Inc. Consumer Services
Jan 31, 2020 11.96 —
Feb 1, 2019 37.80 31.72
Feb 2, 2018 20.26 29.01
Feb 3, 2017 22.62 23.39
Jan 29, 2016 26.67 25.44
Jan 30, 2015 26.24 27.27
Jan 31, 2014 21.79 23.33
Feb 1, 2013 21.13 23.10
Feb 3, 2012 20.46 19.29
Jan 28, 2011 17.66 16.83
Jan 29, 2010 19.70 18.53
Jan 30, 2009 12.26 16.47
Feb 1, 2008 12.74 14.17
Feb 2, 2007 15.42 18.41
Feb 3, 2006 18.31 19.92
Jan 28, 2005 19.15 21.04

Based on: 10-K (filing date: 2020-03-23), 10-K (filing date: 2019-04-02), 10-K (filing date: 2018-04-02), 10-K (filing date: 2017-04-04), 10-K (filing date: 2016-03-29), 10-K (filing date: 2015-03-31), 10-K (filing date: 2014-03-31), 10-K (filing date: 2013-04-02), 10-K (filing date: 2012-04-02), 10-K (filing date: 2011-03-29), 10-K (filing date: 2010-03-30), 10-K (filing date: 2009-03-31), 10-K (filing date: 2008-04-01), 10-K (filing date: 2007-04-03), 10-K (filing date: 2006-04-07), 10-K (filing date: 2005-04-13).