Arcosa, Inc. (ACA) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Arcosa, Inc. (ACA) Bundle
Looking to assess the intrinsic value of Arcosa, Inc.? Our ACA DCF Calculator integrates real-world data with extensive customization features, allowing you to refine your forecasts and enhance your investment strategies.
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 | 1,736.9 | 1,935.6 | 2,036.4 | 2,242.8 | 2,307.9 | 2,479.2 | 2,663.2 | 2,860.8 | 3,073.1 | 3,301.2 |
Revenue Growth, % | 0 | 11.44 | 5.21 | 10.14 | 2.9 | 7.42 | 7.42 | 7.42 | 7.42 | 7.42 |
EBITDA | 239.4 | 263.3 | 251.3 | 501.3 | 383.5 | 390.2 | 419.2 | 450.3 | 483.7 | 519.6 |
EBITDA, % | 13.78 | 13.6 | 12.34 | 22.35 | 16.62 | 15.74 | 15.74 | 15.74 | 15.74 | 15.74 |
Depreciation | 85.8 | 114.5 | 144.3 | 154.1 | 159.5 | 157.3 | 169.0 | 181.5 | 195.0 | 209.4 |
Depreciation, % | 4.94 | 5.92 | 7.09 | 6.87 | 6.91 | 6.34 | 6.34 | 6.34 | 6.34 | 6.34 |
EBIT | 153.6 | 148.8 | 107.0 | 347.2 | 224.0 | 232.9 | 250.2 | 268.8 | 288.7 | 310.1 |
EBIT, % | 8.84 | 7.69 | 5.25 | 15.48 | 9.71 | 9.39 | 9.39 | 9.39 | 9.39 | 9.39 |
Total Cash | 240.4 | 95.8 | 72.9 | 160.4 | 104.8 | 168.9 | 181.4 | 194.9 | 209.4 | 224.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 200.0 | 260.2 | 310.8 | 334.2 | 357.1 | 350.0 | 376.0 | 403.9 | 433.9 | 466.1 |
Account Receivables, % | 11.51 | 13.44 | 15.26 | 14.9 | 15.47 | 14.12 | 14.12 | 14.12 | 14.12 | 14.12 |
Inventories | 283.3 | 276.8 | 324.5 | 315.8 | 401.8 | 386.9 | 415.6 | 446.5 | 479.6 | 515.2 |
Inventories, % | 16.31 | 14.3 | 15.93 | 14.08 | 17.41 | 15.61 | 15.61 | 15.61 | 15.61 | 15.61 |
Accounts Payable | 90.0 | 144.1 | 184.7 | 190.7 | 272.5 | 208.3 | 223.7 | 240.3 | 258.2 | 277.3 |
Accounts Payable, % | 5.18 | 7.44 | 9.07 | 8.5 | 11.81 | 8.4 | 8.4 | 8.4 | 8.4 | 8.4 |
Capital Expenditure | -85.4 | -82.1 | -85.1 | -138.0 | -203.5 | -140.4 | -150.8 | -162.0 | -174.0 | -186.9 |
Capital Expenditure, % | -4.92 | -4.24 | -4.18 | -6.15 | -8.82 | -5.66 | -5.66 | -5.66 | -5.66 | -5.66 |
Tax Rate, % | 18.73 | 18.73 | 18.73 | 18.73 | 18.73 | 18.73 | 18.73 | 18.73 | 18.73 | 18.73 |
EBITAT | 118.5 | 114.8 | 89.1 | 269.9 | 182.0 | 184.7 | 198.4 | 213.2 | 229.0 | 246.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -274.4 | 147.6 | 90.6 | 277.3 | 110.9 | 159.4 | 177.4 | 190.6 | 204.7 | 219.9 |
WACC, % | 7.38 | 7.38 | 7.41 | 7.38 | 7.4 | 7.39 | 7.39 | 7.39 | 7.39 | 7.39 |
PV UFCF | ||||||||||
SUM PV UFCF | 763.9 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 226 | |||||||||
Terminal Value | 5,159 | |||||||||
Present Terminal Value | 3,612 | |||||||||
Enterprise Value | 4,376 | |||||||||
Net Debt | 464 | |||||||||
Equity Value | 3,912 | |||||||||
Diluted Shares Outstanding, MM | 49 | |||||||||
Equity Value Per Share | 80.33 |
What You Will Get
- Real Arcosa Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Arcosa, Inc. (ACA).
- Full Customization: Adjust all critical parameters (yellow cells) such as WACC, growth %, and tax rates to fit your analysis needs.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on Arcosa’s fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and detailed projections specific to Arcosa, Inc. (ACA).
- Time-Saving and Accurate: Avoid the hassle of building models from scratch while ensuring precision and flexibility.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Arcosa, Inc. (ACA).
- WACC Calculator: Includes a pre-configured Weighted Average Cost of Capital sheet with adjustable inputs.
- Customizable Forecast Assumptions: Easily alter growth rates, capital expenditures, and discount rates specific to Arcosa, Inc. (ACA).
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Arcosa, Inc. (ACA).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Download: Obtain the pre-built Excel file featuring Arcosa, Inc. (ACA)'s financial data.
- Customize: Tailor your forecasts, including revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various projections and compare results immediately.
- Make Decisions: Utilize the valuation findings to inform your investment approach.
Why Choose This Calculator for Arcosa, Inc. (ACA)?
- User-Friendly Interface: Perfect for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
- Real-Time Valuation: Observe immediate updates to Arcosa’s valuation as you change inputs.
- Preloaded Data: Comes equipped with Arcosa’s current financial metrics for swift evaluations.
- Relied Upon by Experts: Employed by investors and analysts for making strategic decisions.
Who Should Use This Product?
- Finance Students: Master valuation techniques and apply them using real data related to Arcosa, Inc. (ACA).
- Academics: Integrate professional models into your coursework or research focused on Arcosa, Inc. (ACA).
- Investors: Validate your own assumptions and evaluate valuation outcomes for Arcosa, Inc. (ACA) stock.
- Analysts: Enhance your efficiency with a pre-built, customizable DCF model tailored for Arcosa, Inc. (ACA).
- Small Business Owners: Discover how large public companies like Arcosa, Inc. (ACA) are analyzed in the market.
What the Template Contains
- Historical Data: Includes Arcosa, Inc.'s (ACA) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Arcosa, Inc.'s (ACA) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Arcosa, Inc.'s (ACA) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.