Tortoise Energy Infrastructure Corporation (TYG) 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
Tortoise Energy Infrastructure Corporation (TYG) Bundle
Whether you’re an investor or analyst, this Tortoise Energy Infrastructure Corporation (TYG) DCF Calculator is your go-to tool for accurate valuation. Equipped with real data from Tortoise Energy Infrastructure Corporation, 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 | -185.1 | -568.1 | 136.4 | 105.6 | 15.8 | 11.5 | 8.4 | 6.2 | 4.5 | 3.3 |
| Revenue Growth, % | 0 | 206.85 | -124 | -22.55 | -85.08 | -26.91 | -26.91 | -26.91 | -26.91 | -26.91 |
| EBITDA | -238.8 | -669.0 | 154.9 | 110.7 | -11.7 | 7.5 | 5.5 | 4.0 | 2.9 | 2.1 |
| EBITDA, % | 128.96 | 117.77 | 113.61 | 104.85 | -73.93 | 65.21 | 65.21 | 65.21 | 65.21 | 65.21 |
| Depreciation | -7.1 | -1.0 | .1 | -6.6 | -8.6 | -1.3 | -1.0 | -.7 | -.5 | -.4 |
| Depreciation, % | 3.85 | 0.17811 | 0.08607073 | -6.22 | -54.41 | -11.3 | -11.3 | -11.3 | -11.3 | -11.3 |
| EBIT | -231.6 | -668.0 | 154.8 | 117.3 | -3.1 | 8.8 | 6.4 | 4.7 | 3.4 | 2.5 |
| EBIT, % | 125.11 | 117.59 | 113.52 | 111.06 | -19.51 | 76.1 | 76.1 | 76.1 | 76.1 | 76.1 |
| Total Cash | .2 | .1 | .5 | .3 | .0 | .0 | .0 | .0 | .0 | .0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 3.0 | 1.1 | 8.4 | 2.8 | 1.0 | .3 | .2 | .2 | .1 | .1 |
| Account Receivables, % | -1.6 | -0.18487 | 6.18 | 2.67 | 6.26 | 2.66 | 2.66 | 2.66 | 2.66 | 2.66 |
| Inventories | 14.9 | 53.1 | .0 | .0 | .0 | -.4 | -.3 | -.2 | -.2 | -.1 |
| Inventories, % | -8.06 | -9.35 | 0 | 0 | 0 | -3.48 | -3.48 | -3.48 | -3.48 | -3.48 |
| Accounts Payable | .0 | .6 | 9.3 | 1.7 | .0 | .2 | .1 | .1 | .1 | .1 |
| Accounts Payable, % | 0 | -0.10302 | 6.79 | 1.57 | 0 | 1.65 | 1.65 | 1.65 | 1.65 | 1.65 |
| Capital Expenditure | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Capital Expenditure, % | 0 | 0 | 0 | 0 | 0.000019036069 | 0 | 0 | 0 | 0 | 0 |
| Tax Rate, % | 46.3 | 46.3 | 46.3 | 46.3 | 46.3 | 46.3 | 46.3 | 46.3 | 46.3 | 46.3 |
| EBITAT | -228.4 | -665.4 | 130.9 | 117.3 | -1.7 | 7.7 | 5.6 | 4.1 | 3.0 | 2.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -253.5 | -702.1 | 185.4 | 108.7 | -10.0 | 7.6 | 4.6 | 3.3 | 2.4 | 1.8 |
| WACC, % | 13.29 | 13.3 | 13.18 | 13.3 | 12.94 | 13.2 | 13.2 | 13.2 | 13.2 | 13.2 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 15.0 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 2 | |||||||||
| Terminal Value | 16 | |||||||||
| Present Terminal Value | 9 | |||||||||
| Enterprise Value | 24 | |||||||||
| Net Debt | 72 | |||||||||
| Equity Value | -48 | |||||||||
| Diluted Shares Outstanding, MM | 11 | |||||||||
| Equity Value Per Share | -4.49 |
What You Will Receive
- Genuine Tortoise Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Tortoise Energy Infrastructure Corporation (TYG).
- Complete Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates.
- Immediate Valuation Updates: Automatic recalculations to assess the impact of changes on Tortoise Energy’s fair value.
- Flexible Excel Template: Designed for quick modifications, scenario analysis, and comprehensive projections.
- Efficient and Precise: Avoid constructing models from the ground up while ensuring accuracy and adaptability.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Tortoise Energy Infrastructure Corporation (TYG).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to TYG.
- Customizable Forecast Assumptions: Easily adjust growth rates, capital expenditures, and discount rates for accurate projections.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Tortoise Energy Infrastructure Corporation (TYG).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file for Tortoise Energy Infrastructure Corporation (TYG).
- Step 2: Review TYG’s pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the outputs and leverage the results for your investment decisions.
Why Choose This Calculator for Tortoise Energy Infrastructure Corporation (TYG)?
- Designed for Investors: A sophisticated tool tailored for analysts, portfolio managers, and energy sector consultants.
- Comprehensive Data: TYG’s historical and projected financials are preloaded for enhanced accuracy.
- Flexible Scenario Analysis: Easily simulate various forecasts and investment assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance ensures a smooth calculation process.
Who Should Use This Product?
- Institutional Investors: Develop comprehensive and accurate valuation models for energy infrastructure analysis.
- Energy Sector Analysts: Evaluate valuation scenarios to inform strategic decisions within the energy market.
- Financial Advisors: Offer clients precise valuation insights for Tortoise Energy Infrastructure Corporation (TYG).
- Students and Professors: Utilize real-time data to enhance learning and practice in financial modeling.
- Energy Market Enthusiasts: Gain insights into how energy infrastructure companies like Tortoise are valued in the industry.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring in-depth valuation calculations.
- Real-World Data: Tortoise Energy Infrastructure Corporation’s (TYG) historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results.