|
Valoración de DCF de transporte e infraestructura de fortaleza LLC (FTAI)
US | Industrials | Rental & Leasing Services | 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
Fortress Transportation and Infrastructure Investors LLC (FTAI) Bundle
Ingementista para su precisión, nuestra calculadora DCF (FTAI) le permite evaluar la valoración del transporte de fortalezas e Infraestructura Investores LLC utilizando datos financieros del mundo real, que ofrece una flexibilidad completa para modificar todos los parámetros esenciales para las proyecciones mejoradas.
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 | 578.8 | 366.5 | 455.8 | 708.4 | 1,170.9 | 1,488.2 | 1,891.5 | 2,404.1 | 3,055.5 | 3,883.5 |
| Revenue Growth, % | 0 | -36.68 | 24.37 | 55.42 | 65.28 | 27.1 | 27.1 | 27.1 | 27.1 | 27.1 |
| EBITDA | 241.4 | 245.8 | 263.0 | 230.7 | 530.7 | 727.4 | 924.5 | 1,175.0 | 1,493.5 | 1,898.2 |
| EBITDA, % | 41.71 | 67.08 | 57.71 | 32.57 | 45.32 | 48.88 | 48.88 | 48.88 | 48.88 | 48.88 |
| Depreciation | 176.2 | 176.1 | 147.7 | 166.8 | 185.0 | 447.3 | 568.5 | 722.5 | 918.3 | 1,167.2 |
| Depreciation, % | 30.44 | 48.06 | 32.41 | 23.55 | 15.8 | 30.05 | 30.05 | 30.05 | 30.05 | 30.05 |
| EBIT | 65.2 | 69.7 | 115.3 | 63.9 | 345.7 | 280.1 | 356.0 | 452.5 | 575.1 | 731.0 |
| EBIT, % | 11.27 | 19.02 | 25.29 | 9.02 | 29.52 | 18.82 | 18.82 | 18.82 | 18.82 | 18.82 |
| Total Cash | 226.5 | 121.7 | 188.1 | 33.6 | 90.8 | 375.3 | 477.0 | 606.3 | 770.6 | 979.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 57.8 | 99.3 | 132.5 | 155.0 | 118.2 | 292.1 | 371.2 | 471.8 | 599.7 | 762.2 |
| Account Receivables, % | 9.98 | 27.1 | 29.07 | 21.89 | 10.09 | 19.63 | 19.63 | 19.63 | 19.63 | 19.63 |
| Inventories | 15.2 | 58.3 | 107.1 | -8.6 | 316.6 | 202.0 | 256.7 | 326.3 | 414.7 | 527.1 |
| Inventories, % | 2.63 | 15.91 | 23.5 | -1.21 | 27.04 | 13.57 | 13.57 | 13.57 | 13.57 | 13.57 |
| Accounts Payable | 121.5 | 110.4 | 87.0 | 81.7 | 106.5 | 270.4 | 343.6 | 436.7 | 555.1 | 705.5 |
| Accounts Payable, % | 20.98 | 30.13 | 19.09 | 11.53 | 9.09 | 18.17 | 18.17 | 18.17 | 18.17 | 18.17 |
| Capital Expenditure | -900.7 | -594.8 | -767.6 | -813.7 | -776.9 | -1,388.0 | -1,764.2 | -2,242.3 | -2,849.9 | -3,622.2 |
| Capital Expenditure, % | -155.63 | -162.29 | -168.41 | -114.86 | -66.35 | -93.27 | -93.27 | -93.27 | -93.27 | -93.27 |
| Tax Rate, % | -32.5 | -32.5 | -32.5 | -32.5 | -32.5 | -32.5 | -32.5 | -32.5 | -32.5 | -32.5 |
| EBITAT | 57.6 | 66.0 | 114.4 | 67.1 | 458.0 | 270.1 | 343.3 | 436.4 | 554.6 | 704.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -618.5 | -448.3 | -610.9 | -491.9 | -397.5 | -566.0 | -913.0 | -1,160.4 | -1,474.9 | -1,874.6 |
| WACC, % | 12.82 | 12.89 | 12.94 | 12.95 | 12.95 | 12.91 | 12.91 | 12.91 | 12.91 | 12.91 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -3,952.6 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -1,912 | |||||||||
| Terminal Value | -17,526 | |||||||||
| Present Terminal Value | -9,550 | |||||||||
| Enterprise Value | -13,503 | |||||||||
| Net Debt | 2,427 | |||||||||
| Equity Value | -15,930 | |||||||||
| Diluted Shares Outstanding, MM | 100 | |||||||||
| Equity Value Per Share | -158.62 |
What You Will Receive
- Accurate FTAI Financial Data: Pre-loaded with Fortress Transportation and Infrastructure Investors LLC’s historical and forecasted data for thorough analysis.
- Completely Customizable Template: Easily adjust essential inputs such as revenue growth, WACC, and EBITDA %.
- Instant Calculations: Observe FTAI’s intrinsic value update in real-time as you make adjustments.
- Expert Valuation Tool: Crafted for investors, analysts, and consultants aiming for precise DCF outcomes.
- Intuitive Design: Straightforward layout and clear guidelines suitable for all skill levels.
Key Features
- 🔍 Real-Life FTAI Financials: Pre-filled historical and projected data for Fortress Transportation and Infrastructure Investors LLC (FTAI).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate FTAI’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize FTAI’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the prebuilt Excel template containing FTAI’s data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the updated results, including FTAI’s intrinsic value.
- Step 5: Utilize the outputs to make informed investment decisions or create reports.
Why Choose This Calculator for Fortress Transportation and Infrastructure Investors LLC (FTAI)?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for FTAI.
- Flexible Inputs: Modify the yellow-highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes FTAI’s intrinsic value and Net Present Value.
- Data-Rich Environment: Historical and projected data provide reliable benchmarks.
- Expert-Level Precision: Perfect for financial analysts, investors, and business strategists focused on FTAI.
Who Should Use This Product?
- Finance Students: Explore infrastructure investment strategies and apply them with real-world data.
- Academics: Integrate advanced financial models into your research or teaching materials.
- Investors: Validate your investment hypotheses and evaluate the performance of Fortress Transportation and Infrastructure Investors LLC (FTAI).
- Analysts: Enhance your analysis with a ready-to-use, customizable valuation model tailored for infrastructure investments.
- Small Business Owners: Understand the valuation processes used for large-scale infrastructure companies like Fortress Transportation and Infrastructure Investors LLC (FTAI).
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations.
- Real-World Data: Fortress Transportation and Infrastructure Investors LLC’s (FTAI) historical and projected financials preloaded for analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables that provide clear, actionable results.