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

25.39
 
USD
  
-0.03
  
(-0.12%)
Optionable: Yes  Market Cap: 145,066 M  90-day average vol: 42,872,092

Previous close: 25.42  Open: 25.35  Bid: 25.35  Ask: 25.36
52 week range    
25.23   
   40.37
Peers   
MRK / 
JNJ / 
BMY / 
LLY / 
NVS / 
GSK / 
AMGN / 
ABT / 
Last updated: Friday 19th April 2024
49
MarketXLS Rank
80
Value
7
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

Financials

PFE Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
"""debtc"""5,141 M10,159 M10,688 M9,953 M8,831 M16,195 M2,703 M2,241 M2,945 M10,350 M
Accounts payable3,210 M3,620 M4,536 M4,656 M4,674 M3,887 M4,283 M5,578 M6,809 M6,710 M
Accounts receivable8,401 M8,176 M8,225 M8,221 M8,025 M6,772 M7,913 M11,479 M10,952 M11,177 M
Accrued expenses5,452 M5,890 M9,404 M9,358 M10,383 M6,971 M7,494 M9,093 M10,699 M11,431 M
Accumulated depreciation & depletion-13,226 M-13,502 M-14,807 M-16,172 M-16,591 M-14,990 M-14,661 M-15,074 M-15,174 M-16,045 M
Additional paid in capital78,977 M81,016 M82,685 M84,278 M86,253 M87,428 M88,674 M90,591 M91,802 M92,631 M
Cash and equivalents3,343 M3,641 M2,595 M1,342 M1,139 M1,121 M1,786 M1,944 M416 M2,853 M
CashCashEquivalentsAndShortTermInvestments36,122 M23,290 M17,850 M19,992 M18,833 M9,646 M12,223 M31,069 M22,732 M12,690 M
CashEquivalents3,641 M2,595 M1,342 M1,139 M
CommercialPaper5,800 M6,100 M3,100 M13,915 M556 M7,965 M
Common par484 M485 M485 M485 M486 M485 M470 M473 M476 M478 M
Common stock equity71,300 M64,720 M59,544 M71,308 M63,408 M63,142 M63,238 M77,200 M95,661 M89,014 M
CommonStock455 M459 M461 M464 M467 M468 M470 M473 M476 M478 M
Cost in excess42,069 M48,242 M54,449 M55,952 M53,411 M48,202 M49,556 M49,208 M51,375 M67,783 M
CurrentAccruedExpenses1,784 M2,359 M2,487 M2,196 M2,397 M2,720 M3,058 M3,332 M
CurrentCapitalLeaseObligation183 M202 M220 M209 M300 M269 M320 M449 M620 M527 M
CurrentDeferredAssets4,498 M
CurrentDeferredRevenue1,113 M3,067 M2,520 M2,700 M
CurrentDeferredTaxesAssets10,312 M10,523 M9,857 M9,086 M6,508 M6,682 M7,604 M8,983 M13,265 M17,299 M
CurrentDeferredTaxesLiabilities-32,714 M-36,668 M30,099 M10,808 M7,620 M-11,643 M-10,726 M-7,714 M-9,519 M-16,172 M
Deferred revenues1,113 M3,067 M2,520 M2,700 M
DividendsPayable1,711 M1,852 M1,944 M2,029 M2,047 M2,104 M2,162 M2,249 M2,303 M2,372 M
EmployeeBenefits10,264 M8,119 M1,766 M1,504 M1,338 M6,217 M5,411 M3,724 M2,250 M2,167 M
Finished goods1,905 M2,714 M2,293 M2,883 M2,262 M2,265 M2,867 M3,641 M2,603 M3,495 M
Float term debt31,541 M28,740 M31,398 M33,538 M32,909 M35,955 M37,000 M36,000 M33,000 M62,000 M
GoodwillAndOtherIntangibleAssets77,235 M88,598 M107,097 M104,693 M88,622 M82,138 M77,893 M74,354 M94,745 M132,683 M
Gross fixed assets (Plant Property & Equipment)24,988 M27,268 M28,125 M30,037 M29,976 M27,959 M28,406 M29,956 M31,448 M34,985 M
IncomeTaxPayable531 M418 M437 M477 M1,265 M980 M1,049 M1,266 M1,587 M2,349 M
Intangibles35,166 M40,356 M52,648 M48,741 M35,211 M33,936 M28,337 M25,146 M43,370 M64,900 M
InterestPayable1,360 M1,199 M1,186 M1,270 M1,316 M1,573 M1,449 M1,291 M1,238 M2,209 M
Inventories5,663 M7,513 M6,783 M7,578 M7,508 M7,068 M8,020 M9,059 M8,981 M10,189 M
InventoriesAdjustmentsAllowances-1,183 M-6,199 M
Invested capital134,382 M122,200 M90,942 M104,846 M96,317 M135,052 M137,238 M149,395 M161,661 M213,014 M
LongTermCapitalLeaseObligation1,030 M1,108 M2,510 M2,597 M3,824 M
LongTermDebtAndCapitalLeaseObligation31,541 M28,740 M31,398 M33,538 M32,909 M35,955 M37,133 M36,195 M33,000 M62,000 M
Minority interest321 M278 M296 M348 M351 M303 M235 M262 M256 M274 M
Net fixed assets (net PP&E)11,762 M13,766 M13,318 M13,865 M13,385 M12,969 M13,745 M14,882 M16,274 M18,940 M
NetOtherUnrealizedGainLoss-45 M71 M-32 M237 M-99 M
Non-current deferred income taxes23,317 M26,877 M30,753 M3,900 M3,700 M5,652 M4,063 M349 M1,023 M640 M
NonCurrentDeferredLiabilities23,317 M26,877 M37,159 M9,826 M8,972 M5,652 M4,063 M349 M1,023 M640 M
NonCurrentDeferredTaxesAssets11,927 M12,552 M11,806 M11,289 M8,576 M8,208 M9,190 M10,446 M14,806 M19,037 M
NonCurrentPensionAndOtherPostretirementBenefitPlans10,264 M8,119 M1,766 M1,504 M1,338 M6,217 M5,411 M3,724 M2,250 M2,167 M
Number of employees83000.083000.083000.083000.083000.083000.083000.083000.083000.083000.0
Other current assets5,409 M4,825 M6,091 M5,351 M15,560 M9,317 M6,910 M8,086 M8,594 M9,277 M
Other equity adjustments-7,316 M-9,522 M-11,036 M-9,321 M-11,275 M-11,640 M-11,688 M-5,897 M
Other fixed assets11,762 M13,766 M12,969 M13,745 M14,882 M16,274 M18,940 M
Other non-current assets3,513 M3,420 M3,323 M3,227 M2,799 M17,626 M4,879 M7,679 M13,163 M12,471 M
Other non-current liabilities9,236 M9,249 M10,337 M24,846 M20,587 M19,020 M18,229 M21,074 M22,992 M25,073 M
Other receivable52,546 M53,647 M41,172 M41,651 M81,288 M
OtherCurrentBorrowings5,141 M10,159 M10,688 M9,953 M8,831 M16,195 M2,703 M2,241 M2,945 M10,350 M
OtherCurrentLiabilities10,994 M13,349 M11,023 M11,115 M10,753 M14,137 M14,610 M28,271 M25,975 M23,313 M
OtherInventories5,663 M7,513 M683 M683 M618 M7,068 M8,020 M9,059 M8,981 M10,189 M
OtherPayable384 M16,466 M18,368 M1,000 M10,861 M22,997 M43,430 M
Payables5,452 M5,890 M6,917 M7,162 M7,986 M6,971 M7,494 M9,093 M10,699 M11,431 M
Preferred securities of subsidiary trust29 M26 M24 M21 M19 M17 M
PreferredStock29 M26 M24 M21 M19 M17 M
Raw materials510 M867 M793 M788 M546 M672 M716 M994 M859 M1,007 M
RecievablesAdjustmentsAllowances-412 M-384 M-541 M-493 M-508 M-492 M-449 M-470 M
Retained earnings64,860 M62,471 M71,774 M85,291 M89,554 M86,030 M85,082 M97,497 M117,352 M110,392 M
SecuritySoldNotYetRepurchased5,000 M6,160 M5,000 M5,000 M881 M835 M142 M581 M337 M221 M
Short term debt5,141 M10,159 M10,688 M9,953 M8,831 M16,195 M2,703 M2,241 M2,945 M10,350 M
Total assets167,567 M167,381 M171,615 M171,797 M159,423 M167,594 M154,228 M181,475 M197,000 M227,000 M
Total current assets55,595 M43,804 M38,949 M41,142 M49,926 M32,803 M35,066 M59,693 M51,259 M43,333 M
Total current liabilities21,587 M29,398 M31,115 M30,426 M29,967 M37,303 M25,920 M42,672 M42,138 M47,794 M
Total equity71,300 M64,720 M59,544 M71,308 M63,408 M63,142 M63,238 M77,200 M95,661 M89,014 M
Total liabilities95,945 M102,383 M111,775 M100,140 M95,663 M104,147 M90,623 M103,819 M101,288 M137,213 M
Total non-current assets111,972 M123,577 M132,666 M130,655 M109,497 M134,791 M119,162 M121,782 M145,944 M183,168 M
Total non-current liabilities74,358 M72,985 M80,660 M69,714 M65,696 M66,844 M64,703 M61,147 M59,265 M89,880 M
TotalEquityGrossMinority71,621 M64,998 M59,840 M71,656 M63,759 M63,445 M63,473 M77,462 M95,916 M89,288 M
TotalEquityGrossMinorityInterest71,621 M64,998 M59,840 M71,656 M63,759 M63,445 M63,473 M77,462 M95,916 M89,288 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest167,566 M167,381 M171,615 M171,796 M159,422 M167,592 M154,228 M181,475 M197,205 M226,501 M
TotalNonCurrentLiabilitiesNetMinorityInteres74,358 M72,985 M80,660 M69,714 M65,696 M66,844 M64,703 M61,147 M59,265 M89,880 M
TotalTaxPayable531 M418 M437 M477 M1,265 M980 M1,049 M1,266 M1,587 M2,349 M
Treasury stock-73,021 M-79,252 M-84,364 M-89,425 M-101,610 M-110,801 M-110,988 M-111,361 M-113,969 M-114,487 M
UnearnedIncome1,944 M1,794 M1,812 M1,855 M1,924 M1,911 M2,383 M3,341 M6,693 M3,706 M
UnearnedPremiums11 M12 M11 M-43 M-2 M-1000000.0-121 M
Work in progress3,248 M3,932 M3,696 M3,908 M4,701 M4,131 M4,436 M4,424 M5,519 M5,688 M
Working capital34,008 M14,406 M7,834 M10,716 M19,959 M-4,500 M9,146 M17,021 M9,121 M-4,461 M
ltinv17,518 M15,999 M7,116 M7,015 M2,767 M20,147 M20,262 M21,526 M15,069 M15,368 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.

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