Microsoft Excel LibreOffice Calc

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

Paying users zone. Data is hidden behind: .

  • Get 1-month access to Lowe’s Cos. Inc. for $17.99, or

  • get full access to the entire website for at least 3 months from $49.99.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Apple Pay Google Pay
Verified by Visa MasterCard SecureCode American Express SafeKey

This is a one-time payment. There is no automatic renewal.


Return on Capital (ROC)

Advanced level

Return on capital (ROC) is after tax rate of return on net business assets. ROIC is unaffected by changes in interest rates or company’s debt and equity structure. It measures business productivity performance.


Return on Invested Capital (ROIC)

Lowe’s Cos. Inc., ROIC calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Jan 31, 2020 Feb 1, 2019 Feb 2, 2018 Feb 3, 2017 Jan 29, 2016 Jan 30, 2015
Selected Financial Data (US$ in millions)
Net operating profit after taxes (NOPAT)1
Invested capital2
Performance Ratio
ROIC3
Benchmarks
ROIC, Competitors4
Amazon.com Inc.
Costco Wholesale Corp.
Dollar General Corp.
Home Depot Inc.
Target Corp.
TJX Cos. Inc.
Walmart Inc.

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).

1 NOPAT. See details »

2 Invested capital. See details »

3 2020 Calculation
ROIC = 100 × NOPAT ÷ Invested capital
= 100 × ÷ =

4 Click competitor name to see calculations.

Performance ratio Description The company
ROIC A measure of the periodic, after tax, cash-on-cash yield earned in the business. Lowe’s Cos. Inc.’s ROIC deteriorated from 2018 to 2019 but then improved from 2019 to 2020 exceeding 2018 level.

Decomposition of ROIC

Lowe’s Cos. Inc., decomposition of ROIC

Microsoft Excel LibreOffice Calc
ROIC = OPM1 × TO2 × 1 – CTR3
Jan 31, 2020 = × ×
Feb 1, 2019 = × ×
Feb 2, 2018 = × ×
Feb 3, 2017 = × ×
Jan 29, 2016 = × ×
Jan 30, 2015 = × ×

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).

1 Operating profit margin (OPM). See calculations »

2 Turnover of capital (TO). See calculations »

3 Effective cash tax rate (CTR). See calculations »

The primary reason for the increase in return on invested capital (ROIC) over 2020 year is the increase in profitability measured by operating profit margin (OPM) ratio.


Operating Profit Margin (OPM)

Lowe’s Cos. Inc., OPM calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Jan 31, 2020 Feb 1, 2019 Feb 2, 2018 Feb 3, 2017 Jan 29, 2016 Jan 30, 2015
Selected Financial Data (US$ in millions)
Net operating profit after taxes (NOPAT)1
Add: Cash operating taxes2
Net operating profit before taxes (NOPBT)
 
Net sales
Add: Increase (decrease) in deferred revenue
Adjusted net sales
Profitability Ratio
OPM3
Benchmarks
OPM, Competitors4
Amazon.com Inc.
Costco Wholesale Corp.
Dollar General Corp.
Home Depot Inc.
Target Corp.
TJX Cos. Inc.
Walmart Inc.

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).

1 NOPAT. See details »

2 Cash operating taxes. See details »

3 2020 Calculation
OPM = 100 × NOPBT ÷ Adjusted net sales
= 100 × ÷ =

4 Click competitor name to see calculations.

Profitability ratio Description The company
OPM The operating profit margin (OPM) is the ratio of pretax economic earnings, or NOPBT, to sales. Lowe’s Cos. Inc.’s OPM deteriorated from 2018 to 2019 but then improved from 2019 to 2020 not reaching 2018 level.

Turnover of Capital (TO)

Lowe’s Cos. Inc., TO calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Jan 31, 2020 Feb 1, 2019 Feb 2, 2018 Feb 3, 2017 Jan 29, 2016 Jan 30, 2015
Selected Financial Data (US$ in millions)
Net sales
Add: Increase (decrease) in deferred revenue
Adjusted net sales
 
Invested capital1
Efficiency Ratio
TO2
Benchmarks
TO, Competitors3
Amazon.com Inc.
Costco Wholesale Corp.
Dollar General Corp.
Home Depot Inc.
Target Corp.
TJX Cos. Inc.
Walmart Inc.

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).

1 Invested capital. See details »

2 2020 Calculation
TO = Adjusted net sales ÷ Invested capital
= ÷ =

3 Click competitor name to see calculations.

Efficiency ratio Description The company
TO The turnover of capital (TO) is the ratio of sales to invested capital. Capital turnover is a function of the efficiency of working capital management and of net fixed assets. Lowe’s Cos. Inc.’s TO improved from 2018 to 2019 but then slightly deteriorated from 2019 to 2020.

Effective Cash Tax Rate (CTR)

Lowe’s Cos. Inc., CTR calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Jan 31, 2020 Feb 1, 2019 Feb 2, 2018 Feb 3, 2017 Jan 29, 2016 Jan 30, 2015
Selected Financial Data (US$ in millions)
Net operating profit after taxes (NOPAT)1
Add: Cash operating taxes2
Net operating profit before taxes (NOPBT)
Tax Rate
CTR3
Benchmarks
CTR, Competitors4
Amazon.com Inc.
Costco Wholesale Corp.
Dollar General Corp.
Home Depot Inc.
Target Corp.
TJX Cos. Inc.
Walmart Inc.

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).

1 NOPAT. See details »

2 Cash operating taxes. See details »

3 2020 Calculation
CTR = 100 × Cash operating taxes ÷ NOPBT
= 100 × ÷ =

4 Click competitor name to see calculations.

Tax rate Description The company
CTR Effective cash tax rate on operating income. Lowe’s Cos. Inc.’s CTR decreased from 2018 to 2019 and from 2019 to 2020.