|
C.H. Valoración de DCF de Robinson Worldwide, Inc. (CHRW)
US | Industrials | Integrated Freight & Logistics | NASDAQ
|
- ✓ 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
C.H. Robinson Worldwide, Inc. (CHRW) Bundle
Simplificar C.H. ¡Valoración de Robinson Worldwide, Inc. (CHRW) con esta calculadora DCF personalizable! Con el Real C.H. Robinson Financials y entradas de pronóstico ajustable, puede probar escenarios y descubrir C.H. El valor razonable de Robinson en minutos.
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 | 15,309.5 | 16,207.1 | 23,102.1 | 24,696.6 | 17,596.4 | 18,764.8 | 20,010.7 | 21,339.3 | 22,756.2 | 24,267.1 |
| Revenue Growth, % | 0 | 5.86 | 42.54 | 6.9 | -28.75 | 6.64 | 6.64 | 6.64 | 6.64 | 6.64 |
| EBITDA | 890.4 | 775.0 | 1,173.4 | 1,359.6 | 613.6 | 925.8 | 987.3 | 1,052.8 | 1,122.7 | 1,197.3 |
| EBITDA, % | 5.82 | 4.78 | 5.08 | 5.51 | 3.49 | 4.93 | 4.93 | 4.93 | 4.93 | 4.93 |
| Depreciation | 100.4 | 101.7 | 91.3 | 92.8 | 99.0 | 98.2 | 104.7 | 111.7 | 119.1 | 127.0 |
| Depreciation, % | 0.65612 | 0.62767 | 0.39502 | 0.37566 | 0.56253 | 0.5234 | 0.5234 | 0.5234 | 0.5234 | 0.5234 |
| EBIT | 790.0 | 673.3 | 1,082.1 | 1,266.8 | 514.6 | 827.6 | 882.6 | 941.2 | 1,003.6 | 1,070.3 |
| EBIT, % | 5.16 | 4.15 | 4.68 | 5.13 | 2.92 | 4.41 | 4.41 | 4.41 | 4.41 | 4.41 |
| Total Cash | 447.9 | 243.8 | 257.4 | 217.5 | 145.5 | 272.1 | 290.2 | 309.5 | 330.0 | 351.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 2,107.3 | 2,646.8 | 4,417.1 | 3,249.4 | 2,571.9 | 2,889.3 | 3,081.2 | 3,285.8 | 3,503.9 | 3,736.6 |
| Account Receivables, % | 13.76 | 16.33 | 19.12 | 13.16 | 14.62 | 15.4 | 15.4 | 15.4 | 15.4 | 15.4 |
| Inventories | -132.9 | -197.2 | -453.7 | .0 | .0 | -151.9 | -162.0 | -172.8 | -184.2 | -196.5 |
| Inventories, % | -0.86792 | -1.22 | -1.96 | 0.00000000405 | 0 | -0.80965 | -0.80965 | -0.80965 | -0.80965 | -0.80965 |
| Accounts Payable | 984.6 | 1,195.1 | 1,813.5 | 1,467.0 | 1,304.0 | 1,313.7 | 1,401.0 | 1,494.0 | 1,593.2 | 1,699.0 |
| Accounts Payable, % | 6.43 | 7.37 | 7.85 | 5.94 | 7.41 | 7 | 7 | 7 | 7 | 7 |
| Capital Expenditure | -70.5 | -54.0 | -70.9 | -128.5 | -84.1 | -78.8 | -84.0 | -89.6 | -95.5 | -101.9 |
| Capital Expenditure, % | -0.46027 | -0.33324 | -0.30699 | -0.5203 | -0.478 | -0.41976 | -0.41976 | -0.41976 | -0.41976 | -0.41976 |
| Tax Rate, % | 20.54 | 20.54 | 20.54 | 20.54 | 20.54 | 20.54 | 20.54 | 20.54 | 20.54 | 20.54 |
| EBITAT | 614.1 | 542.6 | 893.6 | 1,021.1 | 408.9 | 663.7 | 707.8 | 754.8 | 804.9 | 858.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -345.7 | 325.7 | 18.4 | 1,353.1 | 938.2 | 527.4 | 634.0 | 676.1 | 721.0 | 768.8 |
| WACC, % | 7.85 | 7.87 | 7.89 | 7.87 | 7.86 | 7.87 | 7.87 | 7.87 | 7.87 | 7.87 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2,631.4 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 792 | |||||||||
| Terminal Value | 16,266 | |||||||||
| Present Terminal Value | 11,138 | |||||||||
| Enterprise Value | 13,769 | |||||||||
| Net Debt | 1,807 | |||||||||
| Equity Value | 11,962 | |||||||||
| Diluted Shares Outstanding, MM | 120 | |||||||||
| Equity Value Per Share | 99.95 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: C.H. Robinson's financial data pre-filled to expedite your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive Data: C.H. Robinson's historical financial statements and pre-filled forecasts.
- Customizable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Insights: Observe C.H. Robinson's intrinsic value recalculating instantly.
- Intuitive Visuals: Dashboard charts illustrate valuation results and essential metrics.
- Designed for Precision: A professional tool tailored for analysts, investors, and finance professionals.
How It Works
- Download the Template: Gain immediate access to the Excel-based CHRW DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates C.H. Robinson's intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial decision-making.
Why Choose This Calculator for C.H. Robinson Worldwide, Inc. (CHRW)?
- Designed for Industry Experts: A sophisticated tool utilized by logistics managers, financial analysts, and supply chain consultants.
- Accurate Data Integration: C.H. Robinson's historical and projected financials are preloaded for precise analysis.
- Versatile Scenario Analysis: Effortlessly test various logistics scenarios and market assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential performance metrics.
- User-Friendly Interface: Step-by-step guidance ensures a seamless experience throughout the calculation process.
Who Should Use This Product?
- Logistics Professionals: Optimize supply chain strategies with accurate data analysis for C.H. Robinson Worldwide, Inc. (CHRW).
- Corporate Operations Teams: Evaluate operational efficiencies to enhance business performance.
- Consultants and Advisors: Deliver precise insights on logistics and transportation solutions for clients.
- Students and Educators: Utilize industry data to learn and teach about logistics management and supply chain principles.
- Business Analysts: Gain a deeper understanding of the logistics sector and market trends impacting C.H. Robinson Worldwide, Inc. (CHRW).
What the Template Contains
- Pre-Filled DCF Model: C.H. Robinson's financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate C.H. Robinson'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.