Paying users zone. Data is covered by hidden.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Apple Pay Google Pay
Verified by Visa MasterCard SecureCode American Express SafeKey

Microsoft Excel LibreOffice Calc

Target Corp. (TGT)


Long-term Debt and Solvency Analysis

Difficulty: Beginner


Ratios (Summary)

Target Corp., debt and solvency ratios

Microsoft Excel LibreOffice Calc
Feb 2, 2019 Feb 3, 2018 Jan 28, 2017 Jan 30, 2016 Jan 31, 2015 Feb 1, 2014
Debt Ratios
Debt to equity hidden hidden hidden hidden hidden hidden
Debt to equity (including operating lease liability) hidden hidden hidden hidden hidden hidden
Debt to capital hidden hidden hidden hidden hidden hidden
Debt to capital (including operating lease liability) hidden hidden hidden hidden hidden hidden
Debt to assets hidden hidden hidden hidden hidden hidden
Debt to assets (including operating lease liability) hidden hidden hidden hidden hidden hidden
Financial leverage hidden hidden hidden hidden hidden hidden
Coverage Ratios
Interest coverage hidden hidden hidden hidden hidden hidden
Fixed charge coverage hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-03-13), 10-K (filing date: 2018-03-14), 10-K (filing date: 2017-03-08), 10-K (filing date: 2016-03-11), 10-K (filing date: 2015-03-13), 10-K (filing date: 2014-03-14).

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 2017 to 2018 but then slightly deteriorated from 2018 to 2019.
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 (including operating lease liability) ratio improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019.
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 2017 to 2018 but then slightly deteriorated from 2018 to 2019.
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 (including operating lease liability) ratio improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019.
Debt to assets ratio A solvency ratio calculated as total debt divided by total assets. Target Corp.’s debt to assets ratio improved from 2017 to 2018 and from 2018 to 2019.
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 (including operating lease liability) ratio improved from 2017 to 2018 but then slightly deteriorated from 2018 to 2019 not reaching 2017 level.
Financial leverage ratio A solvency ratio calculated as total assets divided by total shareholders’ equity. Target Corp.’s financial leverage ratio improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019.

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 2017 to 2018 and from 2018 to 2019.
Fixed charge coverage ratio A solvency ratio calculated as earnings before fixed charges and tax divided by fixed charges. Target Corp.’s fixed charge coverage ratio improved from 2017 to 2018 and from 2018 to 2019.

Debt to Equity

Target Corp., debt to equity calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Feb 2, 2019 Feb 3, 2018 Jan 28, 2017 Jan 30, 2016 Jan 31, 2015 Feb 1, 2014
Selected Financial Data (US$ in millions)
Current portion of long-term debt and other borrowings hidden hidden hidden hidden hidden hidden
Long-term debt and other borrowings, excluding current portion hidden hidden hidden hidden hidden hidden
Total debt hidden hidden hidden hidden hidden hidden
 
Shareholders’ investment hidden hidden hidden hidden hidden hidden
Ratio
Debt to equity1 hidden hidden hidden hidden hidden hidden
Benchmarks
Debt to Equity, Competitors2
Amazon.com Inc. hidden hidden hidden hidden hidden hidden
Costco Wholesale Corp. hidden hidden hidden hidden hidden hidden
eBay Inc. hidden hidden hidden hidden hidden hidden
Home Depot Inc. hidden hidden hidden hidden hidden hidden
Lowe’s Cos. Inc. hidden hidden hidden hidden hidden hidden
Netflix Inc. hidden hidden hidden hidden hidden hidden
TJX Cos. Inc. hidden hidden hidden hidden hidden hidden
Walmart Inc. hidden hidden hidden hidden hidden hidden
Debt to Equity, Sector
General Retailers hidden hidden hidden hidden hidden hidden
Debt to Equity, Industry
Consumer Services hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-03-13), 10-K (filing date: 2018-03-14), 10-K (filing date: 2017-03-08), 10-K (filing date: 2016-03-11), 10-K (filing date: 2015-03-13), 10-K (filing date: 2014-03-14).

1 2019 Calculation
Debt to equity = Total debt ÷ Shareholders’ investment
= hidden ÷ hidden = hidden

2 Click competitor name to see calculations.

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 2017 to 2018 but then slightly deteriorated from 2018 to 2019.

Debt to Equity (including Operating Lease Liability)

Target Corp., debt to equity (including operating lease liability) calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Feb 2, 2019 Feb 3, 2018 Jan 28, 2017 Jan 30, 2016 Jan 31, 2015 Feb 1, 2014
Selected Financial Data (US$ in millions)
Current portion of long-term debt and other borrowings hidden hidden hidden hidden hidden hidden
Long-term debt and other borrowings, excluding current portion hidden hidden hidden hidden hidden hidden
Total debt hidden hidden hidden hidden hidden hidden
Current portion of operating lease liabilities hidden hidden hidden hidden hidden hidden
Noncurrent operating lease liabilities hidden hidden hidden hidden hidden hidden
Total debt (including operating lease liability) hidden hidden hidden hidden hidden hidden
 
Shareholders’ investment hidden hidden hidden hidden hidden hidden
Ratio
Debt to equity (including operating lease liability)1 hidden hidden hidden hidden hidden hidden
Benchmarks
Debt to Equity (including Operating Lease Liability), Industry
Consumer Services hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-03-13), 10-K (filing date: 2018-03-14), 10-K (filing date: 2017-03-08), 10-K (filing date: 2016-03-11), 10-K (filing date: 2015-03-13), 10-K (filing date: 2014-03-14).

1 2019 Calculation
Debt to equity (including operating lease liability) = Total debt (including operating lease liability) ÷ Shareholders’ investment
= hidden ÷ hidden = hidden

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 (including operating lease liability) ratio improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019.

Debt to Capital

Target Corp., debt to capital calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Feb 2, 2019 Feb 3, 2018 Jan 28, 2017 Jan 30, 2016 Jan 31, 2015 Feb 1, 2014
Selected Financial Data (US$ in millions)
Current portion of long-term debt and other borrowings hidden hidden hidden hidden hidden hidden
Long-term debt and other borrowings, excluding current portion hidden hidden hidden hidden hidden hidden
Total debt hidden hidden hidden hidden hidden hidden
Shareholders’ investment hidden hidden hidden hidden hidden hidden
Total capital hidden hidden hidden hidden hidden hidden
Ratio
Debt to capital1 hidden hidden hidden hidden hidden hidden
Benchmarks
Debt to Capital, Competitors2
Amazon.com Inc. hidden hidden hidden hidden hidden hidden
Costco Wholesale Corp. hidden hidden hidden hidden hidden hidden
eBay Inc. hidden hidden hidden hidden hidden hidden
Home Depot Inc. hidden hidden hidden hidden hidden hidden
Lowe’s Cos. Inc. hidden hidden hidden hidden hidden hidden
Netflix Inc. hidden hidden hidden hidden hidden hidden
TJX Cos. Inc. hidden hidden hidden hidden hidden hidden
Walmart Inc. hidden hidden hidden hidden hidden hidden
Debt to Capital, Sector
General Retailers hidden hidden hidden hidden hidden hidden
Debt to Capital, Industry
Consumer Services hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-03-13), 10-K (filing date: 2018-03-14), 10-K (filing date: 2017-03-08), 10-K (filing date: 2016-03-11), 10-K (filing date: 2015-03-13), 10-K (filing date: 2014-03-14).

1 2019 Calculation
Debt to capital = Total debt ÷ Total capital
= hidden ÷ hidden = hidden

2 Click competitor name to see calculations.

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 2017 to 2018 but then slightly deteriorated from 2018 to 2019.

Debt to Capital (including Operating Lease Liability)

Target Corp., debt to capital (including operating lease liability) calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Feb 2, 2019 Feb 3, 2018 Jan 28, 2017 Jan 30, 2016 Jan 31, 2015 Feb 1, 2014
Selected Financial Data (US$ in millions)
Current portion of long-term debt and other borrowings hidden hidden hidden hidden hidden hidden
Long-term debt and other borrowings, excluding current portion hidden hidden hidden hidden hidden hidden
Total debt hidden hidden hidden hidden hidden hidden
Current portion of operating lease liabilities hidden hidden hidden hidden hidden hidden
Noncurrent operating lease liabilities hidden hidden hidden hidden hidden hidden
Total debt (including operating lease liability) hidden hidden hidden hidden hidden hidden
Shareholders’ investment hidden hidden hidden hidden hidden hidden
Total capital (including operating lease liability) hidden hidden hidden hidden hidden hidden
Ratio
Debt to capital (including operating lease liability)1 hidden hidden hidden hidden hidden hidden
Benchmarks
Debt to Capital (including Operating Lease Liability), Industry
Consumer Services hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-03-13), 10-K (filing date: 2018-03-14), 10-K (filing date: 2017-03-08), 10-K (filing date: 2016-03-11), 10-K (filing date: 2015-03-13), 10-K (filing date: 2014-03-14).

1 2019 Calculation
Debt to capital (including operating lease liability) = Total debt (including operating lease liability) ÷ Total capital (including operating lease liability)
= hidden ÷ hidden = hidden

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 (including operating lease liability) ratio improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019.

Debt to Assets

Target Corp., debt to assets calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Feb 2, 2019 Feb 3, 2018 Jan 28, 2017 Jan 30, 2016 Jan 31, 2015 Feb 1, 2014
Selected Financial Data (US$ in millions)
Current portion of long-term debt and other borrowings hidden hidden hidden hidden hidden hidden
Long-term debt and other borrowings, excluding current portion hidden hidden hidden hidden hidden hidden
Total debt hidden hidden hidden hidden hidden hidden
 
Total assets hidden hidden hidden hidden hidden hidden
Ratio
Debt to assets1 hidden hidden hidden hidden hidden hidden
Benchmarks
Debt to Assets, Competitors2
Amazon.com Inc. hidden hidden hidden hidden hidden hidden
Costco Wholesale Corp. hidden hidden hidden hidden hidden hidden
eBay Inc. hidden hidden hidden hidden hidden hidden
Home Depot Inc. hidden hidden hidden hidden hidden hidden
Lowe’s Cos. Inc. hidden hidden hidden hidden hidden hidden
Netflix Inc. hidden hidden hidden hidden hidden hidden
TJX Cos. Inc. hidden hidden hidden hidden hidden hidden
Walmart Inc. hidden hidden hidden hidden hidden hidden
Debt to Assets, Sector
General Retailers hidden hidden hidden hidden hidden hidden
Debt to Assets, Industry
Consumer Services hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-03-13), 10-K (filing date: 2018-03-14), 10-K (filing date: 2017-03-08), 10-K (filing date: 2016-03-11), 10-K (filing date: 2015-03-13), 10-K (filing date: 2014-03-14).

1 2019 Calculation
Debt to assets = Total debt ÷ Total assets
= hidden ÷ hidden = hidden

2 Click competitor name to see calculations.

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 2017 to 2018 and from 2018 to 2019.

Debt to Assets (including Operating Lease Liability)

Target Corp., debt to assets (including operating lease liability) calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Feb 2, 2019 Feb 3, 2018 Jan 28, 2017 Jan 30, 2016 Jan 31, 2015 Feb 1, 2014
Selected Financial Data (US$ in millions)
Current portion of long-term debt and other borrowings hidden hidden hidden hidden hidden hidden
Long-term debt and other borrowings, excluding current portion hidden hidden hidden hidden hidden hidden
Total debt hidden hidden hidden hidden hidden hidden
Current portion of operating lease liabilities hidden hidden hidden hidden hidden hidden
Noncurrent operating lease liabilities hidden hidden hidden hidden hidden hidden
Total debt (including operating lease liability) hidden hidden hidden hidden hidden hidden
 
Total assets hidden hidden hidden hidden hidden hidden
Ratio
Debt to assets (including operating lease liability)1 hidden hidden hidden hidden hidden hidden
Benchmarks
Debt to Assets (including Operating Lease Liability), Industry
Consumer Services hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-03-13), 10-K (filing date: 2018-03-14), 10-K (filing date: 2017-03-08), 10-K (filing date: 2016-03-11), 10-K (filing date: 2015-03-13), 10-K (filing date: 2014-03-14).

1 2019 Calculation
Debt to assets (including operating lease liability) = Total debt (including operating lease liability) ÷ Total assets
= hidden ÷ hidden = hidden

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 (including operating lease liability) ratio improved from 2017 to 2018 but then slightly deteriorated from 2018 to 2019 not reaching 2017 level.

Financial Leverage

Target Corp., financial leverage calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Feb 2, 2019 Feb 3, 2018 Jan 28, 2017 Jan 30, 2016 Jan 31, 2015 Feb 1, 2014
Selected Financial Data (US$ in millions)
Total assets hidden hidden hidden hidden hidden hidden
Shareholders’ investment hidden hidden hidden hidden hidden hidden
Ratio
Financial leverage1 hidden hidden hidden hidden hidden hidden
Benchmarks
Financial Leverage, Competitors2
Amazon.com Inc. hidden hidden hidden hidden hidden hidden
Costco Wholesale Corp. hidden hidden hidden hidden hidden hidden
eBay Inc. hidden hidden hidden hidden hidden hidden
Home Depot Inc. hidden hidden hidden hidden hidden hidden
Lowe’s Cos. Inc. hidden hidden hidden hidden hidden hidden
Netflix Inc. hidden hidden hidden hidden hidden hidden
TJX Cos. Inc. hidden hidden hidden hidden hidden hidden
Walmart Inc. hidden hidden hidden hidden hidden hidden
Financial Leverage, Sector
General Retailers hidden hidden hidden hidden hidden hidden
Financial Leverage, Industry
Consumer Services hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-03-13), 10-K (filing date: 2018-03-14), 10-K (filing date: 2017-03-08), 10-K (filing date: 2016-03-11), 10-K (filing date: 2015-03-13), 10-K (filing date: 2014-03-14).

1 2019 Calculation
Financial leverage = Total assets ÷ Shareholders’ investment
= hidden ÷ hidden = hidden

2 Click competitor name to see calculations.

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 improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019.

Interest Coverage

Target Corp., interest coverage calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Feb 2, 2019 Feb 3, 2018 Jan 28, 2017 Jan 30, 2016 Jan 31, 2015 Feb 1, 2014
Selected Financial Data (US$ in millions)
Net earnings (loss) hidden hidden hidden hidden hidden hidden
Less: Discontinued operations, net of tax hidden hidden hidden hidden hidden hidden
Add: Income tax expense hidden hidden hidden hidden hidden hidden
Add: Net interest expense hidden hidden hidden hidden hidden hidden
Earnings before interest and tax (EBIT) hidden hidden hidden hidden hidden hidden
Ratio
Interest coverage1 hidden hidden hidden hidden hidden hidden
Benchmarks
Interest Coverage, Competitors2
Amazon.com Inc. hidden hidden hidden hidden hidden hidden
Costco Wholesale Corp. hidden hidden hidden hidden hidden hidden
eBay Inc. hidden hidden hidden hidden hidden hidden
Home Depot Inc. hidden hidden hidden hidden hidden hidden
Lowe’s Cos. Inc. hidden hidden hidden hidden hidden hidden
Netflix Inc. hidden hidden hidden hidden hidden hidden
TJX Cos. Inc. hidden hidden hidden hidden hidden hidden
Walmart Inc. hidden hidden hidden hidden hidden hidden
Interest Coverage, Sector
General Retailers hidden hidden hidden hidden hidden hidden
Interest Coverage, Industry
Consumer Services hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-03-13), 10-K (filing date: 2018-03-14), 10-K (filing date: 2017-03-08), 10-K (filing date: 2016-03-11), 10-K (filing date: 2015-03-13), 10-K (filing date: 2014-03-14).

1 2019 Calculation
Interest coverage = EBIT ÷ Interest expense
= hidden ÷ hidden = hidden

2 Click competitor name to see calculations.

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 2017 to 2018 and from 2018 to 2019.

Fixed Charge Coverage

Target Corp., fixed charge coverage calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Feb 2, 2019 Feb 3, 2018 Jan 28, 2017 Jan 30, 2016 Jan 31, 2015 Feb 1, 2014
Selected Financial Data (US$ in millions)
Net earnings (loss) hidden hidden hidden hidden hidden hidden
Less: Discontinued operations, net of tax hidden hidden hidden hidden hidden hidden
Add: Income tax expense hidden hidden hidden hidden hidden hidden
Add: Net interest expense hidden hidden hidden hidden hidden hidden
Earnings before interest and tax (EBIT) hidden hidden hidden hidden hidden hidden
Add: Operating lease cost hidden hidden hidden hidden hidden hidden
Earnings before fixed charges and tax hidden hidden hidden hidden hidden hidden
 
Net interest expense hidden hidden hidden hidden hidden hidden
Operating lease cost hidden hidden hidden hidden hidden hidden
Fixed charges hidden hidden hidden hidden hidden hidden
Ratio
Fixed charge coverage1 hidden hidden hidden hidden hidden hidden
Benchmarks
Fixed Charge Coverage, Competitors2
Amazon.com Inc. hidden hidden hidden hidden hidden hidden
Costco Wholesale Corp. hidden hidden hidden hidden hidden hidden
eBay Inc. hidden hidden hidden hidden hidden hidden
Home Depot Inc. hidden hidden hidden hidden hidden hidden
Lowe’s Cos. Inc. hidden hidden hidden hidden hidden hidden
Netflix Inc. hidden hidden hidden hidden hidden hidden
TJX Cos. Inc. hidden hidden hidden hidden hidden hidden
Walmart Inc. hidden hidden hidden hidden hidden hidden
Fixed Charge Coverage, Sector
General Retailers hidden hidden hidden hidden hidden hidden
Fixed Charge Coverage, Industry
Consumer Services hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-03-13), 10-K (filing date: 2018-03-14), 10-K (filing date: 2017-03-08), 10-K (filing date: 2016-03-11), 10-K (filing date: 2015-03-13), 10-K (filing date: 2014-03-14).

1 2019 Calculation
Fixed charge coverage = Earnings before fixed charges and tax ÷ Fixed charges
= hidden ÷ hidden = hidden

2 Click competitor name to see calculations.

Ratio Description The company
Fixed charge coverage ratio A solvency ratio calculated as earnings before fixed charges and tax divided by fixed charges. Target Corp.’s fixed charge coverage ratio improved from 2017 to 2018 and from 2018 to 2019.