Kennametal Inc. (KMT) 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
Kennametal Inc. (KMT) Bundle
Looking to assess the intrinsic value of Kennametal Inc.? Our KMT DCF Calculator integrates real-world data with extensive customization features, enabling you to refine your forecasts and enhance your investment choices.
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 | 1,885.3 | 1,841.4 | 2,012.5 | 2,078.2 | 2,046.9 | 2,091.5 | 2,137.1 | 2,183.7 | 2,231.3 | 2,280.0 |
Revenue Growth, % | 0 | -2.33 | 9.29 | 3.27 | -1.51 | 2.18 | 2.18 | 2.18 | 2.18 | 2.18 |
EBITDA | 277.7 | 282.7 | 371.1 | 333.1 | 306.6 | 332.7 | 339.9 | 347.4 | 354.9 | 362.7 |
EBITDA, % | 14.73 | 15.35 | 18.44 | 16.03 | 14.98 | 15.91 | 15.91 | 15.91 | 15.91 | 15.91 |
Depreciation | 119.9 | 126.5 | 131.7 | 134.0 | 134.7 | 137.2 | 140.2 | 143.2 | 146.4 | 149.6 |
Depreciation, % | 6.36 | 6.87 | 6.54 | 6.45 | 6.58 | 6.56 | 6.56 | 6.56 | 6.56 | 6.56 |
EBIT | 157.8 | 156.2 | 239.4 | 199.1 | 171.9 | 195.5 | 199.8 | 204.1 | 208.6 | 213.1 |
EBIT, % | 8.37 | 8.48 | 11.9 | 9.58 | 8.4 | 9.35 | 9.35 | 9.35 | 9.35 | 9.35 |
Total Cash | 606.7 | 154.0 | 85.6 | 106.0 | 128.0 | 234.9 | 240.0 | 245.2 | 250.6 | 256.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 238.0 | 302.9 | 295.3 | 307.3 | 302.8 | 306.8 | 313.4 | 320.3 | 327.3 | 334.4 |
Account Receivables, % | 12.62 | 16.45 | 14.68 | 14.79 | 14.79 | 14.67 | 14.67 | 14.67 | 14.67 | 14.67 |
Inventories | 522.4 | 476.3 | 570.8 | 557.6 | 514.6 | 560.2 | 572.4 | 584.9 | 597.6 | 610.7 |
Inventories, % | 27.71 | 25.87 | 28.37 | 26.83 | 25.14 | 26.78 | 26.78 | 26.78 | 26.78 | 26.78 |
Accounts Payable | 164.6 | 177.7 | 227.9 | 203.3 | 191.5 | 204.3 | 208.8 | 213.3 | 218.0 | 222.7 |
Accounts Payable, % | 8.73 | 9.65 | 11.32 | 9.78 | 9.36 | 9.77 | 9.77 | 9.77 | 9.77 | 9.77 |
Capital Expenditure | -244.2 | -127.3 | -96.9 | -94.4 | -107.6 | -144.2 | -147.4 | -150.6 | -153.9 | -157.2 |
Capital Expenditure, % | -12.95 | -6.91 | -4.82 | -4.54 | -5.25 | -6.9 | -6.9 | -6.9 | -6.9 | -6.9 |
Tax Rate, % | 24.32 | 24.32 | 24.32 | 24.32 | 24.32 | 24.32 | 24.32 | 24.32 | 24.32 | 24.32 |
EBITAT | -406.4 | 131.5 | 167.5 | 147.8 | 130.1 | 118.9 | 121.5 | 124.1 | 126.8 | 129.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -1,126.5 | 124.9 | 165.6 | 164.1 | 193.0 | 75.1 | 99.9 | 102.0 | 104.3 | 106.5 |
WACC, % | 9.14 | 10.08 | 9.92 | 9.97 | 9.99 | 9.82 | 9.82 | 9.82 | 9.82 | 9.82 |
PV UFCF | ||||||||||
SUM PV UFCF | 366.6 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 110 | |||||||||
Terminal Value | 1,608 | |||||||||
Present Terminal Value | 1,007 | |||||||||
Enterprise Value | 1,373 | |||||||||
Net Debt | 518 | |||||||||
Equity Value | 855 | |||||||||
Diluted Shares Outstanding, MM | 80 | |||||||||
Equity Value Per Share | 10.70 |
What You Will Receive
- Comprehensive Financial Model: Kennametal Inc.'s (KMT) actual data facilitates accurate DCF valuation.
- Complete Forecast Customization: Modify revenue growth, profit margins, WACC, and other essential drivers.
- Real-Time Calculations: Automatic updates provide instant feedback as you adjust inputs.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Flexible and Reusable: Designed for adaptability, allowing repeated use for in-depth forecasts.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Kennametal Inc. (KMT).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs for precise calculations.
- Customizable Forecast Assumptions: Easily alter growth rates, capital expenditures, and discount rates to fit your analysis needs.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Kennametal Inc. (KMT).
- Interactive Dashboard and Charts: Visual representations that summarize essential valuation metrics for straightforward analysis.
How It Works
- 1. Access the Template: Download and open the Excel file containing Kennametal Inc.'s (KMT) preloaded data.
- 2. Modify Assumptions: Adjust key variables such as growth rates, WACC, and capital expenditures.
- 3. View Results Immediately: The DCF model automatically calculates intrinsic value and NPV.
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation possibilities.
- 5. Present with Assurance: Deliver professional valuation insights to back your strategic decisions.
Why Choose This Calculator for Kennametal Inc. (KMT)?
- User-Friendly Interface: Crafted for both novice and seasoned users.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Feedback: Monitor immediate changes in Kennametal's valuation as you tweak inputs.
- Pre-Configured Data: Comes with Kennametal’s actual financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making strategic decisions.
Who Should Use This Product?
- Investors: Accurately assess Kennametal Inc.’s (KMT) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis.
- Consultants: Efficiently modify the template for valuation reports tailored for clients.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading firms.
- Educators: Implement it as a teaching resource to illustrate valuation techniques.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Kennametal Inc. (KMT) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Kennametal Inc. (KMT).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.