Stock Analysis on Net
Stock Analysis on Net

Target Corp. (NYSE:TGT)

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Beginner level


Long-term Activity Ratios (Summary)

Target Corp., long-term (investment) activity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
May 2, 2020 Feb 1, 2020 Nov 2, 2019 Aug 3, 2019 May 4, 2019 Feb 2, 2019 Nov 3, 2018 Aug 4, 2018 May 5, 2018 Feb 3, 2018 Oct 28, 2017 Jul 29, 2017 Apr 29, 2017 Jan 28, 2017 Oct 29, 2016 Jul 30, 2016 Apr 30, 2016 Jan 30, 2016 Oct 31, 2015 Aug 1, 2015 May 2, 2015 Jan 31, 2015 Nov 1, 2014 Aug 2, 2014 May 3, 2014
Net fixed asset turnover 2.97 2.93 2.91 2.92 2.93 2.92 2.91 2.92 2.92 2.87 2.78 2.80 2.81 2.82 2.83 2.87 2.91 2.93 2.90 2.87 2.83 2.80
Net fixed asset turnover (including operating lease, right-of-use asset) 2.74 2.70 2.69 2.70 2.72 2.71 2.70 2.71 2.71 2.87 2.78 2.80 2.81 2.82 2.83 2.87 2.91 2.93 2.90 2.87 2.83 2.80
Total asset turnover 1.77 1.80 1.75 1.83 1.85 1.80 1.71 1.84 1.86 1.84 1.71 1.86 1.86 1.86 1.82 1.92 1.83 1.83 1.77 1.82 1.81 1.75
Equity turnover 7.08 6.52 6.65 6.41 6.77 6.59 6.72 6.59 6.49 6.14 6.27 6.27 6.29 6.34 6.36 6.19 5.81 5.69 5.58 5.28 5.16 5.19

Based on: 10-Q (filing date: 2020-05-29), 10-K (filing date: 2020-03-11), 10-Q (filing date: 2019-11-27), 10-Q (filing date: 2019-08-30), 10-Q (filing date: 2019-05-31), 10-K (filing date: 2019-03-13), 10-Q (filing date: 2018-11-27), 10-Q (filing date: 2018-08-27), 10-Q (filing date: 2018-05-29), 10-K (filing date: 2018-03-14), 10-Q (filing date: 2017-11-20), 10-Q (filing date: 2017-08-21), 10-Q (filing date: 2017-05-22), 10-K (filing date: 2017-03-08), 10-Q (filing date: 2016-11-23), 10-Q (filing date: 2016-08-24), 10-Q (filing date: 2016-05-25), 10-K (filing date: 2016-03-11), 10-Q (filing date: 2015-11-25), 10-Q (filing date: 2015-08-25), 10-Q (filing date: 2015-05-28), 10-K (filing date: 2015-03-13), 10-Q (filing date: 2014-11-26), 10-Q (filing date: 2014-08-27), 10-Q (filing date: 2014-05-29).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Target Corp.’s net fixed asset turnover ratio improved from Q3 2020 to Q4 2020 and from Q4 2020 to Q1 2021.
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Target Corp.’s net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from Q3 2020 to Q4 2020 and from Q4 2020 to Q1 2021.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Target Corp.’s total asset turnover ratio improved from Q3 2020 to Q4 2020 but then slightly deteriorated from Q4 2020 to Q1 2021 not reaching Q3 2020 level.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Target Corp.’s equity turnover ratio deteriorated from Q3 2020 to Q4 2020 but then improved from Q4 2020 to Q1 2021 exceeding Q3 2020 level.

Net Fixed Asset Turnover

Target Corp., net fixed asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
May 2, 2020 Feb 1, 2020 Nov 2, 2019 Aug 3, 2019 May 4, 2019 Feb 2, 2019 Nov 3, 2018 Aug 4, 2018 May 5, 2018 Feb 3, 2018 Oct 28, 2017 Jul 29, 2017 Apr 29, 2017 Jan 28, 2017 Oct 29, 2016 Jul 30, 2016 Apr 30, 2016 Jan 30, 2016 Oct 31, 2015 Aug 1, 2015 May 2, 2015 Jan 31, 2015 Nov 1, 2014 Aug 2, 2014 May 3, 2014
Selected Financial Data (US$ in millions)
Sales 19,371  23,132  18,414  18,183  17,401  22,735  17,590  17,552  16,556  22,766  16,667  16,429  16,017  20,689  16,441  16,169  16,196  21,626  17,613  17,427  17,119  21,750  17,254  16,957  16,657 
Property and equipment, net 26,589  26,283  26,384  26,012  25,706  25,533  25,607  25,172  24,767  25,018  25,112  24,861  24,682  24,658  24,902  24,934  25,049  25,217  25,472  25,583  25,778  25,958  26,033  26,132  26,334 
Long-term Activity Ratio
Net fixed asset turnover1 2.97 2.93 2.91 2.92 2.93 2.92 2.91 2.92 2.92 2.87 2.78 2.80 2.81 2.82 2.83 2.87 2.91 2.93 2.90 2.87 2.83 2.80
Benchmarks
Net Fixed Asset Turnover, Competitors2
Amazon.com Inc. 3.81 3.86 3.92 3.89 3.96 3.77 3.81 3.80 3.69 3.64 3.55 4.05 4.37 4.67 4.71 4.79 4.87 4.90
Costco Wholesale Corp. 7.31 7.21 7.12 7.15 7.15 7.15 7.12 7.03 7.11 6.98 6.95 6.95 6.87 6.83 6.81 6.81 6.99 7.14 7.19 7.38 7.52 7.61 7.57
Dollar General Corp. 8.91 8.47 8.70 8.83 8.69 8.63 8.59 8.61 8.69 8.69 8.80 8.84 8.98 9.03 8.90 8.94 9.09 9.00 8.95 8.96 9.04 8.94
Home Depot Inc. 4.94 4.84 4.94 4.91 4.92 4.84 4.79 4.76 4.65 4.57 4.52 4.42 4.39 4.32 4.28 4.19 4.06 3.99 3.91 3.83 3.74 3.66
Lowe’s Cos. Inc. 4.00 3.86 3.91 3.94 3.95 3.87 3.76 3.68 3.54 3.48 3.48 3.43 3.37 3.26 3.12 3.01 3.09 3.02 2.97 2.92 2.86 2.81
TJX Cos. Inc. 7.08 7.83 7.74 7.94 7.88 7.42 7.51 7.40 7.32 7.16 7.07 7.15 7.26 7.32 7.57 7.54 7.48 7.48 7.45 7.48 7.48 7.52
Walmart Inc. 4.98 4.74 4.77 4.73 4.72 4.58 4.56 4.56 4.36 4.32 4.25 4.21 4.23 4.22 4.17 4.16 4.12 4.11 4.11 4.14 4.17 4.13

Based on: 10-Q (filing date: 2020-05-29), 10-K (filing date: 2020-03-11), 10-Q (filing date: 2019-11-27), 10-Q (filing date: 2019-08-30), 10-Q (filing date: 2019-05-31), 10-K (filing date: 2019-03-13), 10-Q (filing date: 2018-11-27), 10-Q (filing date: 2018-08-27), 10-Q (filing date: 2018-05-29), 10-K (filing date: 2018-03-14), 10-Q (filing date: 2017-11-20), 10-Q (filing date: 2017-08-21), 10-Q (filing date: 2017-05-22), 10-K (filing date: 2017-03-08), 10-Q (filing date: 2016-11-23), 10-Q (filing date: 2016-08-24), 10-Q (filing date: 2016-05-25), 10-K (filing date: 2016-03-11), 10-Q (filing date: 2015-11-25), 10-Q (filing date: 2015-08-25), 10-Q (filing date: 2015-05-28), 10-K (filing date: 2015-03-13), 10-Q (filing date: 2014-11-26), 10-Q (filing date: 2014-08-27), 10-Q (filing date: 2014-05-29).

1 Q1 2021 Calculation
Net fixed asset turnover = (SalesQ1 2021 + SalesQ4 2020 + SalesQ3 2020 + SalesQ2 2020) ÷ Property and equipment, net
= (19,371 + 23,132 + 18,414 + 18,183) ÷ 26,589 = 2.97

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Target Corp.’s net fixed asset turnover ratio improved from Q3 2020 to Q4 2020 and from Q4 2020 to Q1 2021.

Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)

Target Corp., net fixed asset turnover (including operating lease, right-of-use asset) calculation (quarterly data)

Microsoft Excel LibreOffice Calc
May 2, 2020 Feb 1, 2020 Nov 2, 2019 Aug 3, 2019 May 4, 2019 Feb 2, 2019 Nov 3, 2018 Aug 4, 2018 May 5, 2018 Feb 3, 2018 Oct 28, 2017 Jul 29, 2017 Apr 29, 2017 Jan 28, 2017 Oct 29, 2016 Jul 30, 2016 Apr 30, 2016 Jan 30, 2016 Oct 31, 2015 Aug 1, 2015 May 2, 2015 Jan 31, 2015 Nov 1, 2014 Aug 2, 2014 May 3, 2014
Selected Financial Data (US$ in millions)
Sales 19,371  23,132  18,414  18,183  17,401  22,735  17,590  17,552  16,556  22,766  16,667  16,429  16,017  20,689  16,441  16,169  16,196  21,626  17,613  17,427  17,119  21,750  17,254  16,957  16,657 
 
Property and equipment, net 26,589  26,283  26,384  26,012  25,706  25,533  25,607  25,172  24,767  25,018  25,112  24,861  24,682  24,658  24,902  24,934  25,049  25,217  25,472  25,583  25,778  25,958  26,033  26,132  26,334 
Operating lease assets 2,235  2,236  2,151  2,062  2,019  1,965  1,997  1,976  1,958  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — 
Property and equipment, net (including operating lease, right-of-use asset) 28,824  28,519  28,535  28,074  27,725  27,498  27,604  27,148  26,725  25,018  25,112  24,861  24,682  24,658  24,902  24,934  25,049  25,217  25,472  25,583  25,778  25,958  26,033  26,132  26,334 
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 2.74 2.70 2.69 2.70 2.72 2.71 2.70 2.71 2.71 2.87 2.78 2.80 2.81 2.82 2.83 2.87 2.91 2.93 2.90 2.87 2.83 2.80
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
Amazon.com Inc. 2.85 2.87 2.92 2.92 2.98 3.77 3.81 3.80 3.69 3.64 3.55 4.05 4.37 4.67 4.71 4.79 4.87 4.90
Costco Wholesale Corp. 6.48 6.43 6.35 7.15 7.15 7.15 7.12 7.03 7.11 6.98 6.95 6.95 6.87 6.83 6.81 6.81 6.99 7.14 7.19 7.38 7.52 7.61 7.57
Dollar General Corp. 2.41 2.30 2.31 2.33 2.34 8.63 8.59 8.61 8.69 8.69 8.80 8.84 8.98 9.03 8.90 8.94 9.09 9.00 8.95 8.96 9.04 8.94
Home Depot Inc. 3.96 3.89 3.95 3.90 3.93 4.84 4.79 4.76 4.65 4.57 4.52 4.42 4.39 4.32 4.28 4.19 4.06 3.99 3.91 3.83 3.74 3.66
Lowe’s Cos. Inc. 3.31 3.20 3.23 3.24 3.25 3.87 3.76 3.68 3.54 3.48 3.48 3.43 3.37 3.26 3.12 3.01 3.09 3.02 2.97 2.92 2.86 2.81
TJX Cos. Inc. 2.58 2.90 2.84 2.86 2.86 7.42 7.51 7.40 7.32 7.16 7.07 7.15 7.26 7.32 7.57 7.54 7.48 7.48 7.45 7.48 7.48 7.52
Walmart Inc. 4.30 4.09 4.12 4.08 4.09 4.58 4.56 4.56 4.36 4.32 4.25 4.21 4.23 4.22 4.17 4.16 4.12 4.11 4.11 4.14 4.17 4.13

Based on: 10-Q (filing date: 2020-05-29), 10-K (filing date: 2020-03-11), 10-Q (filing date: 2019-11-27), 10-Q (filing date: 2019-08-30), 10-Q (filing date: 2019-05-31), 10-K (filing date: 2019-03-13), 10-Q (filing date: 2018-11-27), 10-Q (filing date: 2018-08-27), 10-Q (filing date: 2018-05-29), 10-K (filing date: 2018-03-14), 10-Q (filing date: 2017-11-20), 10-Q (filing date: 2017-08-21), 10-Q (filing date: 2017-05-22), 10-K (filing date: 2017-03-08), 10-Q (filing date: 2016-11-23), 10-Q (filing date: 2016-08-24), 10-Q (filing date: 2016-05-25), 10-K (filing date: 2016-03-11), 10-Q (filing date: 2015-11-25), 10-Q (filing date: 2015-08-25), 10-Q (filing date: 2015-05-28), 10-K (filing date: 2015-03-13), 10-Q (filing date: 2014-11-26), 10-Q (filing date: 2014-08-27), 10-Q (filing date: 2014-05-29).

1 Q1 2021 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = (SalesQ1 2021 + SalesQ4 2020 + SalesQ3 2020 + SalesQ2 2020) ÷ Property and equipment, net (including operating lease, right-of-use asset)
= (19,371 + 23,132 + 18,414 + 18,183) ÷ 28,824 = 2.74

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Target Corp.’s net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from Q3 2020 to Q4 2020 and from Q4 2020 to Q1 2021.

Total Asset Turnover

Target Corp., total asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
May 2, 2020 Feb 1, 2020 Nov 2, 2019 Aug 3, 2019 May 4, 2019 Feb 2, 2019 Nov 3, 2018 Aug 4, 2018 May 5, 2018 Feb 3, 2018 Oct 28, 2017 Jul 29, 2017 Apr 29, 2017 Jan 28, 2017 Oct 29, 2016 Jul 30, 2016 Apr 30, 2016 Jan 30, 2016 Oct 31, 2015 Aug 1, 2015 May 2, 2015 Jan 31, 2015 Nov 1, 2014 Aug 2, 2014 May 3, 2014
Selected Financial Data (US$ in millions)
Sales 19,371  23,132  18,414  18,183  17,401  22,735  17,590  17,552  16,556  22,766  16,667  16,429  16,017  20,689  16,441  16,169  16,196  21,626  17,613  17,427  17,119  21,750  17,254  16,957  16,657 
Total assets 44,806  42,779  43,741  41,566  40,619  41,290  43,572  39,996  38,929  38,999  40,708  37,366  37,218  37,431  38,603  37,288  39,908  40,262  41,696  40,386  40,446  41,404  46,461  44,455  44,042 
Long-term Activity Ratio
Total asset turnover1 1.77 1.80 1.75 1.83 1.85 1.80 1.71 1.84 1.86 1.84 1.71 1.86 1.86 1.86 1.82 1.92 1.83 1.83 1.77 1.82 1.81 1.75
Benchmarks
Total Asset Turnover, Competitors2
Amazon.com Inc. 1.34 1.25 1.33 1.32 1.36 1.43 1.54 1.55 1.53 1.35 1.40 1.71 1.76 1.63 1.81 1.85 1.86 1.64
Costco Wholesale Corp. 3.04 3.18 2.94 3.29 3.34 3.36 3.23 3.39 3.44 3.44 3.30 3.47 3.38 3.33 3.20 3.50 3.41 3.54 3.22 3.40 3.39 3.37 3.24
Dollar General Corp. 1.19 1.22 1.22 1.22 1.23 1.94 1.91 1.90 1.92 1.88 1.89 1.88 1.89 1.88 1.78 1.81 1.83 1.81 1.77 1.76 1.76 1.68
Home Depot Inc. 1.91 2.15 2.12 2.12 2.13 2.46 2.34 2.26 2.19 2.27 2.20 2.12 2.13 2.20 2.10 2.08 2.03 2.08 1.96 1.95 1.98 2.08
Lowe’s Cos. Inc. 1.62 1.83 1.80 1.76 1.66 2.07 1.94 1.90 1.81 1.94 1.87 1.85 1.77 1.89 1.77 1.68 1.62 1.89 1.73 1.76 1.65 1.77
TJX Cos. Inc. 1.45 1.73 1.67 1.75 1.76 2.72 2.58 2.67 2.63 2.55 2.48 2.62 2.62 2.58 2.54 2.75 2.70 2.69 2.53 2.64 2.59 2.61
Walmart Inc. 2.28 2.20 2.16 2.19 2.18 2.33 2.24 2.46 2.44 2.42 2.34 2.41 2.42 2.42 2.32 2.42 2.41 2.40 2.34 2.43 2.40 2.37

Based on: 10-Q (filing date: 2020-05-29), 10-K (filing date: 2020-03-11), 10-Q (filing date: 2019-11-27), 10-Q (filing date: 2019-08-30), 10-Q (filing date: 2019-05-31), 10-K (filing date: 2019-03-13), 10-Q (filing date: 2018-11-27), 10-Q (filing date: 2018-08-27), 10-Q (filing date: 2018-05-29), 10-K (filing date: 2018-03-14), 10-Q (filing date: 2017-11-20), 10-Q (filing date: 2017-08-21), 10-Q (filing date: 2017-05-22), 10-K (filing date: 2017-03-08), 10-Q (filing date: 2016-11-23), 10-Q (filing date: 2016-08-24), 10-Q (filing date: 2016-05-25), 10-K (filing date: 2016-03-11), 10-Q (filing date: 2015-11-25), 10-Q (filing date: 2015-08-25), 10-Q (filing date: 2015-05-28), 10-K (filing date: 2015-03-13), 10-Q (filing date: 2014-11-26), 10-Q (filing date: 2014-08-27), 10-Q (filing date: 2014-05-29).

1 Q1 2021 Calculation
Total asset turnover = (SalesQ1 2021 + SalesQ4 2020 + SalesQ3 2020 + SalesQ2 2020) ÷ Total assets
= (19,371 + 23,132 + 18,414 + 18,183) ÷ 44,806 = 1.77

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Target Corp.’s total asset turnover ratio improved from Q3 2020 to Q4 2020 but then slightly deteriorated from Q4 2020 to Q1 2021 not reaching Q3 2020 level.

Equity Turnover

Target Corp., equity turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
May 2, 2020 Feb 1, 2020 Nov 2, 2019 Aug 3, 2019 May 4, 2019 Feb 2, 2019 Nov 3, 2018 Aug 4, 2018 May 5, 2018 Feb 3, 2018 Oct 28, 2017 Jul 29, 2017 Apr 29, 2017 Jan 28, 2017 Oct 29, 2016 Jul 30, 2016 Apr 30, 2016 Jan 30, 2016 Oct 31, 2015 Aug 1, 2015 May 2, 2015 Jan 31, 2015 Nov 1, 2014 Aug 2, 2014 May 3, 2014
Selected Financial Data (US$ in millions)
Sales 19,371  23,132  18,414  18,183  17,401  22,735  17,590  17,552  16,556  22,766  16,667  16,429  16,017  20,689  16,441  16,169  16,196  21,626  17,613  17,427  17,119  21,750  17,254  16,957  16,657 
Shareholders’ investment 11,169  11,833  11,545  11,836  11,117  11,297  11,080  11,167  11,158  11,709  11,137  11,098  11,021  10,953  11,069  11,577  12,545  12,957  13,256  13,942  14,174  13,997  16,373  16,433  16,486 
Long-term Activity Ratio
Equity turnover1 7.08 6.52 6.65 6.41 6.77 6.59 6.72 6.59 6.49 6.14 6.27 6.27 6.29 6.34 6.36 6.19 5.81 5.69 5.58 5.28 5.16 5.19
Benchmarks
Equity Turnover, Competitors2
Amazon.com Inc. 4.54 4.52 4.70 4.75 4.99 5.35 5.65 5.95 6.14 6.42 6.54 6.47 6.58 7.05 7.20 7.29 7.69 8.00
Costco Wholesale Corp. 9.37 9.32 9.54 9.80 10.10 10.39 10.76 10.82 11.23 11.31 11.72 11.71 12.18 9.52 9.76 9.61 10.03 10.43 10.51 10.71 10.71 11.09 9.06
Dollar General Corp. 4.10 4.14 4.10 3.95 3.98 3.99 3.95 3.85 3.84 3.83 4.07 4.00 4.04 4.07 3.97 3.88 3.84 3.79 3.75 3.63 3.58 3.31
Home Depot Inc. 80.00 51.93 60.44 69.40 39.02 27.39 24.16 21.83 16.61 13.82 14.27 14.02 11.38 9.89 9.17 8.92
Lowe’s Cos. Inc. 43.17 36.59 29.20 27.19 22.15 19.57 13.19 12.20 12.03 11.68 12.00 12.26 12.05 10.11 9.47 8.84 8.34 7.72 6.97 6.64 6.01 5.64
TJX Cos. Inc. 7.78 7.01 7.33 7.55 7.71 7.72 7.38 7.22 6.99 6.97 7.40 7.47 7.34 7.36 7.55 7.22 6.97 7.18 6.96 6.99 6.87 6.82
Walmart Inc. 7.78 6.96 7.22 7.31 7.50 7.04 7.05 7.11 6.63 6.37 6.44 6.35 6.55 6.19 6.18 6.27 6.38 5.94 6.04 6.11 6.30 5.92

Based on: 10-Q (filing date: 2020-05-29), 10-K (filing date: 2020-03-11), 10-Q (filing date: 2019-11-27), 10-Q (filing date: 2019-08-30), 10-Q (filing date: 2019-05-31), 10-K (filing date: 2019-03-13), 10-Q (filing date: 2018-11-27), 10-Q (filing date: 2018-08-27), 10-Q (filing date: 2018-05-29), 10-K (filing date: 2018-03-14), 10-Q (filing date: 2017-11-20), 10-Q (filing date: 2017-08-21), 10-Q (filing date: 2017-05-22), 10-K (filing date: 2017-03-08), 10-Q (filing date: 2016-11-23), 10-Q (filing date: 2016-08-24), 10-Q (filing date: 2016-05-25), 10-K (filing date: 2016-03-11), 10-Q (filing date: 2015-11-25), 10-Q (filing date: 2015-08-25), 10-Q (filing date: 2015-05-28), 10-K (filing date: 2015-03-13), 10-Q (filing date: 2014-11-26), 10-Q (filing date: 2014-08-27), 10-Q (filing date: 2014-05-29).

1 Q1 2021 Calculation
Equity turnover = (SalesQ1 2021 + SalesQ4 2020 + SalesQ3 2020 + SalesQ2 2020) ÷ Shareholders’ investment
= (19,371 + 23,132 + 18,414 + 18,183) ÷ 11,169 = 7.08

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Target Corp.’s equity turnover ratio deteriorated from Q3 2020 to Q4 2020 but then improved from Q4 2020 to Q1 2021 exceeding Q3 2020 level.