Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Pfizer Inc. logo

Pfizer Inc.

Sector: Healthcare   

Industry: Drug Manufacturers - Major

27.75
 
USD
  
-0.03
  
(-0.11%)
Optionable: Yes  Market Cap: 155,795 M  90-day average vol: 43,541,721

Previous close: 27.78  Open: 27.82  Bid: 27.74  Ask: 27.75
52 week range    
25.61   
   42.22
Peers   
MRK / 
JNJ / 
BMY / 
LLY / 
NVS / 
GSK / 
AMGN / 
ABT / 
Last updated: Friday 29th March 2024
65
MarketXLS Rank
75
Value
61
Technical
60
Quality

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

ABT

0.0147225 B32.4128.05

AMGN

0.0347129 B23.4223.53

AZN

BMY

0.0332145 B-27.366.19

GSK

JNJ

0.0247450 B22.1171.06

LLY

0.0161238 B37.4243.55

MRK

0.0356207 B28.877.58

NVS

Financials

PFE Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
AccruedPreferredStockDividends2 M2 M-1000000.01000000.0
Amortization of intangibles42,069 M48,242 M4,056 M4,758 M4,893 M48,202 M49,556 M49,208 M51,375 M67,783 M
Basic EPS from continuing operations1.431.131.183.571.92.921.264.05.590.38
Basic EPS total1.441.132.921.733.925.590.38
Basic weighted shares outstanding6,346 M6,176 M6,089 M5,970 M5,872 M5,569 M5,555 M5,601 M5,608 M5,643 M
BasicDiscontinuousOperations0.010.47-0.08
Cost of sales9,577 M9,648 M12,329 M11,228 M11,248 M8,251 M8,484 M30,821 M34,344 M24,954 M
Depletion351 M
Depreciation5,537 M5,157 M-5,757 M-6,269 M-6,384 M6,010 M4,681 M5,191 M5,064 M6,290 M
Depreciation unreconciled4,056 M5,109 M4,893 M
DepreciationAndAmortization5,537 M5,157 M4,056 M4,758 M4,893 M6,010 M4,681 M5,191 M5,064 M6,290 M
DevelopmentExpense3,469 M953 M194 M
Diluted EPS total1.421.112.871.713.855.470.37
Diluted normalized net income/share1.411.111.173.521.862.871.243.935.470.37
Diluted weighted shares outstanding6,424 M6,257 M6,159 M6,058 M5,977 M5,675 M5,632 M5,708 M5,733 M5,709 M
DilutedDiscontinuousOperations0.010.47-0.08
Dividends paid per share1.21.31.381.461.531.571.611.65
Earnings from equity interest-86 M45 M
EarningsFromEquityInterestNetOfTax-86 M45 M
ExciseTaxes1,724 M
GainOnSaleOfBusiness8,086 M6 M222 M
GainOnSaleOfPPE52 M71 M32 M-237 M99 M
GainOnSaleOfSecurity10,200 M4,300 M10,200 M451 M586 M454 M540 M1,344 M126 M1,754 M
GainsLossOnDisposalOfDiscontinuedOperations55 M-6 M16 M2 M10 M
GeneralAndAdministrativeExpense14,097 M14,809 M-292 M-314 M-301 M12,750 M11,597 M12,703 M13,677 M14,771 M
Gross operating profit40,028 M39,203 M40,495 M41,318 M42,399 M32,921 M33,167 M50,467 M65,986 M33,542 M
ImpairmentOfCapitalAssets469 M818 M-1,447 M-395 M-3,115 M2,843 M1,691 M86 M421 M3,024 M
Income before tax12,240 M8,965 M8,351 M12,305 M11,885 M11,485 M7,036 M24,311 M34,729 M1,058 M
Income restructuring and M&A170 M811 M-1,156 M-30 M-782 M227 M-6 M741 M882 M1,968 M
Income taxes3,120 M1,990 M1,123 M-9,049 M706 M618 M370 M1,852 M3,300 M-1,100 M
Interest income425 M471 M470 M391 M333 M225 M73 M36 M251 M1,624 M
InterestExpenseNonOperating1,360 M1,199 M-1,186 M-1,270 M-1,316 M1,573 M1,449 M1,291 M1,238 M2,209 M
InterestExpenseOperating716 M879 M983 M
MinorityInterests-32 M-26 M-31 M-47 M-36 M-29 M-36 M-45 M-35 M-39 M
MiscOtherSpecialCharges-1,009 M-2,860 M-3,655 M-1,416 M-2,116 M-3,314 M-1,219 M4,878 M8,320 M8,417 M
Net income from total operations9,135 M6,960 M7,246 M21,355 M11,188 M16,273 M9,159 M21,979 M31,372 M2,119 M
NetIncomeCommonStockholders13,426 M11,839 M7,213 M21,310 M11,153 M21,337 M13,087 M21,979 M31,372 M2,119 M
NetIncomeContinuousOperations9,135 M6,960 M7,246 M21,355 M11,188 M16,273 M9,159 M21,979 M31,372 M2,119 M
NetIncomeDiscontinuousOperations49 M11 M16 M2 M10 M5,435 M2,529 M-434 M6 M-15 M
NetNonOperatingInterestIncomeExpense-935 M-728 M1,717 M1,733 M1,722 M-1,348 M-1,376 M-1,255 M-987 M-585 M
NonRecurringOperationExpense510 M240 M157 M292 M28 M182 M230 M474 M
Normalized income8,987 M
Operating income17,538 M16,704 M13,730 M13,722 M15,045 M11,777 M12,177 M23,935 M31,391 M316 M
Operating income before depreciation (EBITDA)19,137 M15,321 M13,638 M18,183 M17,936 M18,853 M13,166 M30,793 M41,031 M9,557 M
OperatingExpense22,490 M22,499 M26,765 M27,596 M27,354 M21,144 M20,990 M26,532 M26,058 M25,644 M
Other income net1,009 M2,860 M5,379 M1,416 M2,116 M-4,772 M1,213 M-4,878 M-8,320 M-8,417 M
Other special charges-499 M-495 M
OtherGainLossFromDispositionOfDiscontinuedOperations-6 M17 M5,435 M2,529 M-434 M6 M-15 M
OtherGandA14,097 M14,809 M-292 M-314 M-301 M12,750 M11,597 M12,703 M13,677 M14,771 M
OtherImpairmentOfCapitalAssets396 M323 M-869 M-337 M-3,100 M2,800 M1,700 M421 M3,000 M
OtherOperatingExpenses-795 M-675 M-489 M-753 M-370 M-383 M-411 M-550 M-701 M-515 M
OtherunderPreferredStockDividend2 M2 M-1000000.0-1000000.0-1000000.01000000.0
PreferredStockDividends2 M2 M-1000000.0-1000000.0-1000000.01000000.0
PromotionAndAdvertising3,100 M3,100 M-3,200 M-3,100 M-3,100 M2,400 M1,800 M2,000 M2,800 M3,700 M
RentAndLandingFees216 M243 M-292 M-314 M-301 M
Research & development expense8,393 M7,690 M7,872 M7,683 M8,006 M8,394 M9,393 M13,829 M12,381 M10,873 M
ResearchExpense8,393 M7,690 M7,872 M7,683 M8,006 M8,394 M9,393 M10,360 M11,428 M10,679 M
RestructringAndMnAIncome170 M811 M-1,156 M-30 M-782 M227 M-6 M741 M882 M1,968 M
Revenue per share42,069 M48,242 M4,056 M4,758 M4,893 M48,202 M49,556 M49,208 M51,375 M67,783 M
SalariesAndWages-137 M-141 M-1,600 M-160 M-93 M
Selling Gen & administrative expense14,097 M14,809 M14,837 M14,804 M14,455 M12,750 M11,597 M12,703 M13,677 M14,771 M
SellingAndMarketingExpense3,100 M3,100 M14,837 M14,804 M14,455 M2,400 M1,800 M2,000 M2,800 M3,700 M
SellingExpense14,837 M14,804 M14,455 M
Special income/charges-639 M-1,629 M2,093 M684 M4,235 M-3,362 M-1,713 M-1,009 M-1,533 M-5,466 M
Total Income available for interest expense (EBIT)13,600 M10,164 M7,881 M11,914 M11,552 M13,058 M8,485 M25,602 M35,967 M3,267 M
Total common shares outstanding6,129 M6,184 M5,952 M5,953 M5,552 M5,548 M5,578 M5,623 M5,619 M5,647 M
Total net income9,135 M6,960 M7,246 M21,355 M11,188 M16,273 M9,159 M21,979 M31,372 M2,119 M
Total ordinary shares5,647 M5,647 M5,647 M5,647 M5,647 M5,647 M5,647 M5,647 M5,647 M5,647 M
Total revenues49,605 M48,851 M52,824 M52,546 M53,647 M41,172 M41,651 M81,288 M91,793 M50,914 M
TotalExpenses32,067 M32,147 M39,094 M38,824 M38,602 M29,395 M29,474 M57,353 M60,402 M50,598 M
TotalRevenue49,605 M48,851 M52,824 M52,546 M53,647 M41,172 M41,651 M81,288 M100,330 M58,496 M
WriteOff487 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

We respect your privacy and will never share your email.
MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University