Forum Energy Technologies, Inc. (FET) 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
Forum Energy Technologies, Inc. (FET) Bundle
Evaluate Forum Energy Technologies, Inc.'s (FET) financial outlook like an expert! This (FET) DCF Calculator comes with pre-filled financial data and offers full flexibility to modify revenue growth, WACC, margins, and other crucial assumptions to align with your 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 | 956.5 | 512.5 | 541.1 | 699.9 | 738.9 | 727.9 | 717.1 | 706.5 | 696.1 | 685.7 |
| Revenue Growth, % | 0 | -46.42 | 5.58 | 29.35 | 5.57 | -1.48 | -1.48 | -1.48 | -1.48 | -1.48 |
| EBITDA | -474.0 | -28.5 | -7.8 | 46.0 | 45.2 | -63.9 | -62.9 | -62.0 | -61.1 | -60.2 |
| EBITDA, % | -49.56 | -5.56 | -1.45 | 6.58 | 6.12 | -8.77 | -8.77 | -8.77 | -8.77 | -8.77 |
| Depreciation | 63.2 | 51.0 | 42.2 | 37.0 | 34.7 | 50.0 | 49.3 | 48.5 | 47.8 | 47.1 |
| Depreciation, % | 6.61 | 9.95 | 7.79 | 5.28 | 4.7 | 6.87 | 6.87 | 6.87 | 6.87 | 6.87 |
| EBIT | -537.3 | -79.5 | -50.0 | 9.1 | 10.5 | -113.9 | -112.2 | -110.5 | -108.9 | -107.3 |
| EBIT, % | -56.17 | -15.51 | -9.24 | 1.29 | 1.42 | -15.64 | -15.64 | -15.64 | -15.64 | -15.64 |
| Total Cash | 57.9 | 128.6 | 46.9 | 51.0 | 46.2 | 77.7 | 76.5 | 75.4 | 74.3 | 73.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 159.5 | 90.8 | 134.4 | 170.1 | 161.9 | 153.5 | 151.3 | 149.0 | 146.8 | 144.6 |
| Account Receivables, % | 16.68 | 17.72 | 24.84 | 24.3 | 21.91 | 21.09 | 21.09 | 21.09 | 21.09 | 21.09 |
| Inventories | 414.6 | 251.7 | 241.7 | 269.8 | 299.6 | 314.8 | 310.1 | 305.5 | 301.0 | 296.6 |
| Inventories, % | 43.35 | 49.11 | 44.67 | 38.55 | 40.55 | 43.25 | 43.25 | 43.25 | 43.25 | 43.25 |
| Accounts Payable | 98.7 | 46.4 | 99.4 | 118.3 | 125.9 | 104.3 | 102.8 | 101.3 | 99.8 | 98.3 |
| Accounts Payable, % | 10.32 | 9.04 | 18.37 | 16.9 | 17.04 | 14.33 | 14.33 | 14.33 | 14.33 | 14.33 |
| Capital Expenditure | -15.1 | -2.2 | -2.4 | -7.5 | -7.9 | -6.7 | -6.6 | -6.5 | -6.4 | -6.3 |
| Capital Expenditure, % | -1.58 | -0.42927 | -0.44354 | -1.07 | -1.08 | -0.91965 | -0.91965 | -0.91965 | -0.91965 | -0.91965 |
| Tax Rate, % | -141.57 | -141.57 | -141.57 | -141.57 | -141.57 | -141.57 | -141.57 | -141.57 | -141.57 | -141.57 |
| EBITAT | -535.6 | -70.2 | -50.4 | 3.3 | 25.3 | -96.5 | -95.1 | -93.7 | -92.3 | -91.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -962.8 | 157.9 | 8.8 | -12.1 | 38.1 | -81.6 | -47.1 | -46.4 | -45.7 | -45.0 |
| WACC, % | 12.1 | 11.51 | 12.12 | 8.81 | 12.12 | 11.33 | 11.33 | 11.33 | 11.33 | 11.33 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -200.9 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | -47 | |||||||||
| Terminal Value | -595 | |||||||||
| Present Terminal Value | -348 | |||||||||
| Enterprise Value | -549 | |||||||||
| Net Debt | 155 | |||||||||
| Equity Value | -704 | |||||||||
| Diluted Shares Outstanding, MM | 10 | |||||||||
| Equity Value Per Share | -68.94 |
What You Will Get
- Real Forum Energy Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Forum Energy Technologies, Inc. (FET).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to FET.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Forum Energy’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for FET.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Forum Energy Technologies, Inc. (FET).
Key Features
- Comprehensive Data: Forum Energy Technologies, Inc. (FET)'s historical financial reports and pre-populated projections.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
- Real-Time Insights: Observe the recalculation of Forum Energy Technologies, Inc. (FET)'s intrinsic value instantly.
- Intuitive Visualizations: Dashboard graphs illustrate valuation results and essential metrics clearly.
- Designed for Precision: A professional-grade tool tailored for analysts, investors, and finance specialists.
How It Works
- Step 1: Download the prebuilt Excel template featuring Forum Energy Technologies, Inc. (FET) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see recalibrated results, including the intrinsic value of Forum Energy Technologies, Inc. (FET).
- Step 5: Use the outputs to make informed investment decisions or create detailed reports.
Why Choose This Calculator for Forum Energy Technologies, Inc. (FET)?
- Designed for Industry Experts: A sophisticated tool utilized by engineers, financial analysts, and energy consultants.
- Comprehensive Data: FET’s historical and projected financials preloaded for precise analysis.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly Interface: Step-by-step guidance ensures a smooth experience.
Who Should Use This Product?
- Energy Sector Investors: Develop comprehensive valuation models for analyzing investments in Forum Energy Technologies, Inc. (FET).
- Corporate Strategy Teams: Evaluate valuation scenarios to inform strategic decisions within the energy sector.
- Consultants and Advisors: Deliver precise valuation insights to clients interested in Forum Energy Technologies, Inc. (FET).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling related to the energy industry.
- Industry Enthusiasts: Gain insights into how energy companies like Forum Energy Technologies, Inc. (FET) are valued in the market.
What the Template Contains
- Pre-Filled Data: Includes Forum Energy Technologies, Inc.'s (FET) historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Forum Energy Technologies, Inc.'s (FET) profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.