|
Valoración de DCF de Brookfield Infrastructure Corporation (BIPC)
US | Utilities | Regulated Gas | NYSE
|
- ✓ 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
Brookfield Infrastructure Corporation (BIPC) Bundle
¡Descubra el verdadero valor de Brookfield Infrastructure Corporation (BIPC) utilizando nuestra calculadora DCF avanzada! Ajuste los supuestos esenciales, explore varios escenarios y evalúe cómo los diferentes cambios afectan la valoración de la Corporación de Infraestructura de Brookfield (BIPC), todo dentro de una sola plantilla de Excel.
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,619.0 | 1,430.0 | 1,643.0 | 1,886.0 | 2,503.0 | 2,820.4 | 3,178.1 | 3,581.1 | 4,035.3 | 4,547.0 |
| Revenue Growth, % | 0 | -11.67 | 14.9 | 14.79 | 32.71 | 12.68 | 12.68 | 12.68 | 12.68 | 12.68 |
| EBITDA | 1,301.0 | 562.2 | 953.5 | 2,527.7 | 2,036.0 | 2,025.4 | 2,282.2 | 2,571.6 | 2,897.7 | 3,265.2 |
| EBITDA, % | 80.36 | 39.32 | 58.04 | 134.03 | 81.34 | 71.81 | 71.81 | 71.81 | 71.81 | 71.81 |
| Depreciation | 315.2 | 297.9 | 233.9 | 202.6 | 365.0 | 450.5 | 507.6 | 572.0 | 644.6 | 726.3 |
| Depreciation, % | 19.47 | 20.84 | 14.24 | 10.74 | 14.58 | 15.97 | 15.97 | 15.97 | 15.97 | 15.97 |
| EBIT | 985.8 | 264.3 | 719.6 | 2,325.1 | 1,671.0 | 1,635.4 | 1,842.8 | 2,076.5 | 2,339.9 | 2,636.6 |
| EBIT, % | 60.89 | 18.48 | 43.8 | 123.28 | 66.76 | 57.99 | 57.99 | 57.99 | 57.99 | 57.99 |
| Total Cash | 204.0 | 192.0 | 469.0 | 445.0 | 577.0 | 571.0 | 643.4 | 725.0 | 816.9 | 920.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 356.0 | 345.0 | 1,493.0 | 1,006.5 | 888.0 | 1,273.9 | 1,435.4 | 1,617.5 | 1,822.6 | 2,053.7 |
| Account Receivables, % | 21.99 | 24.13 | 90.87 | 53.37 | 35.48 | 45.17 | 45.17 | 45.17 | 45.17 | 45.17 |
| Inventories | .0 | -49.0 | -45.9 | -57.0 | .0 | -52.1 | -58.8 | -66.2 | -74.6 | -84.1 |
| Inventories, % | 0 | -3.43 | -2.8 | -3.02 | 0 | -1.85 | -1.85 | -1.85 | -1.85 | -1.85 |
| Accounts Payable | 90.0 | 84.0 | 39.0 | 44.0 | 85.0 | 110.2 | 124.2 | 139.9 | 157.7 | 177.7 |
| Accounts Payable, % | 5.56 | 5.87 | 2.37 | 2.33 | 3.4 | 3.91 | 3.91 | 3.91 | 3.91 | 3.91 |
| Capital Expenditure | -465.6 | -399.0 | -415.0 | -521.0 | -594.0 | -751.8 | -847.1 | -954.5 | -1,075.6 | -1,212.0 |
| Capital Expenditure, % | -28.76 | -27.9 | -25.26 | -27.62 | -23.73 | -26.65 | -26.65 | -26.65 | -26.65 | -26.65 |
| Tax Rate, % | 88.6 | 88.6 | 88.6 | 88.6 | 88.6 | 88.6 | 88.6 | 88.6 | 88.6 | 88.6 |
| EBITAT | 667.4 | -1,657.0 | 45.0 | 2,001.2 | 190.4 | 560.7 | 631.8 | 711.9 | 802.2 | 903.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 251.0 | -1,704.0 | -1,332.1 | 2,185.4 | 64.0 | -49.1 | 151.4 | 170.5 | 192.2 | 216.5 |
| WACC, % | 6.17 | 3.47 | 3.72 | 6.9 | 3.93 | 4.84 | 4.84 | 4.84 | 4.84 | 4.84 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 568.9 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 218 | |||||||||
| Terminal Value | 5,017 | |||||||||
| Present Terminal Value | 3,962 | |||||||||
| Enterprise Value | 4,531 | |||||||||
| Net Debt | 11,515 | |||||||||
| Equity Value | -6,984 | |||||||||
| Diluted Shares Outstanding, MM | 143 | |||||||||
| Equity Value Per Share | -48.84 |
What You Will Receive
- Comprehensive Financial Model: Utilize Brookfield Infrastructure Corporation’s (BIPC) actual data for accurate DCF valuation.
- Complete Forecasting Flexibility: Modify revenue growth, margins, WACC, and other essential parameters.
- Real-Time Calculations: Automatic updates provide immediate visibility to results as adjustments are made.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation outputs.
- Adaptable and Reusable: Designed for versatility, enabling repeated application for in-depth forecasts.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Brookfield Infrastructure Corporation (BIPC).
- WACC Calculator: Ready-to-use Weighted Average Cost of Capital sheet with adjustable inputs specific to (BIPC).
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit (BIPC) projections.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Brookfield Infrastructure Corporation (BIPC).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis of (BIPC).
How It Works
- Download the Template: Gain immediate access to the Excel-based BIPC DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Brookfield Infrastructure's intrinsic value.
- Test Scenarios: Experiment with different assumptions to see how valuations may vary.
- Analyze and Decide: Leverage the results to inform your investment or financial analysis.
Why Choose the Brookfield Infrastructure Calculator?
- Designed for Industry Experts: A sophisticated tool tailored for analysts, CFOs, and infrastructure consultants.
- Comprehensive Data: Brookfield Infrastructure's historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance ensures a smooth and intuitive experience.
Who Should Use This Product?
- Individual Investors: Gain insights to make informed decisions regarding investments in Brookfield Infrastructure Corporation (BIPC).
- Financial Analysts: Enhance valuation processes with comprehensive financial models tailored for Brookfield Infrastructure Corporation (BIPC).
- Consultants: Provide clients with accurate and timely valuation insights related to Brookfield Infrastructure Corporation (BIPC).
- Business Owners: Learn how infrastructure companies like Brookfield Infrastructure Corporation (BIPC) are valued to inform your own business strategies.
- Finance Students: Explore valuation methodologies using real-world examples from Brookfield Infrastructure Corporation (BIPC).
What the Template Contains
- Preloaded BIPC 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.