Target Corp. (TGT)


Analysis of Solvency Ratios
Quarterly Data

Beginner level


Solvency Ratios (Summary)

Target Corp., solvency ratios (quarterly data)

Microsoft Excel LibreOffice Calc
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 Feb 1, 2014 Nov 2, 2013 Aug 3, 2013 May 4, 2013
Debt Ratios
Debt to equity 1.01 0.97 1.12 1.00 1.05 1.00 1.02 0.99 1.13 1.10 1.16 1.16 1.16 1.10 1.13 0.98 0.96 0.91 0.90 0.91 0.80 0.79 0.78 0.85 0.92 0.90 0.86
Debt to equity (including operating lease liability) 1.20 1.15 1.30 1.18 1.24 1.18 1.20 0.99 1.13 1.10 1.16 1.16 1.16 1.10 1.13 0.98 0.96 0.91 0.90 0.91 0.80 0.79 0.78 0.85 0.92 0.90 0.86
Debt to capital 0.50 0.49 0.53 0.50 0.51 0.50 0.51 0.50 0.53 0.52 0.54 0.54 0.54 0.52 0.53 0.50 0.49 0.48 0.47 0.48 0.44 0.44 0.44 0.46 0.48 0.47 0.46
Debt to capital (including operating lease liability) 0.55 0.54 0.57 0.54 0.55 0.54 0.55 0.50 0.53 0.52 0.54 0.54 0.54 0.52 0.53 0.50 0.49 0.48 0.47 0.48 0.44 0.44 0.44 0.46 0.48 0.47 0.46
Debt to assets 0.27 0.28 0.31 0.27 0.27 0.28 0.29 0.30 0.31 0.33 0.34 0.34 0.33 0.34 0.36 0.32 0.31 0.32 0.32 0.31 0.28 0.29 0.29 0.31 0.32 0.33 0.32
Debt to assets (including operating lease liability) 0.32 0.33 0.36 0.32 0.31 0.33 0.34 0.30 0.31 0.33 0.34 0.34 0.33 0.34 0.36 0.32 0.31 0.32 0.32 0.31 0.28 0.29 0.29 0.31 0.32 0.33 0.32
Financial leverage 3.79 3.51 3.65 3.65 3.93 3.58 3.49 3.33 3.66 3.37 3.38 3.42 3.49 3.22 3.18 3.11 3.15 2.90 2.85 2.96 2.84 2.71 2.67 2.74 2.87 2.76 2.68
Coverage Ratios
Interest coverage 9.86 9.42 9.09 8.97 8.60 6.75 6.50 6.47 6.70 8.38 6.60 4.95 5.69 5.46 6.56 9.11 8.18 8.29 5.27 5.14 4.41 4.10 5.92 3.76

Based on: 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), 10-K (filing date: 2014-03-14), 10-Q (filing date: 2013-11-27), 10-Q (filing date: 2013-08-28), 10-Q (filing date: 2013-05-30).

Solvency ratio Description The company
Debt to equity ratio A solvency ratio calculated as total debt divided by total shareholders’ equity. Target Corp.’s debt to equity ratio improved from Q1 2020 to Q2 2020 but then slightly deteriorated from Q2 2020 to Q3 2020.
Debt to equity (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total shareholders’ equity. Target Corp.’s debt to equity ratio (including operating lease liability) improved from Q1 2020 to Q2 2020 but then slightly deteriorated from Q2 2020 to Q3 2020.
Debt to capital ratio A solvency ratio calculated as total debt divided by total debt plus shareholders’ equity. Target Corp.’s debt to capital ratio improved from Q1 2020 to Q2 2020 but then slightly deteriorated from Q2 2020 to Q3 2020.
Debt to capital (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total debt (including operating lease liability) plus shareholders’ equity. Target Corp.’s debt to capital ratio (including operating lease liability) improved from Q1 2020 to Q2 2020 but then slightly deteriorated from Q2 2020 to Q3 2020.
Debt to assets ratio A solvency ratio calculated as total debt divided by total assets. Target Corp.’s debt to assets ratio improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.
Debt to assets (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total assets. Target Corp.’s debt to assets ratio (including operating lease liability) improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.
Financial leverage ratio A solvency ratio calculated as total assets divided by total shareholders’ equity. Target Corp.’s financial leverage ratio decreased from Q1 2020 to Q2 2020 but then increased from Q2 2020 to Q3 2020 exceeding Q1 2020 level.

Solvency ratio Description The company
Interest coverage ratio A solvency ratio calculated as EBIT divided by interest payments. Target Corp.’s interest coverage ratio improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.

Debt to Equity

Target Corp., debt to equity calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Feb 1, 2014 Nov 2, 2013 Aug 3, 2013 May 4, 2013
Selected Financial Data (US$ in millions)
Current portion of long-term debt and other borrowings 1,159  1,153  1,056  1,052  1,535  1,044  283  270  1,354  1,354  1,717  1,718  729  647  1,627  815  825  841  112  91  483  294  1,466  1,160  2,122  1,833  523 
Long-term debt and other borrowings, excluding current portion 10,513  10,365  11,357  10,223  10,104  10,108  11,107  11,317  11,277  10,892  11,086  11,031  12,097  12,063  12,596  11,945  11,951  11,883  12,654  12,705  12,623  12,625  11,391  12,622  12,665  12,655  13,691 
Total debt 11,672  11,518  12,413  11,275  11,639  11,152  11,390  11,587  12,631  12,246  12,803  12,749  12,826  12,710  14,223  12,760  12,776  12,724  12,766  12,796  13,106  12,919  12,857  13,782  14,787  14,488  14,214 
 
Shareholders’ investment 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  16,231  16,156  16,020  16,520 
Solvency Ratio
Debt to equity1 1.01 0.97 1.12 1.00 1.05 1.00 1.02 0.99 1.13 1.10 1.16 1.16 1.16 1.10 1.13 0.98 0.96 0.91 0.90 0.91 0.80 0.79 0.78 0.85 0.92 0.90 0.86
Benchmarks
Debt to Equity, Competitors2
Amazon.com Inc. 0.45 0.47 0.51 0.57 0.63 0.70 0.78 0.90 1.04 0.38 0.40 0.45 0.46 0.50 0.56 0.63 0.75 0.81 0.89 0.91 0.38 0.38 0.38
Costco Wholesale Corp. 0.45 0.45 0.47 0.49 0.51 0.54 0.56 0.60 0.62 0.40 0.41 0.43 0.43 0.44 0.45 0.56 0.58 0.57 0.49 0.41 0.41 0.42 0.43 0.44
eBay Inc. 2.37 2.27 1.78 1.47 1.33 1.29 1.21 1.24 0.89 1.00 0.77 0.85 1.32 1.40 1.43 1.03 1.15 0.38 0.39 0.38 0.38 0.28 0.21
Home Depot Inc. 19.53 12.69 15.29 18.59 10.06 7.03 5.79 5.45 4.07 3.15 3.31 3.37 2.74 2.24 1.83 1.84 1.65 1.46 1.21 1.18 1.13 0.82 0.78
Lowe’s Cos. Inc. 7.26 6.65 5.42 4.45 2.89 2.74 2.76 2.89 2.79 2.91 2.90 2.44 2.30 2.29 2.14 1.65 1.50 1.31 1.20 1.14 1.06 0.90 0.88 0.89 0.80 0.69 0.68
Netflix Inc. 1.81 2.06 1.81 1.98 1.66 1.86 1.63 1.81 1.47 1.55 1.13 1.26 0.94 0.98 1.02 1.07 1.11 1.18 1.26 0.48 0.52 0.56 0.61
TJX Cos. Inc. 0.40 0.42 0.44 0.44 0.42 0.43 0.42 0.43 0.48 0.49 0.49 0.49 0.51 0.36 0.36 0.38 0.37 0.38 0.38 0.38 0.37 0.38 0.30 0.30 0.31 0.33 0.34
Walmart Inc. 0.82 0.81 0.85 0.80 0.85 0.76 0.61 0.60 0.66 0.62 0.63 0.59 0.64 0.62 0.67 0.62 0.66 0.62 0.66 0.62 0.70 0.70 0.76 0.74 0.84 0.80 0.81

Based on: 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), 10-K (filing date: 2014-03-14), 10-Q (filing date: 2013-11-27), 10-Q (filing date: 2013-08-28), 10-Q (filing date: 2013-05-30).

1 Q3 2020 Calculation
Debt to equity = Total debt ÷ Shareholders’ investment
= 11,672 ÷ 11,545 = 1.01

2 Click competitor name to see calculations.

Solvency ratio Description The company
Debt to equity ratio A solvency ratio calculated as total debt divided by total shareholders’ equity. Target Corp.’s debt to equity ratio improved from Q1 2020 to Q2 2020 but then slightly deteriorated from Q2 2020 to Q3 2020.

Debt to Equity (including Operating Lease Liability)

Target Corp., debt to equity (including operating lease liability) calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Feb 1, 2014 Nov 2, 2013 Aug 3, 2013 May 4, 2013
Selected Financial Data (US$ in millions)
Current portion of long-term debt and other borrowings 1,159  1,153  1,056  1,052  1,535  1,044  283  270  1,354  1,354  1,717  1,718  729  647  1,627  815  825  841  112  91  483  294  1,466  1,160  2,122  1,833  523 
Long-term debt and other borrowings, excluding current portion 10,513  10,365  11,357  10,223  10,104  10,108  11,107  11,317  11,277  10,892  11,086  11,031  12,097  12,063  12,596  11,945  11,951  11,883  12,654  12,705  12,623  12,625  11,391  12,622  12,665  12,655  13,691 
Total debt 11,672  11,518  12,413  11,275  11,639  11,152  11,390  11,587  12,631  12,246  12,803  12,749  12,826  12,710  14,223  12,760  12,776  12,724  12,766  12,796  13,106  12,919  12,857  13,782  14,787  14,488  14,214 
Noncurrent operating lease liabilities 2,208  2,111  2,064  2,004  2,046  2,028  2,007  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — 
Total debt (including operating lease liability) 13,880  13,629  14,477  13,279  13,685  13,180  13,397  11,587  12,631  12,246  12,803  12,749  12,826  12,710  14,223  12,760  12,776  12,724  12,766  12,796  13,106  12,919  12,857  13,782  14,787  14,488  14,214 
 
Shareholders’ investment 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  16,231  16,156  16,020  16,520 
Solvency Ratio
Debt to equity (including operating lease liability)1 1.20 1.15 1.30 1.18 1.24 1.18 1.20 0.99 1.13 1.10 1.16 1.16 1.16 1.10 1.13 0.98 0.96 0.91 0.90 0.91 0.80 0.79 0.78 0.85 0.92 0.90 0.86
Benchmarks
Debt to Equity (including Operating Lease Liability), Competitors2
Amazon.com Inc. 1.10 1.13 1.20 0.57 0.63 0.70 0.78 0.90 1.04 0.38 0.40 0.45 0.46 0.50 0.56 0.63 0.75 0.81 0.89 0.91 0.38 0.38 0.38
eBay Inc. 2.52 2.39 1.88 1.47 1.33 1.29 1.21 1.24 0.89 1.00 0.77 0.85 1.32 1.40 1.43 1.03 1.15 0.38 0.39 0.38 0.38 0.28 0.21
Home Depot Inc. 19.53 12.69 15.29 18.59 10.06 7.03 5.79 5.45 4.07 3.15 3.31 3.37 2.74 2.24 1.83 1.84 1.65 1.46 1.21 1.18 1.13 0.82 0.78
Lowe’s Cos. Inc. 9.07 8.37 6.83 4.45 2.89 2.74 2.76 2.89 2.79 2.91 2.90 2.44 2.30 2.29 2.14 1.65 1.50 1.31 1.20 1.14 1.06 0.90 0.88 0.89 0.80 0.69 0.68
TJX Cos. Inc. 2.07 2.14 2.18 0.44 0.42 0.43 0.42 0.43 0.48 0.49 0.49 0.49 0.51 0.36 0.36 0.38 0.37 0.38 0.38 0.38 0.37 0.38 0.30 0.30 0.31 0.33 0.34
Walmart Inc. 1.06 1.06 1.11 0.80 0.85 0.76 0.61 0.60 0.66 0.62 0.63 0.59 0.64 0.62 0.67 0.62 0.66 0.62 0.66 0.62 0.70 0.70 0.76 0.74 0.84 0.80 0.81

Based on: 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), 10-K (filing date: 2014-03-14), 10-Q (filing date: 2013-11-27), 10-Q (filing date: 2013-08-28), 10-Q (filing date: 2013-05-30).

1 Q3 2020 Calculation
Debt to equity (including operating lease liability) = Total debt (including operating lease liability) ÷ Shareholders’ investment
= 13,880 ÷ 11,545 = 1.20

2 Click competitor name to see calculations.

Solvency ratio Description The company
Debt to equity (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total shareholders’ equity. Target Corp.’s debt to equity ratio (including operating lease liability) improved from Q1 2020 to Q2 2020 but then slightly deteriorated from Q2 2020 to Q3 2020.

Debt to Capital

Target Corp., debt to capital calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Feb 1, 2014 Nov 2, 2013 Aug 3, 2013 May 4, 2013
Selected Financial Data (US$ in millions)
Current portion of long-term debt and other borrowings 1,159  1,153  1,056  1,052  1,535  1,044  283  270  1,354  1,354  1,717  1,718  729  647  1,627  815  825  841  112  91  483  294  1,466  1,160  2,122  1,833  523 
Long-term debt and other borrowings, excluding current portion 10,513  10,365  11,357  10,223  10,104  10,108  11,107  11,317  11,277  10,892  11,086  11,031  12,097  12,063  12,596  11,945  11,951  11,883  12,654  12,705  12,623  12,625  11,391  12,622  12,665  12,655  13,691 
Total debt 11,672  11,518  12,413  11,275  11,639  11,152  11,390  11,587  12,631  12,246  12,803  12,749  12,826  12,710  14,223  12,760  12,776  12,724  12,766  12,796  13,106  12,919  12,857  13,782  14,787  14,488  14,214 
Shareholders’ investment 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  16,231  16,156  16,020  16,520 
Total capital 23,217  23,354  23,530  22,572  22,719  22,319  22,548  23,296  23,768  23,344  23,824  23,702  23,895  24,287  26,768  25,717  26,032  26,666  26,940  26,793  29,479  29,352  29,343  30,013  30,943  30,508  30,734 
Solvency Ratio
Debt to capital1 0.50 0.49 0.53 0.50 0.51 0.50 0.51 0.50 0.53 0.52 0.54 0.54 0.54 0.52 0.53 0.50 0.49 0.48 0.47 0.48 0.44 0.44 0.44 0.46 0.48 0.47 0.46
Benchmarks
Debt to Capital, Competitors2
Amazon.com Inc. 0.31 0.32 0.34 0.36 0.39 0.41 0.44 0.47 0.51 0.27 0.29 0.31 0.32 0.33 0.36 0.39 0.43 0.45 0.47 0.48 0.28 0.27 0.28
Costco Wholesale Corp. 0.31 0.31 0.32 0.33 0.34 0.35 0.36 0.37 0.38 0.29 0.29 0.30 0.30 0.31 0.31 0.36 0.37 0.36 0.33 0.29 0.29 0.30 0.30 0.31
eBay Inc. 0.70 0.69 0.64 0.60 0.57 0.56 0.55 0.55 0.47 0.50 0.44 0.46 0.57 0.58 0.59 0.51 0.53 0.28 0.28 0.28 0.28 0.22 0.17
Home Depot Inc. 1.04 1.04 1.08 1.07 0.95 0.93 0.94 0.95 0.91 0.88 0.85 0.84 0.80 0.76 0.77 0.77 0.73 0.69 0.65 0.65 0.62 0.59 0.55 0.54 0.53 0.45 0.44
Lowe’s Cos. Inc. 0.88 0.87 0.84 0.82 0.74 0.73 0.73 0.74 0.74 0.74 0.74 0.71 0.70 0.70 0.68 0.62 0.60 0.57 0.55 0.53 0.51 0.47 0.47 0.47 0.44 0.41 0.41
Netflix Inc. 0.64 0.67 0.64 0.66 0.62 0.65 0.62 0.64 0.60 0.61 0.53 0.56 0.48 0.50 0.51 0.52 0.53 0.54 0.56 0.33 0.34 0.36 0.38
TJX Cos. Inc. 0.29 0.30 0.30 0.31 0.30 0.30 0.30 0.30 0.32 0.33 0.33 0.33 0.34 0.27 0.26 0.27 0.27 0.28 0.27 0.28 0.27 0.28 0.23 0.23 0.24 0.25 0.25
Walmart Inc. 0.45 0.45 0.46 0.44 0.46 0.43 0.38 0.37 0.40 0.38 0.39 0.37 0.39 0.38 0.40 0.38 0.40 0.38 0.40 0.38 0.41 0.41 0.43 0.43 0.46 0.44 0.45

Based on: 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), 10-K (filing date: 2014-03-14), 10-Q (filing date: 2013-11-27), 10-Q (filing date: 2013-08-28), 10-Q (filing date: 2013-05-30).

1 Q3 2020 Calculation
Debt to capital = Total debt ÷ Total capital
= 11,672 ÷ 23,217 = 0.50

2 Click competitor name to see calculations.

Solvency ratio Description The company
Debt to capital ratio A solvency ratio calculated as total debt divided by total debt plus shareholders’ equity. Target Corp.’s debt to capital ratio improved from Q1 2020 to Q2 2020 but then slightly deteriorated from Q2 2020 to Q3 2020.

Debt to Capital (including Operating Lease Liability)

Target Corp., debt to capital (including operating lease liability) calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Feb 1, 2014 Nov 2, 2013 Aug 3, 2013 May 4, 2013
Selected Financial Data (US$ in millions)
Current portion of long-term debt and other borrowings 1,159  1,153  1,056  1,052  1,535  1,044  283  270  1,354  1,354  1,717  1,718  729  647  1,627  815  825  841  112  91  483  294  1,466  1,160  2,122  1,833  523 
Long-term debt and other borrowings, excluding current portion 10,513  10,365  11,357  10,223  10,104  10,108  11,107  11,317  11,277  10,892  11,086  11,031  12,097  12,063  12,596  11,945  11,951  11,883  12,654  12,705  12,623  12,625  11,391  12,622  12,665  12,655  13,691 
Total debt 11,672  11,518  12,413  11,275  11,639  11,152  11,390  11,587  12,631  12,246  12,803  12,749  12,826  12,710  14,223  12,760  12,776  12,724  12,766  12,796  13,106  12,919  12,857  13,782  14,787  14,488  14,214 
Noncurrent operating lease liabilities 2,208  2,111  2,064  2,004  2,046  2,028  2,007  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — 
Total debt (including operating lease liability) 13,880  13,629  14,477  13,279  13,685  13,180  13,397  11,587  12,631  12,246  12,803  12,749  12,826  12,710  14,223  12,760  12,776  12,724  12,766  12,796  13,106  12,919  12,857  13,782  14,787  14,488  14,214 
Shareholders’ investment 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  16,231  16,156  16,020  16,520 
Total capital (including operating lease liability) 25,425  25,465  25,594  24,576  24,765  24,347  24,555  23,296  23,768  23,344  23,824  23,702  23,895  24,287  26,768  25,717  26,032  26,666  26,940  26,793  29,479  29,352  29,343  30,013  30,943  30,508  30,734 
Solvency Ratio
Debt to capital (including operating lease liability)1 0.55 0.54 0.57 0.54 0.55 0.54 0.55 0.50 0.53 0.52 0.54 0.54 0.54 0.52 0.53 0.50 0.49 0.48 0.47 0.48 0.44 0.44 0.44 0.46 0.48 0.47 0.46
Benchmarks
Debt to Capital (including Operating Lease Liability), Competitors2
Amazon.com Inc. 0.52 0.53 0.55 0.36 0.39 0.41 0.44 0.47 0.51 0.27 0.29 0.31 0.32 0.33 0.36 0.39 0.43 0.45 0.47 0.48 0.28 0.27 0.28
eBay Inc. 0.72 0.71 0.65 0.60 0.57 0.56 0.55 0.55 0.47 0.50 0.44 0.46 0.57 0.58 0.59 0.51 0.53 0.28 0.28 0.28 0.28 0.22 0.17
Home Depot Inc. 1.03 1.03 1.07 1.07 0.95 0.93 0.94 0.95 0.91 0.88 0.85 0.84 0.80 0.76 0.77 0.77 0.73 0.69 0.65 0.65 0.62 0.59 0.55 0.54 0.53 0.45 0.44
Lowe’s Cos. Inc. 0.90 0.89 0.87 0.82 0.74 0.73 0.73 0.74 0.74 0.74 0.74 0.71 0.70 0.70 0.68 0.62 0.60 0.57 0.55 0.53 0.51 0.47 0.47 0.47 0.44 0.41 0.41
TJX Cos. Inc. 0.67 0.68 0.69 0.31 0.30 0.30 0.30 0.30 0.32 0.33 0.33 0.33 0.34 0.27 0.26 0.27 0.27 0.28 0.27 0.28 0.27 0.28 0.23 0.23 0.24 0.25 0.25
Walmart Inc. 0.51 0.52 0.53 0.44 0.46 0.43 0.38 0.37 0.40 0.38 0.39 0.37 0.39 0.38 0.40 0.38 0.40 0.38 0.40 0.38 0.41 0.41 0.43 0.43 0.46 0.44 0.45

Based on: 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), 10-K (filing date: 2014-03-14), 10-Q (filing date: 2013-11-27), 10-Q (filing date: 2013-08-28), 10-Q (filing date: 2013-05-30).

1 Q3 2020 Calculation
Debt to capital (including operating lease liability) = Total debt (including operating lease liability) ÷ Total capital (including operating lease liability)
= 13,880 ÷ 25,425 = 0.55

2 Click competitor name to see calculations.

Solvency ratio Description The company
Debt to capital (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total debt (including operating lease liability) plus shareholders’ equity. Target Corp.’s debt to capital ratio (including operating lease liability) improved from Q1 2020 to Q2 2020 but then slightly deteriorated from Q2 2020 to Q3 2020.

Debt to Assets

Target Corp., debt to assets calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Feb 1, 2014 Nov 2, 2013 Aug 3, 2013 May 4, 2013
Selected Financial Data (US$ in millions)
Current portion of long-term debt and other borrowings 1,159  1,153  1,056  1,052  1,535  1,044  283  270  1,354  1,354  1,717  1,718  729  647  1,627  815  825  841  112  91  483  294  1,466  1,160  2,122  1,833  523 
Long-term debt and other borrowings, excluding current portion 10,513  10,365  11,357  10,223  10,104  10,108  11,107  11,317  11,277  10,892  11,086  11,031  12,097  12,063  12,596  11,945  11,951  11,883  12,654  12,705  12,623  12,625  11,391  12,622  12,665  12,655  13,691 
Total debt 11,672  11,518  12,413  11,275  11,639  11,152  11,390  11,587  12,631  12,246  12,803  12,749  12,826  12,710  14,223  12,760  12,776  12,724  12,766  12,796  13,106  12,919  12,857  13,782  14,787  14,488  14,214 
 
Total assets 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  44,553  46,373  44,162  44,234 
Solvency Ratio
Debt to assets1 0.27 0.28 0.31 0.27 0.27 0.28 0.29 0.30 0.31 0.33 0.34 0.34 0.33 0.34 0.36 0.32 0.31 0.32 0.32 0.31 0.28 0.29 0.29 0.31 0.32 0.33 0.32
Benchmarks
Debt to Assets, Competitors2
Amazon.com Inc. 0.13 0.13 0.14 0.15 0.17 0.18 0.20 0.19 0.22 0.10 0.11 0.10 0.12 0.13 0.14 0.13 0.17 0.18 0.19 0.18 0.10 0.10 0.11
Costco Wholesale Corp. 0.15 0.15 0.15 0.15 0.16 0.17 0.17 0.17 0.18 0.11 0.14 0.14 0.16 0.15 0.15 0.17 0.18 0.18 0.15 0.15 0.15 0.15 0.16 0.15
eBay Inc. 0.41 0.44 0.41 0.40 0.39 0.38 0.38 0.39 0.39 0.42 0.36 0.38 0.44 0.45 0.46 0.38 0.41 0.17 0.17 0.17 0.17 0.13 0.10
Home Depot Inc. 0.56 0.55 0.55 0.66 0.57 0.55 0.55 0.61 0.57 0.54 0.51 0.55 0.51 0.47 0.47 0.50 0.47 0.44 0.40 0.43 0.40 0.38 0.35 0.36 0.37 0.30 0.29
Lowe’s Cos. Inc. 0.45 0.43 0.41 0.47 0.42 0.43 0.41 0.48 0.44 0.44 0.43 0.46 0.43 0.43 0.41 0.40 0.37 0.35 0.33 0.36 0.33 0.31 0.30 0.32 0.30 0.27 0.26
Netflix Inc. 0.40 0.42 0.38 0.40 0.36 0.37 0.32 0.34 0.29 0.29 0.23 0.25 0.19 0.20 0.21 0.23 0.24 0.25 0.26 0.13 0.13 0.14 0.15
TJX Cos. Inc. 0.09 0.10 0.10 0.16 0.15 0.16 0.16 0.16 0.16 0.17 0.17 0.17 0.17 0.14 0.14 0.14 0.14 0.14 0.14 0.15 0.14 0.15 0.12 0.12 0.12 0.13 0.13
Walmart Inc. 0.24 0.24 0.25 0.26 0.27 0.26 0.23 0.23 0.24 0.24 0.23 0.23 0.24 0.24 0.25 0.25 0.26 0.25 0.25 0.25 0.27 0.27 0.27 0.28 0.29 0.28 0.28

Based on: 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), 10-K (filing date: 2014-03-14), 10-Q (filing date: 2013-11-27), 10-Q (filing date: 2013-08-28), 10-Q (filing date: 2013-05-30).

1 Q3 2020 Calculation
Debt to assets = Total debt ÷ Total assets
= 11,672 ÷ 43,741 = 0.27

2 Click competitor name to see calculations.

Solvency ratio Description The company
Debt to assets ratio A solvency ratio calculated as total debt divided by total assets. Target Corp.’s debt to assets ratio improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.

Debt to Assets (including Operating Lease Liability)

Target Corp., debt to assets (including operating lease liability) calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Feb 1, 2014 Nov 2, 2013 Aug 3, 2013 May 4, 2013
Selected Financial Data (US$ in millions)
Current portion of long-term debt and other borrowings 1,159  1,153  1,056  1,052  1,535  1,044  283  270  1,354  1,354  1,717  1,718  729  647  1,627  815  825  841  112  91  483  294  1,466  1,160  2,122  1,833  523 
Long-term debt and other borrowings, excluding current portion 10,513  10,365  11,357  10,223  10,104  10,108  11,107  11,317  11,277  10,892  11,086  11,031  12,097  12,063  12,596  11,945  11,951  11,883  12,654  12,705  12,623  12,625  11,391  12,622  12,665  12,655  13,691 
Total debt 11,672  11,518  12,413  11,275  11,639  11,152  11,390  11,587  12,631  12,246  12,803  12,749  12,826  12,710  14,223  12,760  12,776  12,724  12,766  12,796  13,106  12,919  12,857  13,782  14,787  14,488  14,214 
Noncurrent operating lease liabilities 2,208  2,111  2,064  2,004  2,046  2,028  2,007  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — 
Total debt (including operating lease liability) 13,880  13,629  14,477  13,279  13,685  13,180  13,397  11,587  12,631  12,246  12,803  12,749  12,826  12,710  14,223  12,760  12,776  12,724  12,766  12,796  13,106  12,919  12,857  13,782  14,787  14,488  14,214 
 
Total assets 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  44,553  46,373  44,162  44,234 
Solvency Ratio
Debt to assets (including operating lease liability)1 0.32 0.33 0.36 0.32 0.31 0.33 0.34 0.30 0.31 0.33 0.34 0.34 0.33 0.34 0.36 0.32 0.31 0.32 0.32 0.31 0.28 0.29 0.29 0.31 0.32 0.33 0.32
Benchmarks
Debt to Assets (including Operating Lease Liability), Competitors2
Amazon.com Inc. 0.31 0.31 0.33 0.15 0.17 0.18 0.20 0.19 0.22 0.10 0.11 0.10 0.12 0.13 0.14 0.13 0.17 0.18 0.19 0.18 0.10 0.10 0.11
eBay Inc. 0.44 0.46 0.44 0.40 0.39 0.38 0.38 0.39 0.39 0.42 0.36 0.38 0.44 0.45 0.46 0.38 0.41 0.17 0.17 0.17 0.17 0.13 0.10
Home Depot Inc. 0.67 0.66 0.66 0.66 0.57 0.55 0.55 0.61 0.57 0.54 0.51 0.55 0.51 0.47 0.47 0.50 0.47 0.44 0.40 0.43 0.40 0.38 0.35 0.36 0.37 0.30 0.29
Lowe’s Cos. Inc. 0.56 0.54 0.51 0.47 0.42 0.43 0.41 0.48 0.44 0.44 0.43 0.46 0.43 0.43 0.41 0.40 0.37 0.35 0.33 0.36 0.33 0.31 0.30 0.32 0.30 0.27 0.26
TJX Cos. Inc. 0.47 0.50 0.50 0.16 0.15 0.16 0.16 0.16 0.16 0.17 0.17 0.17 0.17 0.14 0.14 0.14 0.14 0.14 0.14 0.15 0.14 0.15 0.12 0.12 0.12 0.13 0.13
Walmart Inc. 0.32 0.32 0.32 0.26 0.27 0.26 0.23 0.23 0.24 0.24 0.23 0.23 0.24 0.24 0.25 0.25 0.26 0.25 0.25 0.25 0.27 0.27 0.27 0.28 0.29 0.28 0.28

Based on: 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), 10-K (filing date: 2014-03-14), 10-Q (filing date: 2013-11-27), 10-Q (filing date: 2013-08-28), 10-Q (filing date: 2013-05-30).

1 Q3 2020 Calculation
Debt to assets (including operating lease liability) = Total debt (including operating lease liability) ÷ Total assets
= 13,880 ÷ 43,741 = 0.32

2 Click competitor name to see calculations.

Solvency ratio Description The company
Debt to assets (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total assets. Target Corp.’s debt to assets ratio (including operating lease liability) improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.

Financial Leverage

Target Corp., financial leverage calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Feb 1, 2014 Nov 2, 2013 Aug 3, 2013 May 4, 2013
Selected Financial Data (US$ in millions)
Total assets 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  44,553  46,373  44,162  44,234 
Shareholders’ investment 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  16,231  16,156  16,020  16,520 
Solvency Ratio
Financial leverage1 3.79 3.51 3.65 3.65 3.93 3.58 3.49 3.33 3.66 3.37 3.38 3.42 3.49 3.22 3.18 3.11 3.15 2.90 2.85 2.96 2.84 2.71 2.67 2.74 2.87 2.76 2.68
Benchmarks
Financial Leverage, Competitors2
Amazon.com Inc. 3.52 3.61 3.68 3.73 3.67 3.83 4.02 4.74 4.67 3.78 3.74 4.32 3.99 3.93 4.14 4.89 4.52 4.46 4.61 5.07 3.91 3.57 3.52
Costco Wholesale Corp. 2.98 3.02 3.09 3.33 3.19 3.26 3.29 3.55 3.37 3.60 2.86 3.05 2.75 2.94 2.94 3.27 3.15 3.16 3.29 2.80 2.68 2.77 2.74 2.88
eBay Inc. 5.72 5.16 4.29 3.63 3.41 3.36 3.23 3.22 2.30 2.40 2.14 2.26 3.01 3.10 3.10 2.70 2.82 2.31 2.30 2.27 2.25 2.20 2.07
Home Depot Inc. 34.24 23.01 27.65 30.63 17.70 12.93 11.34 9.92 7.92 6.65 7.04 6.74 5.79 5.07 4.62 4.29 4.11 3.79 3.51 3.24 3.08 2.73 2.70
Lowe’s Cos. Inc. 16.18 15.41 13.36 9.47 6.81 6.42 6.66 6.01 6.41 6.62 6.80 5.35 5.36 5.28 5.15 4.08 4.02 3.77 3.63 3.19 3.17 2.95 2.98 2.76 2.69 2.56 2.62
Netflix Inc. 4.51 4.94 4.77 4.96 4.66 5.04 5.01 5.31 5.09 5.31 4.83 5.07 4.88 4.80 4.86 4.59 4.58 4.75 4.84 3.80 3.93 3.93 4.09
TJX Cos. Inc. 4.38 4.31 4.38 2.84 2.86 2.70 2.66 2.73 2.99 2.85 2.80 2.86 2.97 2.62 2.58 2.67 2.76 2.65 2.65 2.61 2.65 2.56 2.43 2.41 2.59 2.58 2.62
Walmart Inc. 3.35 3.34 3.44 3.02 3.15 2.89 2.71 2.63 2.75 2.64 2.71 2.56 2.66 2.59 2.64 2.48 2.58 2.52 2.62 2.50 2.63 2.62 2.77 2.69 2.86 2.80 2.88

Based on: 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), 10-K (filing date: 2014-03-14), 10-Q (filing date: 2013-11-27), 10-Q (filing date: 2013-08-28), 10-Q (filing date: 2013-05-30).

1 Q3 2020 Calculation
Financial leverage = Total assets ÷ Shareholders’ investment
= 43,741 ÷ 11,545 = 3.79

2 Click competitor name to see calculations.

Solvency ratio Description The company
Financial leverage ratio A solvency ratio calculated as total assets divided by total shareholders’ equity. Target Corp.’s financial leverage ratio decreased from Q1 2020 to Q2 2020 but then increased from Q2 2020 to Q3 2020 exceeding Q1 2020 level.

Interest Coverage

Target Corp., interest coverage calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Feb 1, 2014 Nov 2, 2013 Aug 3, 2013 May 4, 2013
Selected Financial Data (US$ in millions)
Net earnings (loss) 714  938  795  798  622  799  718  1,101  480  672  681  817  608  680  632  1,426  549  753  635  (2,640) 352  234  418  521  341  611  498 
Less: Discontinued operations, net of tax —  —  —  (1) (5) —  55  18  73  (20) (16) (3,601) (174) (157) (153) —  —  —  — 
Add: Income tax expense 195  279  229  216  97  223  210  (84) 137  308  357  386  311  316  283  596  249  409  348  474  232  199  299  304  197  350  281 
Add: Net interest expense 113  120  126  110  115  115  121  133  254  135  144  140  142  307  415  153  151  148  155  151  146  433  152  161  165  171  629 
Earnings before interest and tax (EBIT) 1,014  1,337  1,147  1,124  828  1,137  1,048  1,151  869  1,114  1,178  1,348  1,061  1,248  1,312  2,170  876  1,330  1,154  1,586  904  1,023  1,022  986  703  1,132  1,408 
Solvency Ratio
Interest coverage1 9.86 9.42 9.09 8.97 8.60 6.75 6.50 6.47 6.70 8.38 6.60 4.95 5.69 5.46 6.56 9.11 8.18 8.29 5.27 5.14 4.41 4.10 5.92 3.76
Benchmarks
Interest Coverage, Competitors2
Amazon.com Inc. 9.66 10.39 10.46 8.95 8.15 6.41 5.59 5.48 5.81 7.12 8.43 8.84 8.67 8.18 6.47 4.37 3.46 1.42 0.15 0.65
Costco Wholesale Corp. 32.77 31.86 31.13 29.11 28.94 27.90 30.09 30.08 31.14 32.68 29.46 29.71 28.21 27.82 27.36 28.38 30.06 30.70 31.61 30.62 29.29
Home Depot Inc. 13.68 14.26 14.67 14.85 14.69 14.23 13.91 13.96 14.00 13.96 13.99 13.85 13.51 13.15 12.86 12.99 13.14 13.20 13.19 13.02 12.85 12.83 12.82 12.91
Netflix Inc. 4.52 3.66 3.79 3.92 4.37 4.06 3.06 3.04 3.15 3.25 3.75 2.74 2.35 2.09 2.01 2.07 2.51 3.50 5.47 7.96
Walmart Inc. 8.69 8.11 6.54 5.88 4.96 5.11 6.87 7.49 8.49 9.09 9.60 9.66 9.92 10.33 10.39 9.49 9.79 9.62 9.86 11.08 11.02 11.43 11.35 11.56

Based on: 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), 10-K (filing date: 2014-03-14), 10-Q (filing date: 2013-11-27), 10-Q (filing date: 2013-08-28), 10-Q (filing date: 2013-05-30).

1 Q3 2020 Calculation
Interest coverage = (EBITQ3 2020 + EBITQ2 2020 + EBITQ1 2020 + EBITQ4 2019) ÷ (Interest expenseQ3 2020 + Interest expenseQ2 2020 + Interest expenseQ1 2020 + Interest expenseQ4 2019)
= (1,014 + 1,337 + 1,147 + 1,124) ÷ (113 + 120 + 126 + 110) = 9.86

2 Click competitor name to see calculations.

Solvency ratio Description The company
Interest coverage ratio A solvency ratio calculated as EBIT divided by interest payments. Target Corp.’s interest coverage ratio improved from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.