Euroseas Ltd. (ESEA) 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
Euroseas Ltd. (ESEA) Bundle
Designed for accuracy, our (ESEA) DCF Calculator empowers you to assess Euroseas Ltd. valuation using up-to-date financial data and offers complete flexibility to modify all essential parameters for improved 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 | 40.0 | 53.3 | 93.9 | 182.7 | 189.4 | 287.6 | 436.8 | 663.5 | 1,007.8 | 1,530.7 |
| Revenue Growth, % | 0 | 33.18 | 76.15 | 94.58 | 3.65 | 51.89 | 51.89 | 51.89 | 51.89 | 51.89 |
| EBITDA | 5.9 | 14.8 | 52.9 | 129.8 | 143.8 | 141.5 | 214.9 | 326.3 | 495.7 | 752.9 |
| EBITDA, % | 14.79 | 27.71 | 56.39 | 71.07 | 75.95 | 49.18 | 49.18 | 49.18 | 49.18 | 49.18 |
| Depreciation | 4.2 | 6.6 | 7.2 | 18.5 | 22.8 | 30.3 | 46.0 | 69.9 | 106.2 | 161.4 |
| Depreciation, % | 10.44 | 12.39 | 7.67 | 10.14 | 12.06 | 10.54 | 10.54 | 10.54 | 10.54 | 10.54 |
| EBIT | 1.7 | 8.2 | 45.7 | 111.3 | 121.0 | 111.1 | 168.8 | 256.4 | 389.4 | 591.5 |
| EBIT, % | 4.35 | 15.32 | 48.72 | 60.93 | 63.89 | 38.64 | 38.64 | 38.64 | 38.64 | 38.64 |
| Total Cash | 1.0 | 3.6 | 26.5 | 25.8 | 58.6 | 47.5 | 72.1 | 109.5 | 166.3 | 252.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 2.3 | 3.9 | 3.0 | 6.1 | 4.3 | 12.5 | 19.1 | 28.9 | 44.0 | 66.8 |
| Account Receivables, % | 5.71 | 7.28 | 3.19 | 3.35 | 2.28 | 4.36 | 4.36 | 4.36 | 4.36 | 4.36 |
| Inventories | 1.9 | 1.7 | 2.2 | 2.3 | 2.5 | 7.3 | 11.2 | 16.9 | 25.7 | 39.1 |
| Inventories, % | 4.72 | 3.12 | 2.33 | 1.26 | 1.34 | 2.55 | 2.55 | 2.55 | 2.55 | 2.55 |
| Accounts Payable | 3.9 | 2.9 | 2.8 | 5.2 | 5.7 | 13.8 | 20.9 | 31.8 | 48.3 | 73.3 |
| Accounts Payable, % | 9.74 | 5.35 | 2.99 | 2.82 | 3.03 | 4.79 | 4.79 | 4.79 | 4.79 | 4.79 |
| Capital Expenditure | -55.7 | -.7 | -74.1 | -90.7 | -112.3 | -166.3 | -252.6 | -383.7 | -582.8 | -885.2 |
| Capital Expenditure, % | -139.22 | -1.25 | -78.93 | -49.64 | -59.3 | -57.83 | -57.83 | -57.83 | -57.83 | -57.83 |
| Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| EBITAT | 5.3 | -.2 | 45.8 | 111.3 | 121.0 | 88.9 | 135.0 | 205.1 | 311.6 | 473.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -46.5 | 3.4 | -20.8 | 38.3 | 33.7 | -52.1 | -74.7 | -113.4 | -172.3 | -261.7 |
| WACC, % | 7.38 | 5.65 | 7.38 | 7.38 | 7.38 | 7.04 | 7.04 | 7.04 | 7.04 | 7.04 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -523.9 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | -263 | |||||||||
| Terminal Value | -4,024 | |||||||||
| Present Terminal Value | -2,864 | |||||||||
| Enterprise Value | -3,388 | |||||||||
| Net Debt | 71 | |||||||||
| Equity Value | -3,459 | |||||||||
| Diluted Shares Outstanding, MM | 7 | |||||||||
| Equity Value Per Share | -498.76 |
What You Will Get
- Editable Forecast Inputs: Seamlessly adjust assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Euroseas Ltd. (ESEA)’s financial information pre-filled to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically for you.
- Customizable and Professional: A refined Excel model tailored to meet your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and optimizing your time.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Euroseas Ltd. (ESEA).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs specific to Euroseas Ltd. (ESEA).
- Customizable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates for Euroseas Ltd. (ESEA).
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios for Euroseas Ltd. (ESEA).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for streamlined analysis of Euroseas Ltd. (ESEA).
How It Works
- Download: Obtain the pre-built Excel file featuring Euroseas Ltd. (ESEA) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and instantly compare the results.
- Make Decisions: Leverage the valuation findings to inform your investment approach.
Why Choose This Calculator for Euroseas Ltd. (ESEA)?
- Designed for Industry Experts: A sophisticated tool favored by maritime analysts, CFOs, and shipping consultants.
- Accurate Financial Insights: Euroseas Ltd.’s historical and projected financials preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive 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?
- Investors: Evaluate Euroseas Ltd. (ESEA)'s market potential before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts for Euroseas Ltd. (ESEA).
- Startup Founders: Understand the valuation strategies of established maritime companies like Euroseas Ltd. (ESEA).
- Consultants: Create detailed valuation reports for clients in the shipping industry.
- Students and Educators: Utilize current data to practice and instruct on valuation principles in maritime commerce.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Euroseas Ltd. (ESEA) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Euroseas Ltd. (ESEA).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.