|
NCS Multistage Holdings, Inc. (NCSM) DCF Valuation
US | Energy | Oil & Gas Equipment & Services | NASDAQ
|
- ✓ 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
NCS Multistage Holdings, Inc. (NCSM) Bundle
As an investor or analyst, the DCF Calculator for NCS Multistage Holdings, Inc. (NCSM) is your go-to resource for accurate valuation. With real data from NCS Multistage Holdings, Inc., you can easily adjust forecasts and immediately observe the 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 | 205.5 | 107.0 | 118.5 | 155.6 | 142.5 | 137.4 | 132.5 | 127.7 | 123.2 | 118.8 |
| Revenue Growth, % | 0 | -47.94 | 10.77 | 31.33 | -8.46 | -3.57 | -3.57 | -3.57 | -3.57 | -3.57 |
| EBITDA | .3 | -39.2 | 1.7 | 4.7 | 1.9 | -8.4 | -8.1 | -7.8 | -7.6 | -7.3 |
| EBITDA, % | 0.14356 | -36.65 | 1.45 | 3.04 | 1.3 | -6.14 | -6.14 | -6.14 | -6.14 | -6.14 |
| Depreciation | 10.4 | 5.9 | 4.5 | 4.3 | 4.6 | 5.6 | 5.4 | 5.2 | 5.0 | 4.8 |
| Depreciation, % | 5.08 | 5.51 | 3.8 | 2.78 | 3.24 | 4.08 | 4.08 | 4.08 | 4.08 | 4.08 |
| EBIT | -10.1 | -45.1 | -2.8 | .4 | -2.8 | -14.0 | -13.5 | -13.1 | -12.6 | -12.1 |
| EBIT, % | -4.94 | -42.15 | -2.35 | 0.26601 | -1.94 | -10.22 | -10.22 | -10.22 | -10.22 | -10.22 |
| Total Cash | 11.2 | 15.5 | 22.2 | 16.2 | 16.7 | 16.7 | 16.1 | 15.6 | 15.0 | 14.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 47.0 | 30.3 | 29.1 | 31.6 | 43.0 | 34.7 | 33.4 | 32.2 | 31.1 | 30.0 |
| Account Receivables, % | 22.87 | 28.31 | 24.57 | 20.29 | 30.2 | 25.25 | 25.25 | 25.25 | 25.25 | 25.25 |
| Inventories | 39.9 | 34.9 | 33.9 | 37.0 | 41.6 | 36.7 | 35.4 | 34.1 | 32.9 | 31.8 |
| Inventories, % | 19.43 | 32.6 | 28.62 | 23.8 | 29.21 | 26.73 | 26.73 | 26.73 | 26.73 | 26.73 |
| Accounts Payable | 8.5 | 4.9 | 7.5 | 7.5 | 6.2 | 6.7 | 6.4 | 6.2 | 6.0 | 5.8 |
| Accounts Payable, % | 4.16 | 4.62 | 6.33 | 4.85 | 4.37 | 4.87 | 4.87 | 4.87 | 4.87 | 4.87 |
| Capital Expenditure | -6.4 | -2.2 | -.8 | -1.1 | -2.2 | -2.2 | -2.1 | -2.1 | -2.0 | -1.9 |
| Capital Expenditure, % | -3.1 | -2.01 | -0.70294 | -0.72671 | -1.54 | -1.62 | -1.62 | -1.62 | -1.62 | -1.62 |
| Tax Rate, % | 5.68 | 5.68 | 5.68 | 5.68 | 5.68 | 5.68 | 5.68 | 5.68 | 5.68 | 5.68 |
| EBITAT | -19.2 | -37.6 | -3.0 | .7 | -2.6 | -13.4 | -12.9 | -12.5 | -12.0 | -11.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -93.5 | -15.7 | 5.4 | -1.7 | -17.5 | 3.7 | -7.4 | -7.1 | -6.8 | -6.6 |
| WACC, % | 9.13 | 9 | 9.13 | 9.13 | 9.09 | 9.1 | 9.1 | 9.1 | 9.1 | 9.1 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -17.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -7 | |||||||||
| Terminal Value | -95 | |||||||||
| Present Terminal Value | -61 | |||||||||
| Enterprise Value | -79 | |||||||||
| Net Debt | -3 | |||||||||
| Equity Value | -76 | |||||||||
| Diluted Shares Outstanding, MM | 2 | |||||||||
| Equity Value Per Share | -30.55 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to create various scenarios tailored to NCS Multistage Holdings, Inc. (NCSM).
- Real-World Data: NCSM's financial data pre-filled to kickstart your analysis and insights.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically for NCSM.
- Customizable and Professional: A refined Excel model that adjusts to your specific valuation requirements for NCSM.
- Built for Analysts and Investors: Perfect for evaluating projections, validating strategies, and optimizing time efficiency regarding NCSM.
Key Features
- Customizable Financial Inputs: Adjust essential metrics such as revenue projections, operating margins, and capital investments.
- Instant DCF Valuation: Quickly computes intrinsic value, net present value (NPV), and additional financial metrics.
- High-Precision Valuation: Leverages NCS Multistage Holdings, Inc.'s (NCSM) actual financial data for accurate valuation results.
- Effortless Scenario Analysis: Evaluate various assumptions and easily compare the resulting outcomes.
- Efficiency Booster: Streamline the valuation process without the hassle of creating intricate models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered NCS Multistage data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for NCS Multistage's intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for NCS Multistage Holdings, Inc. (NCSM)?
- Designed for Industry Experts: A sophisticated tool utilized by financial analysts, CFOs, and industry consultants.
- Comprehensive Data: NCSM's historical and projected financials are preloaded for enhanced accuracy.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance makes the process straightforward.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and trustworthy valuation models for portfolio assessments related to NCS Multistage Holdings, Inc. (NCSM).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations regarding NCS Multistage Holdings, Inc. (NCSM).
- Consultants and Advisors: Deliver precise valuation insights to clients focusing on NCS Multistage Holdings, Inc. (NCSM).
- Students and Educators: Utilize authentic data to practice and teach financial modeling centered on NCS Multistage Holdings, Inc. (NCSM).
- Industry Analysts: Gain a deeper understanding of how companies like NCS Multistage Holdings, Inc. (NCSM) are valued in the market.
What the Template Contains
- Pre-Filled DCF Model: NCS Multistage Holdings’ financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate NCS Multistage's 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.