Brookfield Infrastructure Partners L.P. (BIP) 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
Brookfield Infrastructure Partners L.P. (BIP) Bundle
Designed for accuracy, our (BIP) DCF Calculator enables you to evaluate Brookfield Infrastructure Partners L.P. valuation using real-world financial data, while providing the flexibility to modify all key parameters for enhanced 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 | 6,597.0 | 8,885.0 | 11,537.0 | 14,427.0 | 17,931.0 | 19,010.5 | 20,154.9 | 21,368.3 | 22,654.7 | 24,018.5 |
Revenue Growth, % | 0 | 34.68 | 29.85 | 25.05 | 24.29 | 6.02 | 6.02 | 6.02 | 6.02 | 6.02 |
EBITDA | 2,822.0 | 3,948.0 | 6,749.0 | 5,936.0 | 7,022.0 | 8,593.4 | 9,110.7 | 9,659.2 | 10,240.7 | 10,857.2 |
EBITDA, % | 42.78 | 44.43 | 58.5 | 41.15 | 39.16 | 45.2 | 45.2 | 45.2 | 45.2 | 45.2 |
Depreciation | 1,214.0 | 1,705.0 | 2,036.0 | 2,158.0 | 2,739.0 | 3,249.8 | 3,445.4 | 3,652.8 | 3,872.7 | 4,105.9 |
Depreciation, % | 18.4 | 19.19 | 17.65 | 14.96 | 15.28 | 17.09 | 17.09 | 17.09 | 17.09 | 17.09 |
EBIT | 1,608.0 | 2,243.0 | 4,713.0 | 3,778.0 | 4,283.0 | 5,343.6 | 5,665.3 | 6,006.4 | 6,367.9 | 6,751.3 |
EBIT, % | 24.37 | 25.24 | 40.85 | 26.19 | 23.89 | 28.11 | 28.11 | 28.11 | 28.11 | 28.11 |
Total Cash | 827.0 | 867.0 | 1,406.0 | 1,279.0 | 2,442.0 | 2,165.9 | 2,296.3 | 2,434.5 | 2,581.0 | 2,736.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1,802.0 | 1,543.0 | 1,923.0 | 2,342.0 | 3,734.0 | 3,741.5 | 3,966.8 | 4,205.6 | 4,458.8 | 4,727.2 |
Account Receivables, % | 27.32 | 17.37 | 16.67 | 16.23 | 20.82 | 19.68 | 19.68 | 19.68 | 19.68 | 19.68 |
Inventories | 242.0 | 221.0 | 400.0 | 531.0 | 512.0 | 614.4 | 651.4 | 690.6 | 732.1 | 776.2 |
Inventories, % | 3.67 | 2.49 | 3.47 | 3.68 | 2.86 | 3.23 | 3.23 | 3.23 | 3.23 | 3.23 |
Accounts Payable | 973.0 | 1,461.0 | 1,877.0 | 1,872.0 | 2,253.0 | 2,775.6 | 2,942.7 | 3,119.9 | 3,307.7 | 3,506.8 |
Accounts Payable, % | 14.75 | 16.44 | 16.27 | 12.98 | 12.56 | 14.6 | 14.6 | 14.6 | 14.6 | 14.6 |
Capital Expenditure | -1,144.0 | -1,426.0 | -1,982.0 | -2,734.0 | -2,487.0 | -3,170.6 | -3,361.5 | -3,563.8 | -3,778.4 | -4,005.8 |
Capital Expenditure, % | -17.34 | -16.05 | -17.18 | -18.95 | -13.87 | -16.68 | -16.68 | -16.68 | -16.68 | -16.68 |
Tax Rate, % | 81.91 | 81.91 | 81.91 | 81.91 | 81.91 | 81.91 | 81.91 | 81.91 | 81.91 | 81.91 |
EBITAT | 1,126.3 | 1,696.8 | 3,844.8 | 2,684.6 | 774.7 | 3,381.6 | 3,585.2 | 3,801.0 | 4,029.8 | 4,272.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 125.3 | 2,743.8 | 3,755.8 | 1,553.6 | 34.7 | 3,873.5 | 3,574.0 | 3,789.1 | 4,017.3 | 4,259.1 |
WACC, % | 4.87 | 5.09 | 5.32 | 4.91 | 2.84 | 4.6 | 4.6 | 4.6 | 4.6 | 4.6 |
PV UFCF | ||||||||||
SUM PV UFCF | 17,035.6 | |||||||||
Long Term Growth Rate, % | 1.00 | |||||||||
Free cash flow (T + 1) | 4,302 | |||||||||
Terminal Value | 119,339 | |||||||||
Present Terminal Value | 95,286 | |||||||||
Enterprise Value | 112,322 | |||||||||
Net Debt | 47,933 | |||||||||
Equity Value | 64,389 | |||||||||
Diluted Shares Outstanding, MM | 459 | |||||||||
Equity Value Per Share | 140.16 |
What You Will Receive
- Authentic BIP Financial Data: Pre-filled with Brookfield Infrastructure’s historical and forecasted data for in-depth analysis.
- Customizable Template: Easily adjust essential inputs such as revenue growth, WACC, and EBITDA %.
- Instant Calculations: Watch Brookfield Infrastructure’s intrinsic value refresh automatically as you make changes.
- Expert Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF outcomes.
- Intuitive Design: Straightforward layout and clear guidance suitable for all skill levels.
Key Features
- 🔍 Real-Life BIP Financials: Pre-filled historical and projected data for Brookfield Infrastructure Partners L.P. (BIP).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Brookfield’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Brookfield’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 Excel file.
- Step 2: Review pre-entered Brookfield Infrastructure data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Brookfield Infrastructure's intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Brookfield Infrastructure Partners L.P. (BIP)?
- Accurate Data: Access to up-to-date Brookfield Infrastructure financials for dependable valuation outcomes.
- Customizable: Tailor essential inputs like growth projections, WACC, and tax rates to fit your analysis.
- Time-Saving: Pre-configured calculations streamline your workflow, saving you time.
- Professional-Grade Tool: Ideal for investors, analysts, and financial consultants in the infrastructure sector.
- User-Friendly: Designed with an intuitive interface and clear instructions for users of all experience levels.
Who Should Use This Product?
- Investors: Evaluate Brookfield Infrastructure Partners L.P. (BIP) for informed investment decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and assess financial forecasts.
- Startup Founders: Understand the valuation metrics applied to large infrastructure firms like Brookfield.
- Consultants: Provide comprehensive valuation analyses and reports for clients in the infrastructure sector.
- Students and Educators: Utilize current market data to explore and teach infrastructure valuation principles.
What the Template Contains
- Preloaded BIP Data: Historical and projected financial data, including revenue, EBITDA, 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.