Procter Gamble Financial Statements Trends

The Procter Gamble Company -- USA Stock  

USD 93.04  0.1  0.11%

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 Consolidated Income of 9.3 B, Cost of Revenue of 36.8 B or Earning Before Interest and Taxes EBIT of 13.1 B, but also many exotic indicators such as Interest Coverage of 30.8829, Long Term Debt to Equity of 0.3284 or Calculated Tax Rate of 26.1126. 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.

Balance Sheet

Current ValueLast YearHistorical Average 10 Year Trend
Accumulated Other Comprehensive Income(15.1 B)(15.9 B)(8 B)
Decreasing
Slightly volatile
Total Assets127.1 B129.5 B125.5 B
Increasing
Slightly volatile
Current Assets33.8 B29.6 B25.5 B
Increasing
Slightly volatile
Assets Non Current101.7 B93.4 B100.7 B
Increasing
Stable
Cash and Equivalents15.1 B7.1 B5.9 B
Increasing
Slightly volatile
Cash and Equivalents USD7.3 B7.1 B5.3 B
Increasing
Slightly volatile
Total Debt31.6 B30.6 B30.6 B
Increasing
Stable
Debt Current12.5 B11.7 B11.2 B
Increasing
Slightly volatile
Debt Non Current19.6 B18.9 B19.4 B
Increasing
Very volatile
Total Debt USD32.1 B30.6 B30.7 B
Increasing
Stable
Shareholders Equity63.7 B58 B60 B
Increasing
Slightly volatile
Shareholders Equity USD63.7 B58 B60 B
Increasing
Slightly volatile
Goodwill and Intangible Assets72.9 B68.9 B75.3 B
Increasing
Stable
Inventory5.1 B4.7 B6 B
Decreasing
Slightly volatile
Investments5.8 B6.2 B3.2 B
Increasing
Slightly volatile
Investments Current5.8 B6.2 B3.2 B
Increasing
Slightly volatile
Total Liabilities71.4 B69.2 B66.2 B
Increasing
Slightly volatile
Current Liabilities30.8 B29.8 B27.8 B
Increasing
Slightly volatile
Liabilities Non Current39.5 B38.4 B38.3 B
Increasing
Stable
Trade and Non Trade Payables9.2 B9.3 B7.6 B
Increasing
Slightly volatile
Property Plant and Equipment Net20.5 B19.4 B19.8 B
Increasing
Slightly volatile
Trade and Non Trade Receivables4.7 B4.4 B5.3 B
Decreasing
Stable
Accumulated Retained Earnings Deficit90.9 B88 B70.4 B
Increasing
Slightly volatile
Tax Assets1.5 B1.5 B1.2 B
Increasing
Slightly volatile
Tax Liabilities9.6 B9.1 B9.5 B
Increasing
Stable

Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Consolidated Income9.3 B10.6 B10.4 B
Increasing
Very volatile
Cost of Revenue36.8 B32.9 B36.4 B
Increasing
Stable
Earning Before Interest and Taxes EBIT13.1 B14.4 B14.4 B
Decreasing
Very volatile
Earning Before Interest and Taxes USD13.1 B14.4 B14.4 B
Decreasing
Very volatile
Gross Profit32.5 B32.4 B35.3 B
Increasing
Very volatile
Interest Expense634.2 M579 M829.9 M
Decreasing
Slightly volatile
Net Income9.9 B10.5 B10.4 B
Increasing
Very volatile
Net Income Common Stock9.2 B10.5 B10.3 B
Increasing
Very volatile
Net Income Common Stock USD9.2 B10.5 B10.3 B
Increasing
Very volatile
Net Income from Discontinued Operations297.9 M(577 M)(1.1 B)
Increasing
Slightly volatile
Net Income to Non Controlling Interests107.4 M96 M127.3 M
Decreasing
Slightly volatile
Operating Expenses21.9 B18.9 B22.3 B
Increasing
Very volatile
Operating Income12.9 B13.4 B13.2 B
Increasing
Very volatile
Revenues65.1 B65.3 B71.4 B
Increasing
Very volatile
Revenues USD71.6 B65.3 B71.9 B
Increasing
Very volatile
Selling General and Administrative Expense20.8 B18.9 B21.9 B
Decreasing
Very volatile
Weighted Average Shares2.5 B2.7 B2.8 B
Decreasing
Slightly volatile
Weighted Average Shares Diluted3 B2.8 B3 B
Decreasing
Slightly volatile
Income Tax Expense3.2 B3.3 B3.2 B
Increasing
Very volatile

Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(3.7 B)(3.3 B)(3.4 B)
Decreasing
Slightly volatile
Depreciation Amortization and Accretion3.3 B3.1 B3 B
Increasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents(761.1 M)266 M180.1 M
Increasing
Very volatile
Net Cash Flow Business Acquisitions and Disposals(1.2 B)(1.3 B)(669.3 M)
Decreasing
Slightly volatile
Issuance Purchase of Equity Shares(1.6 B)(1.3 B)(3.4 B)
Increasing
Slightly volatile
Issuance Repayment of Debt Securities (1.4 B)1.3 B(526.8 M)
Increasing
Stable
Payment of Dividends and Other Cash Distributions (7.7 B)(7.4 B)(6 B)
Decreasing
Slightly volatile
Net Cash Flow from Financing(11.7 B)(9.2 B)(10.3 B)
Decreasing
Very volatile
Net Cash Flow from Investing(4.5 B)(5.6 B)(3.4 B)
Decreasing
Slightly volatile
Net Cash Flow Investment Acquisitions and Disposals(2.1 B)(1.4 B)(820.4 M)
Decreasing
Slightly volatile
Net Cash Flow from Operations12.8 B15.4 B13.8 B
Increasing
Slightly volatile
Effect of Exchange Rate Changes on Cash (416.8 M)(381 M)(134.6 M)
Decreasing
Slightly volatile
Share Based Compensation353.7 M335 M413.9 M
Decreasing
Slightly volatile
Cash Beginning of Year8.1 B6.8 B5.5 B
Increasing
Slightly volatile
Cash End of Year7.3 B7.1 B5.5 B
Increasing
Slightly volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Asset Turnover0.54630.5090.5998
Decreasing
Slightly volatile
Book Value per Share23.696321.78321.6369
Increasing
Slightly volatile
Current Ratio0.881.0980.906
Increasing
Slightly volatile
Debt to Equity Ratio56.61.1935.7814
Increasing
Slightly volatile
Dividend Yield0.03370.0310.0303
Increasing
Slightly volatile
Dividends per Basic Common Share2.76322.662.0928
Increasing
Slightly volatile
EBITDA Margin0.24160.2680.2414
Increasing
Very volatile
Earnings per Basic Share3.31583.83.6105
Increasing
Stable
Earnings per Diluted Share5.593.693.6592
Increasing
Slightly volatile
EPS Diluted Growth(0.1161)(0.103)0.0111
Decreasing
Slightly volatile
EPS Growth(0.126)(0.1166)0.0072
Decreasing
Slightly volatile
Earnings per Basic Share USD3.31583.83.6105
Increasing
Stable
Enterprise Value over EBIT20.526317.015.0439
Increasing
Slightly volatile
Enterprise Value over EBITDA16.724214.29712.6451
Increasing
Slightly volatile
Free Cash Flow per Share5.944.5543.9575
Increasing
Slightly volatile
Gross Margin0.51160.4960.4933
Increasing
Stable
Financial Leverage1.00.9520.9462
Increasing
Slightly volatile
Leverage Ratio2.17362.06152.0835
Decreasing
Very volatile
NCFO Growth0.0766(0.008)0.0418
Decreasing
Stable
Net Income Growth(0.1239)(0.1119)(0.0032)
Decreasing
Slightly volatile
Profit Margin0.23560.1610.1495
Increasing
Slightly volatile
Payout Ratio0.91370.70.6126
Increasing
Slightly volatile
Price to Book Value4.393.8873.4653
Decreasing
Very volatile
Price to Earnings Ratio16.6522.28219.385
Increasing
Stable
Price to Sales Ratio3.653.4512.658
Increasing
Slightly volatile
Revenue Growth(0.099)(0.1385)(0.0121)
Decreasing
Slightly volatile
Return on Average Assets0.07410.0820.0817
Decreasing
Slightly volatile
Return on Average Equity0.17920.1730.1772
Decreasing
Slightly volatile
Return on Invested Capital0.25530.2820.2949
Decreasing
Slightly volatile
Return on Sales0.19370.2210.1982
Increasing
Very volatile
Weighted Average Share Growth(0.008)(0.0071)(0.0169)
Increasing
Slightly volatile
Sales per Share26.636324.53125.9869
Increasing
Stable
Tax Efficiency0.79070.73830.7534
Increasing
Slightly volatile
Tangible Assets Book Value per Share23.132621.88718.4733
Increasing
Slightly volatile
Total Assets Per Share50.186647.650948.1822
Increasing
Slightly volatile
Cash Flow Per Share5.87715.78515.2742
Increasing
Slightly volatile
Return on Investment14.116414.875915.0169
Decreasing
Slightly volatile
Operating Margin22.5720.583819.2672
Increasing
Very volatile
Calculated Tax Rate26.112624.998125.2404
Decreasing
Slightly volatile
Receivables Turnover14.562614.104513.4874
Increasing
Slightly volatile
Inventory Turnover6.75696.47186.0154
Increasing
Slightly volatile
PPandE Turnover3.61483.28453.8155
Decreasing
Slightly volatile
Cash and Equivalents Turnover10.12789.338315.9028
Decreasing
Slightly volatile
Accounts Payable Turnover8.70167.407610.4757
Decreasing
Slightly volatile
Accrued Expenses Turnover15.320613.948916.4193
Decreasing
Slightly volatile
Interest Coverage30.882933.856421.8424
Increasing
Slightly volatile
Long Term Debt to Equity0.32840.33040.3228
Decreasing
Slightly volatile
Quick Ratio0.59420.57590.4486
Increasing
Slightly volatile
Net Current Assets as percentage of Total Assets1.18842.3691(2.1987)
Increasing
Slightly volatile
Revenue to Assets0.58040.51360.5785
Decreasing
Slightly volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Average Assets137.9 B128.3 B127.4 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA17.5 B17.5 B17.5 B
Increasing
Very volatile
Earnings Before Interest Taxes and Depreciation Amortization USD16.3 B17.5 B17.4 B
Increasing
Very volatile
Earnings before Tax12.4 B13.8 B13.5 B
Increasing
Very volatile
Average Equity65.9 B60.8 B60.8 B
Increasing
Slightly volatile
Enterprise Value249.8 B250.3 B213.4 B
Increasing
Slightly volatile
Free Cash Flow12.1 B12.1 B10.6 B
Increasing
Slightly volatile
Invested Capital53.9 B50.6 B51.2 B
Decreasing
Very volatile
Invested Capital Average53.9 B51.1 B48.5 B
Increasing
Slightly volatile
Market Capitalization237.5 B225.4 B188.3 B
Increasing
Slightly volatile
Tangible Asset Value62.2 B58.3 B50.9 B
Increasing
Slightly volatile
Working Capital3 B(144 M)(2.3 B)
Increasing
Slightly volatile
Revenue Per Employee691.4 K620.2 K641 K
Increasing
Slightly volatile
Net Income Per Employee86.2 K99.8 K90 K
Increasing
Very volatile