Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Procter & Gamble Company (The) logo

Procter & Gamble Company (The)

Sector: Consumer Defensive   

Industry: Household & Personal Products

162.61
 
USD
  
2.06
  
(1.28%)
Optionable: Yes  Market Cap: 377,778 M  90-day average vol: 6,835,257

Previous close: 160.55  Open: 161.36  Bid: 162.44  Ask: 162.61
52 week range    
141.45   
   162.74
Peers   
CL / 
CHD / 
KMB / 
EL / 
CLX / 
JNJ / 
HAIN / 
UL / 
REV / 
Last updated: Thursday 28th March 2024
68
MarketXLS Rank
75
Value
76
Technical
55
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

PG Cash Flow

Annual
Jun-14Jun-15Jun-16Jun-17Jun-18Jun-19Jun-20Jun-21Jun-22Jun-23
(Increase) Decrease in inventories8 M313 M116 M71 M-188 M-239 M-637 M-309 M-1,247 M-119 M
(Increase) Decrease in other current assets1,870 M
(Increase) Decrease in other working capital-1,557 M-976 M204 M-43 M2,000 M-973 M-710 M-369 M-635 M-1,107 M
(Increase) Decrease in payables1000000.0928 M1,285 M-149 M1,385 M1,856 M1,923 M1,391 M1,429 M313 M
(Increase) Decrease in receivables87 M349 M35 M-322 M-177 M-276 M634 M-342 M-694 M-307 M
Acquisitions-24 M-137 M-186 M-16 M-109 M-3,945 M-58 M-34 M-1,381 M-765 M
CapitalExpenditureReported3,848 M3,736 M3,314 M3,384 M3,717 M3,347 M3,073 M2,787 M3,156 M3,062 M
Cash at beginning of period5,930 M8,548 M6,836 M8,098 M5,569 M2,569 M4,239 M16,181 M10,288 M7,214 M
Cash at end of period8,590 M7,247 M7,483 M6,594 M2,550 M4,327 M16,320 M10,187 M7,711 M8,416 M
Cash flow14,046 M14,608 M15,435 M14,623 M14,867 M15,242 M17,403 M18,371 M16,723 M16,848 M
Cash from disc. investing activities-475 M
CashFlowFromContinuingInvestingActivities-4,107 M-2,890 M-5,575 M-7,084 M-3,511 M-3,490 M3,045 M-2,834 M-4,424 M-3,500 M
ChangeInAccountPayable1000000.0928 M1,285 M-149 M1,385 M1,856 M1,923 M1,391 M1,429 M313 M
ChangeInPayablesAndAccruedExpense1000000.0928 M1,285 M-149 M1,385 M1,856 M1,923 M1,391 M1,429 M313 M
ChangeInWorkingCapital-1,461 M614 M1,640 M1,427 M3,020 M368 M1,210 M371 M-1,147 M-1,220 M
ChangesInAccountReceivables87 M349 M35 M-322 M-177 M-276 M634 M-342 M-694 M-307 M
CommonStockDividendPaid-6,911 M-7,287 M-7,436 M-7,236 M-7,310 M-7,498 M-7,789 M-8,263 M-8,770 M-8,999 M
CommonStockPayments-6,005 M-4,604 M-4,004 M-5,204 M-7,004 M-5,003 M-7,405 M-11,009 M-10,003 M-7,353 M
Current deferred income taxes44 M-803 M-815 M-601 M-1,844 M-411 M-596 M-258 M-402 M-453 M
Deferred income taxes44 M-803 M-815 M-601 M-1,844 M-411 M-596 M-258 M-402 M-453 M
Depreciation3,141 M3,134 M3,078 M2,820 M2,834 M2,824 M3,013 M2,735 M2,807 M2,714 M
Depreciation unreconciled3,141 M3,134 M3,078 M2,820 M2,834 M2,824 M3,013 M2,735 M2,807 M2,714 M
DepreciationAndAmortization3,141 M3,134 M3,078 M2,820 M2,834 M2,824 M3,013 M2,735 M2,807 M2,714 M
FinancingCashFlow-7,279 M-13,019 M-9,213 M-8,568 M-14,375 M-9,994 M-8,367 M-21,531 M-14,876 M-12,146 M
Free cash flow10,768 M15,370 M12,553 M11,810 M11,419 M12,289 M14,360 M15,626 M13,677 M13,832 M
GainLossOnSaleOfBusiness-154 M-766 M-41 M-5,490 M-176 M-678 M7 M-16 M
GainLossOnSaleOfPPE-16 M-85 M-40 M
IncomeTaxPaidSupplementalData3,320 M4,558 M3,730 M3,714 M2,830 M3,064 M3,550 M3,822 M3,818 M4,278 M
InterestPaidSupplementalData686 M678 M569 M518 M529 M497 M434 M531 M451 M721 M
Issuance of debt3,304 M-2,580 M-418 M2,727 M-3,437 M-2,215 M2,345 M-3,333 M-150 M818 M
IssuanceOfDebt3,543 M-3,954 M1,285 M1,399 M-1,238 M-817 M4,849 M-3,903 M1,892 M2,937 M
Net cash from financing activities-7,279 M-13,019 M-9,213 M-8,568 M-14,375 M-9,994 M-8,367 M-21,531 M-14,876 M-12,146 M
Net cash from investing activities-4,107 M-2,890 M-5,575 M-7,559 M-3,511 M-3,490 M3,045 M-2,834 M-4,424 M-3,500 M
Net cash from operating activities14,046 M14,608 M15,435 M14,623 M14,867 M15,242 M17,403 M18,371 M16,723 M16,848 M
Net change in cash & cash equivalents2,660 M-1,301 M647 M-1,504 M-3,019 M1,758 M12,081 M-5,994 M-2,577 M1,202 M
Net income from continuing operations11,785 M7,144 M10,604 M15,411 M9,861 M3,966 M13,103 M14,352 M14,793 M14,738 M
NetBusinessPurchaseAndSale-24 M-137 M-186 M-16 M-109 M-3,945 M-58 M-34 M-1,381 M-765 M
NetCommonStockIssuance-6,005 M-4,604 M-4,004 M-5,204 M-7,004 M-5,003 M-7,405 M-11,009 M-10,003 M-7,353 M
NetInvestmentPropertiesPurchaseAndSale-805 M-3,515 M-2,507 M-4,255 M46 M3,408 M6,146 M-55 M3 M281 M
NetInvestmentPurchaseAndSale-805 M-3,515 M-2,507 M-4,255 M46 M3,408 M6,146 M-55 M3 M281 M
NetIssuancePaymentsOfDebt3,543 M-3,954 M1,285 M1,399 M-1,238 M-817 M4,849 M-3,903 M1,892 M2,937 M
NetLongTermDebtIssuance239 M-1,374 M1,703 M-1,328 M2,199 M1,398 M2,504 M-570 M2,042 M2,119 M
NetPPEPurchaseAndSale-3,278 M762 M-2,882 M-2,813 M-3,448 M-2,953 M-3,043 M-2,745 M-3,046 M-3,016 M
Operating (gains) losses-154 M-766 M-41 M-4,947 M170 M-678 M7 M496 M-85 M-40 M
Other financing charges net-1,730 M
Other investing changes net-908 M-1,139 M-874 M
Other non-cash items691 M5,285 M969 M513 M826 M9,173 M666 M675 M757 M1,109 M
Payment of cash dividends6,911 M7,287 M7,436 M7,236 M7,310 M7,498 M7,789 M8,263 M8,770 M8,999 M
ProceedsFromStockOptionExercised2,094 M2,826 M2,672 M2,473 M1,177 M3,324 M1,978 M1,644 M2,005 M1,269 M
Purchase of Float term investments-829 M-3,810 M-2,722 M-4,869 M-3,882 M-220 M-5 M-55 M3 M281 M
Purchase of property plant & equipment-3,278 M762 M-2,882 M-2,813 M-3,448 M-2,953 M-3,043 M-2,745 M-3,046 M-3,016 M
Purchase of short term investments4,334 M2,138 M3,916 M3,603 M5,072 M2,367 M4,951 M4,417 M4,385 M3,997 M
PurchaseOfInvestment-829 M-3,810 M-2,722 M-4,869 M-3,882 M-220 M-5 M-55 M3 M281 M
PurchaseOfPPE-3,848 M-3,736 M-3,314 M-3,384 M-3,717 M-3,347 M-3,073 M-2,787 M-3,156 M-3,062 M
Repayment of debt-4,095 M-3,512 M-2,213 M-4,931 M-2,873 M-969 M-2,447 M-4,987 M-2,343 M-1,878 M
RepaymentOfDebt-4,095 M-3,512 M-2,213 M-4,931 M-2,873 M-969 M-2,447 M-12,564 M-13,821 M-14,909 M
Repurchase of capital stock-6,005 M-4,604 M-4,004 M-5,204 M-7,004 M-5,003 M-7,405 M-11,009 M-10,003 M-7,353 M
Sale of short term investments24 M1,203 M1,354 M1,488 M3,928 M3,628 M6,151 M
SaleOfInvestment24 M1,203 M1,354 M1,488 M3,928 M3,628 M6,151 M
SaleOfPPE570 M4,498 M432 M571 M269 M394 M30 M42 M110 M46 M
ShortTermDebtIssuance3,304 M-2,580 M-418 M2,727 M-3,437 M-2,215 M2,345 M4,244 M11,328 M13,849 M
ShortTermDebtPayments3,304 M-2,580 M-418 M2,727 M-3,437 M-2,215 M2,345 M-7,577 M-11,478 M-13,031 M
StockBasedCompensation360 M337 M335 M351 M395 M515 M558 M540 M528 M545 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