|
Packaging Corporation of America (PKG) DCF Valuation
US | Consumer Cyclical | Packaging & Containers | NYSE
|
- ✓ 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
Packaging Corporation of America (PKG) Bundle
Evaluate the financial outlook of Packaging Corporation of America (PKG) like an expert! This (PKG) DCF Calculator provides you with pre-filled financial data and full flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your projections.
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 | 6,964.3 | 6,658.2 | 7,730.3 | 8,478.0 | 7,802.4 | 8,064.0 | 8,334.3 | 8,613.7 | 8,902.5 | 9,201.0 |
| Revenue Growth, % | 0 | -4.4 | 16.1 | 9.67 | -7.97 | 3.35 | 3.35 | 3.35 | 3.35 | 3.35 |
| EBITDA | 1,434.8 | 1,135.8 | 1,678.4 | 1,892.0 | 1,585.1 | 1,645.1 | 1,700.3 | 1,757.3 | 1,816.2 | 1,877.1 |
| EBITDA, % | 20.6 | 17.06 | 21.71 | 22.32 | 20.32 | 20.4 | 20.4 | 20.4 | 20.4 | 20.4 |
| Depreciation | 389.0 | 409.6 | 417.3 | 456.8 | 517.7 | 470.3 | 486.0 | 502.3 | 519.2 | 536.6 |
| Depreciation, % | 5.59 | 6.15 | 5.4 | 5.39 | 6.64 | 5.83 | 5.83 | 5.83 | 5.83 | 5.83 |
| EBIT | 1,045.8 | 726.2 | 1,261.1 | 1,435.2 | 1,067.4 | 1,174.9 | 1,214.2 | 1,255.0 | 1,297.0 | 1,340.5 |
| EBIT, % | 15.02 | 10.91 | 16.31 | 16.93 | 13.68 | 14.57 | 14.57 | 14.57 | 14.57 | 14.57 |
| Total Cash | 767.4 | 1,080.2 | 704.8 | 405.2 | 1,141.5 | 899.4 | 929.6 | 960.8 | 993.0 | 1,026.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 872.1 | 837.5 | 1,078.4 | 1,067.5 | 1,037.5 | 1,047.3 | 1,082.5 | 1,118.7 | 1,156.3 | 1,195.0 |
| Account Receivables, % | 12.52 | 12.58 | 13.95 | 12.59 | 13.3 | 12.99 | 12.99 | 12.99 | 12.99 | 12.99 |
| Inventories | 794.1 | 787.9 | 902.5 | 977.3 | 1,013.1 | 958.4 | 990.5 | 1,023.7 | 1,058.0 | 1,093.5 |
| Inventories, % | 11.4 | 11.83 | 11.67 | 11.53 | 12.98 | 11.88 | 11.88 | 11.88 | 11.88 | 11.88 |
| Accounts Payable | 351.9 | 387.0 | 452.4 | 410.4 | 402.4 | 430.9 | 445.3 | 460.2 | 475.7 | 491.6 |
| Accounts Payable, % | 5.05 | 5.81 | 5.85 | 4.84 | 5.16 | 5.34 | 5.34 | 5.34 | 5.34 | 5.34 |
| Capital Expenditure | -399.5 | -421.2 | -605.1 | -824.2 | -469.7 | -574.7 | -593.9 | -613.8 | -634.4 | -655.7 |
| Capital Expenditure, % | -5.74 | -6.33 | -7.83 | -9.72 | -6.02 | -7.13 | -7.13 | -7.13 | -7.13 | -7.13 |
| Tax Rate, % | 24.54 | 24.54 | 24.54 | 24.54 | 24.54 | 24.54 | 24.54 | 24.54 | 24.54 | 24.54 |
| EBITAT | 794.2 | 529.1 | 956.7 | 1,082.9 | 805.4 | 882.5 | 912.1 | 942.7 | 974.3 | 1,006.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -530.6 | 593.4 | 478.8 | 609.6 | 839.6 | 851.5 | 751.4 | 776.6 | 802.6 | 829.5 |
| WACC, % | 7.48 | 7.46 | 7.48 | 7.47 | 7.47 | 7.47 | 7.47 | 7.47 | 7.47 | 7.47 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 3,248.6 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 846 | |||||||||
| Terminal Value | 15,461 | |||||||||
| Present Terminal Value | 10,783 | |||||||||
| Enterprise Value | 14,032 | |||||||||
| Net Debt | 2,525 | |||||||||
| Equity Value | 11,507 | |||||||||
| Diluted Shares Outstanding, MM | 90 | |||||||||
| Equity Value Per Share | 128.57 |
What You Will Get
- Real PKG Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess Packaging Corporation of America's future performance.
- User-Friendly Design: Designed for industry professionals while remaining approachable for newcomers.
Key Features
- 🔍 Real-Life PKG Financials: Pre-filled historical and projected data for Packaging Corporation of America (PKG).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Packaging Corporation of America’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Packaging Corporation of America’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file for Packaging Corporation of America (PKG).
- Step 2: Review the pre-filled financial data and forecasts for Packaging Corporation of America (PKG).
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells) for Packaging Corporation of America (PKG).
- Step 4: Observe the DCF model update in real-time as you modify your assumptions for Packaging Corporation of America (PKG).
- Step 5: Evaluate the outputs and leverage the results for your investment strategies regarding Packaging Corporation of America (PKG).
Why Choose This Calculator for Packaging Corporation of America (PKG)?
- Accuracy: Utilizes real financial data from Packaging Corporation of America for precise calculations.
- Flexibility: Allows users to easily modify inputs and test various scenarios.
- Time-Saving: Avoid the complexities of creating a financial model from the ground up.
- Professional-Grade: Crafted with the attention to detail expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users with varying levels of financial expertise.
Who Should Use This Product?
- Investors: Accurately assess the fair value of Packaging Corporation of America (PKG) before making investment choices.
- CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis.
- Consultants: Efficiently customize the template for valuation reports tailored to clients.
- Entrepreneurs: Acquire insights into financial modeling practices employed by industry leaders.
- Educators: Implement it as a teaching resource to illustrate various valuation methodologies.
What the Template Contains
- Historical Data: Includes Packaging Corporation of America’s (PKG) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Packaging Corporation of America’s (PKG) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Packaging Corporation of America’s (PKG) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.