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

PG Stock Annual Balance Sheet. Download in Excel

Procter & Gamble Company (The) logo

Procter & Gamble Company (The)

Sector: Consumer Defensive   

Industry: Household & Personal Products

168.06
 
USD
  
-1.13
  
(-0.67%)
Previous close: 169.19  Open: 168.87  Bid: 168.06  Ask: 168.19
52 week range    
144.97   
   180.43
Mkt Cap: 401,134 M  Avg Vol (90 Days): 6,533,033
Peers   
CL / 
CHD / 
KMB / 
EL / 
CLX / 
JNJ / 
HAIN / 
UL / 
REV / 
Last updated: Sunday 22nd December 2024

Stock Rankings

57
MarketXLS Rank
75
Value
38
Technical
60
Quality
How are these ranks calculated?
Search for a stock

Financials

PG Balance Sheet

Annual
Jun-15Jun-16Jun-17Jun-18Jun-19Jun-20Jun-21Jun-22Jun-23Jun-24
Accounts payable8,138 M9,325 M9,632 M10,344 M11,260 M12,071 M13,720 M14,882 M14,598 M15,364 M
Accounts receivable4,568 M4,373 M4,594 M4,686 M4,951 M4,178 M4,725 M5,143 M5,471 M6,118 M
Accrued expenses16,229 M16,774 M16,656 M17,814 M20,314 M21,793 M24,243 M24,436 M25,527 M26,437 M
Accumulated depreciation & depletion-20,408 M-20,481 M-20,255 M-21,247 M-22,122 M-23,079 M-25,012 M-25,502 M-26,736 M-27,911 M
Additional paid in capital63,852 M63,714 M63,641 M63,846 M63,827 M64,194 M64,848 M65,795 M66,556 M67,684 M
Building & improvements7,209 M
Cash and equivalents6,836 M7,102 M5,569 M2,569 M4,239 M16,181 M10,288 M
CashCashEquivalentsAndShortTermInvestments11,603 M13,348 M15,137 M11,850 M6,048 M16,181 M10,288 M
CashEquivalents6,845 M7,102 M5,569 M1,516 M3,000 M14,600 M9,100 M6,000 M6,800 M8,000 M
CommercialPaper8,807 M8,690 M11,705 M7,761 M6,183 M8,545 M5,171 M4,805 M6,236 M3,327 M
Common par5,086 M5,047 M5,015 M4,976 M4,937 M4,906 M4,879 M4,852 M4,828 M4,807 M
Common stock equity63,739 M58,631 M56,433 M53,497 M48,340 M47,601 M47,384 M71,883 M47,598 M50,286 M
CommonStock4,009 M4,009 M4,009 M4,009 M4,009 M4,009 M4,009 M4,009 M4,009 M4,009 M
Cost in excess44,622 M44,350 M44,699 M45,175 M40,273 M39,901 M40,924 M39,700 M40,659 M40,303 M
CurrentAccruedExpenses8,091 M7,449 M7,024 M7,470 M9,054 M9,722 M10,523 M9,554 M10,929 M11,073 M
CurrentCapitalLeaseObligation249 M237 M261 M275 M263 M205 M222 M243 M
CurrentDeferredAssets1,356 M1,507 M
CurrentDeferredTaxesAssets1,356 M1,507 M5,134 M3,826 M4,203 M4,090 M4,564 M4,091 M4,687 M4,582 M
CurrentDeferredTaxesLiabilities11,622 M11,486 M11,238 M8,018 M8,656 M8,098 M8,503 M9,288 M9,334 M9,355 M
DefinedPensionBenefit14,239 M15,546 M14,512 M14,370 M15,800 M16,500 M17,300 M11,900 M11,800 M11,600 M
DerivativeProductLiabilities307 M445 M325 M
DividendsPayable-7,028 M-7,181 M-6,989 M-7,057 M-7,256 M-7,551 M-8,020 M-8,514 M-8,742 M-9,053 M
Finished goods3,188 M2,965 M2,787 M2,815 M3,116 M3,410 M3,619 M3,900 M4,254 M4,470 M
Float term debt18,327 M18,945 M18,038 M20,863 M20,395 M23,537 M23,099 M22,848 M24,378 M25,269 M
GoodwillAndOtherIntangibleAssets69,632 M68,877 M68,886 M69,077 M64,488 M63,693 M64,566 M63,379 M64,442 M62,350 M
Gross fixed assets (Plant Property & Equipment)40,063 M39,866 M40,148 M41,847 M43,393 M43,771 M46,698 M46,697 M48,645 M50,063 M
IncomeTaxPayable845 M397 M449 M268 M341 M693 M828 M1,042 M
Intangibles25,010 M24,527 M24,187 M23,902 M24,215 M23,792 M23,642 M23,679 M23,783 M22,047 M
InterestPayable235 M282 M
Inventories4,979 M4,716 M4,624 M4,738 M5,017 M5,498 M5,983 M6,924 M7,073 M7,016 M
Invested capital100,393 M96,521 M92,509 M95,223 M89,130 M94,675 M93,582 M117,579 M96,354 M101,561 M
Land & improvements795 M
LongTermCapitalLeaseObligation652 M631 M800 M817 M1,031 M
LongTermDebtAndCapitalLeaseObligation18,327 M18,945 M18,038 M20,863 M20,395 M23,537 M23,099 M22,848 M24,378 M25,269 M
Machinery furniture & equipment30,346 M
Minority interest631 M642 M594 M590 M385 M357 M276 M265 M288 M272 M
Net fixed assets (net PP&E)19,655 M19,385 M19,893 M20,600 M21,271 M20,692 M21,686 M21,195 M21,909 M22,152 M
Non-current deferred income taxes9,179 M9,113 M8,126 M6,163 M6,899 M6,199 M6,153 M6,809 M6,478 M6,516 M
NonCurrentDeferredLiabilities9,179 M9,113 M8,126 M6,163 M6,899 M6,199 M6,153 M6,809 M6,478 M6,516 M
NonCurrentDeferredTaxesAssets839 M764 M709 M699 M931 M829 M878 M862 M874 M843 M
NonCurrentPensionAndOtherPostretirementBenefitPlans5,247 M6,761 M5,487 M4,768 M5,622 M6,223 M5,452 M3,139 M3,116 M2,884 M
Other current assets3,112 M5,895 M465 M470 M-1,146 M485 M-1,006 M-916 M515 M582 M
Other equity adjustments-12,780 M-15,907 M-14,632 M-14,749 M-14,936 M-16,165 M
Other fixed assets19,655 M19,385 M19,893 M20,600 M21,271 M20,692 M21,686 M21,195 M21,909 M22,152 M
Other non-current assets10,562 M5,092 M3,884 M4,109 M6,863 M7,248 M9,964 M10,981 M11,009 M12,421 M
Other non-current liabilities8,432 M10,325 M8,254 M10,164 M10,211 M11,110 M10,269 M7,616 M7,152 M6,398 M
OtherCurrentBorrowings12,018 M11,653 M13,554 M10,423 M9,697 M11,183 M8,889 M8,645 M10,229 M7,191 M
OtherCurrentLiabilities1,543 M2,343 M1,994 M2,183 M2,323 M3,105 M2,939 M2,915 M2,953 M
OtherPayable3,736 M3,314 M3,384 M3,717 M3,347 M3,073 M2,787 M3,156 M3,062 M
Payables8,138 M9,325 M9,632 M10,344 M11,260 M12,071 M13,720 M14,882 M14,598 M15,364 M
Preferred securities of subsidiary trust1,077 M1,038 M1,006 M967 M928 M897 M870 M843 M819 M798 M
PreferredStock1,077 M1,038 M1,006 M967 M928 M897 M870 M843 M819 M798 M
Prepaid expenses2,708 M2,653 M2,139 M2,046 M2,218 M2,130 M2,095 M2,372 M1,858 M2,095 M
Raw materials1,266 M1,188 M1,308 M1,335 M1,289 M1,414 M1,645 M2,168 M1,863 M1,617 M
Restricted cash4,239 M16,181 M10,288 M7,214 M8,246 M9,482 M
Retained earnings72,027 M72,046 M81,492 M83,892 M79,982 M84,074 M92,630 M124,618 M105,950 M111,911 M
SecuritySoldNotYetRepurchased-4,604 M-4,004 M
Short term debt12,018 M11,653 M13,554 M10,423 M9,697 M11,183 M8,889 M8,645 M10,229 M7,191 M
Total assets128,175 M125,846 M119,157 M117,106 M113,949 M119,620 M118,301 M116,292 M120,008 M122,370 M
Total current assets28,326 M32,492 M26,494 M23,320 M21,327 M27,987 M22,085 M20,737 M22,648 M24,709 M
Total current liabilities29,790 M30,770 M30,210 M28,237 M30,011 M32,976 M33,132 M33,081 M35,756 M33,627 M
Total equity63,739 M58,631 M56,433 M53,497 M48,340 M47,601 M47,384 M71,883 M47,598 M50,286 M
Total liabilities66,445 M69,153 M64,628 M65,427 M67,516 M73,822 M72,653 M70,354 M73,764 M71,812 M
Total non-current assets99,849 M93,354 M92,663 M93,786 M92,622 M91,633 M96,216 M95,555 M97,360 M97,660 M
Total non-current liabilities36,655 M38,383 M34,418 M37,190 M37,505 M40,846 M39,521 M37,273 M38,008 M38,185 M
TotalEquityGrossMinority64,370 M59,273 M57,027 M54,087 M48,725 M47,958 M47,660 M72,148 M47,886 M50,558 M
TotalEquityGrossMinorityInterest64,370 M59,273 M57,027 M54,087 M48,725 M47,958 M47,660 M72,148 M47,886 M50,558 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest130,815 M128,426 M121,655 M119,514 M113,949 M119,620 M118,301 M142,502 M121,650 M122,370 M
TotalNonCurrentLiabilitiesNetMinorityInteres36,655 M38,383 M34,418 M37,190 M37,505 M40,846 M39,521 M37,273 M38,008 M38,185 M
Treasury stock-77,226 M-82,176 M-93,715 M-99,217 M-100,406 M-105,573 M-114,973 M-123,382 M-129,736 M-133,379 M
Work in progress525 M563 M529 M588 M612 M674 M719 M856 M956 M929 M
Working capital-1,464 M1,722 M-3,716 M-4,917 M-8,684 M-4,989 M-11,047 M-12,344 M-13,108 M-8,917 M
debtc12,018 M11,653 M13,554 M10,423 M9,697 M11,183 M8,889 M8,645 M10,229 M7,191 M
ltinv4,797 M6,274 M9,700 M9,422 M6,217 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