Paying users zone. Data is covered by hidden.

  • Get to Colgate-Palmolive Co. for $13.99, or

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

Microsoft Excel LibreOffice Calc

Colgate-Palmolive Co. (CL)

Liquidity Analysis
Quarterly Data

Difficulty: Beginner

  • Annual Data
  • Quarterly Data

    • Liquidity ratios measure the company's ability to meet its short-term obligations.

    Ratios (Summary)

    Colgate-Palmolive Co., liquidity ratios (quarterly data)

    Microsoft Excel LibreOffice Calc
    Jun 30, 2018 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
    Current ratio hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Quick ratio hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Cash ratio 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 Colgate-Palmolive Co. Quarterly and Annual Reports
    Ratio Description The company
    Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Colgate-Palmolive Co.'s current ratio deteriorated from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.
    Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Colgate-Palmolive Co.'s quick ratio deteriorated from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.
    Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Colgate-Palmolive Co.'s cash ratio deteriorated from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.

    Current Ratio

    Colgate-Palmolive Co., current ratio calculation (quarterly data)

    Microsoft Excel LibreOffice Calc
    Jun 30, 2018 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
    Selected Financial Data (USD $ in millions)
    Current assets hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Current liabilities hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Ratio
    Current ratio1 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 Colgate-Palmolive Co. Quarterly and Annual Reports

    Q2 2018 Calculations

    1 Current ratio = Current assets ÷ Current liabilities
    = hidden ÷ hidden = hidden

    Ratio Description The company
    Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Colgate-Palmolive Co.'s current ratio deteriorated from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.

    Quick Ratio

    Colgate-Palmolive Co., quick ratio calculation (quarterly data)

    Microsoft Excel LibreOffice Calc
    Jun 30, 2018 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
    Selected Financial Data (USD $ in millions)
    Cash and cash equivalents hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Receivables, net of allowances hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Total quick assets hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Current liabilities hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Ratio
    Quick ratio1 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 Colgate-Palmolive Co. Quarterly and Annual Reports

    Q2 2018 Calculations

    1 Quick ratio = Total quick assets ÷ Current liabilities
    = hidden ÷ hidden = hidden

    Ratio Description The company
    Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Colgate-Palmolive Co.'s quick ratio deteriorated from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.

    Cash Ratio

    Colgate-Palmolive Co., cash ratio calculation (quarterly data)

    Microsoft Excel LibreOffice Calc
    Jun 30, 2018 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
    Selected Financial Data (USD $ in millions)
    Cash and cash equivalents hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Total cash assets hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Current liabilities hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Ratio
    Cash ratio1 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 Colgate-Palmolive Co. Quarterly and Annual Reports

    Q2 2018 Calculations

    1 Cash ratio = Total cash assets ÷ Current liabilities
    = hidden ÷ hidden = hidden

    Ratio Description The company
    Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Colgate-Palmolive Co.'s cash ratio deteriorated from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.