๐ Advanced DCF Valuation
Professional-grade discounted cash flow analysis with scenario modeling for PG
Consumer Defensive โข Household & Personal Products โข Market Cap: $401,022,839,401.86
Scenario Analysis
Compare different scenarios to understand valuation sensitivity
๐ป-61.0% upside
Conservative Case
$67.43
๐-47.7% upside
Base Case
$90.57
๐บ-33.7% upside
Optimistic Case
$114.76
๐ฐMarket Price
Current Price
$173.02
DCF Model & Results
Detailed cash flow projections and valuation analysis
๐ต Enhanced Cash Flow Projections
| Year | Revenue | Growth % | Operating Margin % | NOPAT | CapEx | FCF | PV of FCF |
|---|---|---|---|---|---|---|---|
| 1 | $91,383,600,000.00 | 5.0% | 22.7% | $16,380,966,000.00 | $4,745,186,250.00 | $14,355,529,750.00 | $13,103,520,388.42 |
| 2 | $95,038,944,000.00 | 4.0% | 22.7% | $17,036,204,640.00 | $4,665,374,532.00 | $15,203,721,708.00 | $12,667,398,761.69 |
| 3 | $98,365,307,040.00 | 3.5% | 22.7% | $17,632,471,802.40 | $4,575,986,299.01 | $15,990,812,899.39 | $12,161,211,389.79 |
| 4 | $101,316,266,251.20 | 3.0% | 22.7% | $18,161,445,956.47 | $4,466,601,113.01 | $16,719,578,034.95 | $11,606,475,890.21 |
| 5 | $103,849,172,907.48 | 2.5% | 22.7% | $18,615,482,105.38 | $4,338,640,142.08 | $17,379,652,617.25 | $11,012,474,550.73 |
| Terminal | โ | 3.0% | โ | โ | โ | $276,200,989,152.59 | $175,012,494,836.20 |
Enterprise Value$235,563,575,817.04
Net Debt$24,196,000,000.00
Equity Value$211,367,575,817.04
Price per Share$90.57
EV/Revenue (Final Year)2.3x
Terminal Value %74.3%
WACC9.6%
๐ฅ Company Financial Health
Historical Revenue Growth2.1%
Current Operating Margin22.7%
FCF Conversion Rate17.4%
Net Debt/Equity0.00
ROE0.0%
ROIC0.0%
Beta1.20
Interest Coverage0.00
Enhanced DCF data sourced from Financial Modeling Prep (FMP) โข Model incorporates industry best practices and academic research โข Calculations are estimates and should not be used as sole investment advice โข Consult with a financial advisor before making investment decisions