Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

PG Stock Forecast, Price Targets, Chart, Dividends & Analysis

Procter & Gamble Company (The) logo

Procter & Gamble Company (The)

Sector: Consumer Defensive   

Industry: Household & Personal Products

172.75
 
USD
  
1.86
  
(1.09%)
Previous close: 170.89  Open: 171.66  Bid: 173.5  Ask: 173.58
52 week range    
142.50   
   177.94
Mkt Cap: 402,147 M  Avg Vol (90 Days): 6,808,626
Peers   
CL / 
CHD / 
KMB / 
EL / 
CLX / 
JNJ / 
HAIN / 
UL / 
REV / 
Last updated: Friday 22nd November 2024

Stock Rankings

68
MarketXLS Rank
75
Value
69
Technical
60
Quality
How are these ranks calculated?
Ad slot not ready
Search for a stock

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

CHD

0.010427 B48.97112.25

CL

0.021476 B26.8194.25

CLX

0.029121 B58.21169.15

EL

0.02223 B113.8466.84

ENR

0.03543 B242.2938.09

HAIN

1 B-98.05

JNJ

0.0322368 B25.84155.5

KMB

0.036445 B17.37137.03

REV

3.8999

UL

Financials

PG Income Statement

Annual
Jun-15Jun-16Jun-17Jun-18Jun-19Jun-20Jun-21Jun-22Jun-23Jun-24
AccruedPreferredStockDividends259 M255 M247 M265 M263 M263 M271 M281 M282 M284 M
Amortization of intangibles44,622 M44,350 M44,699 M45,175 M40,273 M39,901 M40,924 M39,700 M40,659 M40,303 M
Basic EPS from continuing operations2.923.593.793.751.455.135.696.06.07
Basic EPS total2.53.85.83.751.455.135.696.06.076.18
Basic weighted shares outstanding2,712 M2,699 M2,598 M2,529 M2,504 M2,487 M2,466 M2,410 M2,368 M
BasicDiscontinuousOperations-0.420.212.01
Cost of sales37,056 M32,909 M32,535 M34,432 M34,768 M35,250 M37,108 M42,157 M42,760 M40,848 M
Depreciation3,134 M3,078 M2,820 M2,834 M2,824 M3,013 M2,735 M2,807 M2,714 M2,896 M
DepreciationAndAmortization3,134 M3,078 M2,820 M2,834 M2,824 M3,013 M2,735 M2,807 M2,714 M2,896 M
Diluted EPS total2.443.695.597.342.864.965.55.815.96.02
Diluted normalized net income/share2.843.493.697.342.864.965.55.815.9
Diluted weighted shares outstanding2,884 M2,844 M2,740 M2,657 M2,540 M2,626 M2,601 M2,539 M2,484 M
DilutedDiscontinuousOperations-0.40.21.9
Dividends paid per share3.03.03.033.243.523.683.83
GainOnSaleOfBusiness766 M41 M5,490 M176 M678 M
GainOnSaleOfSecurity138 M70 M69 M60 M73 M238 M
GeneralAndAdministrativeExpense20,616 M18,949 M18,568 M19,037 M19,084 M19,994 M21,024 M20,217 M21,112 M23,305 M
Gross operating profit33,693 M32,390 M32,523 M32,400 M32,916 M35,700 M76,118 M38,030 M39,246 M43,191 M
ImpairmentOfCapitalAssets2,064 M8,345 M
Income before tax15,068 M13,369 M13,257 M13,326 M6,069 M15,834 M74,925 M17,995 M18,353 M18,761 M
Income restructuring and M&A1,068 M977 M754 M1,070 M754 M782 M330 M253 M329 M659 M
Income taxes2,725 M3,342 M3,063 M3,465 M2,103 M2,731 M-193 M3,202 M3,615 M3,787 M
Interest income149 M182 M171 M247 M220 M155 M45 M51 M307 M473 M
InterestExpenseNonOperating626 M579 M465 M506 M509 M465 M502 M439 M756 M925 M
MinorityInterests-108 M-96 M-85 M-111 M-69 M-76 M46,654 M-51 M-85 M-95 M
MiscOtherSpecialCharges440 M325 M-404 M222 M871 M438 M-512 M570 M668 M668 M
Net income from total operations7,036 M10,508 M15,326 M9,750 M3,897 M13,027 M14,352 M14,742 M14,653 M14,879 M
NetIncomeCommonStockholders11,092 M10,508 M15,326 M9,750 M3,897 M12,764 M14,035 M14,461 M14,371 M14,595 M
NetIncomeContinuousOperations7,036 M10,508 M15,326 M9,750 M3,897 M13,027 M14,352 M14,793 M14,738 M14,974 M
NetIncomeDiscontinuousOperations-1,143 M577 M5,217 M
NetIncomeExtraordinary14,352 M14,793 M
NetNonOperatingInterestIncomeExpense-477 M-397 M-294 M-259 M-289 M-310 M-457 M388 M307 M473 M
Normalized income12,160 M9,626 M3,881 M11,422 M21,489 M
Operating income11,049 M13,441 M13,955 M13,363 M5,487 M15,706 M75,638 M17,813 M18,134 M18,545 M
Operating income before depreciation (EBITDA)18,828 M17,026 M16,542 M16,666 M9,402 M19,312 M77,660 M21,241 M21,823 M22,582 M
OperatingExpense18,588 M18,949 M18,568 M19,037 M19,084 M19,994 M480 M20,217 M21,112 M23,305 M
Other income net-440 M-325 M404 M-222 M-871 M-438 M383 M570 M-668 M673 M
OtherGainLossFromDispositionOfDiscontinuedOperations-1,143 M577 M5,217 M
OtherGandA20,616 M18,949 M18,568 M19,037 M19,084 M19,994 M21,024 M20,217 M21,112 M23,305 M
OtherImpairmentOfCapitalAssets1,341 M
OtherOperatingExpenses-118 M-97 M-75 M-87 M-71 M-82 M-60 M-53 M-60 M-160 M
OtherunderPreferredStockDividend259 M255 M247 M265 M263 M263 M271 M281 M282 M284 M
PreferredStockDividends259 M255 M247 M265 M263 M263 M271 M281 M282 M284 M
PromotionAndAdvertising7,200 M7,200 M7,100 M7,100 M6,800 M7,300 M8,200 M7,900 M8,000 M9,600 M
Research & development expense2,000 M1,900 M1,900 M1,900 M1,900 M1,800 M1,900 M2,000 M2,000 M2,000 M
ResearchExpense2,000 M1,900 M1,900 M1,900 M1,900 M1,800 M1,900 M2,000 M2,000 M2,000 M
RestructringAndMnAIncome1,068 M977 M754 M1,070 M754 M782 M330 M253 M329 M659 M
Revenue per share44,622 M44,350 M44,699 M45,175 M40,273 M39,901 M40,924 M39,700 M40,659 M40,303 M
SalariesAndWages-2,028 M335 M351 M395 M515 M558 M540 M528 M-103 M-103 M
Selling Gen & administrative expense20,616 M18,949 M18,568 M19,037 M19,084 M19,994 M21,024 M20,217 M21,112 M23,305 M
SellingAndMarketingExpense7,200 M7,200 M7,100 M7,100 M6,800 M7,300 M8,200 M7,900 M8,000 M9,600 M
Special income/charges-3,132 M-977 M-754 M-1,070 M-8,345 M-782 M-330 M-253 M-329 M-659 M
Total Income available for interest expense (EBIT)15,694 M13,948 M13,722 M13,832 M6,578 M16,299 M74,925 M18,434 M19,109 M19,686 M
Total common shares outstanding2,713 M2,669 M2,550 M2,488 M2,502 M2,486 M2,427 M2,390 M2,357 M2,354 M
Total net income7,036 M10,508 M15,326 M9,750 M3,897 M13,027 M14,352 M14,742 M14,653 M14,879 M
Total ordinary shares2,354 M2,354 M2,354 M2,354 M2,354 M2,354 M2,354 M2,354 M2,354 M2,354 M
Total revenues70,749 M65,299 M65,058 M66,832 M67,684 M70,950 M76,118 M80,187 M82,006 M84,039 M
TotalExpenses55,644 M51,858 M51,103 M53,469 M53,852 M55,244 M480 M62,374 M63,872 M64,153 M
TotalRevenue70,749 M65,299 M65,058 M66,832 M67,684 M70,950 M76,118 M80,187 M82,006 M84,039 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