Paying users zone. Data is covered by hidden.

  • Get to Johnson & Johnson for $19.99, or

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


Common Stock Valuation Ratios (Price Multiples)
Quarterly Data

Difficulty: Beginner


Historical Valuation Ratios (Summary)

Johnson & Johnson, historical price multiples (quarterly data)

Microsoft Excel LibreOffice Calc
Jul 1, 2018 Apr 1, 2018 Dec 31, 2017 Oct 1, 2017 Jul 2, 2017 Apr 2, 2017 Dec 31, 2016 Oct 2, 2016 Jul 3, 2016 Apr 3, 2016 Dec 31, 2015 Sep 27, 2015 Jun 28, 2015 Mar 29, 2015 Dec 28, 2014 Sep 28, 2014 Jun 29, 2014 Mar 30, 2014 Dec 29, 2013 Sep 29, 2013 Jun 30, 2013 Mar 31, 2013
Price to earnings (P/E) hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Price to operating profit (P/OP) hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Price to sales (P/S) hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Price to book value (P/BV) hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Ratio Description The company
P/E ratio The P/E ratio tells analyst how much an investor in common stock pays per dollar of current earnings. Johnson & Johnson's P/E ratio increased from Q4 2017 to Q1 2018 but then declined significantly from Q1 2018 to Q2 2018.
P/OP ratio Because P/E ratio is calculated using net income, the ratio can be sensitive to nonrecurring earnings and capital structure, analysts may use price to operating profit. Johnson & Johnson's P/OP ratio declined from Q4 2017 to Q1 2018 but then increased from Q1 2018 to Q2 2018 not reaching Q4 2017 level.
P/S ratio An rationale for the P/S ratio is that sales, as the top line in an income statement, are generally less subject to distortion or manipulation than other fundamentals such as EPS or book value. Sales are also more stable than earnings and never negative. Johnson & Johnson's P/S ratio declined from Q4 2017 to Q1 2018 but then slightly increased from Q1 2018 to Q2 2018.
P/BV ratio The P/BV ratio is interpreted as an indicator of market judgment about the relationship between a company's required rate of return and its actual rate of return. Johnson & Johnson's P/BV ratio declined from Q4 2017 to Q1 2018 but then increased from Q1 2018 to Q2 2018 not reaching Q4 2017 level.

Price to Earnings (P/E)

Johnson & Johnson, historical P/E calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jul 1, 2018 Apr 1, 2018 Dec 31, 2017 Oct 1, 2017 Jul 2, 2017 Apr 2, 2017 Dec 31, 2016 Oct 2, 2016 Jul 3, 2016 Apr 3, 2016 Dec 31, 2015 Sep 27, 2015 Jun 28, 2015 Mar 29, 2015 Dec 28, 2014 Sep 28, 2014 Jun 29, 2014 Mar 30, 2014 Dec 29, 2013 Sep 29, 2013 Jun 30, 2013 Mar 31, 2013
No. shares of common stock outstanding1 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Selected Financial Data (USD $)
Net earnings (in millions) hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Earnings per share (EPS)3 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Share price1, 2 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
P/E ratio4 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden

1 Data adjusted for splits and stock dividends.

2 Close price on the filing date of Johnson & Johnson's Quarterly or Annual Report.

Q2 2018 Calculations

3 EPS = (Net earningsQ2 2018 + Net earningsQ1 2018 + Net earningsQ4 2017 + Net earningsQ3 2017) ÷ No. shares of common stock outstanding
= (hidden + hidden + hidden + hidden) ÷ hidden = hidden

4 P/E ratio = Share price ÷ EPS
= hidden ÷ hidden = hidden

Ratio Description The company
P/E ratio The P/E ratio tells analyst how much an investor in common stock pays per dollar of current earnings. Johnson & Johnson's P/E ratio increased from Q4 2017 to Q1 2018 but then declined significantly from Q1 2018 to Q2 2018.

Price to Operating Profit (P/OP)

Johnson & Johnson, historical P/OP calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jul 1, 2018 Apr 1, 2018 Dec 31, 2017 Oct 1, 2017 Jul 2, 2017 Apr 2, 2017 Dec 31, 2016 Oct 2, 2016 Jul 3, 2016 Apr 3, 2016 Dec 31, 2015 Sep 27, 2015 Jun 28, 2015 Mar 29, 2015 Dec 28, 2014 Sep 28, 2014 Jun 29, 2014 Mar 30, 2014 Dec 29, 2013 Sep 29, 2013 Jun 30, 2013 Mar 31, 2013
No. shares of common stock outstanding1 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Selected Financial Data (USD $)
Operating earnings (in millions) hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Operating profit per share3 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Share price1, 2 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
P/OP ratio4 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden

1 Data adjusted for splits and stock dividends.

2 Close price on the filing date of Johnson & Johnson's Quarterly or Annual Report.

Q2 2018 Calculations

3 Operating profit per share = (Operating earningsQ2 2018 + Operating earningsQ1 2018 + Operating earningsQ4 2017 + Operating earningsQ3 2017) ÷ No. shares of common stock outstanding
= (hidden + hidden + hidden + hidden) ÷ hidden = hidden

4 P/OP ratio = Share price ÷ Operating profit per share
= hidden ÷ hidden = hidden

Ratio Description The company
P/OP ratio Because P/E ratio is calculated using net income, the ratio can be sensitive to nonrecurring earnings and capital structure, analysts may use price to operating profit. Johnson & Johnson's P/OP ratio declined from Q4 2017 to Q1 2018 but then increased from Q1 2018 to Q2 2018 not reaching Q4 2017 level.

Price to Sales (P/S)

Johnson & Johnson, historical P/S calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jul 1, 2018 Apr 1, 2018 Dec 31, 2017 Oct 1, 2017 Jul 2, 2017 Apr 2, 2017 Dec 31, 2016 Oct 2, 2016 Jul 3, 2016 Apr 3, 2016 Dec 31, 2015 Sep 27, 2015 Jun 28, 2015 Mar 29, 2015 Dec 28, 2014 Sep 28, 2014 Jun 29, 2014 Mar 30, 2014 Dec 29, 2013 Sep 29, 2013 Jun 30, 2013 Mar 31, 2013
No. shares of common stock outstanding1 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Selected Financial Data (USD $)
Sales to customers (in millions) hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Sales per share3 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Share price1, 2 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
P/S ratio4 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden

1 Data adjusted for splits and stock dividends.

2 Close price on the filing date of Johnson & Johnson's Quarterly or Annual Report.

Q2 2018 Calculations

3 Sales per share = (Sales to customersQ2 2018 + Sales to customersQ1 2018 + Sales to customersQ4 2017 + Sales to customersQ3 2017) ÷ No. shares of common stock outstanding
= (hidden + hidden + hidden + hidden) ÷ hidden = hidden

4 P/S ratio = Share price ÷ Sales per share
= hidden ÷ hidden = hidden

Ratio Description The company
P/S ratio An rationale for the P/S ratio is that sales, as the top line in an income statement, are generally less subject to distortion or manipulation than other fundamentals such as EPS or book value. Sales are also more stable than earnings and never negative. Johnson & Johnson's P/S ratio declined from Q4 2017 to Q1 2018 but then slightly increased from Q1 2018 to Q2 2018.

Price to Book Value (P/BV)

Johnson & Johnson, historical P/BV calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jul 1, 2018 Apr 1, 2018 Dec 31, 2017 Oct 1, 2017 Jul 2, 2017 Apr 2, 2017 Dec 31, 2016 Oct 2, 2016 Jul 3, 2016 Apr 3, 2016 Dec 31, 2015 Sep 27, 2015 Jun 28, 2015 Mar 29, 2015 Dec 28, 2014 Sep 28, 2014 Jun 29, 2014 Mar 30, 2014 Dec 29, 2013 Sep 29, 2013 Jun 30, 2013 Mar 31, 2013
No. shares of common stock outstanding1 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Selected Financial Data (USD $)
Shareholders’ equity (in millions) hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Book value per share (BVPS)3 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Share price1, 2 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
P/BV ratio4 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden

1 Data adjusted for splits and stock dividends.

2 Close price on the filing date of Johnson & Johnson's Quarterly or Annual Report.

Q2 2018 Calculations

3 BVPS = Shareholders’ equity ÷ No. shares of common stock outstanding
= hidden ÷ hidden = hidden

4 P/BV ratio = Share price ÷ BVPS
= hidden ÷ hidden = hidden

Ratio Description The company
P/BV ratio The P/BV ratio is interpreted as an indicator of market judgment about the relationship between a company's required rate of return and its actual rate of return. Johnson & Johnson's P/BV ratio declined from Q4 2017 to Q1 2018 but then increased from Q1 2018 to Q2 2018 not reaching Q4 2017 level.