Procter Gamble Financial Statements Trends

PG -- USA Stock  

Fiscal Quarter End: December 31, 2019  

This module enables investors to look at Procter Gamble various fundamental indicators over time in order to gain insight into the company future performance. Macroaxis historical fundamental analysis tools allow evaluation of not only typical financial statement drivers such as Direct Expenses of 40.3 B, Consolidated Income of 10.9 B or Cost of Revenue of 33.9 B, but also many exotic indicators such as Interest Coverage of 21.8401, Long Term Debt to Equity of 0.3688 or Calculated Tax Rate of 28.9587. This module is a perfect complement to use when analyzing Procter Gamble Valuation or Volatility. It can also complement various Procter Gamble Technical models. Additionally take a look at analysis of Procter Gamble Correlation with competitors.
Revenues

Procter Gamble Balance Sheet

Current ValueLast YearHistorical Average 10 Year Trend
Total Assets127.1 B121.3 B131.1 B
Increasing
Very volatile
Cash and Equivalents10.3 B5.5 B5.3 B
Increasing
Slightly volatile
InvestmentsB2.4 B4.2 B
Decreasing
Slightly volatile
Investments CurrentB2.4 B4.2 B
Decreasing
Slightly volatile
Property Plant and Equipment Net23.6 B22.4 B20.3 B
Increasing
Slightly volatile
Inventory5.8 B6.2 B6.5 B
Increasing
Very volatile
Tax Assets1.4 B1.4 B1.3 B
Increasing
Very volatile
Trade and Non Trade ReceivablesB5.3 B5.6 B
Decreasing
Stable
Trade and Non Trade Payables8.6 B6.9 B6.8 B
Decreasing
Stable
Goodwill and Intangible Assets75.2 B80.2 B84.8 B
Increasing
Very volatile
Total Liabilities62.7 B64.3 B69.7 B
Decreasing
Slightly volatile
Shareholders Equity55.8 B57 B60.7 B
Increasing
Very volatile
Accumulated Retained Earnings Deficit81.8 B65.9 B63.7 B
Decreasing
Very volatile
Accumulated Other Comprehensive Income(5.8 B)(3 B)(4.6 B)
Increasing
Slightly volatile
Current Assets33.8 B25.2 B23.3 B
Increasing
Slightly volatile
Assets Non Current97.6 B101.6 B108.7 B
Decreasing
Very volatile
Current Liabilities30.8 B35.5 B31.2 B
Increasing
Slightly volatile
Liabilities Non Current35.8 B36.5 B39.5 B
Decreasing
Slightly volatile
Tax Liabilities9.1 B9.7 B10.1 B
Increasing
Stable
Total Debt30.1 B33.3 B35.4 B
Decreasing
Stable
Debt Current12.7 B14.7 B15.2 B
Increasing
Very volatile
Debt Non Current18.2 B18.6 B20.2 B
Decreasing
Slightly volatile
Shareholders Equity USD55.8 B57 B60.7 B
Increasing
Very volatile
Cash and Equivalents USD5.8 B5.5 B4.9 B
Increasing
Slightly volatile
Total Debt USD30.9 B33.3 B35.5 B
Decreasing
Very volatile
Accounts Payable9.7 B11.3 BB
Increasing
Slightly volatile
Receivables5.7 BB5.4 B
Decreasing
Slightly volatile
InventoriesBB5.9 B
Decreasing
Slightly volatile

Procter Gamble Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Revenues67.7 B69 B74.4 B
Decreasing
Stable
Cost of Revenue33.9 B34.8 B37.5 B
Decreasing
Stable
Selling General and Administrative Expense20 B20.4 B21.9 B
Decreasing
Very volatile
Operating Expenses20.5 B20.4 B22.7 B
Decreasing
Slightly volatile
Interest Expense948.1 M1.2 B1.2 B
Increasing
Stable
Income Tax Expense3.1 B3.4 B3.5 B
Increasing
Stable
Net Loss Income from Discontinued Operations(1.9 B)(2.5 B)(2.9 B)
Increasing
Slightly volatile
Consolidated Income10.9 B12.1 B12.2 B
Increasing
Stable
Net Income to Non Controlling Interests98 M99 M104.2 M
Increasing
Stable
Net Income3.6 B12.1 B11.6 B
Decreasing
Very volatile
Net Income Common Stock10.9 B12.1 B12.2 B
Increasing
Stable
Weighted Average Shares2.5 B2.6 B2.8 B
Decreasing
Stable
Weighted Average Shares DilutedB2.5 B2.9 B
Decreasing
Slightly volatile
Earning Before Interest and Taxes EBIT15 B16.7 B16.9 B
Increasing
Stable
Revenues USD67.2 B69 B74.3 B
Decreasing
Stable
Net Income Common Stock USD10.9 B12.1 B12.2 B
Increasing
Stable
Earning Before Interest and Taxes USD15 B16.7 B16.9 B
Increasing
Stable
Gross Profit33.4 B34.2 B36.8 B
Decreasing
Stable
Operating Income12.8 B13.8 B14.1 B
Increasing
Stable
Direct Expenses40.3 B34.8 B38.1 B
Decreasing
Slightly volatile

Procter Gamble Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(3 B)(2.9 B)(3.2 B)
Increasing
Slightly volatile
Net Cash Flow Business Acquisitions and Disposals(537.4 M)(331.2 M)(705.2 M)
Increasing
Slightly volatile
Net Cash Flow Investment Acquisitions and Disposals(228.7 M)190.9 M427.1 M
Decreasing
Slightly volatile
Net Cash Flow from Financing(12.8 B)(12.4 B)(11.1 B)
Decreasing
Slightly volatile
Issuance Repayment of Debt Securities (306.2 M)(93.2 M)(169.5 M)
Increasing
Stable
Issuance Purchase of Equity Shares(5.5 B)(6.5 B)(5.4 B)
Decreasing
Slightly volatile
Payment of Dividends and Other Cash Distributions (5.2 B)(4.5 B)(5.2 B)
Increasing
Slightly volatile
Net Cash Flow from Investing(2.6 B)(2.1 B)(2.5 B)
Increasing
Slightly volatile
Net Cash Flow from Operations10.4 B13.4 B14.4 B
Decreasing
Slightly volatile
Effect of Exchange Rate Changes on Cash (235.2 M)(326.6 M)(265.6 M)
Decreasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents693.3 M1.3 B1.4 B
Decreasing
Slightly volatile
Share Based Compensation412.8 M464.4 M501.8 M
Decreasing
Slightly volatile
Depreciation Amortization and Accretion2.7 B2.8 BB
Decreasing
Slightly volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Earnings per Basic Share3.74214.044.1047
Increasing
Stable
Earnings per Diluted Share1.433.833.7064
Decreasing
Very volatile
Earnings per Basic Share USD3.74214.044.1047
Increasing
Stable
Dividends per Basic Common Share2.35681.8861.8418
Decreasing
Very volatile
Return on Average Equity0.17390.19260.1957
Increasing
Stable
Return on Average Assets0.08080.08820.0896
Increasing
Stable
Return on Invested Capital0.31250.35550.3603
Increasing
Stable
Gross Margin0.44310.44640.4858
Decreasing
Slightly volatile
Profit Margin0.14460.15750.16
Increasing
Stable
EBITDA Margin0.23520.25380.2621
Increasing
Stable
Return on Sales0.19890.21780.2226
Increasing
Stable
Asset Turnover0.50090.50580.5516
Decreasing
Slightly volatile
Payout Ratio0.63730.41980.5432
Decreasing
Slightly volatile
Enterprise Value over EBITDA13.31059.7611.2147
Decreasing
Slightly volatile
Enterprise Value over EBIT16.263211.513.9785
Decreasing
Slightly volatile
Price to Earnings Ratio86.4413.0924.1999
Increasing
Very volatile
Sales per Share23.889523.6825.9143
Decreasing
Slightly volatile
Price to Sales Ratio4.572.23332.4003
Increasing
Very volatile
Price to Book Value6.692.70253.0885
Increasing
Very volatile
Debt to Equity Ratio63.21.29616.8119
Increasing
Slightly volatile
Dividend Yield0.02840.02880.0308
Decreasing
Very volatile
Current Ratio0.750.81540.726
Increasing
Slightly volatile
Free Cash Flow per Share4.114.614.1387
Decreasing
Very volatile
Book Value per Share19.815819.5721.1202
Decreasing
Very volatile
Tangible Assets Book Value per Share20.552618.0416.7491
Increasing
Stable
Total Assets Per Share52.147745.950748.6541
Increasing
Very volatile
Cash Flow Per Share5.47646.08525.4106
Increasing
Slightly volatile
Return on Investment11.86416.821914.0659
Decreasing
Slightly volatile
Operating Margin25.318.106818.3975
Increasing
Very volatile
Calculated Tax Rate28.958734.651525.7796
Increasing
Slightly volatile
Receivables Turnover13.235114.046713.8191
Increasing
Very volatile
Inventory Turnover6.4577.12826.4368
Increasing
Slightly volatile
PPandE Turnover3.82793.2333.6802
Decreasing
Slightly volatile
Cash and Equivalents Turnover20.107219.883716.9646
Decreasing
Slightly volatile
Accounts Payable Turnover8.46636.26598.8865
Decreasing
Slightly volatile
Accrued Expenses Turnover15.207911.86515.4594
Decreasing
Slightly volatile
Interest Coverage21.840118.986227.5667
Increasing
Slightly volatile
Long Term Debt to Equity0.36880.43220.3387
Increasing
Slightly volatile
Quick Ratio0.4730.50770.4872
Increasing
Slightly volatile
Net Current Assets as percentage of Total Assets(5.0532)(6.5494)(2.9814)
Decreasing
Stable
Revenue to Assets0.64650.58810.588
Decreasing
Stable

Procter Gamble Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Earnings before Tax14 B15.5 B15.7 B
Increasing
Stable
Earnings Before Interest Taxes and Depreciation Amortization EBITDA17.1 B19.4 B19.9 B
Increasing
Stable
Earnings Before Interest Taxes and Depreciation Amortization USD17.7 B19.4 B19.9 B
Increasing
Stable
Market Capitalization309.4 B171.3 B177 B
Increasing
Stable
Enterprise Value330.8 B210.8 B210.1 B
Increasing
Stable
Invested Capital56.8 B54.1 B48.5 B
Increasing
Slightly volatile
Average Equity56 B56.5 B60.7 B
Decreasing
Very volatile
Average Assets120.1 B122.9 B132.3 B
Decreasing
Stable
Invested Capital Average57 B53.9 B48.6 B
Increasing
Slightly volatile
Tangible Asset Value57.4 B52.6 B47.8 B
Increasing
Slightly volatile
Free Cash Flow10.1 B10.5 B11.5 B
Decreasing
Slightly volatile
Working CapitalB(10.3 B)(7.9 B)
Increasing
Slightly volatile
Revenue Per Employee651.3 K697.8 K672.5 K
Increasing
Slightly volatile
Net Income Per Employee75.6 K40.2 K92.3 K
Decreasing
Very volatile

Procter Gamble Fundamental Market Drivers

Short Percent Of Float0.89%
Forward Price Earnings23.46
Shares Short Prior Month22.24M
Average Daily Volume Last 10 Day4.89M
Average Daily Volume In Three Month6.62M
Date Short InterestNovember 15, 2019
Fifty Day Average120.95
Two Hundred Day Average116.88

Procter Gamble Upcoming Events

Upcoming Quarterly Earning ReportJanuary 22, 2020
Next Earnings ReportApril 28, 2020
Next Fiscal Quarter EndDecember 31, 2019
Next Fiscal Year EndAugust 4, 2020
Last Quarter Report DateSeptember 30, 2019
Last Earning Anouncement DateDecember 31, 2018
Search macroaxis.com