PPG Industries, Inc. (PPG) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
PPG Industries, Inc. (PPG) Bundle
Gain mastery over your PPG Industries, Inc. (PPG) valuation analysis using our state-of-the-art DCF Calculator! This Excel template comes preloaded with authentic PPG data, enabling you to adjust forecasts and assumptions for a highly accurate calculation of PPG's intrinsic value.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 15,146.0 | 13,834.0 | 16,802.0 | 17,652.0 | 18,246.0 | 19,213.8 | 20,232.9 | 21,306.0 | 22,436.1 | 23,626.1 |
Revenue Growth, % | 0 | -8.66 | 21.45 | 5.06 | 3.37 | 5.3 | 5.3 | 5.3 | 5.3 | 5.3 |
EBITDA | 2,402.0 | 2,075.0 | 2,569.0 | 2,380.0 | 2,601.0 | 2,839.3 | 2,989.9 | 3,148.4 | 3,315.4 | 3,491.3 |
EBITDA, % | 15.86 | 15 | 15.29 | 13.48 | 14.26 | 14.78 | 14.78 | 14.78 | 14.78 | 14.78 |
Depreciation | 588.0 | 547.0 | 605.0 | 567.0 | 604.0 | 690.1 | 726.7 | 765.3 | 805.9 | 848.6 |
Depreciation, % | 3.88 | 3.95 | 3.6 | 3.21 | 3.31 | 3.59 | 3.59 | 3.59 | 3.59 | 3.59 |
EBIT | 1,814.0 | 1,528.0 | 1,964.0 | 1,813.0 | 1,997.0 | 2,149.1 | 2,263.1 | 2,383.2 | 2,509.6 | 2,642.7 |
EBIT, % | 11.98 | 11.05 | 11.69 | 10.27 | 10.94 | 11.19 | 11.19 | 11.19 | 11.19 | 11.19 |
Total Cash | 1,273.0 | 1,922.0 | 1,072.0 | 1,154.0 | 1,589.0 | 1,687.9 | 1,777.4 | 1,871.7 | 1,971.0 | 2,075.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 2,756.0 | 2,726.0 | 3,152.0 | 3,303.0 | 3,279.0 | 3,587.0 | 3,777.2 | 3,977.6 | 4,188.5 | 4,410.7 |
Account Receivables, % | 18.2 | 19.71 | 18.76 | 18.71 | 17.97 | 18.67 | 18.67 | 18.67 | 18.67 | 18.67 |
Inventories | 1,710.0 | 1,735.0 | 2,171.0 | 2,272.0 | 2,127.0 | 2,354.9 | 2,479.8 | 2,611.3 | 2,749.8 | 2,895.7 |
Inventories, % | 11.29 | 12.54 | 12.92 | 12.87 | 11.66 | 12.26 | 12.26 | 12.26 | 12.26 | 12.26 |
Accounts Payable | 2,910.0 | 2,259.0 | 3,735.0 | 2,538.0 | 2,612.0 | 3,322.6 | 3,498.9 | 3,684.5 | 3,879.9 | 4,085.7 |
Accounts Payable, % | 19.21 | 16.33 | 22.23 | 14.38 | 14.32 | 17.29 | 17.29 | 17.29 | 17.29 | 17.29 |
Capital Expenditure | -413.0 | -304.0 | -371.0 | -518.0 | -549.0 | -502.5 | -529.1 | -557.2 | -586.7 | -617.9 |
Capital Expenditure, % | -2.73 | -2.2 | -2.21 | -2.93 | -3.01 | -2.62 | -2.62 | -2.62 | -2.62 | -2.62 |
Tax Rate, % | 27.35 | 27.35 | 27.35 | 27.35 | 27.35 | 27.35 | 27.35 | 27.35 | 27.35 | 27.35 |
EBITAT | 1,357.5 | 1,188.1 | 1,557.1 | 1,347.0 | 1,450.9 | 1,628.3 | 1,714.6 | 1,805.6 | 1,901.3 | 2,002.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -23.5 | 785.1 | 2,405.1 | -53.0 | 1,748.9 | 1,990.7 | 1,773.3 | 1,867.4 | 1,966.4 | 2,070.7 |
WACC, % | 9 | 9.03 | 9.04 | 9 | 8.99 | 9.01 | 9.01 | 9.01 | 9.01 | 9.01 |
PV UFCF | ||||||||||
SUM PV UFCF | 7,497.5 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 2,133 | |||||||||
Terminal Value | 35,478 | |||||||||
Present Terminal Value | 23,045 | |||||||||
Enterprise Value | 30,543 | |||||||||
Net Debt | 5,356 | |||||||||
Equity Value | 25,187 | |||||||||
Diluted Shares Outstanding, MM | 237 | |||||||||
Equity Value Per Share | 106.18 |
What You Will Get
- Real PPG Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for PPG Industries, Inc. (PPG).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates according to PPG's specifics.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on PPG’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections relevant to PPG Industries, Inc. (PPG).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for PPG.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for PPG Industries, Inc. (PPG).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to PPG.
- Customizable Forecast Assumptions: Easily adjust growth rates, capital expenditures, and discount rates for accurate projections.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to PPG Industries, Inc. (PPG).
- Interactive Dashboard and Charts: Visual representations that summarize essential valuation metrics for streamlined analysis.
How It Works
- Step 1: Download the prebuilt Excel template with PPG Industries, Inc.'s (PPG) data included.
- Step 2: Explore the pre-filled sheets and understand the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including PPG Industries, Inc.'s (PPG) intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose This Calculator for PPG Industries, Inc. (PPG)?
- Comprehensive Tool: Features DCF, WACC, and financial ratio analyses all in one platform.
- Customizable Inputs: Modify the highlighted cells to explore different financial scenarios.
- Detailed Insights: Automatically computes PPG's intrinsic value and Net Present Value.
- Preloaded Data: Access to historical and projected data for reliable starting points.
- Professional Quality: Perfect for financial analysts, investors, and business consultants.
Who Should Use This Product?
- Investors: Accurately assess PPG's fair value before making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial analysis and reporting.
- Consultants: Easily customize the template for client valuation reports.
- Entrepreneurs: Acquire insights into financial modeling practices of leading companies.
- Educators: Employ it as a teaching resource to illustrate valuation techniques.
What the Template Contains
- Preloaded PPG Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.