Microsoft Excel LibreOffice Calc

TJX Cos. Inc. (TJX)

Long-term (Investment) Activity Analysis
Quarterly Data

Difficulty: Beginner

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

Ratios (Summary)

TJX Cos. Inc., long-term (investment) activity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
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 Feb 1, 2014 Nov 2, 2013 Aug 3, 2013 May 4, 2013
Net fixed asset turnover 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 7.42 7.47 7.60 7.63 — — —
Net fixed asset turnover (including operating lease, right-of-use asset) 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 7.42 7.47 7.60 7.63 — — —
Total asset turnover 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 2.47 2.58 2.66 2.69 — — —
Equity turnover 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 6.54 6.60 6.47 6.48 — — —

Based on: 10-Q (filing date: 2019-05-31), 10-K (filing date: 2019-04-03), 10-Q (filing date: 2018-12-04), 10-Q (filing date: 2018-08-31), 10-Q (filing date: 2018-06-01), 10-K (filing date: 2018-04-04), 10-Q (filing date: 2017-11-28), 10-Q (filing date: 2017-08-25), 10-Q (filing date: 2017-05-26), 10-K (filing date: 2017-03-28), 10-Q (filing date: 2016-11-30), 10-Q (filing date: 2016-08-26), 10-Q (filing date: 2016-05-27), 10-K (filing date: 2016-03-29), 10-Q (filing date: 2015-12-01), 10-Q (filing date: 2015-08-28), 10-Q (filing date: 2015-05-29), 10-K (filing date: 2015-03-31), 10-Q (filing date: 2014-12-02), 10-Q (filing date: 2014-08-29), 10-Q (filing date: 2014-05-30), 10-K (filing date: 2014-04-01), 10-Q (filing date: 2013-12-03), 10-Q (filing date: 2013-08-30), 10-Q (filing date: 2013-05-31).

Ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. TJX Cos. Inc.’s net fixed asset turnover deteriorated from Q3 2019 to Q4 2019 but then improved from Q4 2019 to Q1 2020 exceeding Q3 2019 level.
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). TJX Cos. Inc.’s net fixed asset turnover (including operating lease, right-of-use asset) deteriorated from Q3 2019 to Q4 2019 and from Q4 2019 to Q1 2020.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. TJX Cos. Inc.’s total asset turnover improved from Q3 2019 to Q4 2019 but then deteriorated significantly from Q4 2019 to Q1 2020.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. TJX Cos. Inc.’s equity turnover improved from Q3 2019 to Q4 2019 but then slightly deteriorated from Q4 2019 to Q1 2020.

Net Fixed Asset Turnover

TJX Cos. Inc., net fixed asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Feb 1, 2014 Nov 2, 2013 Aug 3, 2013 May 4, 2013
Selected Financial Data (USD $ in thousands)
Net sales 9,277,585  11,127,340  9,825,759  9,331,115  8,688,720  10,960,720  8,762,220  8,357,700  7,784,024  9,467,647  8,291,688  7,882,053  7,542,356  8,962,075  7,753,495  7,363,731  6,865,637  8,303,953  7,366,066  6,917,212  6,491,176  7,808,787  6,981,876  6,442,424  6,189,609 
Net property at cost 5,018,598  5,255,208  5,165,875  5,100,454  5,026,092  5,006,053  4,858,284  4,744,690  4,601,044  4,532,894  4,318,829  4,263,380  4,229,704  4,137,575  4,066,987  3,995,978  3,936,731  3,868,365  3,849,804  3,776,037  3,645,570  3,594,501  3,540,532  3,377,839  3,273,322 
Ratio
Net fixed asset turnover1 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 7.42 7.47 7.60 7.63 — — —

Based on: 10-Q (filing date: 2019-05-31), 10-K (filing date: 2019-04-03), 10-Q (filing date: 2018-12-04), 10-Q (filing date: 2018-08-31), 10-Q (filing date: 2018-06-01), 10-K (filing date: 2018-04-04), 10-Q (filing date: 2017-11-28), 10-Q (filing date: 2017-08-25), 10-Q (filing date: 2017-05-26), 10-K (filing date: 2017-03-28), 10-Q (filing date: 2016-11-30), 10-Q (filing date: 2016-08-26), 10-Q (filing date: 2016-05-27), 10-K (filing date: 2016-03-29), 10-Q (filing date: 2015-12-01), 10-Q (filing date: 2015-08-28), 10-Q (filing date: 2015-05-29), 10-K (filing date: 2015-03-31), 10-Q (filing date: 2014-12-02), 10-Q (filing date: 2014-08-29), 10-Q (filing date: 2014-05-30), 10-K (filing date: 2014-04-01), 10-Q (filing date: 2013-12-03), 10-Q (filing date: 2013-08-30), 10-Q (filing date: 2013-05-31).

Q1 2020 Calculations

1 Net fixed asset turnover = (Net salesQ1 2020 + Net salesQ4 2019 + Net salesQ3 2019 + Net salesQ2 2019) ÷ Net property at cost
= (9,277,585 + 11,127,340 + 9,825,759 + 9,331,115) ÷ 5,018,598 = 7.88

Ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. TJX Cos. Inc.’s net fixed asset turnover deteriorated from Q3 2019 to Q4 2019 but then improved from Q4 2019 to Q1 2020 exceeding Q3 2019 level.

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

TJX Cos. Inc., net fixed asset turnover (including operating lease, right-of-use asset) calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Feb 1, 2014 Nov 2, 2013 Aug 3, 2013 May 4, 2013
Selected Financial Data (USD $ in thousands)
Net sales 9,277,585  11,127,340  9,825,759  9,331,115  8,688,720  10,960,720  8,762,220  8,357,700  7,784,024  9,467,647  8,291,688  7,882,053  7,542,356  8,962,075  7,753,495  7,363,731  6,865,637  8,303,953  7,366,066  6,917,212  6,491,176  7,808,787  6,981,876  6,442,424  6,189,609 
 
Net property at cost 5,018,598  5,255,208  5,165,875  5,100,454  5,026,092  5,006,053  4,858,284  4,744,690  4,601,044  4,532,894  4,318,829  4,263,380  4,229,704  4,137,575  4,066,987  3,995,978  3,936,731  3,868,365  3,849,804  3,776,037  3,645,570  3,594,501  3,540,532  3,377,839  3,273,322 
Operating lease right of use assets 8,810,367  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — 
Net property at cost (including operating lease, right-of-use asset) 13,828,965  5,255,208  5,165,875  5,100,454  5,026,092  5,006,053  4,858,284  4,744,690  4,601,044  4,532,894  4,318,829  4,263,380  4,229,704  4,137,575  4,066,987  3,995,978  3,936,731  3,868,365  3,849,804  3,776,037  3,645,570  3,594,501  3,540,532  3,377,839  3,273,322 
Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 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 7.42 7.47 7.60 7.63 — — —

Based on: 10-Q (filing date: 2019-05-31), 10-K (filing date: 2019-04-03), 10-Q (filing date: 2018-12-04), 10-Q (filing date: 2018-08-31), 10-Q (filing date: 2018-06-01), 10-K (filing date: 2018-04-04), 10-Q (filing date: 2017-11-28), 10-Q (filing date: 2017-08-25), 10-Q (filing date: 2017-05-26), 10-K (filing date: 2017-03-28), 10-Q (filing date: 2016-11-30), 10-Q (filing date: 2016-08-26), 10-Q (filing date: 2016-05-27), 10-K (filing date: 2016-03-29), 10-Q (filing date: 2015-12-01), 10-Q (filing date: 2015-08-28), 10-Q (filing date: 2015-05-29), 10-K (filing date: 2015-03-31), 10-Q (filing date: 2014-12-02), 10-Q (filing date: 2014-08-29), 10-Q (filing date: 2014-05-30), 10-K (filing date: 2014-04-01), 10-Q (filing date: 2013-12-03), 10-Q (filing date: 2013-08-30), 10-Q (filing date: 2013-05-31).

Q1 2020 Calculations

1 Net fixed asset turnover (including operating lease, right-of-use asset) = (Net salesQ1 2020 + Net salesQ4 2019 + Net salesQ3 2019 + Net salesQ2 2019) ÷ Net property at cost (including operating lease, right-of-use asset)
= (9,277,585 + 11,127,340 + 9,825,759 + 9,331,115) ÷ 13,828,965 = 2.86

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). TJX Cos. Inc.’s net fixed asset turnover (including operating lease, right-of-use asset) deteriorated from Q3 2019 to Q4 2019 and from Q4 2019 to Q1 2020.

Total Asset Turnover

TJX Cos. Inc., total asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Feb 1, 2014 Nov 2, 2013 Aug 3, 2013 May 4, 2013
Selected Financial Data (USD $ in thousands)
Net sales 9,277,585  11,127,340  9,825,759  9,331,115  8,688,720  10,960,720  8,762,220  8,357,700  7,784,024  9,467,647  8,291,688  7,882,053  7,542,356  8,962,075  7,753,495  7,363,731  6,865,637  8,303,953  7,366,066  6,917,212  6,491,176  7,808,787  6,981,876  6,442,424  6,189,609 
Total assets 22,489,064  14,326,029  15,025,242  14,111,428  14,007,124  14,058,015  13,877,695  12,935,615  12,763,481  12,883,808  12,866,836  11,670,653  11,704,722  11,499,482  11,992,433  11,341,042  11,365,946  11,128,381  11,592,048  10,921,997  10,429,938  10,201,022  10,669,239  9,926,043  9,840,364 
Ratio
Total asset turnover1 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 2.47 2.58 2.66 2.69 — — —

Based on: 10-Q (filing date: 2019-05-31), 10-K (filing date: 2019-04-03), 10-Q (filing date: 2018-12-04), 10-Q (filing date: 2018-08-31), 10-Q (filing date: 2018-06-01), 10-K (filing date: 2018-04-04), 10-Q (filing date: 2017-11-28), 10-Q (filing date: 2017-08-25), 10-Q (filing date: 2017-05-26), 10-K (filing date: 2017-03-28), 10-Q (filing date: 2016-11-30), 10-Q (filing date: 2016-08-26), 10-Q (filing date: 2016-05-27), 10-K (filing date: 2016-03-29), 10-Q (filing date: 2015-12-01), 10-Q (filing date: 2015-08-28), 10-Q (filing date: 2015-05-29), 10-K (filing date: 2015-03-31), 10-Q (filing date: 2014-12-02), 10-Q (filing date: 2014-08-29), 10-Q (filing date: 2014-05-30), 10-K (filing date: 2014-04-01), 10-Q (filing date: 2013-12-03), 10-Q (filing date: 2013-08-30), 10-Q (filing date: 2013-05-31).

Q1 2020 Calculations

1 Total asset turnover = (Net salesQ1 2020 + Net salesQ4 2019 + Net salesQ3 2019 + Net salesQ2 2019) ÷ Total assets
= (9,277,585 + 11,127,340 + 9,825,759 + 9,331,115) ÷ 22,489,064 = 1.76

Ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. TJX Cos. Inc.’s total asset turnover improved from Q3 2019 to Q4 2019 but then deteriorated significantly from Q4 2019 to Q1 2020.

Equity Turnover

TJX Cos. Inc., equity turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Feb 1, 2014 Nov 2, 2013 Aug 3, 2013 May 4, 2013
Selected Financial Data (USD $ in thousands)
Net sales 9,277,585  11,127,340  9,825,759  9,331,115  8,688,720  10,960,720  8,762,220  8,357,700  7,784,024  9,467,647  8,291,688  7,882,053  7,542,356  8,962,075  7,753,495  7,363,731  6,865,637  8,303,953  7,366,066  6,917,212  6,491,176  7,808,787  6,981,876  6,442,424  6,189,609 
Shareholders’ equity 5,131,895  5,048,606  5,256,873  5,227,073  5,262,408  5,148,309  4,645,608  4,540,804  4,553,523  4,510,599  4,329,811  4,451,356  4,534,969  4,307,075  4,350,461  4,276,067  4,290,290  4,264,230  4,373,808  4,274,652  4,283,494  4,229,893  4,123,771  3,850,139  3,762,665 
Ratio
Equity turnover1 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 6.54 6.60 6.47 6.48 — — —

Based on: 10-Q (filing date: 2019-05-31), 10-K (filing date: 2019-04-03), 10-Q (filing date: 2018-12-04), 10-Q (filing date: 2018-08-31), 10-Q (filing date: 2018-06-01), 10-K (filing date: 2018-04-04), 10-Q (filing date: 2017-11-28), 10-Q (filing date: 2017-08-25), 10-Q (filing date: 2017-05-26), 10-K (filing date: 2017-03-28), 10-Q (filing date: 2016-11-30), 10-Q (filing date: 2016-08-26), 10-Q (filing date: 2016-05-27), 10-K (filing date: 2016-03-29), 10-Q (filing date: 2015-12-01), 10-Q (filing date: 2015-08-28), 10-Q (filing date: 2015-05-29), 10-K (filing date: 2015-03-31), 10-Q (filing date: 2014-12-02), 10-Q (filing date: 2014-08-29), 10-Q (filing date: 2014-05-30), 10-K (filing date: 2014-04-01), 10-Q (filing date: 2013-12-03), 10-Q (filing date: 2013-08-30), 10-Q (filing date: 2013-05-31).

Q1 2020 Calculations

1 Equity turnover = (Net salesQ1 2020 + Net salesQ4 2019 + Net salesQ3 2019 + Net salesQ2 2019) ÷ Shareholders’ equity
= (9,277,585 + 11,127,340 + 9,825,759 + 9,331,115) ÷ 5,131,895 = 7.71

Ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. TJX Cos. Inc.’s equity turnover improved from Q3 2019 to Q4 2019 but then slightly deteriorated from Q4 2019 to Q1 2020.