Stock Analysis on Net
Stock Analysis on Net

Target Corp. (NYSE:TGT)

Analysis of Liquidity Ratios
Quarterly Data

Beginner level

Liquidity Ratios (Summary)

Target Corp., liquidity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
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 Jan 31, 2015 Nov 1, 2014 Aug 2, 2014 May 3, 2014
Current ratio 1.05 1.11 1.01 0.89 0.83 0.84 0.88 0.83 0.83 0.82 0.90 0.95 0.96 0.91 0.95 0.94 1.02 1.05 1.16 1.12 1.10 1.15 1.24 1.20 1.02 1.02 0.92
Quick ratio 0.31 0.46 0.32 0.18 0.06 0.12 0.09 0.10 0.05 0.08 0.09 0.20 0.18 0.18 0.22 0.20 0.10 0.13 0.34 0.32 0.14 0.24 0.26 0.19 0.05 0.07 0.06
Cash ratio 0.31 0.46 0.32 0.18 0.06 0.12 0.09 0.10 0.05 0.08 0.09 0.20 0.18 0.18 0.22 0.20 0.10 0.13 0.34 0.32 0.14 0.24 0.26 0.19 0.05 0.07 0.06

Based on: 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), 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).

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Target Corp.’s current ratio improved from Q1 2021 to Q2 2021 but then slightly deteriorated from Q2 2021 to Q3 2021 not reaching Q1 2021 level.
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Target Corp.’s quick ratio improved from Q1 2021 to Q2 2021 but then deteriorated significantly from Q2 2021 to Q3 2021.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Target Corp.’s cash ratio improved from Q1 2021 to Q2 2021 but then deteriorated significantly from Q2 2021 to Q3 2021.

Current Ratio

Target Corp., current ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Jan 31, 2015 Nov 1, 2014 Aug 2, 2014 May 3, 2014
Selected Financial Data (US$ in millions)
Current assets 20,309  17,623  14,615  12,902  13,805  12,119  11,607  12,519  14,639  11,503  10,876  12,564  14,709  11,620  11,739  11,990  12,842  11,503  13,948  14,130  15,204  13,358  13,198  14,087  13,838  11,554  11,023 
Current liabilities 19,357  15,892  14,412  14,487  16,608  14,364  13,239  15,014  17,590  14,038  12,044  13,201  15,376  12,729  12,392  12,708  12,642  11,003  12,019  12,622  13,858  11,613  10,648  11,736  13,525  11,336  12,040 
Liquidity Ratio
Current ratio1 1.05 1.11 1.01 0.89 0.83 0.84 0.88 0.83 0.83 0.82 0.90 0.95 0.96 0.91 0.95 0.94 1.02 1.05 1.16 1.12 1.10 1.15 1.24 1.20 1.02 1.02 0.92
Benchmarks
Current Ratio, Competitors2
Amazon.com Inc. 1.11 1.18 1.08 1.10 1.10 1.10 1.09 1.10 1.08 1.07 1.06 1.04 1.03 1.01 1.06 1.04 1.06 1.09 1.08 1.08 1.08 1.10 1.12
Costco Wholesale Corp. 0.98 1.13 1.11 1.04 1.01 1.01 0.98 0.96 1.02 1.02 1.01 1.00 0.98 0.99 0.81 0.93 0.97 0.98 0.97 1.01 1.03 1.05 1.05 0.99 1.20
Dollar General Corp. 1.28 1.40 1.44 1.14 1.12 1.14 1.16 1.55 1.55 1.55 1.65 1.43 1.41 1.42 1.39 1.40 1.34 1.36 1.73 1.72 1.75 1.59 1.57 1.78 1.58 1.59 1.58
Home Depot Inc. 1.36 1.30 1.17 1.08 1.08 1.10 1.04 1.11 1.09 1.13 1.17 1.17 1.23 1.30 1.21 1.25 1.34 1.30 1.25 1.36 1.16 1.19 1.06 1.36 1.37 1.44 1.32
Lowe’s Cos. Inc. 1.38 1.30 1.20 1.01 1.04 1.06 1.09 0.98 1.00 1.06 1.02 1.06 1.02 1.03 1.04 1.00 1.01 1.01 1.17 1.01 1.02 0.94 0.99 1.08 1.12 1.11 1.11
TJX Cos. Inc. 1.41 1.51 2.20 1.24 1.22 1.25 1.23 1.53 1.55 1.64 1.69 1.66 1.53 1.63 1.64 1.63 1.62 1.58 1.60 1.54 1.55 1.63 1.66 1.71 1.63 1.72 1.68
Walmart Inc. 0.84 0.79 0.77 0.79 0.81 0.76 0.77 0.80 0.81 0.93 0.73 0.76 0.81 0.78 0.77 0.86 0.86 0.85 0.84 0.93 0.92 0.89 0.89 0.97 0.92 0.89 0.88

Based on: 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), 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 Q3 2021 Calculation
Current ratio = Current assets ÷ Current liabilities
= 20,309 ÷ 19,357 = 1.05

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Target Corp.’s current ratio improved from Q1 2021 to Q2 2021 but then slightly deteriorated from Q2 2021 to Q3 2021 not reaching Q1 2021 level.

Quick Ratio

Target Corp., quick ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Jan 31, 2015 Nov 1, 2014 Aug 2, 2014 May 3, 2014
Selected Financial Data (US$ in millions)
Cash and cash equivalents 5,996  7,284  4,566  2,577  969  1,656  1,173  1,556  825  1,180  1,060  2,643  2,725  2,291  2,680  2,512  1,231  1,480  4,036  4,046  1,977  2,742  2,768  2,210  718  766  677 
Total quick assets 5,996  7,284  4,566  2,577  969  1,656  1,173  1,556  825  1,180  1,060  2,643  2,725  2,291  2,680  2,512  1,231  1,480  4,036  4,046  1,977  2,742  2,768  2,210  718  766  677 
 
Current liabilities 19,357  15,892  14,412  14,487  16,608  14,364  13,239  15,014  17,590  14,038  12,044  13,201  15,376  12,729  12,392  12,708  12,642  11,003  12,019  12,622  13,858  11,613  10,648  11,736  13,525  11,336  12,040 
Liquidity Ratio
Quick ratio1 0.31 0.46 0.32 0.18 0.06 0.12 0.09 0.10 0.05 0.08 0.09 0.20 0.18 0.18 0.22 0.20 0.10 0.13 0.34 0.32 0.14 0.24 0.26 0.19 0.05 0.07 0.06
Benchmarks
Quick Ratio, Competitors2
Amazon.com Inc. 0.67 0.76 0.62 0.63 0.60 0.60 0.58 0.60 0.54 0.53 0.52 0.54 0.52 0.53 0.58 0.59 0.55 0.56 0.56 0.58 0.54 0.59 0.59
Costco Wholesale Corp. 0.49 0.60 0.58 0.47 0.45 0.47 0.43 0.41 0.43 0.45 0.44 0.41 0.41 0.41 0.34 0.40 0.40 0.38 0.43 0.41 0.42 0.46 0.48 0.48 0.55
Dollar General Corp. 0.37 0.55 0.55 0.05 0.06 0.06 0.07 0.08 0.09 0.09 0.11 0.09 0.08 0.08 0.08 0.07 0.07 0.07 0.09 0.08 0.09 0.08 0.11 0.29 0.11 0.09 0.09
Home Depot Inc. 0.68 0.69 0.48 0.23 0.23 0.26 0.21 0.22 0.22 0.31 0.33 0.34 0.36 0.44 0.35 0.32 0.39 0.41 0.35 0.33 0.31 0.40 0.27 0.28 0.31 0.46 0.33
Lowe’s Cos. Inc. 0.52 0.60 0.34 0.06 0.06 0.13 0.18 0.05 0.12 0.18 0.11 0.06 0.06 0.13 0.14 0.05 0.09 0.16 0.34 0.07 0.11 0.09 0.12 0.06 0.16 0.11 0.07
TJX Cos. Inc. 0.93 0.92 0.96 0.50 0.33 0.39 0.40 0.61 0.52 0.63 0.70 0.70 0.59 0.70 0.75 0.78 0.64 0.58 0.61 0.61 0.51 0.60 0.69 0.76 0.61 0.71 0.69
Walmart Inc. 0.23 0.27 0.24 0.20 0.17 0.18 0.18 0.18 0.17 0.29 0.15 0.16 0.16 0.16 0.16 0.19 0.15 0.19 0.18 0.22 0.17 0.17 0.19 0.24 0.18 0.18 0.18

Based on: 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), 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 Q3 2021 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 5,996 ÷ 19,357 = 0.31

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Target Corp.’s quick ratio improved from Q1 2021 to Q2 2021 but then deteriorated significantly from Q2 2021 to Q3 2021.

Cash Ratio

Target Corp., cash ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Jan 31, 2015 Nov 1, 2014 Aug 2, 2014 May 3, 2014
Selected Financial Data (US$ in millions)
Cash and cash equivalents 5,996  7,284  4,566  2,577  969  1,656  1,173  1,556  825  1,180  1,060  2,643  2,725  2,291  2,680  2,512  1,231  1,480  4,036  4,046  1,977  2,742  2,768  2,210  718  766  677 
Total cash assets 5,996  7,284  4,566  2,577  969  1,656  1,173  1,556  825  1,180  1,060  2,643  2,725  2,291  2,680  2,512  1,231  1,480  4,036  4,046  1,977  2,742  2,768  2,210  718  766  677 
 
Current liabilities 19,357  15,892  14,412  14,487  16,608  14,364  13,239  15,014  17,590  14,038  12,044  13,201  15,376  12,729  12,392  12,708  12,642  11,003  12,019  12,622  13,858  11,613  10,648  11,736  13,525  11,336  12,040 
Liquidity Ratio
Cash ratio1 0.31 0.46 0.32 0.18 0.06 0.12 0.09 0.10 0.05 0.08 0.09 0.20 0.18 0.18 0.22 0.20 0.10 0.13 0.34 0.32 0.14 0.24 0.26 0.19 0.05 0.07 0.06
Benchmarks
Cash Ratio, Competitors2
Amazon.com Inc. 0.67 0.76 0.62 0.63 0.60 0.60 0.58 0.60 0.54 0.53 0.52 0.54 0.52 0.53 0.58 0.59 0.55 0.56 0.56 0.58 0.54 0.59 0.59
Costco Wholesale Corp. 0.44 0.54 0.52 0.38 0.38 0.41 0.36 0.32 0.35 0.36 0.36 0.31 0.34 0.33 0.27 0.32 0.32 0.30 0.35 0.31 0.34 0.39 0.41 0.41 0.48
Dollar General Corp. 0.37 0.55 0.55 0.05 0.06 0.06 0.07 0.08 0.09 0.09 0.11 0.09 0.08 0.08 0.08 0.07 0.07 0.07 0.09 0.08 0.09 0.08 0.11 0.29 0.11 0.09 0.09
Home Depot Inc. 0.58 0.58 0.37 0.12 0.11 0.14 0.10 0.11 0.10 0.19 0.20 0.22 0.22 0.31 0.22 0.18 0.25 0.28 0.21 0.18 0.19 0.30 0.17 0.15 0.18 0.33 0.19
Lowe’s Cos. Inc. 0.52 0.60 0.34 0.06 0.06 0.13 0.18 0.05 0.12 0.18 0.11 0.06 0.06 0.13 0.14 0.05 0.09 0.16 0.34 0.07 0.11 0.09 0.12 0.06 0.16 0.11 0.07
TJX Cos. Inc. 0.90 0.87 0.92 0.45 0.27 0.33 0.34 0.55 0.45 0.56 0.63 0.64 0.53 0.63 0.68 0.73 0.58 0.52 0.55 0.56 0.45 0.54 0.63 0.71 0.55 0.65 0.63
Walmart Inc. 0.16 0.21 0.18 0.12 0.10 0.12 0.12 0.10 0.11 0.22 0.10 0.09 0.09 0.09 0.09 0.10 0.08 0.11 0.11 0.13 0.10 0.09 0.11 0.14 0.09 0.09 0.09

Based on: 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), 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 Q3 2021 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 5,996 ÷ 19,357 = 0.31

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Target Corp.’s cash ratio improved from Q1 2021 to Q2 2021 but then deteriorated significantly from Q2 2021 to Q3 2021.