Brookfield Asset Management Inc. (BAM) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Brookfield Asset Management Inc. (BAM) Bundle
As an investor or analyst, the Brookfield Asset Management Inc. (BAM) DCF Calculator is your go-to resource for accurate valuation. With real data from Brookfield Asset Management Inc. already integrated, you can easily adjust forecasts and observe the effects immediately.
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,173.0 | 2,251.0 | 2,788.0 | 3,627.0 | 390.0 | 359.1 | 330.6 | 304.4 | 280.3 | 258.1 |
Revenue Growth, % | 0 | 3.59 | 23.86 | 30.09 | -89.25 | -7.93 | -7.93 | -7.93 | -7.93 | -7.93 |
EBITDA | 1,363.0 | 1,371.0 | 2,078.0 | 35.0 | 522.0 | 214.8 | 197.8 | 182.1 | 167.7 | 154.4 |
EBITDA, % | 62.72 | 60.91 | 74.53 | 0.96498 | 133.84 | 59.83 | 59.83 | 59.83 | 59.83 | 59.83 |
Depreciation | 6.0 | 7.0 | 11.0 | 13.0 | 470.0 | 72.8 | 67.0 | 61.7 | 56.8 | 52.3 |
Depreciation, % | 0.27612 | 0.31097 | 0.39455 | 0.35842 | 120.51 | 20.27 | 20.27 | 20.27 | 20.27 | 20.27 |
EBIT | 1,357.0 | 1,364.0 | 2,067.0 | 22.0 | 52.0 | 151.6 | 139.6 | 128.5 | 118.4 | 109.0 |
EBIT, % | 62.45 | 60.6 | 74.14 | 0.60656 | 13.33 | 42.22 | 42.22 | 42.22 | 42.22 | 42.22 |
Total Cash | 2,101.0 | 2,494.0 | 3,545.0 | 9.0 | ||||||
Total Cash, percent | .0 | .0 | .0 | .0 | ||||||
Account Receivables | 54.0 | 26.0 | 782.0 | 824.0 | ||||||
Account Receivables, % | 2.4 | 0.93257 | 21.56 | 211.27 | ||||||
Inventories | .0 | -6,890.0 | -2,305.0 | .0 | ||||||
Inventories, % | 0 | -247.13 | -63.55 | 0 | ||||||
Accounts Payable | 611.0 | 561.0 | 781.0 | 859.0 | ||||||
Accounts Payable, % | 27.14 | 20.12 | 21.53 | 220.24 | ||||||
Capital Expenditure | -1.0 | -20.0 | -35.0 | -13.0 | -17.0 | -5.0 | -4.6 | -4.2 | -3.9 | -3.6 |
Capital Expenditure, % | -0.04601933 | -0.88849 | -1.26 | -0.35842 | -4.36 | -1.38 | -1.38 | -1.38 | -1.38 | -1.38 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | 1,507.5 | 679.4 | 1,153.2 | .2 | 52.0 | 92.9 | 85.5 | 78.8 | 72.5 | 66.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 1,512.5 | 1,223.4 | 7,997.2 | -5,120.8 | -1,764.0 | 125.7 | 148.0 | 136.3 | 125.5 | 115.5 |
WACC, % | 13.05 | 12.89 | 12.91 | 12.73 | 13.05 | 12.93 | 12.93 | 12.93 | 12.93 | 12.93 |
PV UFCF | ||||||||||
SUM PV UFCF | 462.0 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 118 | |||||||||
Terminal Value | 1,078 | |||||||||
Present Terminal Value | 587 | |||||||||
Enterprise Value | 1,049 | |||||||||
Net Debt | 247 | |||||||||
Equity Value | 802 | |||||||||
Diluted Shares Outstanding, MM | 399 | |||||||||
Equity Value Per Share | 2.01 |
What You Will Get
- Pre-Filled Financial Model: Brookfield Asset Management Inc.'s (BAM) actual data facilitates accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, profit margins, WACC, and other essential parameters.
- Instant Calculations: Real-time updates guarantee you see outcomes as you implement changes.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation analysis.
- Customizable and Reusable: Designed for adaptability, allowing repeated application for comprehensive forecasts.
Key Features
- Comprehensive Data: Brookfield’s historical financial statements and pre-filled projections.
- Customizable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Analysis: Observe Brookfield’s intrinsic value recalculated instantly.
- Intuitive Visual Outputs: Dashboard charts illustrate valuation results and essential metrics.
- Designed for Precision: A professional-grade tool for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the prebuilt Excel template with Brookfield Asset Management Inc.'s (BAM) data included.
- Step 2: Explore the pre-filled sheets and familiarize yourself with the essential metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including Brookfield Asset Management Inc.'s (BAM) intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose Brookfield Asset Management (BAM)?
- Expertise: Leverage decades of experience in asset management for reliable insights.
- Versatility: Tailored solutions that accommodate a wide range of investment strategies.
- Efficiency: Streamlined processes that save you time and effort in managing investments.
- Institutional Quality: Built with the sophistication and rigor expected by institutional investors.
- Accessible: Designed for ease of use, catering to both seasoned investors and newcomers.
Who Should Use Brookfield Asset Management Inc. (BAM)?
- Investors: Gain insights for informed investment decisions with our comprehensive asset management services.
- Financial Analysts: Utilize our detailed reports and analyses to streamline your financial assessments.
- Consultants: Leverage our expertise to enhance client strategies and presentations.
- Finance Enthusiasts: Explore diverse investment opportunities and strategies through our resources.
- Educators and Students: Access valuable case studies and materials for finance education and research.
What the Template Contains
- Pre-Filled Data: Includes Brookfield Asset Management Inc.'s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Brookfield Asset Management Inc.'s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.