The Procter & Gamble Company (PG) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
The Procter & Gamble Company (PG) Bundle
Discover the true value of The Procter & Gamble Company (PG) with our professional-grade DCF Calculator! Customize key assumptions, explore various scenarios, and evaluate how adjustments affect The Procter & Gamble Company (PG) valuation – all within one convenient Excel template.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 70,950.0 | 76,118.0 | 80,187.0 | 82,006.0 | 84,039.0 | 87,689.9 | 91,499.4 | 95,474.4 | 99,622.1 | 103,950.0 |
| Revenue Growth, % | 0 | 7.28 | 5.35 | 2.27 | 2.48 | 4.34 | 4.34 | 4.34 | 4.34 | 4.34 |
| EBITDA | 19,312.0 | 20,852.0 | 21,241.0 | 21,823.0 | 22,582.0 | 23,603.5 | 24,628.9 | 25,698.9 | 26,815.3 | 27,980.2 |
| EBITDA, % | 27.22 | 27.39 | 26.49 | 26.61 | 26.87 | 26.92 | 26.92 | 26.92 | 26.92 | 26.92 |
| Depreciation | 3,013.0 | 2,735.0 | 2,807.0 | 2,714.0 | 2,896.0 | 3,173.6 | 3,311.5 | 3,455.4 | 3,605.5 | 3,762.1 |
| Depreciation, % | 4.25 | 3.59 | 3.5 | 3.31 | 3.45 | 3.62 | 3.62 | 3.62 | 3.62 | 3.62 |
| EBIT | 16,299.0 | 18,117.0 | 18,434.0 | 19,109.0 | 19,686.0 | 20,429.9 | 21,317.4 | 22,243.5 | 23,209.8 | 24,218.1 |
| EBIT, % | 22.97 | 23.8 | 22.99 | 23.3 | 23.42 | 23.3 | 23.3 | 23.3 | 23.3 | 23.3 |
| Total Cash | 16,181.0 | 10,288.0 | 7,214.0 | 8,246.0 | 9,482.0 | 11,690.2 | 12,198.1 | 12,728.0 | 13,281.0 | 13,857.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 4,178.0 | 4,725.0 | 5,143.0 | 5,471.0 | 6,118.0 | 5,693.1 | 5,940.4 | 6,198.4 | 6,467.7 | 6,748.7 |
| Account Receivables, % | 5.89 | 6.21 | 6.41 | 6.67 | 7.28 | 6.49 | 6.49 | 6.49 | 6.49 | 6.49 |
| Inventories | 5,498.0 | 5,983.0 | 6,924.0 | 7,073.0 | 7,016.0 | 7,228.7 | 7,542.8 | 7,870.4 | 8,212.4 | 8,569.1 |
| Inventories, % | 7.75 | 7.86 | 8.63 | 8.62 | 8.35 | 8.24 | 8.24 | 8.24 | 8.24 | 8.24 |
| Accounts Payable | 12,071.0 | 13,720.0 | 14,882.0 | 14,598.0 | 15,364.0 | 15,728.1 | 16,411.4 | 17,124.3 | 17,868.3 | 18,644.5 |
| Accounts Payable, % | 17.01 | 18.02 | 18.56 | 17.8 | 18.28 | 17.94 | 17.94 | 17.94 | 17.94 | 17.94 |
| Capital Expenditure | -3,073.0 | -2,787.0 | -3,156.0 | -3,062.0 | -3,322.0 | -3,440.1 | -3,589.6 | -3,745.5 | -3,908.2 | -4,078.0 |
| Capital Expenditure, % | -4.33 | -3.66 | -3.94 | -3.73 | -3.95 | -3.92 | -3.92 | -3.92 | -3.92 | -3.92 |
| Tax Rate, % | 20.69 | 20.69 | 20.69 | 20.69 | 20.69 | 20.69 | 20.69 | 20.69 | 20.69 | 20.69 |
| EBITAT | 13,409.6 | 14,713.7 | 15,101.6 | 15,256.6 | 15,612.6 | 16,530.1 | 17,248.2 | 17,997.6 | 18,779.4 | 19,595.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 15,744.6 | 15,278.7 | 14,555.6 | 14,147.6 | 15,362.6 | 16,840.0 | 17,092.1 | 17,834.6 | 18,609.4 | 19,417.9 |
| WACC, % | 6.2 | 6.2 | 6.2 | 6.19 | 6.19 | 6.2 | 6.2 | 6.2 | 6.2 | 6.2 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 74,910.8 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 20,000 | |||||||||
| Terminal Value | 625,540 | |||||||||
| Present Terminal Value | 463,113 | |||||||||
| Enterprise Value | 538,024 | |||||||||
| Net Debt | 23,887 | |||||||||
| Equity Value | 514,137 | |||||||||
| Diluted Shares Outstanding, MM | 2,472 | |||||||||
| Equity Value Per Share | 207.99 |
What You Will Get
- Real Procter & Gamble Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for (PG).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to (PG).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Procter & Gamble’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for (PG).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for (PG).
Key Features
- Pre-Loaded Data: Procter & Gamble’s historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins.
- Instant Results: View Procter & Gamble’s intrinsic value recalculated in real time.
- Clear Visual Outputs: Dashboard charts showcase valuation results and key metrics.
- Built for Accuracy: A professional tool designed for analysts, investors, and finance experts.
How It Works
- Download: Obtain the pre-built Excel file containing Procter & Gamble’s financial data.
- Customize: Modify projections, such as sales growth, EBITDA margin, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and evaluate results immediately.
- Make Decisions: Leverage the valuation findings to inform your investment approach.
Why Choose Procter & Gamble (PG)?
- Innovative Products: A diverse range of trusted brands that meet consumer needs.
- Global Reach: Operates in numerous countries, providing products to millions worldwide.
- Sustainability Commitment: Focused on environmentally friendly practices and reducing waste.
- Strong Financial Performance: Consistent revenue growth and shareholder returns over the years.
- Expertise in Consumer Insights: Deep understanding of market trends to drive product development.
Who Should Use This Product?
- Individual Investors: Gain insights to make informed decisions about buying or selling Procter & Gamble stock (PG).
- Financial Analysts: Enhance valuation processes with accessible financial models tailored for Procter & Gamble (PG).
- Consultants: Provide clients with accurate and timely valuation insights regarding Procter & Gamble (PG).
- Business Owners: Learn how major corporations like Procter & Gamble (PG) are valued to inform your own business strategies.
- Finance Students: Explore valuation methodologies through the lens of Procter & Gamble (PG) using real-world data.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Procter & Gamble historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Procter & Gamble.
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.