NewMarket Corporation (NEU) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
NewMarket Corporation (NEU) Bundle
As an investor or analyst, the NewMarket Corporation (NEU) DCF Calculator is your go-to resource for accurate valuation. Equipped with real data from NewMarket Corporation, you can adjust forecasts and observe the immediate effects.
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 | 2,190.3 | 2,010.9 | 2,356.1 | 2,764.8 | 2,698.4 | 2,859.8 | 3,030.8 | 3,212.1 | 3,404.2 | 3,607.7 |
| Revenue Growth, % | 0 | -8.19 | 17.17 | 17.35 | -2.4 | 5.98 | 5.98 | 5.98 | 5.98 | 5.98 |
| EBITDA | 448.4 | 441.6 | 401.1 | 465.2 | 604.3 | 564.4 | 598.2 | 633.9 | 671.8 | 712.0 |
| EBITDA, % | 20.47 | 21.96 | 17.02 | 16.83 | 22.4 | 19.74 | 19.74 | 19.74 | 19.74 | 19.74 |
| Depreciation | 116.6 | 113.0 | 119.3 | 82.3 | 78.0 | 125.1 | 132.6 | 140.5 | 148.9 | 157.8 |
| Depreciation, % | 5.32 | 5.62 | 5.06 | 2.98 | 2.89 | 4.37 | 4.37 | 4.37 | 4.37 | 4.37 |
| EBIT | 331.8 | 328.6 | 281.8 | 382.9 | 526.3 | 439.3 | 465.6 | 493.4 | 522.9 | 554.2 |
| EBIT, % | 15.15 | 16.34 | 11.96 | 13.85 | 19.5 | 15.36 | 15.36 | 15.36 | 15.36 | 15.36 |
| Total Cash | 144.4 | 125.2 | 459.2 | 68.7 | 111.9 | 222.7 | 236.0 | 250.2 | 265.1 | 281.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 335.8 | 336.4 | 391.8 | 453.7 | 432.3 | 464.0 | 491.7 | 521.1 | 552.3 | 585.3 |
| Account Receivables, % | 15.33 | 16.73 | 16.63 | 16.41 | 16.02 | 16.22 | 16.22 | 16.22 | 16.22 | 16.22 |
| Inventories | 365.9 | 401.0 | 498.5 | 631.4 | 456.2 | 558.0 | 591.3 | 626.7 | 664.2 | 703.9 |
| Inventories, % | 16.71 | 19.94 | 21.16 | 22.84 | 16.91 | 19.51 | 19.51 | 19.51 | 19.51 | 19.51 |
| Accounts Payable | 178.8 | 189.9 | 246.1 | 273.3 | 231.1 | 266.0 | 281.9 | 298.7 | 316.6 | 335.5 |
| Accounts Payable, % | 8.16 | 9.45 | 10.45 | 9.88 | 8.57 | 9.3 | 9.3 | 9.3 | 9.3 | 9.3 |
| Capital Expenditure | -59.4 | -93.3 | -78.9 | -56.2 | -48.3 | -83.1 | -88.0 | -93.3 | -98.9 | -104.8 |
| Capital Expenditure, % | -2.71 | -4.64 | -3.35 | -2.03 | -1.79 | -2.91 | -2.91 | -2.91 | -2.91 | -2.91 |
| Tax Rate, % | 20.47 | 20.47 | 20.47 | 20.47 | 20.47 | 20.47 | 20.47 | 20.47 | 20.47 | 20.47 |
| EBITAT | 254.5 | 268.4 | 217.3 | 307.8 | 418.6 | 347.4 | 368.2 | 390.2 | 413.5 | 438.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -211.4 | 263.6 | 161.0 | 166.4 | 602.6 | 290.9 | 367.5 | 389.5 | 412.8 | 437.4 |
| WACC, % | 6.49 | 6.53 | 6.5 | 6.52 | 6.51 | 6.51 | 6.51 | 6.51 | 6.51 | 6.51 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,559.3 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 440 | |||||||||
| Terminal Value | 7,316 | |||||||||
| Present Terminal Value | 5,337 | |||||||||
| Enterprise Value | 6,897 | |||||||||
| Net Debt | 622 | |||||||||
| Equity Value | 6,275 | |||||||||
| Diluted Shares Outstanding, MM | 10 | |||||||||
| Equity Value Per Share | 654.79 |
What You Will Receive
- Customizable Excel Template: A fully adaptable Excel-based DCF Calculator featuring pre-populated financials for NewMarket Corporation (NEU).
- Accurate Historical Data: Access to past performance metrics and future projections (highlighted in the yellow cells).
- Assumption Flexibility: Modify key forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect NewMarket Corporation's (NEU) valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- User-Centric Design: Organized for clarity and ease of navigation, complete with step-by-step guidance.
Key Features
- Customizable Financial Inputs: Adjust essential metrics such as revenue growth, operating margin, and capital investments.
- Instant DCF Valuation: Quickly computes intrinsic value, net present value (NPV), and additional financial metrics.
- High-Precision Accuracy: Leverages NewMarket Corporation’s (NEU) actual financial data for credible valuation results.
- Effortless Scenario Analysis: Evaluate various assumptions and analyze results with ease.
- Efficiency Booster: Remove the hassle of constructing intricate valuation models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered NewMarket Corporation (NEU) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for NewMarket Corporation’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for NewMarket Corporation (NEU)?
- Designed for Experts: A sophisticated tool utilized by financial analysts, CFOs, and industry consultants.
- Accurate Data: Historical and projected financials for NewMarket Corporation (NEU) preloaded for precision.
- Forecast Simulations: Effortlessly test various scenarios and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance ensures a smooth calculation process.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling NewMarket Corporation (NEU) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models tailored for NewMarket Corporation (NEU).
- Consultants: Deliver professional valuation insights on NewMarket Corporation (NEU) to clients quickly and accurately.
- Business Owners: Understand how companies like NewMarket Corporation (NEU) are valued to guide your own business strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to NewMarket Corporation (NEU).
What the Template Contains
- Pre-Filled DCF Model: NewMarket Corporation’s (NEU) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate NewMarket Corporation’s (NEU) 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.