Microsoft Excel LibreOffice Calc

Target Corp. (NYSE:TGT)


Analysis of Solvency Ratios
Quarterly Data

Beginner level


Solvency Ratios (Summary)

Target Corp., solvency 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
Debt Ratios
Debt to equity 1.28 0.97 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
Debt to equity (including operating lease liability) 1.48 1.16 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
Debt to capital 0.56 0.49 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
Debt to capital (including operating lease liability) 0.60 0.54 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
Debt to assets 0.32 0.27 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
Debt to assets (including operating lease liability) 0.37 0.32 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
Financial leverage 4.01 3.62 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
Coverage Ratios
Interest coverage 8.47 9.78 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

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).

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 Q3 2020 to Q4 2020 but then deteriorated significantly from Q4 2020 to Q1 2021.
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 Q3 2020 to Q4 2020 but then deteriorated significantly from Q4 2020 to Q1 2021.
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 Q3 2020 to Q4 2020 but then deteriorated significantly from Q4 2020 to Q1 2021.
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 Q3 2020 to Q4 2020 but then deteriorated significantly from Q4 2020 to Q1 2021.
Debt to assets ratio A solvency ratio calculated as total debt divided by total assets. Target Corp.’s debt to assets ratio deteriorated from Q3 2020 to Q4 2020 and from Q4 2020 to Q1 2021.
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) deteriorated from Q3 2020 to Q4 2020 and from Q4 2020 to Q1 2021.
Financial leverage ratio A solvency ratio calculated as total assets divided by total shareholders’ equity. Target Corp.’s financial leverage ratio decreased from Q3 2020 to Q4 2020 but then increased from Q4 2020 to Q1 2021 exceeding Q3 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 deteriorated from Q3 2020 to Q4 2020 and from Q4 2020 to Q1 2021.

Debt to Equity

Target Corp., debt to equity 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)
Current portion of long-term debt and other borrowings 168  161  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 
Long-term debt and other borrowings, excluding current portion 14,073  11,338  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 
Total debt 14,241  11,499  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 
 
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 
Solvency Ratio
Debt to equity1 1.28 0.97 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
Benchmarks
Debt to Equity, Competitors2
Amazon.com Inc. 0.78 0.83 0.90 0.93 0.99 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
Costco Wholesale Corp. 0.54 0.34 0.43 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
Dollar General Corp. 0.55 0.43 0.42 0.38 0.42 0.45 0.46 0.44 0.46 0.49 0.54 0.54 0.55 0.59 0.59 0.56 0.56 0.55 0.58 0.53 0.50 0.48 0.52 0.59 0.64
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
Lowe’s Cos. Inc. 12.71 9.79 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
TJX Cos. Inc. 1.52 0.38 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
Walmart Inc. 0.85 0.73 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

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
Debt to equity = Total debt ÷ Shareholders’ investment
= 14,241 ÷ 11,169 = 1.28

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 Q3 2020 to Q4 2020 but then deteriorated significantly from Q4 2020 to Q1 2021.

Debt to Equity (including Operating Lease Liability)

Target Corp., debt to equity (including operating lease liability) 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)
Current portion of long-term debt and other borrowings 168  161  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 
Long-term debt and other borrowings, excluding current portion 14,073  11,338  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 
Total debt 14,241  11,499  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 
Noncurrent operating lease liabilities 2,249  2,275  2,208  2,111  2,064  2,004  2,046  2,028  2,007  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — 
Total debt (including operating lease liability) 16,490  13,774  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 
 
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 
Solvency Ratio
Debt to equity (including operating lease liability)1 1.48 1.16 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
Benchmarks
Debt to Equity (including Operating Lease Liability), Competitors2
Amazon.com Inc. 1.20 1.25 1.32 1.35 1.43 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
Costco Wholesale Corp. 0.69 0.48 0.58 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
Dollar General Corp. 1.79 1.75 1.71 1.63 1.65 0.45 0.46 0.44 0.46 0.49 0.54 0.54 0.55 0.59 0.59 0.56 0.56 0.55 0.58 0.53 0.50 0.48 0.52 0.59 0.64
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
Lowe’s Cos. Inc. 15.28 12.04 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
TJX Cos. Inc. 3.48 1.93 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
Walmart Inc. 1.11 0.97 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

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
Debt to equity (including operating lease liability) = Total debt (including operating lease liability) ÷ Shareholders’ investment
= 16,490 ÷ 11,169 = 1.48

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 Q3 2020 to Q4 2020 but then deteriorated significantly from Q4 2020 to Q1 2021.

Debt to Capital

Target Corp., debt to capital 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)
Current portion of long-term debt and other borrowings 168  161  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 
Long-term debt and other borrowings, excluding current portion 14,073  11,338  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 
Total debt 14,241  11,499  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 
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 
Total capital 25,410  23,332  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 
Solvency Ratio
Debt to capital1 0.56 0.49 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
Benchmarks
Debt to Capital, Competitors2
Amazon.com Inc. 0.44 0.45 0.47 0.48 0.50 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
Costco Wholesale Corp. 0.35 0.25 0.30 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
Dollar General Corp. 0.35 0.30 0.29 0.28 0.29 0.31 0.31 0.30 0.31 0.33 0.35 0.35 0.35 0.37 0.37 0.36 0.36 0.36 0.37 0.35 0.34 0.32 0.34 0.37 0.39
Home Depot Inc. 1.11 1.11 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
Lowe’s Cos. Inc. 0.93 0.91 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
TJX Cos. Inc. 0.60 0.27 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
Walmart Inc. 0.46 0.42 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

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
Debt to capital = Total debt ÷ Total capital
= 14,241 ÷ 25,410 = 0.56

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 Q3 2020 to Q4 2020 but then deteriorated significantly from Q4 2020 to Q1 2021.

Debt to Capital (including Operating Lease Liability)

Target Corp., debt to capital (including operating lease liability) 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)
Current portion of long-term debt and other borrowings 168  161  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 
Long-term debt and other borrowings, excluding current portion 14,073  11,338  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 
Total debt 14,241  11,499  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 
Noncurrent operating lease liabilities 2,249  2,275  2,208  2,111  2,064  2,004  2,046  2,028  2,007  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — 
Total debt (including operating lease liability) 16,490  13,774  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 
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 
Total capital (including operating lease liability) 27,659  25,607  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 
Solvency Ratio
Debt to capital (including operating lease liability)1 0.60 0.54 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
Benchmarks
Debt to Capital (including Operating Lease Liability), Competitors2
Amazon.com Inc. 0.54 0.56 0.57 0.57 0.59 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
Costco Wholesale Corp. 0.41 0.33 0.37 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
Dollar General Corp. 0.64 0.64 0.63 0.62 0.62 0.31 0.31 0.30 0.31 0.33 0.35 0.35 0.35 0.37 0.37 0.36 0.36 0.36 0.37 0.35 0.34 0.32 0.34 0.37 0.39
Home Depot Inc. 1.09 1.09 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
Lowe’s Cos. Inc. 0.94 0.92 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
TJX Cos. Inc. 0.78 0.66 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
Walmart Inc. 0.53 0.49 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

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
Debt to capital (including operating lease liability) = Total debt (including operating lease liability) ÷ Total capital (including operating lease liability)
= 16,490 ÷ 27,659 = 0.60

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 Q3 2020 to Q4 2020 but then deteriorated significantly from Q4 2020 to Q1 2021.

Debt to Assets

Target Corp., debt to assets 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)
Current portion of long-term debt and other borrowings 168  161  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 
Long-term debt and other borrowings, excluding current portion 14,073  11,338  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 
Total debt 14,241  11,499  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 
 
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 
Solvency Ratio
Debt to assets1 0.32 0.27 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
Benchmarks
Debt to Assets, Competitors2
Amazon.com Inc. 0.23 0.23 0.25 0.26 0.27 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
Costco Wholesale Corp. 0.18 0.11 0.13 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
Dollar General Corp. 0.16 0.13 0.12 0.12 0.13 0.22 0.22 0.21 0.23 0.24 0.25 0.25 0.26 0.28 0.27 0.26 0.26 0.26 0.28 0.26 0.25 0.24 0.25 0.28 0.29
Home Depot Inc. 0.61 0.61 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
Lowe’s Cos. Inc. 0.48 0.49 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
TJX Cos. Inc. 0.28 0.09 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
Walmart Inc. 0.25 0.23 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

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
Debt to assets = Total debt ÷ Total assets
= 14,241 ÷ 44,806 = 0.32

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 deteriorated from Q3 2020 to Q4 2020 and from Q4 2020 to Q1 2021.

Debt to Assets (including Operating Lease Liability)

Target Corp., debt to assets (including operating lease liability) 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)
Current portion of long-term debt and other borrowings 168  161  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 
Long-term debt and other borrowings, excluding current portion 14,073  11,338  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 
Total debt 14,241  11,499  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 
Noncurrent operating lease liabilities 2,249  2,275  2,208  2,111  2,064  2,004  2,046  2,028  2,007  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — 
Total debt (including operating lease liability) 16,490  13,774  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 
 
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 
Solvency Ratio
Debt to assets (including operating lease liability)1 0.37 0.32 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
Benchmarks
Debt to Assets (including Operating Lease Liability), Competitors2
Amazon.com Inc. 0.35 0.34 0.37 0.37 0.39 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
Costco Wholesale Corp. 0.22 0.16 0.18 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
Dollar General Corp. 0.52 0.51 0.51 0.50 0.51 0.22 0.22 0.21 0.23 0.24 0.25 0.25 0.26 0.28 0.27 0.26 0.26 0.26 0.28 0.26 0.25 0.24 0.25 0.28 0.29
Home Depot Inc. 0.71 0.73 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
Lowe’s Cos. Inc. 0.57 0.60 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
TJX Cos. Inc. 0.65 0.47 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
Walmart Inc. 0.32 0.31 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

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
Debt to assets (including operating lease liability) = Total debt (including operating lease liability) ÷ Total assets
= 16,490 ÷ 44,806 = 0.37

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) deteriorated from Q3 2020 to Q4 2020 and from Q4 2020 to Q1 2021.

Financial Leverage

Target Corp., financial leverage 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)
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 
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 
Solvency Ratio
Financial leverage1 4.01 3.62 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
Benchmarks
Financial Leverage, Competitors2
Amazon.com Inc. 3.39 3.63 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
Costco Wholesale Corp. 3.08 2.94 3.24 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
Dollar General Corp. 3.45 3.41 3.37 3.25 3.24 2.06 2.06 2.03 2.00 2.04 2.15 2.13 2.13 2.16 2.22 2.15 2.10 2.09 2.11 2.07 2.03 1.97 2.04 2.12 2.19
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
Lowe’s Cos. Inc. 26.71 20.02 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
TJX Cos. Inc. 5.36 4.06 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
Walmart Inc. 3.41 3.17 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

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
Financial leverage = Total assets ÷ Shareholders’ investment
= 44,806 ÷ 11,169 = 4.01

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 Q3 2020 to Q4 2020 but then increased from Q4 2020 to Q1 2021 exceeding Q3 2020 level.

Interest Coverage

Target Corp., interest coverage 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)
Net earnings (loss) 284  834  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 
Less: Discontinued operations, net of tax —  —  —  —  (1) (5) —  55  18  73  (20) (16) (3,601) (174) (157) (153)
Add: Income tax expense 45  218  195  279  229  216  97  223  210  (84) 137  308  357  386  311  316  283  596  249  409  348  474  232  199  299 
Add: Net interest expense 117  118  113  120  126  110  115  115  121  133  254  135  144  140  142  307  415  153  151  148  155  151  146  433  152 
Earnings before interest and tax (EBIT) 446  1,169  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 
Solvency Ratio
Interest coverage1 8.47 9.78 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
Benchmarks
Interest Coverage, Competitors2
Amazon.com Inc. 8.85 9.73 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
Costco Wholesale Corp. 33.40 33.57 33.16 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
Dollar General Corp. 25.27 22.89 22.18 21.62 21.16 21.18 21.19 21.07 20.91 20.66 20.98 20.76 20.79 21.09 20.87 21.76 22.28 22.31 22.23 21.78 20.76 20.05
Home Depot Inc. 12.61 13.25 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
Walmart Inc. 9.08 8.74 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

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
Interest coverage = (EBITQ1 2021 + EBITQ4 2020 + EBITQ3 2020 + EBITQ2 2020) ÷ (Interest expenseQ1 2021 + Interest expenseQ4 2020 + Interest expenseQ3 2020 + Interest expenseQ2 2020)
= (446 + 1,169 + 1,014 + 1,337) ÷ (117 + 118 + 113 + 120) = 8.47

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 deteriorated from Q3 2020 to Q4 2020 and from Q4 2020 to Q1 2021.