|
GMS Inc. (GMS) DCF Valuation
US | Industrials | Construction | NYSE
|
- ✓ 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
GMS Inc. (GMS) Bundle
Looking to assess GMS Inc. intrinsic value? Our GMS (GMS) DCF Calculator integrates real-world data with comprehensive customization features, allowing you to refine your forecasts and enhance your investment choices.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 3,241.3 | 3,298.8 | 4,634.9 | 5,329.3 | 5,501.9 | 6,334.0 | 7,292.0 | 8,394.8 | 9,664.5 | 11,126.2 |
Revenue Growth, % | 0 | 1.77 | 40.5 | 14.98 | 3.24 | 15.12 | 15.12 | 15.12 | 15.12 | 15.12 |
EBITDA | 281.9 | 299.9 | 542.1 | 640.3 | 585.9 | 660.6 | 760.5 | 875.5 | 1,008.0 | 1,160.4 |
EBITDA, % | 8.7 | 9.09 | 11.7 | 12.01 | 10.65 | 10.43 | 10.43 | 10.43 | 10.43 | 10.43 |
Depreciation | 116.5 | 108.1 | 119.2 | 126.9 | 133.4 | 180.5 | 207.8 | 239.3 | 275.5 | 317.1 |
Depreciation, % | 3.6 | 3.28 | 2.57 | 2.38 | 2.42 | 2.85 | 2.85 | 2.85 | 2.85 | 2.85 |
EBIT | 165.4 | 191.7 | 422.9 | 513.3 | 452.5 | 480.1 | 552.7 | 636.3 | 732.5 | 843.3 |
EBIT, % | 5.1 | 5.81 | 9.12 | 9.63 | 8.22 | 7.58 | 7.58 | 7.58 | 7.58 | 7.58 |
Total Cash | 210.9 | 167.0 | 101.9 | 164.7 | 166.1 | 251.8 | 289.9 | 333.8 | 384.3 | 442.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 440.9 | 558.7 | 750.0 | 792.2 | 850.0 | 975.9 | 1,123.5 | 1,293.4 | 1,489.0 | 1,714.2 |
Account Receivables, % | 13.6 | 16.94 | 16.18 | 14.87 | 15.45 | 15.41 | 15.41 | 15.41 | 15.41 | 15.41 |
Inventories | 299.8 | 357.1 | 551.0 | 575.5 | 580.8 | 675.4 | 777.6 | 895.2 | 1,030.6 | 1,186.4 |
Inventories, % | 9.25 | 10.82 | 11.89 | 10.8 | 10.56 | 10.66 | 10.66 | 10.66 | 10.66 | 10.66 |
Accounts Payable | 248.9 | 323.0 | 367.3 | 377.0 | 420.2 | 508.1 | 584.9 | 673.4 | 775.2 | 892.5 |
Accounts Payable, % | 7.68 | 9.79 | 7.93 | 7.07 | 7.64 | 8.02 | 8.02 | 8.02 | 8.02 | 8.02 |
Capital Expenditure | -25.2 | -29.9 | -41.1 | -52.7 | -57.2 | -58.2 | -67.1 | -77.2 | -88.9 | -102.3 |
Capital Expenditure, % | -0.77725 | -0.90557 | -0.88637 | -0.98836 | -1.04 | -0.91961 | -0.91961 | -0.91961 | -0.91961 | -0.91961 |
Tax Rate, % | 26.21 | 26.21 | 26.21 | 26.21 | 26.21 | 26.21 | 26.21 | 26.21 | 26.21 | 26.21 |
EBITAT | 83.5 | 147.6 | 317.0 | 382.0 | 333.9 | 336.6 | 387.6 | 446.2 | 513.7 | 591.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -317.0 | 125.0 | 54.2 | 399.2 | 390.2 | 326.3 | 355.4 | 409.2 | 471.1 | 542.3 |
WACC, % | 9.34 | 9.74 | 9.71 | 9.7 | 9.69 | 9.64 | 9.64 | 9.64 | 9.64 | 9.64 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,572.1 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 545 | |||||||||
Terminal Value | 5,965 | |||||||||
Present Terminal Value | 3,765 | |||||||||
Enterprise Value | 5,337 | |||||||||
Net Debt | 1,368 | |||||||||
Equity Value | 3,969 | |||||||||
Diluted Shares Outstanding, MM | 41 | |||||||||
Equity Value Per Share | 97.02 |
What You Will Get
- Real GMS Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Automatic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess GMS’s future performance.
- User-Friendly Design: Designed for professionals while remaining accessible to newcomers.
Key Features
- Comprehensive GMS Data: Pre-loaded with GMS Inc.'s historical financial performance and future projections.
- Customizable Parameters: Modify revenue growth rates, profit margins, WACC, tax rates, and capital expenditures to fit your analysis.
- Interactive Valuation Model: Automatically refreshes Net Present Value (NPV) and intrinsic value based on your customized inputs.
- Scenario Analysis: Develop various forecasting scenarios to explore different valuation possibilities.
- Intuitive Interface: Designed to be straightforward and accessible for both seasoned professionals and newcomers.
How It Works
- 1. Download the Template: Obtain and open the Excel file containing GMS Inc.'s (GMS) financial data.
- 2. Adjust Assumptions: Modify key inputs such as growth projections, WACC, and capital expenditures.
- 3. Analyze Results Immediately: The DCF model automatically computes intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Evaluate various forecasts to understand different valuation possibilities.
- 5. Present with Assurance: Deliver professional valuation analyses to bolster your decision-making process.
Why Choose This Calculator for GMS Inc. (GMS)?
- Accurate Data: Real GMS financials provide trustworthy valuation outcomes.
- Customizable: Tailor key inputs such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you the effort of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the industry.
- User-Friendly: Easy-to-navigate design and detailed guidance make it accessible for all users.
Who Should Use GMS Inc. (GMS)?
- Professional Investors: Develop comprehensive and trustworthy valuation models for investment analysis.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions.
- Consultants and Advisors: Deliver precise valuation insights for GMS Inc. (GMS) to clients.
- Students and Educators: Utilize real-world data for practicing and teaching financial modeling techniques.
- Industry Enthusiasts: Gain insights into how companies like GMS Inc. (GMS) are valued within the market.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled GMS Inc. (GMS) 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 with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for GMS Inc. (GMS).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions for easy analysis of results.