Stock Analysis on Net
Stock Analysis on Net
Microsoft Excel LibreOffice Calc

Target Corp. (NYSE:TGT)

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

Beginner level

Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.

Long-term Activity Ratios (Summary)

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

Microsoft Excel LibreOffice Calc
Jan 30, 2021 Oct 31, 2020 Aug 1, 2020 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
Net fixed asset turnover 3.44 3.27 3.13 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 — — —
Net fixed asset turnover (including operating lease, right-of-use asset) 3.17 3.02 2.89 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 — — —
Total asset turnover 1.80 1.73 1.74 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 — — —
Equity turnover 6.40 6.57 6.65 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 — — —

Based on: 10-K (filing date: 2021-03-10), 10-Q (filing date: 2020-11-25), 10-Q (filing date: 2020-08-28), 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).

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 Q2 2021 to Q3 2021 and from Q3 2021 to Q4 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 Q2 2021 to Q3 2021 and from Q3 2021 to Q4 2021.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Target Corp.’s total asset turnover ratio deteriorated from Q2 2021 to Q3 2021 but then improved from Q3 2021 to Q4 2021 exceeding Q2 2021 level.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Target Corp.’s equity turnover ratio deteriorated from Q2 2021 to Q3 2021 and from Q3 2021 to Q4 2021.

Net Fixed Asset Turnover

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

Microsoft Excel LibreOffice Calc
Jan 30, 2021 Oct 31, 2020 Aug 1, 2020 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
Selected Financial Data (US$ in millions)
Sales 27,997  22,336  22,696  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 
Property and equipment, net 26,879  26,773  26,739  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 
Long-term Activity Ratio
Net fixed asset turnover1 3.44 3.27 3.13 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 — — —
Benchmarks
Net Fixed Asset Turnover, Competitors2
Amazon.com Inc. — — — 3.45 3.41 3.48 3.72 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 — — —
Costco Wholesale Corp. — — 7.77 7.60 7.48 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
Dollar General Corp. 8.65 8.78 8.88 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 — — —
Home Depot Inc. 5.35 5.27 5.10 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 — — —
Lowe’s Cos. Inc. 4.68 4.57 4.32 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 — — —
TJX Cos. Inc. 6.38 6.67 6.61 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 — — —
Walmart Inc. 5.77 5.08 5.08 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 — — —

Based on: 10-K (filing date: 2021-03-10), 10-Q (filing date: 2020-11-25), 10-Q (filing date: 2020-08-28), 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).

1 Q4 2021 Calculation
Net fixed asset turnover = (SalesQ4 2021 + SalesQ3 2021 + SalesQ2 2021 + SalesQ1 2021) ÷ Property and equipment, net
= (27,997 + 22,336 + 22,696 + 19,371) ÷ 26,879 = 3.44

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 Q2 2021 to Q3 2021 and from Q3 2021 to Q4 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
Jan 30, 2021 Oct 31, 2020 Aug 1, 2020 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
Selected Financial Data (US$ in millions)
Sales 27,997  22,336  22,696  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 
 
Property and equipment, net 26,879  26,773  26,739  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 
Operating lease assets 2,227  2,208  2,233  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) 29,106  28,981  28,972  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 
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 3.17 3.02 2.89 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 — — —
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
Amazon.com Inc. — — — 2.61 2.56 2.59 2.80 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 — — —
Costco Wholesale Corp. — — 6.88 6.75 6.64 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
Dollar General Corp. 2.52 2.49 2.47 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 — — —
Home Depot Inc. 4.31 4.29 4.14 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 — — —
Lowe’s Cos. Inc. 3.90 3.79 3.59 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 — — —
TJX Cos. Inc. 2.29 2.38 2.38 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 — — —
Walmart Inc. 5.05 4.38 4.38 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 — — —

Based on: 10-K (filing date: 2021-03-10), 10-Q (filing date: 2020-11-25), 10-Q (filing date: 2020-08-28), 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).

1 Q4 2021 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = (SalesQ4 2021 + SalesQ3 2021 + SalesQ2 2021 + SalesQ1 2021) ÷ Property and equipment, net (including operating lease, right-of-use asset)
= (27,997 + 22,336 + 22,696 + 19,371) ÷ 29,106 = 3.17

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 Q2 2021 to Q3 2021 and from Q3 2021 to Q4 2021.

Total Asset Turnover

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

Microsoft Excel LibreOffice Calc
Jan 30, 2021 Oct 31, 2020 Aug 1, 2020 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
Selected Financial Data (US$ in millions)
Sales 27,997  22,336  22,696  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 
Total assets 51,248  50,661  48,000  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 
Long-term Activity Ratio
Total asset turnover1 1.80 1.73 1.74 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 — — —
Benchmarks
Total Asset Turnover, Competitors2
Amazon.com Inc. — — — 1.30 1.20 1.23 1.25 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 — — —
Costco Wholesale Corp. — — 3.19 2.81 2.94 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
Dollar General Corp. 1.30 1.24 1.21 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 — — —
Home Depot Inc. 1.87 1.88 1.88 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 — — —
Lowe’s Cos. Inc. 1.92 1.68 1.55 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 — — —
TJX Cos. Inc. 1.04 1.06 1.27 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 — — —
Walmart Inc. 2.20 2.17 2.27 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 — — —

Based on: 10-K (filing date: 2021-03-10), 10-Q (filing date: 2020-11-25), 10-Q (filing date: 2020-08-28), 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).

1 Q4 2021 Calculation
Total asset turnover = (SalesQ4 2021 + SalesQ3 2021 + SalesQ2 2021 + SalesQ1 2021) ÷ Total assets
= (27,997 + 22,336 + 22,696 + 19,371) ÷ 51,248 = 1.80

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 deteriorated from Q2 2021 to Q3 2021 but then improved from Q3 2021 to Q4 2021 exceeding Q2 2021 level.

Equity Turnover

Target Corp., equity turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jan 30, 2021 Oct 31, 2020 Aug 1, 2020 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
Selected Financial Data (US$ in millions)
Sales 27,997  22,336  22,696  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 
Shareholders’ investment 14,440  13,319  12,578  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 
Long-term Activity Ratio
Equity turnover1 6.40 6.57 6.65 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 — — —
Benchmarks
Equity Turnover, Competitors2
Amazon.com Inc. — — — 4.06 4.13 4.20 4.36 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 — — —
Costco Wholesale Corp. — — 11.18 11.40 8.93 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
Dollar General Corp. 5.07 4.65 4.25 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 — — —
Home Depot Inc. 40.05 81.84 — — — — — — — 80.00 51.93 60.44 69.40 39.02 27.39 24.16 21.83 16.61 13.82 14.27 14.02 — — —
Lowe’s Cos. Inc. 62.35 20.95 18.46 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 — — —
TJX Cos. Inc. 5.51 6.00 7.24 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 — — —
Walmart Inc. 6.86 6.69 7.14 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 — — —

Based on: 10-K (filing date: 2021-03-10), 10-Q (filing date: 2020-11-25), 10-Q (filing date: 2020-08-28), 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).

1 Q4 2021 Calculation
Equity turnover = (SalesQ4 2021 + SalesQ3 2021 + SalesQ2 2021 + SalesQ1 2021) ÷ Shareholders’ investment
= (27,997 + 22,336 + 22,696 + 19,371) ÷ 14,440 = 6.40

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 Q2 2021 to Q3 2021 and from Q3 2021 to Q4 2021.