National Presto Industries, Inc. (NPK) 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
National Presto Industries, Inc. (NPK) Bundle
Designed for accuracy, our (NPK) DCF Calculator enables you to evaluate the valuation of National Presto Industries, Inc. using real-world financial data, offering complete flexibility to modify all key parameters for more accurate 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 | 308.5 | 352.6 | 355.8 | 321.6 | 340.9 | 350.8 | 361.0 | 371.4 | 382.2 | 393.3 |
Revenue Growth, % | 0 | 14.3 | 0.8933 | -9.6 | 6 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 |
EBITDA | 50.1 | 59.2 | 33.0 | 30.3 | 41.0 | 44.7 | 46.0 | 47.4 | 48.7 | 50.1 |
EBITDA, % | 16.23 | 16.79 | 9.28 | 9.41 | 12.04 | 12.75 | 12.75 | 12.75 | 12.75 | 12.75 |
Depreciation | 3.7 | 3.0 | 3.0 | 3.3 | 6.0 | 4.0 | 4.1 | 4.2 | 4.3 | 4.5 |
Depreciation, % | 1.2 | 0.85218 | 0.83704 | 1.04 | 1.76 | 1.14 | 1.14 | 1.14 | 1.14 | 1.14 |
EBIT | 46.4 | 56.2 | 30.0 | 26.9 | 35.0 | 40.7 | 41.9 | 43.1 | 44.4 | 45.7 |
EBIT, % | 15.03 | 15.94 | 8.44 | 8.37 | 10.28 | 11.61 | 11.61 | 11.61 | 11.61 | 11.61 |
Total Cash | 158.3 | 155.0 | 144.0 | 95.6 | 114.1 | 139.6 | 143.6 | 147.8 | 152.1 | 156.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 44.3 | 56.5 | 55.7 | 73.3 | 50.4 | 58.7 | 60.4 | 62.1 | 63.9 | 65.8 |
Account Receivables, % | 14.36 | 16.03 | 15.66 | 22.78 | 14.77 | 16.72 | 16.72 | 16.72 | 16.72 | 16.72 |
Inventories | 128.5 | 135.5 | 143.9 | 152.1 | 190.4 | 156.9 | 161.5 | 166.2 | 171.0 | 175.9 |
Inventories, % | 41.66 | 38.42 | 40.44 | 47.3 | 55.86 | 44.74 | 44.74 | 44.74 | 44.74 | 44.74 |
Accounts Payable | 21.7 | 25.7 | 32.8 | 28.9 | 38.2 | 30.7 | 31.6 | 32.5 | 33.4 | 34.4 |
Accounts Payable, % | 7.02 | 7.3 | 9.21 | 9 | 11.21 | 8.75 | 8.75 | 8.75 | 8.75 | 8.75 |
Capital Expenditure | -3.1 | -2.6 | -2.9 | -1.0 | -1.8 | -2.4 | -2.5 | -2.5 | -2.6 | -2.7 |
Capital Expenditure, % | -1.02 | -0.74328 | -0.80556 | -0.32025 | -0.53973 | -0.68519 | -0.68519 | -0.68519 | -0.68519 | -0.68519 |
Tax Rate, % | 18.55 | 18.55 | 18.55 | 18.55 | 18.55 | 18.55 | 18.55 | 18.55 | 18.55 | 18.55 |
EBITAT | 37.4 | 44.0 | 23.7 | 21.5 | 28.5 | 32.5 | 33.5 | 34.4 | 35.4 | 36.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -113.2 | 29.3 | 23.3 | -5.8 | 26.6 | 51.8 | 29.7 | 30.6 | 31.5 | 32.4 |
WACC, % | 7.33 | 7.33 | 7.33 | 7.33 | 7.33 | 7.33 | 7.33 | 7.33 | 7.33 | 7.33 |
PV UFCF | ||||||||||
SUM PV UFCF | 145.3 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 33 | |||||||||
Terminal Value | 477 | |||||||||
Present Terminal Value | 335 | |||||||||
Enterprise Value | 480 | |||||||||
Net Debt | -77 | |||||||||
Equity Value | 557 | |||||||||
Diluted Shares Outstanding, MM | 7 | |||||||||
Equity Value Per Share | 78.37 |
What You Will Get
- Real NPK 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 automatically.
- Scenario Analysis: Explore various scenarios to assess National Presto's future performance.
- User-Friendly Design: Crafted for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive NPK Data: Pre-filled with National Presto Industries' historical financials and future projections.
- Fully Customizable Inputs: Modify revenue growth, profit margins, WACC, tax rates, and capital expenditures as needed.
- Dynamic Valuation Model: Instant updates to Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Testing: Develop various forecast scenarios to evaluate different valuation results.
- User-Friendly Design: Intuitive, organized, and crafted for both professionals and novices.
How It Works
- 1. Access the Template: Download and open the Excel file featuring National Presto Industries, Inc. (NPK) preloaded data.
- 2. Modify Assumptions: Adjust critical inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results in Real-Time: The DCF model automatically computes intrinsic value and NPV.
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation outcomes.
- 5. Present with Assurance: Deliver professional valuation insights to bolster your decision-making.
Why Choose This Calculator for National Presto Industries, Inc. (NPK)?
- Accurate Data: Real National Presto financials ensure reliable valuation results.
- Customizable: Adjust key parameters like growth rates, WACC, and tax rates to align with your projections.
- Time-Saving: Pre-built calculations eliminate the hassle of starting from scratch.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the industry.
- User-Friendly: Intuitive design and step-by-step instructions make it accessible for all users.
Who Should Use National Presto Industries, Inc. (NPK)?
- Investors: Gain insights into a reliable company with a strong market presence.
- Financial Analysts: Utilize comprehensive data to enhance your analysis of consumer products.
- Consultants: Easily tailor information for presentations or strategic reports on the industry.
- Finance Enthusiasts: Explore the dynamics of the consumer goods sector through detailed case studies.
- Educators and Students: Leverage real-world examples to enrich finance and business curriculum.
What the Template Contains
- Historical Data: Includes National Presto Industries, Inc.'s (NPK) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate National Presto Industries, Inc.'s (NPK) 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 National Presto Industries, Inc.'s (NPK) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.