Knight-Swift Transportation Holdings Inc. (KNX) 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
Knight-Swift Transportation Holdings Inc. (KNX) Bundle
Evaluate Knight-Swift Transportation Holdings Inc.'s (KNX) financial outlook like an expert! This (KNX) DCF Calculator provides you with pre-filled financial data and full 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 | 4,844.0 | 4,673.9 | 5,998.0 | 7,428.6 | 7,141.8 | 7,941.8 | 8,831.5 | 9,820.8 | 10,921.0 | 12,144.4 |
Revenue Growth, % | 0 | -3.51 | 28.33 | 23.85 | -3.86 | 11.2 | 11.2 | 11.2 | 11.2 | 11.2 |
EBITDA | 1,027.1 | 1,165.2 | 1,618.9 | 1,773.1 | 1,132.5 | 1,792.5 | 1,993.3 | 2,216.6 | 2,464.9 | 2,741.0 |
EBITDA, % | 21.2 | 24.93 | 26.99 | 23.87 | 15.86 | 22.57 | 22.57 | 22.57 | 22.57 | 22.57 |
Depreciation | 583.7 | 587.6 | 623.1 | 701.8 | 735.1 | 869.6 | 967.0 | 1,075.4 | 1,195.8 | 1,329.8 |
Depreciation, % | 12.05 | 12.57 | 10.39 | 9.45 | 10.29 | 10.95 | 10.95 | 10.95 | 10.95 | 10.95 |
EBIT | 443.4 | 577.6 | 995.8 | 1,071.3 | 397.4 | 922.8 | 1,026.2 | 1,141.2 | 1,269.0 | 1,411.2 |
EBIT, % | 9.15 | 12.36 | 16.6 | 14.42 | 5.56 | 11.62 | 11.62 | 11.62 | 11.62 | 11.62 |
Total Cash | 159.7 | 156.7 | 261.0 | 196.8 | 466.4 | 320.5 | 356.4 | 396.4 | 440.8 | 490.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 531.2 | 593.0 | 937.0 | 858.2 | 966.7 | 1,022.4 | 1,136.9 | 1,264.2 | 1,405.9 | 1,563.4 |
Account Receivables, % | 10.97 | 12.69 | 15.62 | 11.55 | 13.54 | 12.87 | 12.87 | 12.87 | 12.87 | 12.87 |
Inventories | 154.2 | 149.7 | 191.8 | 341.7 | .0 | 225.3 | 250.5 | 278.6 | 309.8 | 344.5 |
Inventories, % | 3.18 | 3.2 | 3.2 | 4.6 | 0 | 2.84 | 2.84 | 2.84 | 2.84 | 2.84 |
Accounts Payable | 99.2 | 101.0 | 224.8 | 220.8 | 355.2 | 252.6 | 280.9 | 312.4 | 347.4 | 386.3 |
Accounts Payable, % | 2.05 | 2.16 | 3.75 | 2.97 | 4.97 | 3.18 | 3.18 | 3.18 | 3.18 | 3.18 |
Capital Expenditure | -830.0 | -521.1 | -534.1 | -800.6 | -1,071.6 | -1,000.2 | -1,112.2 | -1,236.8 | -1,375.4 | -1,529.4 |
Capital Expenditure, % | -17.13 | -11.15 | -8.9 | -10.78 | -15 | -12.59 | -12.59 | -12.59 | -12.59 | -12.59 |
Tax Rate, % | 19.66 | 19.66 | 19.66 | 19.66 | 19.66 | 19.66 | 19.66 | 19.66 | 19.66 | 19.66 |
EBITAT | 331.2 | 422.7 | 759.5 | 809.7 | 319.3 | 701.5 | 780.0 | 867.4 | 964.6 | 1,072.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -501.3 | 433.6 | 586.3 | 635.9 | 350.2 | 187.4 | 523.4 | 582.0 | 647.2 | 719.8 |
WACC, % | 7.61 | 7.59 | 7.63 | 7.62 | 7.67 | 7.62 | 7.62 | 7.62 | 7.62 | 7.62 |
PV UFCF | ||||||||||
SUM PV UFCF | 2,073.9 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 741 | |||||||||
Terminal Value | 16,037 | |||||||||
Present Terminal Value | 11,107 | |||||||||
Enterprise Value | 13,181 | |||||||||
Net Debt | 2,207 | |||||||||
Equity Value | 10,973 | |||||||||
Diluted Shares Outstanding, MM | 162 | |||||||||
Equity Value Per Share | 67.81 |
What You Will Get
- Pre-Filled Financial Model: Knight-Swift's actual data facilitates accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, margins, WACC, and other essential drivers.
- Instant Calculations: Real-time updates ensure you see results immediately as you make adjustments.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation.
- Customizable and Reusable: Designed for flexibility, allowing for repeated use in comprehensive forecasts.
Key Features
- Comprehensive KNX Data: Pre-filled with Knight-Swift's historical performance metrics and future growth forecasts.
- Customizable Assumptions: Tailor inputs for revenue growth, operating margins, WACC, tax rates, and capital expenditures.
- Interactive Valuation Framework: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on your customized inputs.
- Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation possibilities.
- Intuitive Interface: Designed for ease of use, catering to both seasoned professionals and newcomers.
How It Works
- 1. Access the Template: Download and open the Excel file containing Knight-Swift Transportation Holdings Inc.'s preloaded data.
- 2. Modify Assumptions: Adjust essential inputs such as growth rates, WACC, and capital expenditures specific to (KNX).
- 3. View Results in Real-Time: The DCF model automatically calculates intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation results for (KNX).
- 5. Present with Assurance: Deliver professional valuation insights to enhance your decision-making process for (KNX).
Why Choose Knight-Swift Transportation Holdings Inc. (KNX)?
- Streamlined Operations: Benefit from an established logistics network that enhances efficiency.
- Data-Driven Decisions: Access to reliable analytics and insights for informed strategic planning.
- Flexible Solutions: Customize services to meet your specific transportation needs and goals.
- User-Friendly Interface: Intuitive tools and resources simplify the management of your logistics.
- Industry Expertise: Rely on a team of professionals dedicated to delivering top-notch transportation services.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Knight-Swift Transportation Holdings Inc. (KNX) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models specific to Knight-Swift Transportation Holdings Inc. (KNX).
- Consultants: Deliver professional valuation insights on Knight-Swift Transportation Holdings Inc. (KNX) to clients quickly and accurately.
- Business Owners: Understand how large transportation companies like Knight-Swift Transportation Holdings Inc. (KNX) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Knight-Swift Transportation Holdings Inc. (KNX).
What the Template Contains
- Pre-Filled DCF Model: Knight-Swift’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Knight-Swift’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.