SEACOR Marine Holdings Inc. (SMHI) 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
SEACOR Marine Holdings Inc. (SMHI) Bundle
Whether you’re an investor or analyst, this SEACOR Marine Holdings Inc. (SMHI) DCF Calculator is your go-to tool for accurate valuation. Preloaded with real data from SEACOR Marine, you can adjust forecasts and instantly 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 | 201.5 | 141.8 | 170.9 | 217.3 | 279.5 | 312.1 | 348.5 | 389.2 | 434.6 | 485.3 |
Revenue Growth, % | 0 | -29.61 | 20.52 | 27.13 | 28.61 | 11.67 | 11.67 | 11.67 | 11.67 | 11.67 |
EBITDA | 2.2 | -8.8 | -.2 | 16.3 | 86.7 | 20.8 | 23.2 | 25.9 | 28.9 | 32.3 |
EBITDA, % | 1.09 | -6.22 | -0.11056 | 7.49 | 31.01 | 6.65 | 6.65 | 6.65 | 6.65 | 6.65 |
Depreciation | 57.2 | 57.2 | 57.4 | 56.0 | 53.8 | 91.9 | 102.6 | 114.6 | 128.0 | 142.9 |
Depreciation, % | 28.37 | 40.3 | 33.58 | 25.75 | 19.26 | 29.45 | 29.45 | 29.45 | 29.45 | 29.45 |
EBIT | -55.0 | -66.0 | -57.6 | -39.7 | 32.9 | -71.2 | -79.5 | -88.7 | -99.1 | -110.6 |
EBIT, % | -27.28 | -46.53 | -33.69 | -18.26 | 11.76 | -22.8 | -22.8 | -22.8 | -22.8 | -22.8 |
Total Cash | 83.9 | 32.7 | 37.6 | 40.0 | 67.5 | 80.7 | 90.1 | 100.6 | 112.3 | 125.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 43.1 | 88.6 | 62.9 | 54.4 | 75.8 | 107.9 | 120.4 | 134.5 | 150.2 | 167.7 |
Account Receivables, % | 21.37 | 62.49 | 36.8 | 25.03 | 27.1 | 34.56 | 34.56 | 34.56 | 34.56 | 34.56 |
Inventories | 1.2 | .6 | .9 | 2.1 | 1.6 | 1.9 | 2.2 | 2.4 | 2.7 | 3.0 |
Inventories, % | 0.60945 | 0.4061 | 0.54288 | 0.97688 | 0.57565 | 0.62219 | 0.62219 | 0.62219 | 0.62219 | 0.62219 |
Accounts Payable | 24.6 | 30.0 | 28.4 | 38.0 | 27.6 | 48.2 | 53.9 | 60.2 | 67.2 | 75.0 |
Accounts Payable, % | 12.21 | 21.13 | 16.63 | 17.46 | 9.86 | 15.46 | 15.46 | 15.46 | 15.46 | 15.46 |
Capital Expenditure | -60.6 | -20.8 | -7.0 | -.2 | -10.6 | -32.9 | -36.7 | -41.0 | -45.8 | -51.2 |
Capital Expenditure, % | -30.07 | -14.67 | -4.1 | -0.08512596 | -3.79 | -10.54 | -10.54 | -10.54 | -10.54 | -10.54 |
Tax Rate, % | -1708.54 | -1708.54 | -1708.54 | -1708.54 | -1708.54 | -1708.54 | -1708.54 | -1708.54 | -1708.54 | -1708.54 |
EBITAT | -49.7 | -50.6 | 42.3 | -44.5 | 594.3 | -52.2 | -58.3 | -65.1 | -72.7 | -81.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -72.8 | -53.8 | 116.5 | 28.1 | 606.3 | -5.0 | .4 | .4 | .5 | .5 |
WACC, % | 10.6 | 9.54 | 3.67 | 11.33 | 11.33 | 9.29 | 9.29 | 9.29 | 9.29 | 9.29 |
PV UFCF | ||||||||||
SUM PV UFCF | -3.2 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 1 | |||||||||
Terminal Value | 7 | |||||||||
Present Terminal Value | 5 | |||||||||
Enterprise Value | 2 | |||||||||
Net Debt | 254 | |||||||||
Equity Value | -252 | |||||||||
Diluted Shares Outstanding, MM | 27 | |||||||||
Equity Value Per Share | -9.31 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real SMHI financials.
- Authentic Data: Historical figures and forward-looking projections (as indicated in the yellow cells).
- Flexible Forecasting: Adjust forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Immediately observe the effect of your inputs on SEACOR Marine’s valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for clarity and ease of navigation, complete with step-by-step guidance.
Key Features
- Customizable Operational Metrics: Adjust essential inputs such as fleet utilization, operating costs, and revenue projections.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other financial metrics.
- Industry-Leading Precision: Leverages SEACOR Marine's actual financial data for accurate valuation results.
- Effortless Scenario Testing: Evaluate various assumptions and analyze results with ease.
- Efficiency Boost: Avoid the hassle of constructing intricate valuation models from the ground up.
How It Works
- Step 1: Download the Excel file for SEACOR Marine Holdings Inc. (SMHI).
- Step 2: Review SEACOR'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 outputs and utilize the results for your investment decisions.
Why Choose SEACOR Marine Holdings Inc. (SMHI)?
- Industry Expertise: Benefit from years of experience in marine logistics and transportation.
- Enhanced Safety: Commitment to high safety standards ensures reliable operations.
- Innovative Solutions: Cutting-edge technology and services tailored to meet client needs.
- Global Reach: Extensive network allows for efficient service delivery worldwide.
- Proven Track Record: Trusted by clients for delivering consistent and quality results.
Who Should Use This Product?
- Investors: Accurately assess SEACOR Marine Holdings Inc.'s (SMHI) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis.
- Consultants: Easily modify the template for valuation reports tailored to clients' needs.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading marine companies.
- Educators: Employ it as a teaching resource to illustrate valuation methodologies effectively.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations for SEACOR Marine Holdings Inc. (SMHI).
- Real-World Data: SEACOR Marine's historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test various scenarios.
- Financial Statements: Full annual and quarterly breakdowns for deeper insights into SEACOR Marine's performance.
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage specific to SEACOR Marine Holdings Inc. (SMHI).
- Dashboard with Visual Outputs: Charts and tables for clear, actionable results tailored to SEACOR Marine Holdings Inc. (SMHI).