Ampco-Pittsburgh Corporation (AP) 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
Ampco-Pittsburgh Corporation (AP) Bundle
Enhance your investment strategy with the Ampco-Pittsburgh Corporation (AP) DCF Calculator! Utilize real financial data, adjust growth predictions and expenses, and instantly observe how these modifications affect the intrinsic value of Ampco-Pittsburgh Corporation (AP).
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 | 397.9 | 328.5 | 344.9 | 390.2 | 422.3 | 451.1 | 481.7 | 514.5 | 549.5 | 586.9 |
Revenue Growth, % | 0 | -17.43 | 4.98 | 13.12 | 8.24 | 6.8 | 6.8 | 6.8 | 6.8 | 6.8 |
EBITDA | 16.0 | 31.4 | 20.5 | 28.4 | -12.2 | 21.6 | 23.0 | 24.6 | 26.3 | 28.1 |
EBITDA, % | 4.01 | 9.56 | 5.95 | 7.28 | -2.9 | 4.78 | 4.78 | 4.78 | 4.78 | 4.78 |
Depreciation | 19.0 | 18.6 | 17.9 | 17.4 | 17.7 | 21.9 | 23.4 | 25.0 | 26.7 | 28.5 |
Depreciation, % | 4.77 | 5.66 | 5.19 | 4.47 | 4.18 | 4.86 | 4.86 | 4.86 | 4.86 | 4.86 |
EBIT | -3.0 | 12.8 | 2.6 | 11.0 | -29.9 | -.3 | -.4 | -.4 | -.4 | -.4 |
EBIT, % | -0.76023 | 3.9 | 0.75496 | 2.82 | -7.08 | -0.07375366 | -0.07375366 | -0.07375366 | -0.07375366 | -0.07375366 |
Total Cash | 7.0 | 16.8 | 10.3 | 8.7 | 7.3 | 12.5 | 13.3 | 14.2 | 15.2 | 16.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 97.8 | 76.4 | 84.8 | 93.5 | 99.3 | 108.2 | 115.5 | 123.4 | 131.8 | 140.7 |
Account Receivables, % | 24.57 | 23.24 | 24.59 | 23.96 | 23.51 | 23.98 | 23.98 | 23.98 | 23.98 | 23.98 |
Inventories | 82.3 | 73.2 | 88.2 | 121.7 | 124.7 | 116.6 | 124.5 | 133.0 | 142.1 | 151.7 |
Inventories, % | 20.68 | 22.29 | 25.57 | 31.2 | 29.52 | 25.85 | 25.85 | 25.85 | 25.85 | 25.85 |
Accounts Payable | 33.3 | 26.7 | 44.2 | 43.6 | 37.2 | 44.5 | 47.5 | 50.7 | 54.2 | 57.9 |
Accounts Payable, % | 8.36 | 8.12 | 12.82 | 11.18 | 8.82 | 9.86 | 9.86 | 9.86 | 9.86 | 9.86 |
Capital Expenditure | -11.0 | -8.5 | -15.2 | -16.7 | -20.4 | -17.0 | -18.2 | -19.4 | -20.7 | -22.1 |
Capital Expenditure, % | -2.76 | -2.58 | -4.42 | -4.28 | -4.84 | -3.77 | -3.77 | -3.77 | -3.77 | -3.77 |
Tax Rate, % | -1.66 | -1.66 | -1.66 | -1.66 | -1.66 | -1.66 | -1.66 | -1.66 | -1.66 | -1.66 |
EBITAT | -3.8 | 11.7 | 3.2 | 6.8 | -30.4 | -.3 | -.3 | -.3 | -.4 | -.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -142.6 | 45.7 | .0 | -35.3 | -48.3 | 11.1 | -7.4 | -7.9 | -8.4 | -9.0 |
WACC, % | 7.37 | 6.91 | 7.37 | 5.29 | 7.37 | 6.86 | 6.86 | 6.86 | 6.86 | 6.86 |
PV UFCF | ||||||||||
SUM PV UFCF | -15.5 | |||||||||
Long Term Growth Rate, % | 3.50 | |||||||||
Free cash flow (T + 1) | -9 | |||||||||
Terminal Value | -277 | |||||||||
Present Terminal Value | -198 | |||||||||
Enterprise Value | -214 | |||||||||
Net Debt | 126 | |||||||||
Equity Value | -340 | |||||||||
Diluted Shares Outstanding, MM | 20 | |||||||||
Equity Value Per Share | -17.33 |
What You Will Get
- Real AP Financial Data: Pre-filled with Ampco-Pittsburgh’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Ampco-Pittsburgh’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive Historical Data: Ampco-Pittsburgh Corporation’s (AP) past financial statements and projected forecasts.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins to suit your analysis.
- Real-Time Calculations: Observe the intrinsic value of Ampco-Pittsburgh Corporation (AP) update instantly.
- Intuitive Visualizations: Dashboard graphics illustrate valuation outcomes and essential metrics.
- Designed for Precision: A robust tool tailored for analysts, investors, and finance professionals.
How It Works
- 1. Download the Template: Get the Excel file containing Ampco-Pittsburgh Corporation’s (AP) preloaded data.
- 2. Adjust Key Inputs: Modify essential parameters such as growth rates, WACC, and capital expenditures.
- 3. Instant Results: The DCF model automatically computes intrinsic value and NPV based on your inputs.
- 4. Explore Different Scenarios: Analyze various forecasts to evaluate different valuation scenarios.
- 5. Present with Confidence: Share professional valuation insights to bolster your decision-making process.
Why Choose This Calculator for Ampco-Pittsburgh Corporation (AP)?
- Accurate Data: Utilize real financials from Ampco-Pittsburgh Corporation for dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants focused on Ampco-Pittsburgh Corporation.
- User-Friendly: An intuitive design and clear, step-by-step guidance make it accessible for all users.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for portfolio assessment of Ampco-Pittsburgh Corporation (AP).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the company.
- Consultants and Advisors: Deliver precise valuation insights to clients regarding Ampco-Pittsburgh Corporation (AP) stock.
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Industry Analysts: Gain insights into how companies like Ampco-Pittsburgh Corporation (AP) are valued in the industrial sector.
What the Template Contains
- Historical Data: Includes Ampco-Pittsburgh Corporation’s (AP) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Ampco-Pittsburgh Corporation’s (AP) 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 Ampco-Pittsburgh Corporation’s (AP) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.