Paying users zone. Data is covered by hidden.

  • Get to Automatic Data Processing Inc. for $15.99, or

  • get to whole website for at least 3 months from $49.99.


Long-term Debt and Solvency Analysis
Quarterly Data

Difficulty: Beginner

Solvency ratios also known as long-term debt ratios measure a company's ability to meet long-term obligations.


Ratios (Summary)

Automatic Data Processing Inc., debt and solvency ratios (quarterly data)

Microsoft Excel LibreOffice Calc
Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013 Dec 31, 2012 Sep 30, 2012 Jun 30, 2012 Mar 31, 2012 Dec 31, 2011 Sep 30, 2011
Debt to equity hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Debt to capital hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Interest coverage hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Source: Based on data from Automatic Data Processing Inc. Quarterly and Annual Reports
Ratio Description The company
Debt-to-equity ratio A solvency ratio calculated as total debt divided by total shareholders' equity. Automatic Data Processing Inc.'s debt-to-equity ratio improved from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018.
Debt-to-capital ratio A solvency ratio calculated as total debt divided by total debt plus shareholders' equity. Automatic Data Processing Inc.'s debt-to-capital ratio improved from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018.
Interest coverage ratio A solvency ratio calculated as EBIT divided by interest payments. Automatic Data Processing Inc.'s interest coverage ratio deteriorated from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018.

Debt to Equity

Automatic Data Processing Inc., debt to equity calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013 Dec 31, 2012 Sep 30, 2012 Jun 30, 2012 Mar 31, 2012 Dec 31, 2011 Sep 30, 2011
Selected Financial Data (USD $ in thousands)
Obligations under reverse repurchase agreements hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Obligations under commercial paper borrowings hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Long-term debt hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Total debt hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Stockholders' equity hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Ratio
Debt to equity1 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Source: Based on data from Automatic Data Processing Inc. Quarterly and Annual Reports

Q3 2018 Calculations

1 Debt to equity = Total debt ÷ Stockholders' equity
= hidden ÷ hidden = hidden

Ratio Description The company
Debt-to-equity ratio A solvency ratio calculated as total debt divided by total shareholders' equity. Automatic Data Processing Inc.'s debt-to-equity ratio improved from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018.

Debt to Capital

Automatic Data Processing Inc., debt to capital calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013 Dec 31, 2012 Sep 30, 2012 Jun 30, 2012 Mar 31, 2012 Dec 31, 2011 Sep 30, 2011
Selected Financial Data (USD $ in thousands)
Obligations under reverse repurchase agreements hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Obligations under commercial paper borrowings hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Long-term debt hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Total debt hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Stockholders' equity hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Total capital hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Ratio
Debt to capital1 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Source: Based on data from Automatic Data Processing Inc. Quarterly and Annual Reports

Q3 2018 Calculations

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

Ratio Description The company
Debt-to-capital ratio A solvency ratio calculated as total debt divided by total debt plus shareholders' equity. Automatic Data Processing Inc.'s debt-to-capital ratio improved from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018.

Interest Coverage

Automatic Data Processing Inc., interest coverage calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013 Dec 31, 2012 Sep 30, 2012 Jun 30, 2012 Mar 31, 2012 Dec 31, 2011 Sep 30, 2011
Selected Financial Data (USD $ in thousands)
Net earnings hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Less: Net earnings (loss) from discontinued operations hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Add: Income tax expense hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Add: Interest expense hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Earnings before interest and tax (EBIT) hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Ratio
Interest coverage1 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Source: Based on data from Automatic Data Processing Inc. Quarterly and Annual Reports

Q3 2018 Calculations

1 Interest coverage = (EBITQ3 2018 + EBITQ2 2018 + EBITQ1 2018 + EBITQ4 2017) ÷ (Interest expenseQ3 2018 + Interest expenseQ2 2018 + Interest expenseQ1 2018 + Interest expenseQ4 2017)
= (hidden + hidden + hidden + hidden) ÷ (hidden + hidden + hidden + hidden) = hidden

Ratio Description The company
Interest coverage ratio A solvency ratio calculated as EBIT divided by interest payments. Automatic Data Processing Inc.'s interest coverage ratio deteriorated from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018.