Nordson Corporation (NDSN) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Nordson Corporation (NDSN) Bundle
Explore Nordson Corporation's (NDSN) financial prospects with our user-friendly DCF Calculator! Enter your assumptions regarding growth, margins, and costs to determine Nordson Corporation's (NDSN) intrinsic value and shape your investment decisions.
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 | 2,121.1 | 2,362.2 | 2,590.3 | 2,628.6 | 2,689.9 | 2,856.9 | 3,034.3 | 3,222.7 | 3,422.8 | 3,635.3 |
Revenue Growth, % | 0 | 11.37 | 9.65 | 1.48 | 2.33 | 6.21 | 6.21 | 6.21 | 6.21 | 6.21 |
EBITDA | 447.0 | 703.6 | 771.6 | 786.7 | 674.0 | 775.0 | 823.1 | 874.2 | 928.5 | 986.1 |
EBITDA, % | 21.07 | 29.78 | 29.79 | 29.93 | 25.06 | 27.13 | 27.13 | 27.13 | 27.13 | 27.13 |
Depreciation | 113.3 | 103.9 | 99.9 | 111.9 | .0 | 102.0 | 108.3 | 115.1 | 122.2 | 129.8 |
Depreciation, % | 5.34 | 4.4 | 3.86 | 4.26 | 0 | 3.57 | 3.57 | 3.57 | 3.57 | 3.57 |
EBIT | 333.6 | 599.7 | 671.7 | 674.8 | 674.0 | 673.0 | 714.7 | 759.1 | 806.2 | 856.3 |
EBIT, % | 15.73 | 25.39 | 25.93 | 25.67 | 25.06 | 23.56 | 23.56 | 23.56 | 23.56 | 23.56 |
Total Cash | 208.3 | 300.0 | 163.5 | 115.7 | 116.0 | 214.5 | 227.8 | 242.0 | 257.0 | 272.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 471.9 | 489.4 | 537.3 | 590.9 | 594.7 | 618.8 | 657.2 | 698.0 | 741.3 | 787.4 |
Account Receivables, % | 22.25 | 20.72 | 20.74 | 22.48 | 22.11 | 21.66 | 21.66 | 21.66 | 21.66 | 21.66 |
Inventories | 277.0 | 327.2 | 383.4 | 454.8 | 476.9 | 438.5 | 465.7 | 494.6 | 525.4 | 558.0 |
Inventories, % | 13.06 | 13.85 | 14.8 | 17.3 | 17.73 | 15.35 | 15.35 | 15.35 | 15.35 | 15.35 |
Accounts Payable | 70.9 | 91.7 | 99.3 | 106.3 | 25.6 | 91.7 | 97.4 | 103.5 | 109.9 | 116.7 |
Accounts Payable, % | 3.34 | 3.88 | 3.83 | 4.04 | 0.95122 | 3.21 | 3.21 | 3.21 | 3.21 | 3.21 |
Capital Expenditure | -50.5 | -38.3 | -51.4 | -34.6 | -64.4 | -55.4 | -58.9 | -62.5 | -66.4 | -70.5 |
Capital Expenditure, % | -2.38 | -1.62 | -1.99 | -1.32 | -2.39 | -1.94 | -1.94 | -1.94 | -1.94 | -1.94 |
Tax Rate, % | 20.19 | 20.19 | 20.19 | 20.19 | 20.19 | 20.19 | 20.19 | 20.19 | 20.19 | 20.19 |
EBITAT | 276.2 | 474.5 | 530.8 | 534.6 | 537.9 | 538.3 | 571.7 | 607.2 | 644.9 | 685.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -339.0 | 493.2 | 482.8 | 494.0 | 366.9 | 665.4 | 561.3 | 596.1 | 633.1 | 672.4 |
WACC, % | 7.92 | 7.9 | 7.9 | 7.9 | 7.9 | 7.9 | 7.9 | 7.9 | 7.9 | 7.9 |
PV UFCF | ||||||||||
SUM PV UFCF | 2,500.0 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 699 | |||||||||
Terminal Value | 17,918 | |||||||||
Present Terminal Value | 12,249 | |||||||||
Enterprise Value | 14,749 | |||||||||
Net Debt | 2,204 | |||||||||
Equity Value | 12,545 | |||||||||
Diluted Shares Outstanding, MM | 58 | |||||||||
Equity Value Per Share | 217.73 |
What You Will Get
- Editable Forecast Inputs: Effortlessly modify key assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Nordson Corporation’s financial information pre-loaded to streamline your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model that adjusts to meet your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive Nordson Financials: Gain access to precise pre-loaded historical data and future estimates for Nordson Corporation (NDSN).
- Adjustable Forecast Parameters: Modify highlighted cells for variables such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic adjustments to DCF, Net Present Value (NPV), and cash flow evaluations.
- Interactive Dashboard: User-friendly charts and summaries to help visualize your valuation outcomes.
- Designed for All Skill Levels: An intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file for Nordson Corporation (NDSN).
- Step 2: Review Nordson's pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust assumptions.
- Step 5: Analyze the results and leverage them for your investment decisions.
Why Choose This Calculator for Nordson Corporation (NDSN)?
- All-in-One Solution: Combines DCF, WACC, and comprehensive financial ratio analyses tailored for Nordson Corporation.
- Flexible Inputs: Modify the highlighted cells to explore different financial scenarios for (NDSN).
- In-Depth Analysis: Automatically computes Nordson's intrinsic value and Net Present Value.
- Preloaded Information: Historical and projected data provide reliable baselines for analysis.
- Expert-Level Quality: Perfect for financial analysts, investors, and business consultants focusing on (NDSN).
Who Should Use This Product?
- Investors: Accurately estimate Nordson Corporation’s (NDSN) fair value before making investment decisions.
- CFOs: Leverage a professional-grade DCF model for financial reporting and analysis specific to Nordson Corporation.
- Consultants: Quickly adapt the template for valuation reports tailored for Nordson Corporation clients.
- Entrepreneurs: Gain insights into financial modeling practices utilized by industry leaders like Nordson Corporation.
- Educators: Use it as a teaching tool to demonstrate valuation methodologies relevant to Nordson Corporation.
What the Template Contains
- Pre-Filled DCF Model: Nordson Corporation’s (NDSN) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Nordson Corporation’s (NDSN) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.