DigitalBridge Group, Inc. (DBRG) DCF Valuation

DigitalBridge Group, Inc. (DBRG) 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

DigitalBridge Group, Inc. (DBRG) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Whether you’re an investor or an analyst, this (DBRG) DCF Calculator is your go-to tool for accurate valuation. With real data from DigitalBridge Group, Inc. preloaded, you can adjust forecasts and instantly observe the effects.


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,326.4 1,236.6 965.8 1,144.6 821.4 660.3 530.7 426.6 342.9 275.7
Revenue Growth, % 0 -46.84 -21.9 18.51 -28.24 -19.62 -19.62 -19.62 -19.62 -19.62
EBITDA 77.4 54.5 415.1 220.4 426.8 161.0 129.4 104.0 83.6 67.2
EBITDA, % 3.32 4.41 42.98 19.26 51.96 24.39 24.39 24.39 24.39 24.39
Depreciation 1,369.9 631.8 1,295.5 518.7 36.7 343.0 275.7 221.6 178.2 143.2
Depreciation, % 58.89 51.09 134.14 45.31 4.46 51.95 51.95 51.95 51.95 51.95
EBIT -1,292.5 -577.3 -880.4 -298.3 390.2 -227.1 -182.5 -146.7 -117.9 -94.8
EBIT, % -55.56 -46.68 -91.16 -26.06 47.5 -34.39 -34.39 -34.39 -34.39 -34.39
Total Cash 1,205.2 703.5 1,602.1 918.3 345.3 437.0 351.3 282.4 227.0 182.5
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 126.7 76.9 343.0 41.3 95.4
Account Receivables, % 5.45 6.22 35.52 3.61 11.61
Inventories -.3 5,122.1 .0 -37.5 .0 127.7 102.7 82.5 66.3 53.3
Inventories, % -0.01354046 414.21 0.000000104 -3.27 0 19.34 19.34 19.34 19.34 19.34
Accounts Payable 91.6 120.7 121.9 25.2 13.8 39.9 32.1 25.8 20.7 16.7
Accounts Payable, % 3.94 9.76 12.62 2.2 1.69 6.04 6.04 6.04 6.04 6.04
Capital Expenditure 4,189.8 -2,128.1 -369.9 -2,141.2 .0 -314.7 -252.9 -203.3 -163.4 -131.4
Capital Expenditure, % 180.1 -172.1 -38.3 -187.08 0 -47.66 -47.66 -47.66 -47.66 -47.66
Tax Rate, % 49.33 49.33 49.33 49.33 49.33 49.33 49.33 49.33 49.33 49.33
EBITAT -1,303.6 -574.9 -601.5 -308.1 197.7 -190.1 -152.8 -122.8 -98.7 -79.4
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 4,221.3 -7,114.8 5,181.3 -1,688.2 131.4 -250.5 -96.6 -77.7 -62.4 -50.2
WACC, % 12.25 12.25 11.91 12.25 11.71 12.08 12.08 12.08 12.08 12.08
PV UFCF
SUM PV UFCF -423.6
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) -51
Terminal Value -508
Present Terminal Value -287
Enterprise Value -711
Net Debt 75
Equity Value -786
Diluted Shares Outstanding, MM 170
Equity Value Per Share -4.63

What You Will Get

  • Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to generate various scenarios.
  • Real-World Data: DigitalBridge Group, Inc. (DBRG) financial data pre-loaded to kickstart your analysis.
  • Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
  • Customizable and Professional: A sleek Excel model tailored to meet your valuation requirements.
  • Built for Analysts and Investors: Perfect for testing forecasts, validating strategies, and enhancing efficiency.

Key Features

  • Pre-Loaded Data: DigitalBridge Group’s historical financial statements and pre-filled forecasts.
  • Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
  • Instant Results: Observe DigitalBridge Group’s intrinsic value recalculating in real time.
  • Clear Visual Outputs: Dashboard charts illustrate valuation results and key metrics effectively.
  • Built for Accuracy: A professional tool tailored for analysts, investors, and finance professionals.

How It Works

  1. Step 1: Download the Excel file for DigitalBridge Group, Inc. (DBRG).
  2. Step 2: Review the pre-filled financial data and forecasts for DigitalBridge.
  3. Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
  4. Step 4: Observe the DCF model update in real-time as you modify your assumptions.
  5. Step 5: Evaluate the outputs and leverage the results for your investment strategies.

Why Choose This Calculator for DigitalBridge Group, Inc. (DBRG)?

  • Designed for Industry Experts: A sophisticated tool utilized by investors, analysts, and financial advisors.
  • Comprehensive Data: DigitalBridge’s historical and projected financials are preloaded for precise analysis.
  • Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
  • Insightful Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
  • User-Friendly Interface: Step-by-step guidance ensures a smooth experience throughout the process.

Who Should Use This Product?

  • Investors: Accurately assess DigitalBridge Group, Inc.'s (DBRG) fair value before making investment choices.
  • CFOs: Utilize a high-quality DCF model for financial analysis and reporting.
  • Consultants: Efficiently customize the template for valuation reports tailored to clients.
  • Entrepreneurs: Acquire knowledge on financial modeling practices adopted by leading firms.
  • Educators: Employ it as a resource to illustrate various valuation techniques.

What the Template Contains

  • Historical Data: Includes DigitalBridge Group, Inc.'s (DBRG) past financials and baseline forecasts.
  • DCF and Levered DCF Models: Detailed templates to calculate DigitalBridge Group, Inc.'s (DBRG) intrinsic value.
  • WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
  • Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
  • Quarterly and Annual Statements: A complete breakdown of DigitalBridge Group, Inc.'s (DBRG) financials.
  • Interactive Dashboard: Visualize valuation results and projections dynamically.

Es wurden keine passenden Produkte gefunden.