Kirby Corporation (KEX) 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
Kirby Corporation (KEX) Bundle
Evaluate Kirby Corporation's (KEX) financial outlook like an expert! This (KEX) DCF Calculator comes with pre-loaded financials and offers 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 | 2,838.4 | 2,171.4 | 2,246.7 | 2,784.8 | 3,091.6 | 3,207.1 | 3,326.9 | 3,451.1 | 3,580.0 | 3,713.7 |
| Revenue Growth, % | 0 | -23.5 | 3.47 | 23.95 | 11.02 | 3.73 | 3.73 | 3.73 | 3.73 | 3.73 |
| EBITDA | 489.4 | -162.5 | -31.9 | 400.0 | 546.0 | 258.9 | 268.6 | 278.6 | 289.0 | 299.8 |
| EBITDA, % | 17.24 | -7.48 | -1.42 | 14.36 | 17.66 | 8.07 | 8.07 | 8.07 | 8.07 | 8.07 |
| Depreciation | 243.6 | 250.1 | 246.9 | 230.5 | 211.2 | 296.3 | 307.4 | 318.9 | 330.8 | 343.1 |
| Depreciation, % | 8.58 | 11.52 | 10.99 | 8.28 | 6.83 | 9.24 | 9.24 | 9.24 | 9.24 | 9.24 |
| EBIT | 245.8 | -412.6 | -278.8 | 169.5 | 334.9 | -37.4 | -38.8 | -40.3 | -41.8 | -43.3 |
| EBIT, % | 8.66 | -19 | -12.41 | 6.09 | 10.83 | -1.17 | -1.17 | -1.17 | -1.17 | -1.17 |
| Total Cash | 24.7 | 80.3 | 34.8 | 80.6 | 32.6 | 64.6 | 67.0 | 69.5 | 72.1 | 74.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 483.3 | 600.2 | 567.9 | 598.0 | 578.7 | 706.5 | 732.8 | 760.2 | 788.6 | 818.0 |
| Account Receivables, % | 17.03 | 27.64 | 25.28 | 21.47 | 18.72 | 22.03 | 22.03 | 22.03 | 22.03 | 22.03 |
| Inventories | 351.4 | 309.7 | 331.4 | 461.8 | 454.4 | 466.1 | 483.5 | 501.6 | 520.3 | 539.8 |
| Inventories, % | 12.38 | 14.26 | 14.75 | 16.58 | 14.7 | 14.53 | 14.53 | 14.53 | 14.53 | 14.53 |
| Accounts Payable | 206.8 | 162.5 | 199.1 | 278.1 | 269.4 | 271.5 | 281.6 | 292.2 | 303.1 | 314.4 |
| Accounts Payable, % | 7.29 | 7.48 | 8.86 | 9.99 | 8.71 | 8.47 | 8.47 | 8.47 | 8.47 | 8.47 |
| Capital Expenditure | -248.2 | -148.2 | -98.0 | -172.6 | -401.7 | -250.9 | -260.3 | -270.0 | -280.1 | -290.6 |
| Capital Expenditure, % | -8.74 | -6.82 | -4.36 | -6.2 | -12.99 | -7.82 | -7.82 | -7.82 | -7.82 | -7.82 |
| Tax Rate, % | 24.2 | 24.2 | 24.2 | 24.2 | 24.2 | 24.2 | 24.2 | 24.2 | 24.2 | 24.2 |
| EBITAT | 184.3 | -242.9 | -236.8 | 125.6 | 253.8 | -27.6 | -28.6 | -29.7 | -30.8 | -32.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -448.2 | -260.3 | -40.7 | 102.0 | 81.3 | -119.6 | -15.2 | -15.8 | -16.3 | -17.0 |
| WACC, % | 8.96 | 8.85 | 9.03 | 8.95 | 8.97 | 8.95 | 8.95 | 8.95 | 8.95 | 8.95 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -157.4 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | -17 | |||||||||
| Terminal Value | -293 | |||||||||
| Present Terminal Value | -191 | |||||||||
| Enterprise Value | -348 | |||||||||
| Net Debt | 1,156 | |||||||||
| Equity Value | -1,505 | |||||||||
| Diluted Shares Outstanding, MM | 60 | |||||||||
| Equity Value Per Share | -25.14 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real KEX financials.
- Authentic Data: Historical data and forward-looking projections (highlighted in the yellow cells).
- Assumption Flexibility: Modify forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe the effects of your inputs on Kirby Corporation’s valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Layout: Organized for clarity and ease of use, complete with step-by-step guidance.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Kirby Corporation (KEX).
- WACC Calculator: Ready-to-use Weighted Average Cost of Capital sheet with adjustable inputs specific to Kirby Corporation (KEX).
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit your analysis of Kirby Corporation (KEX).
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Kirby Corporation (KEX).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis of Kirby Corporation (KEX).
How It Works
- Download the Template: Gain immediate access to the Excel-based KEX DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
- Instant Calculations: The model automatically recalculates Kirby Corporation’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial assessment.
Why Choose This Calculator for Kirby Corporation (KEX)?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for Kirby Corporation (KEX).
- Flexible Inputs: Modify the yellow-highlighted fields to explore different financial scenarios.
- In-Depth Analysis: Automatically computes the intrinsic value and Net Present Value for Kirby Corporation (KEX).
- Preloaded Information: Access historical and projected data for accurate financial assessments.
- High-Quality Standards: Perfect for financial analysts, investors, and business consultants focusing on Kirby Corporation (KEX).
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for portfolio assessment of Kirby Corporation (KEX).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights to clients regarding Kirby Corporation (KEX) stock.
- Students and Educators: Utilize real-time data to practice and teach financial modeling techniques.
- Industry Analysts: Gain insights into how companies like Kirby Corporation (KEX) are valued in the marketplace.
What the Template Contains
- Pre-Filled DCF Model: Kirby Corporation’s (KEX) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Kirby Corporation’s (KEX) 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.