Bridge Investment Group Holdings Inc. (BRDG) 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
Bridge Investment Group Holdings Inc. (BRDG) Bundle
Whether you’re an investor or analyst, this (BRDG) DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from Bridge Investment Group Holdings Inc., you can adjust forecasts and observe the effects in real-time.
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 | 246.3 | 231.9 | 330.0 | 409.0 | 390.6 | 445.3 | 507.5 | 578.4 | 659.3 | 751.4 |
Revenue Growth, % | 0 | -5.82 | 42.28 | 23.95 | -4.5 | 13.98 | 13.98 | 13.98 | 13.98 | 13.98 |
EBITDA | 167.2 | 70.5 | 84.6 | 119.0 | -37.6 | 127.7 | 145.5 | 165.9 | 189.1 | 215.5 |
EBITDA, % | 67.88 | 30.39 | 25.65 | 29.09 | -9.61 | 28.68 | 28.68 | 28.68 | 28.68 | 28.68 |
Depreciation | 133.4 | 103.6 | -8.4 | 182.7 | 16.4 | 129.3 | 147.3 | 167.9 | 191.4 | 218.1 |
Depreciation, % | 54.16 | 44.69 | -2.56 | 44.67 | 4.19 | 29.03 | 29.03 | 29.03 | 29.03 | 29.03 |
EBIT | 33.8 | -33.2 | 93.1 | -63.7 | -53.9 | -1.6 | -1.8 | -2.0 | -2.3 | -2.6 |
EBIT, % | 13.71 | -14.29 | 28.21 | -15.57 | -13.8 | -0.34987 | -0.34987 | -0.34987 | -0.34987 | -0.34987 |
Total Cash | 62.1 | 106.9 | 86.5 | 198.2 | 77.5 | 147.6 | 168.3 | 191.8 | 218.6 | 249.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 40.4 | 15.4 | 150.7 | 675.8 | 474.6 | 239.2 | 272.7 | 310.8 | 354.3 | 403.8 |
Account Receivables, % | 16.39 | 6.62 | 45.66 | 165.21 | 121.5 | 53.73 | 53.73 | 53.73 | 53.73 | 53.73 |
Inventories | 112.1 | 196.8 | 43.7 | .0 | .0 | 127.9 | 145.7 | 166.1 | 189.3 | 215.8 |
Inventories, % | 45.51 | 84.86 | 13.23 | 0 | 0 | 28.72 | 28.72 | 28.72 | 28.72 | 28.72 |
Accounts Payable | 7.3 | 11.1 | 13.6 | 24.9 | 34.6 | 23.9 | 27.2 | 31.0 | 35.4 | 40.3 |
Accounts Payable, % | 2.97 | 4.8 | 4.12 | 6.1 | 8.85 | 5.37 | 5.37 | 5.37 | 5.37 | 5.37 |
Capital Expenditure | -1.7 | -.3 | -1.1 | -3.2 | -2.4 | -2.3 | -2.6 | -3.0 | -3.4 | -3.8 |
Capital Expenditure, % | -0.69597 | -0.11296 | -0.33968 | -0.78915 | -0.61641 | -0.51083 | -0.51083 | -0.51083 | -0.51083 | -0.51083 |
Tax Rate, % | 85.36 | 85.36 | 85.36 | 85.36 | 85.36 | 85.36 | 85.36 | 85.36 | 85.36 | 85.36 |
EBITAT | 29.3 | -29.1 | 91.2 | -58.9 | -7.9 | -1.2 | -1.3 | -1.5 | -1.8 | -2.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 15.9 | 18.4 | 101.9 | -349.5 | 216.8 | 222.6 | 95.4 | 108.7 | 123.9 | 141.3 |
WACC, % | 7.3 | 7.33 | 7.75 | 7.53 | 4.37 | 6.85 | 6.85 | 6.85 | 6.85 | 6.85 |
PV UFCF | ||||||||||
SUM PV UFCF | 577.5 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 144 | |||||||||
Terminal Value | 2,968 | |||||||||
Present Terminal Value | 2,131 | |||||||||
Enterprise Value | 2,708 | |||||||||
Net Debt | 426 | |||||||||
Equity Value | 2,282 | |||||||||
Diluted Shares Outstanding, MM | 26 | |||||||||
Equity Value Per Share | 87.77 |
What You Will Get
- Real BRDG Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Automated Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Explore various scenarios to assess Bridge Investment Group's future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive Data: Bridge Investment Group Holdings Inc.'s (BRDG) historical financial reports and pre-populated projections.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Insights: Instantly view the recalculated intrinsic value of Bridge Investment Group Holdings Inc. (BRDG).
- Intuitive Visualizations: Dashboard charts showcase valuation outcomes and essential metrics.
- Designed for Precision: A reliable tool for analysts, investors, and finance professionals.
How It Works
- 1. Access the Template: Download and open the Excel file containing Bridge Investment Group Holdings Inc.'s (BRDG) preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth projections, WACC, and capital expenditures as needed.
- 3. View Results Instantly: The DCF model automatically calculates the intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Analyze various forecasts to compare different valuation results.
- 5. Present with Assurance: Deliver professional valuation insights to back your investment decisions.
Why Choose This Calculator for Bridge Investment Group Holdings Inc. (BRDG)?
- Accuracy: Utilizes real Bridge Investment Group financials for precise data.
- Flexibility: Allows users to easily test and adjust inputs as needed.
- Time-Saving: Eliminates the complexities of creating a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Simple to navigate, even for those with limited financial modeling skills.
Who Should Use This Product?
- Institutional Investors: Develop comprehensive investment strategies based on Bridge Investment Group Holdings Inc. (BRDG) performance.
- Asset Management Teams: Evaluate investment opportunities and risks associated with BRDG to enhance portfolio management.
- Financial Advisors: Deliver precise investment recommendations to clients considering Bridge Investment Group Holdings Inc. (BRDG).
- Academic Researchers: Analyze financial data for studies related to investment trends and market behavior.
- Market Analysts: Gain insights into the valuation and growth potential of Bridge Investment Group Holdings Inc. (BRDG).
What the Template Contains
- Pre-Filled Data: Contains historical financials and forecasts for Bridge Investment Group Holdings Inc. (BRDG).
- Discounted Cash Flow Model: An editable DCF valuation model featuring automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on user-defined inputs.
- Key Financial Ratios: Evaluate Bridge Investment Group's profitability, efficiency, and leverage.
- Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
- Clear Dashboard: Visual representations and tables summarizing essential valuation outcomes.