Kinder Morgan, Inc. (KMI) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Kinder Morgan, Inc. (KMI) Bundle
Save time and improve precision with our [KMI] DCF Calculator! Equipped with real data from Kinder Morgan, Inc. and customizable assumptions, this tool allows you to forecast, analyze, and value [Company] just like a seasoned investor.
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 | 13,209.0 | 11,700.0 | 16,610.0 | 19,200.0 | 15,334.0 | 15,648.7 | 15,969.8 | 16,297.6 | 16,632.0 | 16,973.4 |
| Revenue Growth, % | 0 | -11.42 | 41.97 | 15.59 | -20.14 | 2.05 | 2.05 | 2.05 | 2.05 | 2.05 |
| EBITDA | 7,364.0 | 5,656.0 | 6,675.0 | 6,219.0 | 6,440.0 | 6,843.7 | 6,984.2 | 7,127.5 | 7,273.8 | 7,423.0 |
| EBITDA, % | 55.75 | 48.34 | 40.19 | 32.39 | 42 | 43.73 | 43.73 | 43.73 | 43.73 | 43.73 |
| Depreciation | 2,411.0 | 2,164.0 | 2,135.0 | 2,186.0 | 2,250.0 | 2,368.0 | 2,416.6 | 2,466.2 | 2,516.8 | 2,568.4 |
| Depreciation, % | 18.25 | 18.5 | 12.85 | 11.39 | 14.67 | 15.13 | 15.13 | 15.13 | 15.13 | 15.13 |
| EBIT | 4,953.0 | 3,492.0 | 4,540.0 | 4,033.0 | 4,190.0 | 4,475.7 | 4,567.6 | 4,661.3 | 4,757.0 | 4,854.6 |
| EBIT, % | 37.5 | 29.85 | 27.33 | 21.01 | 27.32 | 28.6 | 28.6 | 28.6 | 28.6 | 28.6 |
| Total Cash | 185.0 | 1,184.0 | 1,140.0 | 745.0 | 83.0 | 713.7 | 728.4 | 743.3 | 758.6 | 774.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,370.0 | 1,293.0 | 1,611.0 | 1,840.0 | 1,588.0 | 1,598.1 | 1,630.9 | 1,664.4 | 1,698.5 | 1,733.4 |
| Account Receivables, % | 10.37 | 11.05 | 9.7 | 9.58 | 10.36 | 10.21 | 10.21 | 10.21 | 10.21 | 10.21 |
| Inventories | 371.0 | 348.0 | 562.0 | 634.0 | 525.0 | 497.4 | 507.6 | 518.0 | 528.6 | 539.5 |
| Inventories, % | 2.81 | 2.97 | 3.38 | 3.3 | 3.42 | 3.18 | 3.18 | 3.18 | 3.18 | 3.18 |
| Accounts Payable | 914.0 | 837.0 | 1,259.0 | 1,444.0 | 1,366.0 | 1,191.9 | 1,216.3 | 1,241.3 | 1,266.8 | 1,292.8 |
| Accounts Payable, % | 6.92 | 7.15 | 7.58 | 7.52 | 8.91 | 7.62 | 7.62 | 7.62 | 7.62 | 7.62 |
| Capital Expenditure | -2,270.0 | -1,707.0 | -1,281.0 | -1,621.0 | -2,345.0 | -1,978.7 | -2,019.3 | -2,060.8 | -2,103.0 | -2,146.2 |
| Capital Expenditure, % | -17.19 | -14.59 | -7.71 | -8.44 | -15.29 | -12.64 | -12.64 | -12.64 | -12.64 | -12.64 |
| Tax Rate, % | 25.3 | 25.3 | 25.3 | 25.3 | 25.3 | 25.3 | 25.3 | 25.3 | 25.3 | 25.3 |
| EBITAT | 3,427.2 | 950.9 | 3,650.0 | 3,081.3 | 3,129.7 | 2,935.4 | 2,995.6 | 3,057.1 | 3,119.8 | 3,183.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 2,741.2 | 1,430.9 | 4,394.0 | 3,530.3 | 3,317.7 | 3,168.0 | 3,374.3 | 3,443.6 | 3,514.2 | 3,586.4 |
| WACC, % | 6.78 | 6.13 | 6.95 | 6.89 | 6.86 | 6.72 | 6.72 | 6.72 | 6.72 | 6.72 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 14,064.4 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | 3,712 | |||||||||
| Terminal Value | 115,268 | |||||||||
| Present Terminal Value | 83,267 | |||||||||
| Enterprise Value | 97,332 | |||||||||
| Net Debt | 32,033 | |||||||||
| Equity Value | 65,299 | |||||||||
| Diluted Shares Outstanding, MM | 2,234 | |||||||||
| Equity Value Per Share | 29.23 |
What You Will Get
- Real KMI Financials: Access to historical and projected data for precise valuation.
- Adjustable Inputs: Customize WACC, tax rates, revenue growth, and capital expenditures.
- Automatic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Explore various scenarios to assess Kinder Morgan's future performance.
- Clear and Intuitive Design: Designed for industry professionals while remaining user-friendly for newcomers.
Key Features
- 🔍 Real-Life KMI Financials: Pre-filled historical and projected data for Kinder Morgan, Inc. (KMI).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) such as WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Kinder Morgan’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Kinder Morgan’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download: Get the pre-built Excel file featuring Kinder Morgan, Inc.'s (KMI) financial data.
- Customize: Modify projections, including revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and instantly compare results.
- Make Decisions: Leverage the valuation findings to inform your investment approach.
Why Choose This Calculator for Kinder Morgan, Inc. (KMI)?
- Designed for Experts: A sophisticated tool utilized by industry analysts, CFOs, and financial consultants.
- Accurate Data: Kinder Morgan’s historical and projected financials are preloaded for precise calculations.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Clear, step-by-step instructions lead you through every stage.
Who Should Use This Product?
- Energy Students: Explore pipeline valuation techniques and apply them using real-world data.
- Researchers: Integrate industry-specific models into academic studies or projects.
- Investors: Evaluate your investment strategies and assess valuation scenarios for Kinder Morgan, Inc. (KMI).
- Financial Analysts: Enhance your analysis with a customizable DCF model tailored for the energy sector.
- Entrepreneurs: Understand the valuation processes used for major energy companies like Kinder Morgan.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for Kinder Morgan, Inc. (KMI).
- Real-World Data: Kinder Morgan's historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables that present clear, actionable results for informed decision-making.