Paying users zone. Data is covered by hidden.

  • Get to Procter & Gamble Co. for $19.99, or

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

Microsoft Excel LibreOffice Calc

Procter & Gamble Co. (PG)

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)

    Procter & Gamble 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 Dec 31, 2012 Sep 30, 2012
    Current ratio hidden hidden 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 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 hidden hidden
    Source: Based on data from Procter & Gamble Co. Quarterly and Annual Reports
    Ratio Description The company
    Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Procter & Gamble Co.'s current ratio deteriorated from Q2 2018 to Q3 2018 and from Q3 2018 to Q4 2018.
    Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Procter & Gamble Co.'s quick ratio deteriorated from Q2 2018 to Q3 2018 and from Q3 2018 to Q4 2018.
    Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Procter & Gamble Co.'s cash ratio deteriorated from Q2 2018 to Q3 2018 and from Q3 2018 to Q4 2018.

    Current Ratio

    Procter & Gamble 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 Dec 31, 2012 Sep 30, 2012
    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 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 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 hidden hidden
    Source: Based on data from Procter & Gamble Co. Quarterly and Annual Reports

    Q4 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. Procter & Gamble Co.'s current ratio deteriorated from Q2 2018 to Q3 2018 and from Q3 2018 to Q4 2018.

    Quick Ratio

    Procter & Gamble 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 Dec 31, 2012 Sep 30, 2012
    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 hidden hidden
    Restricted cash hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Available-for-sale investment securities hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Accounts receivable 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 quick assets hidden hidden 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 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 hidden hidden
    Source: Based on data from Procter & Gamble Co. Quarterly and Annual Reports

    Q4 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. Procter & Gamble Co.'s quick ratio deteriorated from Q2 2018 to Q3 2018 and from Q3 2018 to Q4 2018.

    Cash Ratio

    Procter & Gamble 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 Dec 31, 2012 Sep 30, 2012
    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 hidden hidden
    Restricted cash hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Available-for-sale investment securities 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 cash assets hidden hidden 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 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 hidden hidden
    Source: Based on data from Procter & Gamble Co. Quarterly and Annual Reports

    Q4 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. Procter & Gamble Co.'s cash ratio deteriorated from Q2 2018 to Q3 2018 and from Q3 2018 to Q4 2018.