ArcBest Corporation (ARCB) 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
ArcBest Corporation (ARCB) Bundle
Evaluate ArcBest Corporation’s financial outlook like an expert! This (ARCB) DCF Calculator provides pre-filled financial data along with the complete flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your 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 | 2,988.3 | 2,940.2 | 3,980.1 | 5,324.1 | 4,427.4 | 4,988.5 | 5,620.6 | 6,332.7 | 7,135.2 | 8,039.3 |
Revenue Growth, % | 0 | -1.61 | 35.37 | 33.77 | -16.84 | 12.67 | 12.67 | 12.67 | 12.67 | 12.67 |
EBITDA | 175.4 | 222.6 | 410.3 | 534.2 | 341.4 | 414.0 | 466.4 | 525.5 | 592.1 | 667.1 |
EBITDA, % | 5.87 | 7.57 | 10.31 | 10.03 | 7.71 | 8.3 | 8.3 | 8.3 | 8.3 | 8.3 |
Depreciation | 112.5 | 118.4 | 124.2 | 138.2 | 145.7 | 167.6 | 188.8 | 212.8 | 239.7 | 270.1 |
Depreciation, % | 3.76 | 4.03 | 3.12 | 2.59 | 3.29 | 3.36 | 3.36 | 3.36 | 3.36 | 3.36 |
EBIT | 62.9 | 104.2 | 286.1 | 396.0 | 195.6 | 246.4 | 277.6 | 312.8 | 352.4 | 397.0 |
EBIT, % | 2.11 | 3.54 | 7.19 | 7.44 | 4.42 | 4.94 | 4.94 | 4.94 | 4.94 | 4.94 |
Total Cash | 318.5 | 369.4 | 125.0 | 326.0 | 330.1 | 398.5 | 449.0 | 505.8 | 569.9 | 642.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 301.4 | 335.2 | 595.4 | 528.5 | 482.2 | 571.3 | 643.7 | 725.3 | 817.2 | 920.7 |
Account Receivables, % | 10.08 | 11.4 | 14.96 | 9.93 | 10.89 | 11.45 | 11.45 | 11.45 | 11.45 | 11.45 |
Inventories | 30.4 | 37.8 | 40.1 | 40.2 | .0 | 40.6 | 45.7 | 51.5 | 58.0 | 65.4 |
Inventories, % | 1.02 | 1.28 | 1.01 | 0.75582 | 0 | 0.81294 | 0.81294 | 0.81294 | 0.81294 | 0.81294 |
Accounts Payable | 134.4 | 170.9 | 311.4 | 269.9 | 214.0 | 279.7 | 315.1 | 355.1 | 400.1 | 450.8 |
Accounts Payable, % | 4.5 | 5.81 | 7.82 | 5.07 | 4.83 | 5.61 | 5.61 | 5.61 | 5.61 | 5.61 |
Capital Expenditure | -102.4 | -57.5 | -78.5 | -165.5 | -232.0 | -156.7 | -176.5 | -198.9 | -224.1 | -252.5 |
Capital Expenditure, % | -3.43 | -1.96 | -1.97 | -3.11 | -5.24 | -3.14 | -3.14 | -3.14 | -3.14 | -3.14 |
Tax Rate, % | 23.94 | 23.94 | 23.94 | 23.94 | 23.94 | 23.94 | 23.94 | 23.94 | 23.94 | 23.94 |
EBITAT | 48.9 | 80.1 | 220.4 | 300.4 | 148.8 | 189.0 | 212.9 | 239.9 | 270.3 | 304.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -138.4 | 136.3 | 144.1 | 298.3 | 93.2 | 136.0 | 183.1 | 206.3 | 232.5 | 261.9 |
WACC, % | 10.14 | 10.13 | 10.13 | 10.13 | 10.13 | 10.13 | 10.13 | 10.13 | 10.13 | 10.13 |
PV UFCF | ||||||||||
SUM PV UFCF | 748.6 | |||||||||
Long Term Growth Rate, % | 1.00 | |||||||||
Free cash flow (T + 1) | 265 | |||||||||
Terminal Value | 2,897 | |||||||||
Present Terminal Value | 1,788 | |||||||||
Enterprise Value | 2,537 | |||||||||
Net Debt | 176 | |||||||||
Equity Value | 2,361 | |||||||||
Diluted Shares Outstanding, MM | 25 | |||||||||
Equity Value Per Share | 95.85 |
What You Will Get
- Real ARCB Financial Data: Pre-filled with ArcBest Corporation’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See ArcBest Corporation’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive Financial Data: Gain access to precise historical performance and future forecasts for ArcBest Corporation (ARCB).
- Adjustable Forecast Parameters: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Instant updates for DCF, Net Present Value (NPV), and cash flow evaluations.
- User-Friendly Dashboard: Clear charts and summaries to help you interpret your valuation findings.
- Designed for All Skill Levels: An intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the prebuilt Excel template with ArcBest Corporation’s (ARCB) data included.
- Step 2: Explore the pre-filled sheets and familiarize yourself with the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including ArcBest Corporation’s (ARCB) intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose This Calculator for ArcBest Corporation (ARCB)?
- Accurate Data: Utilize real ArcBest financials for trustworthy valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of building from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the logistics sector.
- User-Friendly: Simple design and step-by-step guidance ensure accessibility for all users.
Who Should Use This Product?
- Logistics Professionals: Develop comprehensive and accurate logistics models for operational analysis.
- Supply Chain Managers: Evaluate shipping scenarios to optimize internal processes.
- Consultants and Advisors: Offer clients precise insights into the valuation of ArcBest Corporation (ARCB).
- Students and Educators: Utilize real-world logistics data to practice and teach financial modeling.
- Industry Analysts: Gain insights into how logistics companies like ArcBest Corporation (ARCB) are valued in the market.
What the Template Contains
- Pre-Filled DCF Model: ArcBest Corporation’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate ArcBest Corporation’s profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.