|
Valoración de DCF de Forward Air Corporation (FWRD)
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
Forward Air Corporation (FWRD) Bundle
¡Mejore su estrategia de inversión con la calculadora DCF (FWRD)! Utilice datos financieros de la corporación aérea auténtica, ajuste las predicciones y gastos de crecimiento e inmediatamente observe cómo estas modificaciones afectan el valor intrínseco de (FWRD).
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,410.4 | 1,269.6 | 1,662.4 | 1,973.4 | 1,370.7 | 1,402.0 | 1,434.0 | 1,466.7 | 1,500.2 | 1,534.4 |
| Revenue Growth, % | 0 | -9.98 | 30.94 | 18.71 | -30.54 | 2.28 | 2.28 | 2.28 | 2.28 | 2.28 |
| EBITDA | 148.8 | 111.0 | 198.9 | 290.1 | 145.6 | 158.7 | 162.3 | 166.0 | 169.8 | 173.6 |
| EBITDA, % | 10.55 | 8.75 | 11.96 | 14.7 | 10.62 | 11.32 | 11.32 | 11.32 | 11.32 | 11.32 |
| Depreciation | 36.4 | 37.1 | 39.6 | 42.6 | 57.4 | 39.9 | 40.8 | 41.7 | 42.7 | 43.7 |
| Depreciation, % | 2.58 | 2.92 | 2.38 | 2.16 | 4.19 | 2.85 | 2.85 | 2.85 | 2.85 | 2.85 |
| EBIT | 112.4 | 73.9 | 159.3 | 247.6 | 88.2 | 118.8 | 121.5 | 124.3 | 127.1 | 130.0 |
| EBIT, % | 7.97 | 5.82 | 9.58 | 12.55 | 6.44 | 8.47 | 8.47 | 8.47 | 8.47 | 8.47 |
| Total Cash | 64.7 | 40.3 | 37.3 | 45.8 | 122.0 | 59.5 | 60.9 | 62.3 | 63.7 | 65.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 136.2 | 156.5 | 216.2 | 188.2 | 158.7 | 157.3 | 160.9 | 164.6 | 168.3 | 172.2 |
| Account Receivables, % | 9.66 | 12.33 | 13 | 9.54 | 11.58 | 11.22 | 11.22 | 11.22 | 11.22 | 11.22 |
| Inventories | 2.1 | 21.0 | .0 | .0 | .0 | 5.1 | 5.2 | 5.3 | 5.4 | 5.5 |
| Inventories, % | 0.15116 | 1.65 | 0 | 0.0000000507 | 0 | 0.36108 | 0.36108 | 0.36108 | 0.36108 | 0.36108 |
| Accounts Payable | 25.4 | 38.4 | 44.8 | 50.1 | 45.4 | 37.5 | 38.4 | 39.2 | 40.1 | 41.0 |
| Accounts Payable, % | 1.8 | 3.02 | 2.7 | 2.54 | 3.31 | 2.67 | 2.67 | 2.67 | 2.67 | 2.67 |
| Capital Expenditure | -30.7 | -20.3 | -39.1 | -40.7 | -30.7 | -29.2 | -29.9 | -30.6 | -31.3 | -32.0 |
| Capital Expenditure, % | -2.17 | -1.6 | -2.35 | -2.06 | -2.24 | -2.09 | -2.09 | -2.09 | -2.09 | -2.09 |
| Tax Rate, % | -195.47 | -195.47 | -195.47 | -195.47 | -195.47 | -195.47 | -195.47 | -195.47 | -195.47 | -195.47 |
| EBITAT | 84.3 | 56.2 | 108.8 | 183.4 | 260.6 | 93.5 | 95.6 | 97.8 | 100.0 | 102.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -22.9 | 46.9 | 77.0 | 218.4 | 312.2 | 92.5 | 103.6 | 106.0 | 108.4 | 110.9 |
| WACC, % | 5.04 | 5.07 | 4.82 | 5.01 | 5.83 | 5.15 | 5.15 | 5.15 | 5.15 | 5.15 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 447.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 113 | |||||||||
| Terminal Value | 3,587 | |||||||||
| Present Terminal Value | 2,790 | |||||||||
| Enterprise Value | 3,238 | |||||||||
| Net Debt | 1,824 | |||||||||
| Equity Value | 1,414 | |||||||||
| Diluted Shares Outstanding, MM | 26 | |||||||||
| Equity Value Per Share | 54.37 |
What You Will Get
- Real Forward Air Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Forward Air Corporation (FWRD).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis needs.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on Forward Air’s fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and in-depth projections specific to Forward Air Corporation (FWRD).
- Time-Saving and Accurate: Eliminate the hassle of building models from scratch while ensuring precision and flexibility in your evaluations.
Key Features
- Comprehensive DCF Model: Features both unlevered and levered DCF valuation frameworks tailored for Forward Air Corporation (FWRD).
- Customizable WACC Tool: Ready-to-use Weighted Average Cost of Capital sheet with adjustable parameters.
- Modifiable Forecast Inputs: Adjust growth projections, capital investments, and discount rates as needed.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency metrics specifically for Forward Air Corporation (FWRD).
- Interactive Dashboard and Visuals: Graphical representations that highlight essential valuation indicators for straightforward analysis.
How It Works
- Download the Template: Gain immediate access to the Excel-based FWRD DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Forward Air’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial decisions.
Why Choose Forward Air Corporation (FWRD)?
- Streamlined Operations: Benefit from our efficient logistics solutions that save you time and resources.
- Enhanced Reliability: Our proven track record ensures dependable transportation and delivery services.
- Fully Tailored Services: Customize our offerings to meet your specific shipping and logistics needs.
- User-Friendly Technology: Our intuitive platforms make tracking and managing shipments effortless.
- Industry Expertise: Rely on our experienced team who are dedicated to providing top-notch service.
Who Should Use This Product?
- Investors: Evaluate Forward Air Corporation’s (FWRD) valuation before making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and assess financial forecasts.
- Startup Founders: Gain insights into how established logistics companies like Forward Air Corporation are appraised.
- Consultants: Create detailed valuation reports for clients in the logistics sector.
- Students and Educators: Utilize real-time data to practice and instruct on valuation strategies.
What the Template Contains
- Preloaded FWRD 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.