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.26
 
USD
  
-1.01
  
(-3.84%)
Optionable: Yes  Market Cap: 148,623 M  90-day average vol: 42,148,530

Previous close: 26.27  Open: 26.27  Bid: 25.38  Ask: 25.39
52 week range    
25.23   
   40.37
Peers   
MRK / 
JNJ / 
BMY / 
LLY / 
NVS / 
GSK / 
AMGN / 
ABT / 
Last updated: Friday 26th April 2024
59
MarketXLS Rank
80
Value
38
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 Cash Flow

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
(Increase) Decrease in inventories175 M-199 M365 M-357 M-717 M-1,080 M-778 M-1,125 M-591 M-1,200 M
(Increase) Decrease in other current assets1,156 M249 M-60 M7 M-16 M795 M-146 M
(Increase) Decrease in other current liabilities-845 M664 M-223 M-67 M98 M851 M2,768 M18,721 M-1,449 M595 M
(Increase) Decrease in other working capital1,156 M236 M840 M-137 M-1,057 M-4,506 M-663 M
(Increase) Decrease in payables789 M19 M137 M1,492 M353 M-3,424 M-885 M76 M646 M-1,282 M
(Increase) Decrease in receivables148 M21 M-134 M259 M-644 M-1,140 M-1,275 M-3,811 M261 M347 M
Acquisitions-195 M-16,466 M-18,368 M-1,000 M-10,861 M-22,997 M-43,430 M
AssetImpairmentCharge531 M1,119 M1,613 M634 M3,398 M2,941 M2,049 M276 M1,733 M9,607 M
CapitalExpenditureReported1,583 M1,496 M1,999 M2,217 M2,196 M2,490 M2,226 M2,711 M3,236 M3,907 M
Cash at beginning of period2,183 M3,343 M3,641 M2,666 M1,431 M1,225 M1,350 M1,825 M1,983 M468 M
Cash at end of period3,342 M3,643 M6,300 M1,430 M1,229 M6,782 M4,356 M1,825 M468 M2,917 M
Cash flow16,933 M14,683 M15,900 M16,800 M15,828 M7,010 M10,542 M32,923 M29,267 M8,670 M
Cash from disc. financing activities11,991 M
Cash from disc. investing activities-94 M-109 M-12 M
CashFlowFromContinuingInvestingActivities-5,654 M-2,980 M-7,812 M-4,740 M4,526 M-3,852 M-4,163 M-22,533 M-15,783 M-32,277 M
CashFromDiscontinuedOperatingActivities-51 M6 M11,011 M6,392 M-777 M6 M-15 M
ChangeInAccountPayable297 M254 M871 M46 M431 M-340 M355 M1,242 M1,191 M-300 M
ChangeInPayablesAndAccruedExpense789 M19 M137 M1,492 M353 M-3,424 M-885 M76 M646 M-1,282 M
ChangeInTaxPayable492 M-235 M-734 M1,446 M-78 M-3,084 M-1,240 M-1,166 M-545 M-982 M
ChangeInWorkingCapital1,423 M741 M85 M1,334 M-926 M-3,953 M-307 M12,804 M-5,639 M-2,203 M
ChangesInAccountReceivables148 M21 M-134 M259 M-644 M-1,140 M-1,275 M-3,811 M261 M347 M
CommonStockDividendPaid-6,609 M-6,940 M-7,317 M-7,659 M-7,978 M-8,043 M-8,440 M-8,729 M-8,983 M-9,247 M
CommonStockPayments-5,000 M-6,160 M-5,000 M-5,000 M-12,198 M-8,865 M-2,000 M
Current deferred income taxes317 M-18 M-700 M-2,410 M-2,205 M596 M-1,575 M-4,293 M-3,764 M-3,442 M
Deferred income taxes317 M-18 M-700 M-2,410 M-2,205 M596 M-1,575 M-4,293 M-3,764 M-3,442 M
Depreciation5,537 M5,157 M5,757 M6,269 M6,384 M5,795 M4,681 M5,191 M5,064 M6,290 M
Depreciation unreconciled5,537 M5,157 M5,757 M6,269 M6,384 M5,795 M4,681 M5,191 M5,064 M6,290 M
DepreciationAndAmortization5,537 M5,157 M5,757 M6,269 M6,384 M5,795 M4,681 M5,191 M5,064 M6,290 M
Effect of exchange rate changes-83 M-1,000 M-215 M53 M-116 M-32 M-8 M-59 M-165 M-40 M
ExcessTaxBenefitFromStockBasedCompensation-596 M-323 M
FinancingCashFlow-9,986 M-10,409 M-5,214 M-13,349 M-20,440 M-8,486 M-9,648 M-9,816 M-14,834 M26,066 M
Free cash flow15,299 M13,193 M13,901 M14,583 M13,632 M15,531 M14,708 M29,869 M26,031 M4,793 M
GainLossOnSaleOfBusiness1,712 M55 M-1000000.0
IncomeTaxPaidSupplementalData2,100 M2,383 M2,521 M2,489 M3,655 M3,664 M3,153 M7,427 M7,867 M3,147 M
InterestPaidSupplementalData1,550 M1,302 M1,451 M1,518 M1,311 M1,587 M1,641 M1,467 M1,442 M2,215 M
Issuance of debt-1,838 M4,309 M-714 M-61 M-2,343 M10,628 M-13,974 M-96 M-218 M7,683 M
IssuanceOfDebt549 M1,319 M2,573 M-941 M-935 M8,764 M-12,755 M-1,103 M-3,516 M35,945 M
Net cash from financing activities-9,986 M-10,409 M-5,214 M-13,349 M-20,440 M-8,486 M-21,639 M-9,816 M-14,834 M26,067 M
Net cash from investing activities-5,654 M-2,980 M-7,812 M-4,740 M4,526 M-3,946 M-4,272 M-22,546 M-15,783 M-32,278 M
Net cash from operating activities16,882 M14,689 M15,900 M16,800 M15,828 M18,021 M16,934 M32,580 M29,267 M8,700 M
Net change in cash & cash equivalents1,159 M1,300 M2,659 M-1,236 M-202 M5,557 M3,014 M218 M-1,350 M2,488 M
Net income from continuing operations9,168 M6,986 M7,246 M21,355 M11,188 M10,867 M6,666 M22,459 M31,401 M2,172 M
NetBusinessPurchaseAndSale-195 M-16,466 M-18,368 M-1,000 M-10,861 M-22,997 M-43,430 M
NetCommonStockIssuance-5,000 M-6,160 M-5,000 M-5,000 M-12,198 M-8,865 M-2,000 M
NetForeignCurrencyExchangeGainLoss806 M
NetIntangiblesPurchaseAndSale-384 M-99 M-176 M-261 M-154 M-418 M-539 M
NetInvestmentPropertiesPurchaseAndSale-3,876 M14,982 M12,555 M-1,523 M6,722 M9,499 M-1,937 M-19,822 M10,450 M15,060 M
NetInvestmentPurchaseAndSale-3,876 M14,982 M12,555 M-1,523 M6,722 M9,499 M-1,937 M-19,822 M10,450 M15,060 M
NetIssuancePaymentsOfDebt549 M1,319 M2,573 M-941 M-935 M8,764 M-12,755 M-1,103 M-3,516 M35,945 M
NetLongTermDebtIssuance2,387 M-2,990 M3,287 M-880 M1,408 M-1,864 M1,219 M-1,007 M-3,298 M28,262 M
NetPPEPurchaseAndSale-1,199 M-1,397 M-1,823 M-1,956 M-2,042 M-2,072 M-2,226 M-2,711 M-3,236 M-3,907 M
Operating (gains) losses806 M1,712 M55 M-1000000.0
Other financing charges net72 M109 M3,511 M-611 M-588 M-736 M-444 M16 M-335 M-631 M
Other investing changes net347 M344 M51 M671 M288 M7,120 M655 M-8,393 M3,285 M4,995 M
Other non-cash items488 M1,011 M1,800 M-9,803 M1,387 M-6,295 M1,077 M-3,238 M2,205 M5,853 M
Payment of cash dividends6,609 M6,940 M7,317 M7,659 M7,978 M8,043 M8,440 M8,729 M8,983 M9,247 M
ProceedsFromStockOptionExercised1,002 M1,263 M1,019 M862 M1,259 M394 M425 M
Purchase of Float term investments-57,742 M-32,355 M-20,175 M-12,538 M-15,594 M-7,036 M-14,402 M-39,525 M-38,297 M-31,178 M
Purchase of property plant & equipment-1,583 M-1,496 M-1,999 M-2,217 M-2,196 M-2,490 M-2,226 M-2,711 M-3,236 M-3,907 M
Purchase of short term investments4,491 M10,976 M5,274 M4,974 M4,942 M5,222 M997 M30,831 M
PurchaseOfIntangibles-384 M-99 M-176 M-261 M-154 M-418 M-539 M
PurchaseOfInvestment-57,742 M-32,355 M-28,186 M-16,075 M-17,391 M-7,036 M-14,402 M-39,525 M-38,297 M-31,178 M
PurchaseOfLongTermInvestments-10,718 M-9,542 M-8,011 M-3,537 M-1,797 M-201 M-597 M
PurchaseOfPPE-1,199 M-1,397 M-1,823 M-1,956 M-2,042 M-2,072 M-2,226 M-2,711 M-3,236 M-3,907 M
Repayment of debt-2,104 M-2,990 M-7,689 M-6,154 M-3,566 M-6,806 M-4,003 M-2,004 M-3,298 M-2,569 M
RepaymentOfDebt-2,114 M-6,955 M-12,791 M-16,101 M-8,003 M-15,184 M-26,200 M-2,004 M-7,185 M-2,572 M
Repurchase of capital stock-5,000 M-6,160 M-5,000 M-5,000 M-12,198 M-8,865 M-2,000 M
Sale of Float term investments6,145 M6,929 M11,254 M3,579 M6,244 M232 M723 M649 M641 M1,979 M
Sale of short term investments47,374 M40,064 M29,436 M10,302 M17,581 M9,183 M11,087 M27,447 M44,821 M39,264 M
SaleOfInvestment53,519 M46,993 M40,690 M13,881 M23,825 M9,415 M11,810 M28,096 M45,462 M41,243 M
ShortTermDebtIssuance-1,828 M8,274 M4,388 M9,886 M2,094 M19,006 M8,223 M-96 M3,669 M7,686 M
ShortTermDebtPayments-10 M-3,965 M-5,102 M-9,947 M-4,437 M-8,378 M-22,197 M-3,887 M-3 M
StockBasedCompensation586 M669 M691 M840 M949 M688 M755 M1,182 M872 M525 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