Granite Construction Incorporated (GVA) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Granite Construction Incorporated (GVA) Bundle
Evaluate Granite Construction Incorporated's financial prospects like an expert! This (GVA) DCF Calculator provides you with pre-filled financial data and the flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your predictions.
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 | 3,445.6 | 3,562.5 | 3,010.1 | 3,301.3 | 3,509.1 | 3,543.0 | 3,577.1 | 3,611.6 | 3,646.4 | 3,681.6 |
| Revenue Growth, % | 0 | 3.39 | -15.51 | 9.67 | 6.3 | 0.96411 | 0.96411 | 0.96411 | 0.96411 | 0.96411 |
| EBITDA | 61.3 | -29.3 | 67.3 | 153.5 | 170.6 | 90.0 | 90.9 | 91.8 | 92.7 | 93.6 |
| EBITDA, % | 1.78 | -0.82261 | 2.24 | 4.65 | 4.86 | 2.54 | 2.54 | 2.54 | 2.54 | 2.54 |
| Depreciation | 123.4 | 63.7 | 109.1 | 82.6 | 92.3 | 100.1 | 101.0 | 102.0 | 103.0 | 104.0 |
| Depreciation, % | 3.58 | 1.79 | 3.62 | 2.5 | 2.63 | 2.82 | 2.82 | 2.82 | 2.82 | 2.82 |
| EBIT | -62.1 | -93.0 | -41.7 | 71.0 | 78.3 | -10.0 | -10.1 | -10.2 | -10.3 | -10.4 |
| EBIT, % | -1.8 | -2.61 | -1.39 | 2.15 | 2.23 | -0.28358 | -0.28358 | -0.28358 | -0.28358 | -0.28358 |
| Total Cash | 483.2 | 624.9 | 585.6 | 517.2 | 453.5 | 564.1 | 569.5 | 575.0 | 580.6 | 586.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 758.9 | 518.3 | 610.0 | 705.9 | 861.7 | 728.3 | 735.3 | 742.4 | 749.5 | 756.8 |
| Account Receivables, % | 22.02 | 14.55 | 20.27 | 21.38 | 24.56 | 20.56 | 20.56 | 20.56 | 20.56 | 20.56 |
| Inventories | 88.9 | 82.4 | 62.0 | 86.8 | 103.9 | 88.9 | 89.7 | 90.6 | 91.5 | 92.3 |
| Inventories, % | 2.58 | 2.31 | 2.06 | 2.63 | 2.96 | 2.51 | 2.51 | 2.51 | 2.51 | 2.51 |
| Accounts Payable | 400.8 | 321.3 | 324.3 | 334.4 | 408.4 | 376.9 | 380.6 | 384.2 | 387.9 | 391.7 |
| Accounts Payable, % | 11.63 | 9.02 | 10.77 | 10.13 | 11.64 | 10.64 | 10.64 | 10.64 | 10.64 | 10.64 |
| Capital Expenditure | -106.8 | -93.3 | -94.8 | -121.6 | -140.4 | -117.3 | -118.4 | -119.6 | -120.7 | -121.9 |
| Capital Expenditure, % | -3.1 | -2.62 | -3.15 | -3.68 | -4 | -3.31 | -3.31 | -3.31 | -3.31 | -3.31 |
| Tax Rate, % | 27.16 | 27.16 | 27.16 | 27.16 | 27.16 | 27.16 | 27.16 | 27.16 | 27.16 | 27.16 |
| EBITAT | -45.7 | -92.8 | -36.3 | 64.4 | 57.0 | -8.5 | -8.6 | -8.7 | -8.8 | -8.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -476.1 | 45.3 | -90.4 | -85.3 | -90.0 | 91.3 | -30.2 | -30.5 | -30.8 | -31.1 |
| WACC, % | 10.01 | 10.17 | 10.09 | 10.11 | 10.01 | 10.08 | 10.08 | 10.08 | 10.08 | 10.08 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -5.1 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | -32 | |||||||||
| Terminal Value | -489 | |||||||||
| Present Terminal Value | -303 | |||||||||
| Enterprise Value | -308 | |||||||||
| Net Debt | 317 | |||||||||
| Equity Value | -625 | |||||||||
| Diluted Shares Outstanding, MM | 53 | |||||||||
| Equity Value Per Share | -11.90 |
What You Will Get
- Comprehensive GVA Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Explore various scenarios to assess Granite Construction's future performance.
- User-Friendly Design: Crafted for professionals while remaining accessible to newcomers.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Granite Construction Incorporated (GVA).
- WACC Calculator: Features a pre-constructed Weighted Average Cost of Capital sheet with adjustable inputs specific to the construction industry.
- Customizable Forecast Assumptions: Easily adjust growth projections, capital expenditures, and discount rates to fit Granite Construction's financial outlook.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios pertinent to Granite Construction Incorporated (GVA).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for streamlined analysis.
How It Works
- Step 1: Download the prebuilt Excel template featuring Granite Construction Incorporated's (GVA) data.
- Step 2: Review 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 recalculated results, including Granite Construction Incorporated's (GVA) intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the results.
Why Choose This Calculator for Granite Construction Incorporated (GVA)?
- Designed for Industry Experts: A sophisticated tool utilized by engineers, project managers, and financial analysts.
- Comprehensive Data: Granite Construction’s historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential performance metrics.
- User-Friendly: Step-by-step guidance ensures a smooth navigation through the process.
Who Should Use This Product?
- Investors: Make informed decisions by accurately estimating Granite Construction's fair value before investing.
- CFOs: Utilize a sophisticated DCF model for financial reporting and strategic analysis at Granite Construction (GVA).
- Consultants: Efficiently customize the template for client valuation reports related to Granite Construction (GVA).
- Entrepreneurs: Discover financial modeling techniques employed by industry leaders like Granite Construction (GVA).
- Educators: Implement this tool to teach valuation methodologies in a practical context, using Granite Construction (GVA) as a case study.
What the Template Contains
- Preloaded GVA Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.