Microsoft Excel LibreOffice Calc

Pfizer Inc. (PFE)


Profitability Analysis

Difficulty: Beginner


Ratios (Summary)

Pfizer Inc., profitability ratios

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Return on Sales
Gross profit margin 79.03% 78.61% 76.66% 80.25% 80.69%
Operating profit margin 26.10% 25.92% 22.73% 24.20% 26.71%
Net profit margin 20.79% 40.55% 13.66% 14.25% 18.42%
Return on Investment
Return on equity (ROE) 17.59% 29.88% 12.12% 10.75% 12.81%
Return on assets (ROA) 7.00% 12.40% 4.20% 4.16% 5.40%

Based on: 10-K (filing date: 2019-02-28), 10-K (filing date: 2018-02-22), 10-K (filing date: 2017-02-23), 10-K (filing date: 2016-02-29), 10-K (filing date: 2015-02-27).

Ratio Description The company
Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. Pfizer Inc.’s gross profit margin improved from 2016 to 2017 and from 2017 to 2018.
Operating profit margin A profitability ratio calculated as operating income divided by revenue. Pfizer Inc.’s operating profit margin improved from 2016 to 2017 and from 2017 to 2018.
Net profit margin An indicator of profitability, calculated as net income divided by revenue. Pfizer Inc.’s net profit margin improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level.

Ratio Description The company
ROE A profitability ratio calculated as net income divided by shareholders’ equity. Pfizer Inc.’s ROE improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level.
ROA A profitability ratio calculated as net income divided by total assets. Pfizer Inc.’s ROA improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level.

Gross Profit Margin

Pfizer Inc., gross profit margin calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (USD $ in millions)
Gross profit 42,399  41,306  40,495  39,203  40,028 
Revenues 53,647  52,546  52,824  48,851  49,605 
Ratio
Gross profit margin1 79.03% 78.61% 76.66% 80.25% 80.69%
Benchmarks
Gross Profit Margin, Competitors2
Abbott Laboratories 51.32% 47.75% 54.09% 54.19% 51.73%
AbbVie Inc. 76.44% 75.05% 77.25% 80.31% 77.83%
Allergan PLC 86.12% 86.40% 87.23% 68.08% 51.74%
Amgen Inc. 81.80% 81.33% 80.99% 79.82% 77.12%
Biogen Inc. 86.50% 86.72% 87.08% 88.48% 87.93%
Bristol-Myers Squibb Co. 70.98% 70.80% 74.54% 76.39% 75.24%
Celgene Corp. 96.15% 96.45% 96.08% 95.41% 94.90%
Eli Lilly & Co. 73.81% 73.46% 73.35% 74.76% 74.85%
Gilead Sciences Inc. 77.61% 82.97% 85.77% 87.54% 84.52%
Johnson & Johnson 66.79% 66.84% 69.84% 69.27% 69.40%
Merck & Co. Inc. 68.06% 68.16% 65.10% 62.19% 60.30%
Regeneron Pharmaceuticals Inc. 93.53% 93.24% 93.83% 90.43% 92.73%

Based on: 10-K (filing date: 2019-02-28), 10-K (filing date: 2018-02-22), 10-K (filing date: 2017-02-23), 10-K (filing date: 2016-02-29), 10-K (filing date: 2015-02-27).

1 2018 Calculation
Gross profit margin = 100 × Gross profit ÷ Revenues
= 100 × 42,399 ÷ 53,647 = 79.03%

2 Click competitor name to see calculations.

Ratio Description The company
Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. Pfizer Inc.’s gross profit margin improved from 2016 to 2017 and from 2017 to 2018.

Operating Profit Margin

Pfizer Inc., operating profit margin calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (USD $ in millions)
Operating income 14,001  13,620  12,006  11,824  13,249 
Revenues 53,647  52,546  52,824  48,851  49,605 
Ratio
Operating profit margin1 26.10% 25.92% 22.73% 24.20% 26.71%
Benchmarks
Operating Profit Margin, Competitors2
Abbott Laboratories 11.94% 6.30% 15.27% 14.05% 12.84%
AbbVie Inc. 19.49% 33.99% 36.60% 32.97% 17.09%
Allergan PLC -39.57% -37.15% -12.53% -20.00% -9.71%
Amgen Inc. 45.55% 45.76% 44.74% 40.44% 32.03%
Biogen Inc. 43.77% 43.54% 44.99% 45.44% 40.94%
Bristol-Myers Squibb Co. 22.69% 17.39% 23.83% 11.41% 16.32%
Celgene Corp. 34.01% 36.28% 28.31% 24.61% 33.30%
Eli Lilly & Co. 15.15% 9.38% 16.30% 13.47% 13.56%
Gilead Sciences Inc. 37.83% 55.04% 58.87% 69.03% 62.37%
Johnson & Johnson 24.27% 24.07% 28.72% 25.05% 28.20%
Merck & Co. Inc. 19.62% 16.28% 13.51% 17.54% 13.42%
Regeneron Pharmaceuticals Inc. 37.77% 35.41% 27.38% 30.51% 29.74%
Operating Profit Margin, Sector
Pharmaceuticals & Biotechnology 22.64% 23.68% 27.18% 26.43% 24.67%
Operating Profit Margin, Industry
Health Care 17.22% 17.82% 19.75% 19.78% 19.62%

Based on: 10-K (filing date: 2019-02-28), 10-K (filing date: 2018-02-22), 10-K (filing date: 2017-02-23), 10-K (filing date: 2016-02-29), 10-K (filing date: 2015-02-27).

1 2018 Calculation
Operating profit margin = 100 × Operating income ÷ Revenues
= 100 × 14,001 ÷ 53,647 = 26.10%

2 Click competitor name to see calculations.

Ratio Description The company
Operating profit margin A profitability ratio calculated as operating income divided by revenue. Pfizer Inc.’s operating profit margin improved from 2016 to 2017 and from 2017 to 2018.

Net Profit Margin

Pfizer Inc., net profit margin calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (USD $ in millions)
Net income attributable to Pfizer Inc. 11,153  21,308  7,215  6,960  9,135 
Revenues 53,647  52,546  52,824  48,851  49,605 
Ratio
Net profit margin1 20.79% 40.55% 13.66% 14.25% 18.42%
Benchmarks
Net Profit Margin, Competitors2
Abbott Laboratories 7.74% 1.74% 6.71% 21.68% 11.28%
AbbVie Inc. 17.36% 18.82% 23.22% 22.50% 8.89%
Allergan PLC -32.28% -25.88% 102.76% 25.98% -12.48%
Amgen Inc. 37.25% 9.08% 35.27% 33.13% 26.69%
Biogen Inc. 32.93% 20.69% 32.34% 32.95% 30.25%
Bristol-Myers Squibb Co. 21.81% 4.85% 22.94% 9.45% 12.62%
Celgene Corp. 26.51% 22.66% 17.87% 17.49% 26.44%
Eli Lilly & Co. 13.16% -0.89% 12.90% 12.07% 12.19%
Gilead Sciences Inc. 25.16% 18.03% 45.07% 56.32% 49.44%
Johnson & Johnson 18.75% 1.70% 23.01% 21.99% 21.96%
Merck & Co. Inc. 14.71% 5.97% 9.85% 11.25% 28.22%
Regeneron Pharmaceuticals Inc. 36.42% 20.41% 18.42% 15.50% 12.34%
Net Profit Margin, Sector
Pharmaceuticals & Biotechnology 17.88% 11.23% 24.60% 22.73% 20.93%
Net Profit Margin, Industry
Health Care 13.16% 9.41% 16.74% 16.15% 15.80%

Based on: 10-K (filing date: 2019-02-28), 10-K (filing date: 2018-02-22), 10-K (filing date: 2017-02-23), 10-K (filing date: 2016-02-29), 10-K (filing date: 2015-02-27).

1 2018 Calculation
Net profit margin = 100 × Net income attributable to Pfizer Inc. ÷ Revenues
= 100 × 11,153 ÷ 53,647 = 20.79%

2 Click competitor name to see calculations.

Ratio Description The company
Net profit margin An indicator of profitability, calculated as net income divided by revenue. Pfizer Inc.’s net profit margin improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level.

Return on Equity (ROE)

Pfizer Inc., ROE calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (USD $ in millions)
Net income attributable to Pfizer Inc. 11,153  21,308  7,215  6,960  9,135 
Total Pfizer Inc. shareholders’ equity 63,407  71,308  59,544  64,720  71,301 
Ratio
ROE1 17.59% 29.88% 12.12% 10.75% 12.81%
Benchmarks
ROE, Competitors2
Abbott Laboratories 7.76% 1.54% 6.82% 20.85% 10.61%
AbbVie Inc. 104.16% 128.41% 130.39% 101.84%
Allergan PLC -7.83% -5.59% 19.65% 5.11% -5.76%
Amgen Inc. 67.15% 7.84% 25.85% 24.71% 20.01%
Biogen Inc. 33.98% 20.13% 30.50% 37.84% 27.15%
Bristol-Myers Squibb Co. 35.07% 8.58% 27.55% 10.97% 13.49%
Celgene Corp. 65.67% 42.48% 30.29% 27.07% 30.65%
Eli Lilly & Co. 32.88% -1.76% 19.54% 16.53% 15.55%
Gilead Sciences Inc. 25.51% 22.64% 71.48% 97.70% 78.45%
Johnson & Johnson 25.60% 2.16% 23.49% 21.66% 23.40%
Merck & Co. Inc. 23.30% 6.97% 9.78% 9.94% 24.50%
Regeneron Pharmaceuticals Inc. 27.91% 19.51% 20.13% 17.40% 13.69%
ROE, Sector
Pharmaceuticals & Biotechnology 21.24% 11.00% 22.76% 19.94% 20.07%
ROE, Industry
Health Care 18.61% 11.57% 19.86% 17.48% 18.82%

Based on: 10-K (filing date: 2019-02-28), 10-K (filing date: 2018-02-22), 10-K (filing date: 2017-02-23), 10-K (filing date: 2016-02-29), 10-K (filing date: 2015-02-27).

1 2018 Calculation
ROE = 100 × Net income attributable to Pfizer Inc. ÷ Total Pfizer Inc. shareholders’ equity
= 100 × 11,153 ÷ 63,407 = 17.59%

2 Click competitor name to see calculations.

Ratio Description The company
ROE A profitability ratio calculated as net income divided by shareholders’ equity. Pfizer Inc.’s ROE improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level.

Return on Assets (ROA)

Pfizer Inc., ROA calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (USD $ in millions)
Net income attributable to Pfizer Inc. 11,153  21,308  7,215  6,960  9,135 
Total assets 159,422  171,797  171,615  167,460  169,274 
Ratio
ROA1 7.00% 12.40% 4.20% 4.16% 5.40%
Benchmarks
ROA, Competitors2
Abbott Laboratories 3.53% 0.63% 2.66% 10.72% 5.53%
AbbVie Inc. 9.58% 7.50% 9.01% 9.70% 6.44%
Allergan PLC -5.01% -3.49% 11.61% 2.88% -3.10%
Amgen Inc. 12.64% 2.48% 9.95% 9.69% 7.47%
Biogen Inc. 17.52% 10.73% 16.19% 18.19% 20.50%
Bristol-Myers Squibb Co. 14.06% 3.00% 13.22% 4.93% 5.94%
Celgene Corp. 11.40% 9.75% 7.12% 5.92% 11.53%
Eli Lilly & Co. 7.36% -0.45% 7.05% 6.77% 6.43%
Gilead Sciences Inc. 8.57% 6.58% 23.70% 34.93% 34.91%
Johnson & Johnson 10.00% 0.83% 11.71% 11.55% 12.45%
Merck & Co. Inc. 7.53% 2.72% 4.11% 4.36% 12.12%
Regeneron Pharmaceuticals Inc. 20.83% 13.67% 12.84% 11.34% 8.99%
ROA, Sector
Pharmaceuticals & Biotechnology 7.58% 4.19% 9.23% 8.58% 9.14%
ROA, Industry
Health Care 7.08% 4.52% 8.13% 7.47% 8.53%

Based on: 10-K (filing date: 2019-02-28), 10-K (filing date: 2018-02-22), 10-K (filing date: 2017-02-23), 10-K (filing date: 2016-02-29), 10-K (filing date: 2015-02-27).

1 2018 Calculation
ROA = 100 × Net income attributable to Pfizer Inc. ÷ Total assets
= 100 × 11,153 ÷ 159,422 = 7.00%

2 Click competitor name to see calculations.

Ratio Description The company
ROA A profitability ratio calculated as net income divided by total assets. Pfizer Inc.’s ROA improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level.