|
Park Aerospace Corp. (PKE) DCF Valoración
US | Industrials | Aerospace & Defense | NYSE
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Park Aerospace Corp. (PKE) Bundle
¡Descubra el verdadero valor de Park Aerospace Corp. (PKE) con nuestra calculadora DCF avanzada! Ajuste los supuestos esenciales, explore varios escenarios y examine cómo los diferentes factores influyen en la valoración de Park Aerospace Corp. (PKE), todo dentro de una sola plantilla de Excel.
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 | 60.0 | 46.3 | 53.6 | 54.1 | 56.0 | 55.6 | 55.3 | 54.9 | 54.6 | 54.2 |
Revenue Growth, % | 0 | -22.89 | 15.78 | 0.89029 | 3.61 | -0.65405 | -0.65405 | -0.65405 | -0.65405 | -0.65405 |
EBITDA | 12.3 | 8.6 | 12.8 | 11.1 | 9.9 | 11.3 | 11.2 | 11.1 | 11.0 | 11.0 |
EBITDA, % | 20.47 | 18.69 | 23.9 | 20.52 | 17.66 | 20.25 | 20.25 | 20.25 | 20.25 | 20.25 |
Depreciation | 1.5 | 1.2 | 1.1 | 1.1 | 1.4 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
Depreciation, % | 2.57 | 2.49 | 2.12 | 2.1 | 2.5 | 2.36 | 2.36 | 2.36 | 2.36 | 2.36 |
EBIT | 10.7 | 7.5 | 11.7 | 10.0 | 8.5 | 10.0 | 9.9 | 9.8 | 9.8 | 9.7 |
EBIT, % | 17.9 | 16.2 | 21.78 | 18.41 | 15.16 | 17.89 | 17.89 | 17.89 | 17.89 | 17.89 |
Total Cash | 122.4 | 116.5 | 110.4 | 105.4 | 77.2 | 55.6 | 55.3 | 54.9 | 54.6 | 54.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 10.9 | 7.6 | 8.3 | 10.0 | 12.4 | 10.1 | 10.0 | 10.0 | 9.9 | 9.8 |
Account Receivables, % | 18.2 | 16.49 | 15.56 | 18.48 | 22.11 | 18.17 | 18.17 | 18.17 | 18.17 | 18.17 |
Inventories | 6.4 | 4.8 | 4.7 | 6.8 | 6.4 | 6.0 | 5.9 | 5.9 | 5.9 | 5.8 |
Inventories, % | 10.63 | 10.36 | 8.69 | 12.52 | 11.43 | 10.73 | 10.73 | 10.73 | 10.73 | 10.73 |
Accounts Payable | 4.7 | 3.3 | 2.5 | 4.5 | 3.5 | 3.8 | 3.8 | 3.8 | 3.8 | 3.7 |
Accounts Payable, % | 7.89 | 7.13 | 4.73 | 8.41 | 6.27 | 6.89 | 6.89 | 6.89 | 6.89 | 6.89 |
Capital Expenditure | -6.8 | -7.5 | -4.4 | -1.0 | -.6 | -4.3 | -4.3 | -4.3 | -4.2 | -4.2 |
Capital Expenditure, % | -11.41 | -16.19 | -8.16 | -1.94 | -1.15 | -7.77 | -7.77 | -7.77 | -7.77 | -7.77 |
Tax Rate, % | 20.78 | 20.78 | 20.78 | 20.78 | 20.78 | 20.78 | 20.78 | 20.78 | 20.78 | 20.78 |
EBITAT | 7.3 | 5.0 | 8.4 | 9.7 | 6.7 | 7.6 | 7.6 | 7.5 | 7.5 | 7.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -10.6 | 2.1 | 3.8 | 8.0 | 4.4 | 7.6 | 4.7 | 4.6 | 4.6 | 4.6 |
WACC, % | 6.34 | 6.34 | 6.34 | 6.34 | 6.34 | 6.34 | 6.34 | 6.34 | 6.34 | 6.34 |
PV UFCF | ||||||||||
SUM PV UFCF | 22.1 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 5 | |||||||||
Terminal Value | 79 | |||||||||
Present Terminal Value | 58 | |||||||||
Enterprise Value | 80 | |||||||||
Net Debt | -6 | |||||||||
Equity Value | 86 | |||||||||
Diluted Shares Outstanding, MM | 20 | |||||||||
Equity Value Per Share | 4.24 |
What You Will Get
- Real PKE 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 Park Aerospace's future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- 🔍 Real-Life PKE Financials: Pre-filled historical and projected data for Park Aerospace Corp.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Park Aerospace’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Park Aerospace’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download: Obtain the pre-formatted Excel file containing Park Aerospace Corp.'s (PKE) financial data.
- Customize: Modify projections such as revenue growth, EBITDA %, and WACC to fit your analysis.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time as you make changes.
- Test Scenarios: Develop various forecasts and instantly compare the results.
- Make Decisions: Leverage the valuation outcomes to inform your investment choices.
Why Choose This Calculator for Park Aerospace Corp. (PKE)?
- Accuracy: Utilizes real Park Aerospace financials to ensure precise data.
- Flexibility: Built for users to easily test and adjust inputs as needed.
- Time-Saving: Avoid the complexities of constructing a DCF model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for those without extensive financial modeling skills.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Park Aerospace Corp. (PKE) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Park Aerospace Corp. (PKE).
- Consultants: Deliver professional valuation insights on Park Aerospace Corp. (PKE) to clients quickly and accurately.
- Business Owners: Understand how companies like Park Aerospace Corp. (PKE) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Park Aerospace Corp. (PKE).
What the Template Contains
- Historical Data: Includes Park Aerospace Corp. (PKE)’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Park Aerospace Corp. (PKE)’s 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 Park Aerospace Corp. (PKE)’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.