Paying users zone. Data is covered by hidden.

  • Get to Johnson & Johnson for $19.99, or

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

Visa Mastercard Maestro American Express Discover JCB    PayPal
Next
Microsoft Excel LibreOffice Calc

Johnson & Johnson (JNJ)

Profitability Analysis
Quarterly Data

Difficulty: Beginner

Profitability ratios measure the company’s ability to generate profitable sales from its resources (assets).

Ratios (Summary)

Johnson & Johnson, profitability ratios (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 30, 2018 Sep 30, 2018 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
Return on Sales
Gross profit margin hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Operating profit margin hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Net profit margin hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Return on Investment
Return on equity (ROE) hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Return on assets (ROA) hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-02-20), 10-Q (filing date: 2018-10-31), 10-Q (filing date: 2018-08-02), 10-Q (filing date: 2018-05-01), 10-K (filing date: 2018-02-21), 10-Q (filing date: 2017-11-02), 10-Q (filing date: 2017-08-03), 10-Q (filing date: 2017-05-08), 10-K (filing date: 2017-02-27), 10-Q (filing date: 2016-11-04), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-10), 10-K (filing date: 2016-02-24), 10-Q (filing date: 2015-10-30), 10-Q (filing date: 2015-07-31), 10-Q (filing date: 2015-05-01), 10-K (filing date: 2015-02-24), 10-Q (filing date: 2014-10-30), 10-Q (filing date: 2014-08-01), 10-Q (filing date: 2014-05-02).

Ratio Description The company
Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. Johnson & Johnson’s gross profit margin improved from Q2 2018 to Q3 2018 and from Q3 2018 to Q4 2018.
Operating profit margin A profitability ratio calculated as operating income divided by revenue. Johnson & Johnson’s operating profit margin deteriorated from Q2 2018 to Q3 2018 but then improved from Q3 2018 to Q4 2018 exceeding Q2 2018 level.
Net profit margin An indicator of profitability, calculated as net income divided by revenue. Johnson & Johnson’s net profit margin improved from Q2 2018 to Q3 2018 and from Q3 2018 to Q4 2018.
Ratio Description The company
ROE A profitability ratio calculated as net income divided by shareholders’ equity. Johnson & Johnson’s ROE improved from Q2 2018 to Q3 2018 and from Q3 2018 to Q4 2018.
ROA A profitability ratio calculated as net income divided by total assets. Johnson & Johnson’s ROA improved from Q2 2018 to Q3 2018 and from Q3 2018 to Q4 2018.

Gross Profit Margin

Johnson & Johnson, gross profit margin calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 30, 2018 Sep 30, 2018 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
Selected Financial Data (USD $ in millions)
Gross profit hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Sales to customers hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Ratio
Gross profit margin1 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-02-20), 10-Q (filing date: 2018-10-31), 10-Q (filing date: 2018-08-02), 10-Q (filing date: 2018-05-01), 10-K (filing date: 2018-02-21), 10-Q (filing date: 2017-11-02), 10-Q (filing date: 2017-08-03), 10-Q (filing date: 2017-05-08), 10-K (filing date: 2017-02-27), 10-Q (filing date: 2016-11-04), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-10), 10-K (filing date: 2016-02-24), 10-Q (filing date: 2015-10-30), 10-Q (filing date: 2015-07-31), 10-Q (filing date: 2015-05-01), 10-K (filing date: 2015-02-24), 10-Q (filing date: 2014-10-30), 10-Q (filing date: 2014-08-01), 10-Q (filing date: 2014-05-02).

Q4 2018 Calculations

1 Gross profit margin = 100 × (Gross profitQ4 2018 + Gross profitQ3 2018 + Gross profitQ2 2018 + Gross profitQ1 2018) ÷ (Sales to customersQ4 2018 + Sales to customersQ3 2018 + Sales to customersQ2 2018 + Sales to customersQ1 2018)
= 100 × (hidden + hidden + hidden + hidden) ÷ (hidden + hidden + hidden + hidden) = hidden

Ratio Description The company
Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. Johnson & Johnson’s gross profit margin improved from Q2 2018 to Q3 2018 and from Q3 2018 to Q4 2018.

Operating Profit Margin

Johnson & Johnson, operating profit margin calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 30, 2018 Sep 30, 2018 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
Selected Financial Data (USD $ in millions)
Operating earnings hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Sales to customers hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Ratio
Operating profit margin1 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-02-20), 10-Q (filing date: 2018-10-31), 10-Q (filing date: 2018-08-02), 10-Q (filing date: 2018-05-01), 10-K (filing date: 2018-02-21), 10-Q (filing date: 2017-11-02), 10-Q (filing date: 2017-08-03), 10-Q (filing date: 2017-05-08), 10-K (filing date: 2017-02-27), 10-Q (filing date: 2016-11-04), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-10), 10-K (filing date: 2016-02-24), 10-Q (filing date: 2015-10-30), 10-Q (filing date: 2015-07-31), 10-Q (filing date: 2015-05-01), 10-K (filing date: 2015-02-24), 10-Q (filing date: 2014-10-30), 10-Q (filing date: 2014-08-01), 10-Q (filing date: 2014-05-02).

Q4 2018 Calculations

1 Operating profit margin = 100 × (Operating earningsQ4 2018 + Operating earningsQ3 2018 + Operating earningsQ2 2018 + Operating earningsQ1 2018) ÷ (Sales to customersQ4 2018 + Sales to customersQ3 2018 + Sales to customersQ2 2018 + Sales to customersQ1 2018)
= 100 × (hidden + hidden + hidden + hidden) ÷ (hidden + hidden + hidden + hidden) = hidden

Ratio Description The company
Operating profit margin A profitability ratio calculated as operating income divided by revenue. Johnson & Johnson’s operating profit margin deteriorated from Q2 2018 to Q3 2018 but then improved from Q3 2018 to Q4 2018 exceeding Q2 2018 level.

Net Profit Margin

Johnson & Johnson, net profit margin calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 30, 2018 Sep 30, 2018 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
Selected Financial Data (USD $ in millions)
Net earnings hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Sales to customers hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Ratio
Net profit margin1 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-02-20), 10-Q (filing date: 2018-10-31), 10-Q (filing date: 2018-08-02), 10-Q (filing date: 2018-05-01), 10-K (filing date: 2018-02-21), 10-Q (filing date: 2017-11-02), 10-Q (filing date: 2017-08-03), 10-Q (filing date: 2017-05-08), 10-K (filing date: 2017-02-27), 10-Q (filing date: 2016-11-04), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-10), 10-K (filing date: 2016-02-24), 10-Q (filing date: 2015-10-30), 10-Q (filing date: 2015-07-31), 10-Q (filing date: 2015-05-01), 10-K (filing date: 2015-02-24), 10-Q (filing date: 2014-10-30), 10-Q (filing date: 2014-08-01), 10-Q (filing date: 2014-05-02).

Q4 2018 Calculations

1 Net profit margin = 100 × (Net earningsQ4 2018 + Net earningsQ3 2018 + Net earningsQ2 2018 + Net earningsQ1 2018) ÷ (Sales to customersQ4 2018 + Sales to customersQ3 2018 + Sales to customersQ2 2018 + Sales to customersQ1 2018)
= 100 × (hidden + hidden + hidden + hidden) ÷ (hidden + hidden + hidden + hidden) = hidden

Ratio Description The company
Net profit margin An indicator of profitability, calculated as net income divided by revenue. Johnson & Johnson’s net profit margin improved from Q2 2018 to Q3 2018 and from Q3 2018 to Q4 2018.

Return on Equity (ROE)

Johnson & Johnson, ROE calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 30, 2018 Sep 30, 2018 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
Selected Financial Data (USD $ in millions)
Net earnings hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Shareholders’ equity hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Ratio
ROE1 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-02-20), 10-Q (filing date: 2018-10-31), 10-Q (filing date: 2018-08-02), 10-Q (filing date: 2018-05-01), 10-K (filing date: 2018-02-21), 10-Q (filing date: 2017-11-02), 10-Q (filing date: 2017-08-03), 10-Q (filing date: 2017-05-08), 10-K (filing date: 2017-02-27), 10-Q (filing date: 2016-11-04), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-10), 10-K (filing date: 2016-02-24), 10-Q (filing date: 2015-10-30), 10-Q (filing date: 2015-07-31), 10-Q (filing date: 2015-05-01), 10-K (filing date: 2015-02-24), 10-Q (filing date: 2014-10-30), 10-Q (filing date: 2014-08-01), 10-Q (filing date: 2014-05-02).

Q4 2018 Calculations

1 ROE = 100 × (Net earningsQ4 2018 + Net earningsQ3 2018 + Net earningsQ2 2018 + Net earningsQ1 2018) ÷ Shareholders’ equity
= 100 × (hidden + hidden + hidden + hidden) ÷ hidden = hidden

Ratio Description The company
ROE A profitability ratio calculated as net income divided by shareholders’ equity. Johnson & Johnson’s ROE improved from Q2 2018 to Q3 2018 and from Q3 2018 to Q4 2018.

Return on Assets (ROA)

Johnson & Johnson, ROA calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 30, 2018 Sep 30, 2018 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
Selected Financial Data (USD $ in millions)
Net earnings hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Total assets hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
Ratio
ROA1 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-02-20), 10-Q (filing date: 2018-10-31), 10-Q (filing date: 2018-08-02), 10-Q (filing date: 2018-05-01), 10-K (filing date: 2018-02-21), 10-Q (filing date: 2017-11-02), 10-Q (filing date: 2017-08-03), 10-Q (filing date: 2017-05-08), 10-K (filing date: 2017-02-27), 10-Q (filing date: 2016-11-04), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-10), 10-K (filing date: 2016-02-24), 10-Q (filing date: 2015-10-30), 10-Q (filing date: 2015-07-31), 10-Q (filing date: 2015-05-01), 10-K (filing date: 2015-02-24), 10-Q (filing date: 2014-10-30), 10-Q (filing date: 2014-08-01), 10-Q (filing date: 2014-05-02).

Q4 2018 Calculations

1 ROA = 100 × (Net earningsQ4 2018 + Net earningsQ3 2018 + Net earningsQ2 2018 + Net earningsQ1 2018) ÷ Total assets
= 100 × (hidden + hidden + hidden + hidden) ÷ hidden = hidden

Ratio Description The company
ROA A profitability ratio calculated as net income divided by total assets. Johnson & Johnson’s ROA improved from Q2 2018 to Q3 2018 and from Q3 2018 to Q4 2018.