|
Ultrapa Participações S.A. (UGP) Valoración de DCF
BR | Energy | Oil & Gas Refining & Marketing | 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
Ultrapar Participações S.A. (UGP) Bundle
¡Mejore sus estrategias de inversión con la calculadora DCF (UGP)! Utilice datos financieros reales de UltraPar Participações S.A., ajuste las predicciones y gastos de crecimiento, y observe instantáneamente cómo las modificaciones afectan el valor intrínseco de (UGP).
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 | 14,411.3 | 13,111.0 | 17,709.1 | 23,180.3 | 20,342.2 | 22,615.5 | 25,142.7 | 27,952.4 | 31,076.0 | 34,548.7 |
| Revenue Growth, % | 0 | -9.02 | 35.07 | 30.89 | -12.24 | 11.17 | 11.17 | 11.17 | 11.17 | 11.17 |
| EBITDA | 474.9 | 492.6 | 446.4 | 723.2 | 827.1 | 758.0 | 842.7 | 936.9 | 1,041.6 | 1,158.0 |
| EBITDA, % | 3.3 | 3.76 | 2.52 | 3.12 | 4.07 | 3.35 | 3.35 | 3.35 | 3.35 | 3.35 |
| Depreciation | 184.7 | 207.9 | 147.5 | 164.7 | 186.4 | 241.0 | 267.9 | 297.8 | 331.1 | 368.1 |
| Depreciation, % | 1.28 | 1.59 | 0.83278 | 0.71059 | 0.91615 | 1.07 | 1.07 | 1.07 | 1.07 | 1.07 |
| EBIT | 290.2 | 284.7 | 298.9 | 558.5 | 640.7 | 517.1 | 574.8 | 639.1 | 710.5 | 789.9 |
| EBIT, % | 2.01 | 2.17 | 1.69 | 2.41 | 3.15 | 2.29 | 2.29 | 2.29 | 2.29 | 2.29 |
| Total Cash | 840.1 | 1,241.8 | 659.1 | 991.2 | 1,003.6 | 1,277.0 | 1,419.7 | 1,578.3 | 1,754.7 | 1,950.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 972.4 | 938.6 | 955.8 | 1,193.1 | 863.6 | 1,297.9 | 1,443.0 | 1,604.2 | 1,783.5 | 1,982.8 |
| Account Receivables, % | 6.75 | 7.16 | 5.4 | 5.15 | 4.25 | 5.74 | 5.74 | 5.74 | 5.74 | 5.74 |
| Inventories | 599.6 | 620.7 | 632.4 | 791.8 | 692.6 | 872.4 | 969.8 | 1,078.2 | 1,198.7 | 1,332.7 |
| Inventories, % | 4.16 | 4.73 | 3.57 | 3.42 | 3.4 | 3.86 | 3.86 | 3.86 | 3.86 | 3.86 |
| Accounts Payable | 435.7 | 652.1 | 934.4 | 1,190.7 | 923.4 | 1,038.0 | 1,154.0 | 1,283.0 | 1,426.4 | 1,585.8 |
| Accounts Payable, % | 3.02 | 4.97 | 5.28 | 5.14 | 4.54 | 4.59 | 4.59 | 4.59 | 4.59 | 4.59 |
| Capital Expenditure | -200.1 | -185.7 | -206.7 | -196.7 | -211.1 | -265.0 | -294.6 | -327.5 | -364.1 | -404.8 |
| Capital Expenditure, % | -1.39 | -1.42 | -1.17 | -0.84865 | -1.04 | -1.17 | -1.17 | -1.17 | -1.17 | -1.17 |
| Tax Rate, % | 31.82 | 31.82 | 31.82 | 31.82 | 31.82 | 31.82 | 31.82 | 31.82 | 31.82 | 31.82 |
| EBITAT | 138.7 | 169.7 | 252.5 | 535.1 | 436.8 | 368.0 | 409.1 | 454.8 | 505.7 | 562.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1,013.0 | 420.9 | 446.7 | 362.7 | 573.6 | -155.6 | 255.9 | 284.5 | 316.3 | 351.6 |
| WACC, % | 7.73 | 8.35 | 9.65 | 10.24 | 8.8 | 8.95 | 8.95 | 8.95 | 8.95 | 8.95 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 746.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 359 | |||||||||
| Terminal Value | 5,158 | |||||||||
| Present Terminal Value | 3,360 | |||||||||
| Enterprise Value | 4,106 | |||||||||
| Net Debt | 1,189 | |||||||||
| Equity Value | 2,917 | |||||||||
| Diluted Shares Outstanding, MM | 1,105 | |||||||||
| Equity Value Per Share | 2.64 |
What You Will Get
- Editable Forecast Inputs: Effortlessly modify assumptions (growth %, margins, WACC) to develop various scenarios.
- Real-World Data: Ultrapar Participações S.A. (UGP)’s financial data pre-loaded to accelerate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and increasing efficiency.
Key Features
- Comprehensive DCF Calculator: Offers both unlevered and levered DCF valuation models tailored for Ultrapar Participações S.A. (UGP).
- WACC Calculator: Features a pre-configured Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Ultrapar Participações S.A. (UGP).
- Interactive Dashboard and Charts: Visual representations highlight essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the prebuilt Excel template with Ultrapar Participações S.A.'s (UGP) data included.
- Step 2: Explore the pre-filled sheets and familiarize yourself with the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including Ultrapar Participações S.A.'s (UGP) intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose This Calculator for Ultrapar Participações S.A. (UGP)?
- Accurate Data: Utilize real Ultrapar financials for dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Pre-configured calculations save you from starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants focusing on Ultrapar.
- User-Friendly: Easy-to-navigate design and clear instructions make it accessible for all users.
Who Should Use This Product?
- Investors: Evaluate Ultrapar’s valuation before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and validate financial forecasts.
- Startup Founders: Discover how established companies like Ultrapar are assessed in the market.
- Consultants: Provide clients with detailed and accurate valuation analyses.
- Students and Educators: Utilize real market data to enhance learning and understanding of valuation practices.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for Ultrapar Participações S.A. (UGP).
- Real-World Data: Ultrapar’s historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to evaluate different scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Interactive charts and tables for clear, actionable results.