|
DT Midstream, Inc. (DTM) DCF Valuation
US | Energy | Oil & Gas Midstream | NYSE
|
- ✓ 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
DT Midstream, Inc. (DTM) Bundle
Gain mastery over your DT Midstream, Inc. (DTM) valuation analysis using our sophisticated DCF Calculator! Featuring real-time data for (DTM), this Excel template enables you to adjust forecasts and assumptions to accurately determine the intrinsic value of DT Midstream, Inc.
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 | 504.0 | 754.0 | 840.0 | 920.0 | 922.0 | 1,021.8 | 1,132.5 | 1,255.1 | 1,391.0 | 1,541.7 |
Revenue Growth, % | 0 | 49.6 | 11.41 | 9.52 | 0.21739 | 10.83 | 10.83 | 10.83 | 10.83 | 10.83 |
EBITDA | 477.0 | 722.0 | 718.0 | 808.0 | 850.0 | 931.7 | 1,032.6 | 1,144.4 | 1,268.3 | 1,405.7 |
EBITDA, % | 94.64 | 95.76 | 85.48 | 87.83 | 92.19 | 91.18 | 91.18 | 91.18 | 91.18 | 91.18 |
Depreciation | 110.0 | 169.0 | 184.0 | 189.0 | 200.0 | 221.5 | 245.5 | 272.1 | 301.5 | 334.2 |
Depreciation, % | 21.83 | 22.41 | 21.9 | 20.54 | 21.69 | 21.68 | 21.68 | 21.68 | 21.68 | 21.68 |
EBIT | 367.0 | 553.0 | 534.0 | 619.0 | 650.0 | 710.2 | 787.1 | 872.3 | 966.8 | 1,071.5 |
EBIT, % | 72.82 | 73.34 | 63.57 | 67.28 | 70.5 | 69.5 | 69.5 | 69.5 | 69.5 | 69.5 |
Total Cash | 46.0 | 42.0 | 132.0 | 61.0 | 56.0 | 88.1 | 97.7 | 108.2 | 120.0 | 132.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 110.0 | 400.0 | 178.0 | 161.0 | 169.0 | 269.6 | 298.7 | 331.1 | 366.9 | 406.7 |
Account Receivables, % | 21.83 | 53.05 | 21.19 | 17.5 | 18.33 | 26.38 | 26.38 | 26.38 | 26.38 | 26.38 |
Inventories | .0 | .0 | 25.0 | 22.0 | .0 | 11.0 | 12.2 | 13.5 | 14.9 | 16.5 |
Inventories, % | 0 | 0 | 2.98 | 2.39 | 0 | 1.07 | 1.07 | 1.07 | 1.07 | 1.07 |
Accounts Payable | 49.0 | 39.0 | 22.0 | 119.0 | 94.0 | 83.1 | 92.1 | 102.0 | 113.1 | 125.3 |
Accounts Payable, % | 9.72 | 5.17 | 2.62 | 12.93 | 10.2 | 8.13 | 8.13 | 8.13 | 8.13 | 8.13 |
Capital Expenditure | -211.0 | -518.0 | -140.0 | -338.0 | -772.0 | -506.2 | -561.0 | -621.8 | -689.1 | -763.7 |
Capital Expenditure, % | -41.87 | -68.7 | -16.67 | -36.74 | -83.73 | -49.54 | -49.54 | -49.54 | -49.54 | -49.54 |
Tax Rate, % | 23.2 | 23.2 | 23.2 | 23.2 | 23.2 | 23.2 | 23.2 | 23.2 | 23.2 | 23.2 |
EBITAT | 256.4 | 392.1 | 388.5 | 475.2 | 499.2 | 521.4 | 577.9 | 640.4 | 709.8 | 786.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 94.4 | -256.9 | 612.5 | 443.2 | -83.8 | 114.2 | 240.9 | 267.0 | 295.9 | 328.0 |
WACC, % | 6.75 | 6.76 | 6.78 | 6.83 | 6.83 | 6.79 | 6.79 | 6.79 | 6.79 | 6.79 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,001.3 | |||||||||
Long Term Growth Rate, % | 3.50 | |||||||||
Free cash flow (T + 1) | 339 | |||||||||
Terminal Value | 10,328 | |||||||||
Present Terminal Value | 7,438 | |||||||||
Enterprise Value | 8,439 | |||||||||
Net Debt | 3,214 | |||||||||
Equity Value | 5,225 | |||||||||
Diluted Shares Outstanding, MM | 98 | |||||||||
Equity Value Per Share | 53.59 |
What You Will Get
- Real DTM Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for DT Midstream, Inc. (DTM).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to suit your analysis.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on DT Midstream’s fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and comprehensive projections.
- Time-Saving and Accurate: Eliminate the need to build models from scratch while ensuring precision and flexibility.
Key Features
- Customizable Financial Metrics: Adjust essential inputs such as revenue projections, operating margins, and capital investment plans.
- Instant DCF Valuation: Automatically computes intrinsic value, net present value (NPV), and other financial metrics in real-time.
- High-Precision Accuracy: Leverages DT Midstream's actual financial data for credible valuation results.
- Simplified Scenario Analysis: Effortlessly evaluate various scenarios and analyze their impacts on financial outcomes.
- Efficiency Booster: Streamline the valuation process without the hassle of constructing intricate financial models from the ground up.
How It Works
- Download the Template: Gain immediate access to the Excel-based DTM DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model will automatically refresh DTM’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation shifts.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose DT Midstream, Inc. (DTM) Calculator?
- Save Time: Quickly access a comprehensive DCF model without the hassle of building one from the ground up.
- Enhance Accuracy: Utilize dependable financial data and formulas to minimize valuation errors.
- Completely Customizable: Adjust the model to align with your unique assumptions and forecasts.
- User-Friendly: Intuitive charts and outputs facilitate straightforward analysis of the results.
- Endorsed by Professionals: Crafted for experts who prioritize accuracy and functionality.
Who Should Use This Product?
- Investors: Accurately estimate DT Midstream, Inc.’s (DTM) fair value before making investment decisions.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis related to DT Midstream, Inc. (DTM).
- Consultants: Quickly customize the template for valuation reports tailored to DT Midstream, Inc. (DTM) clients.
- Entrepreneurs: Gain insights into financial modeling practices employed by leading energy companies like DT Midstream, Inc. (DTM).
- Educators: Use it as a teaching tool to illustrate valuation methodologies relevant to DT Midstream, Inc. (DTM).
What the Template Contains
- Historical Data: Includes DT Midstream, Inc. (DTM)’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate DT Midstream, Inc. (DTM)’s 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 DT Midstream, Inc. (DTM)’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.