Great Lakes Dredge & Dock Corporation (GLDD) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Great Lakes Dredge & Dock Corporation (GLDD) Bundle
Whether you're an investor or analyst, this Great Lakes Dredge & Dock Corporation (GLDD) DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from Great Lakes Dredge & Dock Corporation, you can adjust forecasts and observe the effects in real time.
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 | 711.5 | 733.6 | 726.1 | 648.8 | 589.6 | 576.7 | 564.0 | 551.6 | 539.5 | 527.6 |
| Revenue Growth, % | 0 | 3.1 | -1.02 | -10.65 | -9.12 | -2.2 | -2.2 | -2.2 | -2.2 | -2.2 |
| EBITDA | 135.6 | 151.1 | 127.4 | 17.0 | 73.0 | 83.3 | 81.4 | 79.6 | 77.9 | 76.2 |
| EBITDA, % | 19.06 | 20.59 | 17.55 | 2.62 | 12.38 | 14.44 | 14.44 | 14.44 | 14.44 | 14.44 |
| Depreciation | 37.1 | 38.2 | 43.0 | 46.3 | 42.5 | 35.4 | 34.6 | 33.9 | 33.1 | 32.4 |
| Depreciation, % | 5.22 | 5.2 | 5.92 | 7.13 | 7.21 | 6.14 | 6.14 | 6.14 | 6.14 | 6.14 |
| EBIT | 98.4 | 112.9 | 84.4 | -29.3 | 30.5 | 47.9 | 46.8 | 45.8 | 44.8 | 43.8 |
| EBIT, % | 13.84 | 15.39 | 11.63 | -4.52 | 5.16 | 8.3 | 8.3 | 8.3 | 8.3 | 8.3 |
| Total Cash | 187.0 | 216.5 | 145.5 | 6.5 | 22.8 | 93.1 | 91.0 | 89.0 | 87.1 | 85.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 42.3 | 71.1 | 122.8 | 110.8 | 123.5 | 81.4 | 79.6 | 77.9 | 76.2 | 74.5 |
| Account Receivables, % | 5.95 | 9.69 | 16.91 | 17.08 | 20.95 | 14.12 | 14.12 | 14.12 | 14.12 | 14.12 |
| Inventories | 30.2 | 34.7 | 30.8 | 29.2 | 33.9 | 27.1 | 26.5 | 25.9 | 25.3 | 24.8 |
| Inventories, % | 4.24 | 4.73 | 4.24 | 4.51 | 5.75 | 4.69 | 4.69 | 4.69 | 4.69 | 4.69 |
| Accounts Payable | 76.1 | 71.3 | 85.6 | 94.1 | 83.8 | 70.3 | 68.7 | 67.2 | 65.7 | 64.3 |
| Accounts Payable, % | 10.69 | 9.72 | 11.78 | 14.5 | 14.22 | 12.18 | 12.18 | 12.18 | 12.18 | 12.18 |
| Capital Expenditure | -49.4 | -47.6 | -116.7 | -143.0 | -150.8 | -89.0 | -87.0 | -85.1 | -83.2 | -81.4 |
| Capital Expenditure, % | -6.94 | -6.49 | -16.07 | -22.04 | -25.58 | -15.43 | -15.43 | -15.43 | -15.43 | -15.43 |
| Tax Rate, % | 24.06 | 24.06 | 24.06 | 24.06 | 24.06 | 24.06 | 24.06 | 24.06 | 24.06 | 24.06 |
| EBITAT | 68.5 | 86.5 | 66.4 | -23.0 | 23.1 | 36.3 | 35.5 | 34.7 | 34.0 | 33.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 59.8 | 39.0 | -40.7 | -97.7 | -112.8 | 18.2 | -16.0 | -15.7 | -15.3 | -15.0 |
| WACC, % | 7.14 | 7.26 | 7.3 | 7.29 | 7.25 | 7.25 | 7.25 | 7.25 | 7.25 | 7.25 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -31.9 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | -15 | |||||||||
| Terminal Value | -364 | |||||||||
| Present Terminal Value | -256 | |||||||||
| Enterprise Value | -288 | |||||||||
| Net Debt | 480 | |||||||||
| Equity Value | -769 | |||||||||
| Diluted Shares Outstanding, MM | 67 | |||||||||
| Equity Value Per Share | -11.48 |
What You Will Get
- Real GLDD Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Great Lakes Dredge & Dock Corporation (GLDD).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to GLDD.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Great Lakes Dredge & Dock Corporation’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for GLDD.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for your GLDD analysis.
Key Features
- Real-Life GLDD Data: Pre-filled with Great Lakes Dredge & Dock Corporation’s historical performance and future projections.
- Fully Customizable Inputs: Modify revenue growth rates, profit margins, WACC, tax rates, and capital expenditures as needed.
- Dynamic Valuation Model: Automatically recalculates Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Testing: Develop various forecasting scenarios to evaluate different valuation results.
- User-Friendly Design: Intuitive layout, crafted for both professionals and novices.
How It Works
- Download the Template: Gain immediate access to the Excel-based GLDD DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
- Instant Calculations: The model automatically recalculates Great Lakes Dredge & Dock Corporation’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation shifts.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial decisions.
Why Choose This Calculator for Great Lakes Dredge & Dock Corporation (GLDD)?
- Accurate Data: Up-to-date financials for Great Lakes Dredge & Dock ensure trustworthy valuation results.
- Customizable: Tailor key metrics such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the industry.
- User-Friendly: An intuitive design and clear instructions make it accessible for all users.
Who Should Use This Product?
- Investors: Accurately assess Great Lakes Dredge & Dock Corporation’s (GLDD) fair value before making investment choices.
- CFOs: Utilize a high-quality DCF model for financial reporting and analysis related to (GLDD).
- Consultants: Easily customize the template for valuation reports tailored to clients involving (GLDD).
- Entrepreneurs: Acquire knowledge of financial modeling practices employed by leading companies like (GLDD).
- Educators: Implement it as a teaching resource to illustrate valuation techniques applicable to (GLDD).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Great Lakes Dredge & Dock Corporation (GLDD) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), featuring parameters such as Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models that present intrinsic value along with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate comprehensive analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios relevant to Great Lakes Dredge & Dock Corporation (GLDD).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions for easy analysis of results.