|
Valoración de DCF de UGI Corporation (UGI)
US | Utilities | Regulated Gas | NYSE
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
UGI Corporation (UGI) Bundle
¡Mejore sus opciones de inversión con la calculadora DCF de UGI Corporation (UGI)! Explore datos financieros genuinos para UGI, ajuste las proyecciones y gastos de crecimiento, y observe instantáneamente cómo estas modificaciones afectan el valor intrínseco de UGI Corporation (UGI).
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 6,559.0 | 7,447.0 | 10,106.0 | 8,928.0 | 7,210.0 | 7,540.7 | 7,886.5 | 8,248.2 | 8,626.5 | 9,022.1 |
| Revenue Growth, % | 0 | 13.54 | 35.71 | -11.66 | -19.24 | 4.59 | 4.59 | 4.59 | 4.59 | 4.59 |
| EBITDA | 1,577.0 | 2,944.0 | 2,191.0 | -886.0 | 1,285.0 | 1,404.9 | 1,469.3 | 1,536.7 | 1,607.2 | 1,680.9 |
| EBITDA, % | 24.04 | 39.53 | 21.68 | -9.92 | 17.82 | 18.63 | 18.63 | 18.63 | 18.63 | 18.63 |
| Depreciation | 484.0 | 502.0 | 518.0 | 532.0 | 551.0 | 495.4 | 518.1 | 541.9 | 566.7 | 592.7 |
| Depreciation, % | 7.38 | 6.74 | 5.13 | 5.96 | 7.64 | 6.57 | 6.57 | 6.57 | 6.57 | 6.57 |
| EBIT | 1,093.0 | 2,442.0 | 1,673.0 | -1,418.0 | 734.0 | 909.5 | 951.2 | 994.9 | 1,040.5 | 1,088.2 |
| EBIT, % | 16.66 | 32.79 | 16.55 | -15.88 | 10.18 | 12.06 | 12.06 | 12.06 | 12.06 | 12.06 |
| Total Cash | 336.0 | 855.0 | 405.0 | 241.0 | 213.0 | 396.1 | 414.3 | 433.3 | 453.1 | 473.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 746.0 | 1,023.0 | 1,278.0 | 947.0 | 709.0 | 877.7 | 917.9 | 960.0 | 1,004.1 | 1,050.1 |
| Account Receivables, % | 11.37 | 13.74 | 12.65 | 10.61 | 9.83 | 11.64 | 11.64 | 11.64 | 11.64 | 11.64 |
| Inventories | 241.0 | 469.0 | 665.0 | 433.0 | 411.0 | 408.7 | 427.5 | 447.1 | 467.6 | 489.0 |
| Inventories, % | 3.67 | 6.3 | 6.58 | 4.85 | 5.7 | 5.42 | 5.42 | 5.42 | 5.42 | 5.42 |
| Accounts Payable | 475.0 | 837.0 | 891.0 | 613.0 | 544.0 | 629.0 | 657.9 | 688.0 | 719.6 | 752.6 |
| Accounts Payable, % | 7.24 | 11.24 | 8.82 | 6.87 | 7.55 | 8.34 | 8.34 | 8.34 | 8.34 | 8.34 |
| Capital Expenditure | -655.0 | -690.0 | -804.0 | -974.0 | -796.0 | -741.4 | -775.4 | -810.9 | -848.1 | -887.0 |
| Capital Expenditure, % | -9.99 | -9.27 | -7.96 | -10.91 | -11.04 | -9.83 | -9.83 | -9.83 | -9.83 | -9.83 |
| Tax Rate, % | 20.88 | 20.88 | 20.88 | 20.88 | 20.88 | 20.88 | 20.88 | 20.88 | 20.88 | 20.88 |
| EBITAT | 871.8 | 1,801.1 | 1,294.3 | -1,159.4 | 580.7 | 712.6 | 745.3 | 779.5 | 815.2 | 852.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 188.8 | 1,470.1 | 611.3 | -1,316.4 | 526.7 | 385.2 | 457.9 | 478.9 | 500.9 | 523.8 |
| WACC, % | 7.15 | 6.97 | 7.08 | 7.22 | 7.13 | 7.11 | 7.11 | 7.11 | 7.11 | 7.11 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,900.6 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 534 | |||||||||
| Terminal Value | 10,454 | |||||||||
| Present Terminal Value | 7,415 | |||||||||
| Enterprise Value | 9,316 | |||||||||
| Net Debt | 6,465 | |||||||||
| Equity Value | 2,851 | |||||||||
| Diluted Shares Outstanding, MM | 215 | |||||||||
| Equity Value Per Share | 13.24 |
What You Will Receive
- Authentic UGI Financial Data: Pre-loaded with UGI Corporation’s historical and forecasted data for accurate analysis.
- Completely Customizable Template: Easily adjust essential inputs such as revenue growth, WACC, and EBITDA %.
- Instant Calculations: Watch UGI’s intrinsic value refresh in real-time as you make modifications.
- Expert Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF outcomes.
- Intuitive Layout: Clear structure and straightforward instructions suitable for all skill levels.
Key Features
- Customizable Financial Metrics: Adjust essential parameters such as revenue growth, operating margins, and capital investments.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and additional financial metrics.
- High-Quality Precision: Utilizes UGI Corporation's real financial data for accurate valuation results.
- Effortless Scenario Analysis: Explore various assumptions and evaluate results with ease.
- Efficiency Booster: Remove the hassle of constructing intricate valuation models from the ground up.
How It Works
- Download the Template: Get instant access to the Excel-based UGI DCF Calculator.
- Input Your Assumptions: Adjust yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically updates UGI Corporation’s intrinsic value.
- Test Scenarios: Simulate different assumptions to evaluate potential valuation changes.
- Analyze and Decide: Use the results to guide your investment or financial analysis.
Why Choose This Calculator for UGI Corporation (UGI)?
- Accurate Data: Utilize real UGI Corporation financials for dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Built-in calculations save you from starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants focused on UGI Corporation.
- User-Friendly: A straightforward design and clear instructions ensure ease of use for everyone.
Who Should Use This Product?
- Investors: Assess UGI Corporation’s valuation before making stock transactions.
- CFOs and Financial Analysts: Optimize valuation workflows and evaluate financial forecasts.
- Startup Founders: Understand the valuation methods applied to established companies like UGI Corporation.
- Consultants: Provide detailed valuation assessments for client projects.
- Students and Educators: Utilize real-time data to learn and teach valuation methodologies.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled UGI Corporation historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for UGI Corporation (UGI).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.