Global Partners LP (GLP) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Global Partners LP (GLP) Bundle
Explore the financial future of Global Partners LP (GLP) with our user-friendly DCF Calculator! Enter your assumptions for growth, margins, and costs to calculate the intrinsic value of Global Partners LP (GLP) and enhance your investment strategy.
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 | 13,081.7 | 8,321.6 | 13,248.3 | 18,877.9 | 16,492.2 | 18,663.8 | 21,121.5 | 23,902.7 | 27,050.2 | 30,612.1 |
| Revenue Growth, % | 0 | -36.39 | 59.2 | 42.49 | -12.64 | 13.17 | 13.17 | 13.17 | 13.17 | 13.17 |
| EBITDA | 234.3 | 285.2 | 244.5 | 565.1 | 356.4 | 456.1 | 516.1 | 584.1 | 661.0 | 748.1 |
| EBITDA, % | 1.79 | 3.43 | 1.85 | 2.99 | 2.16 | 2.44 | 2.44 | 2.44 | 2.44 | 2.44 |
| Depreciation | 108.2 | 100.1 | 102.2 | 104.8 | 110.1 | 150.2 | 170.0 | 192.4 | 217.7 | 246.4 |
| Depreciation, % | 0.82705 | 1.2 | 0.77173 | 0.55513 | 0.66753 | 0.80495 | 0.80495 | 0.80495 | 0.80495 | 0.80495 |
| EBIT | 126.1 | 185.1 | 142.2 | 460.3 | 246.3 | 305.8 | 346.1 | 391.7 | 443.3 | 501.6 |
| EBIT, % | 0.96415 | 2.22 | 1.07 | 2.44 | 1.49 | 1.64 | 1.64 | 1.64 | 1.64 | 1.64 |
| Total Cash | 12.0 | 9.7 | 10.8 | 4.0 | 19.6 | 16.1 | 18.2 | 20.6 | 23.3 | 26.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 421.0 | 229.7 | 412.3 | 481.2 | 559.9 | 561.2 | 635.1 | 718.8 | 813.4 | 920.5 |
| Account Receivables, % | 3.22 | 2.76 | 3.11 | 2.55 | 3.39 | 3.01 | 3.01 | 3.01 | 3.01 | 3.01 |
| Inventories | 450.5 | 384.4 | 509.5 | 566.7 | 397.3 | 646.5 | 731.7 | 828.0 | 937.0 | 1,060.4 |
| Inventories, % | 3.44 | 4.62 | 3.85 | 3 | 2.41 | 3.46 | 3.46 | 3.46 | 3.46 | 3.46 |
| Accounts Payable | 373.4 | 207.9 | 353.3 | 530.9 | 648.7 | 551.1 | 623.7 | 705.8 | 798.8 | 904.0 |
| Accounts Payable, % | 2.85 | 2.5 | 2.67 | 2.81 | 3.93 | 2.95 | 2.95 | 2.95 | 2.95 | 2.95 |
| Capital Expenditure | -82.9 | -76.3 | -101.7 | -106.8 | -402.0 | -198.7 | -224.8 | -254.4 | -287.9 | -325.8 |
| Capital Expenditure, % | -0.63343 | -0.91729 | -0.76778 | -0.56573 | -2.44 | -1.06 | -1.06 | -1.06 | -1.06 | -1.06 |
| Tax Rate, % | 5.06 | 5.06 | 5.06 | 5.06 | 5.06 | 5.06 | 5.06 | 5.06 | 5.06 | 5.06 |
| EBITAT | 124.7 | 186.3 | 139.2 | 439.9 | 233.8 | 298.0 | 337.3 | 381.7 | 432.0 | 488.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -348.1 | 301.9 | -22.6 | 489.4 | 150.4 | -98.5 | 196.0 | 221.8 | 251.0 | 284.1 |
| WACC, % | 8.3 | 8.33 | 8.27 | 8.21 | 8.19 | 8.26 | 8.26 | 8.26 | 8.26 | 8.26 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 624.9 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 286 | |||||||||
| Terminal Value | 3,680 | |||||||||
| Present Terminal Value | 2,475 | |||||||||
| Enterprise Value | 3,100 | |||||||||
| Net Debt | 1,519 | |||||||||
| Equity Value | 1,581 | |||||||||
| Diluted Shares Outstanding, MM | 34 | |||||||||
| Equity Value Per Share | 46.45 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to create various scenarios.
- Real-World Data: Global Partners LP’s (GLP) financial data pre-filled to accelerate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A refined Excel model that adapts to your valuation requirements.
- Built for Analysts and Investors: Perfect for testing projections, validating strategies, and saving time.
Key Features
- Comprehensive GLP Data: Pre-filled with Global Partners LP's historical financials and future projections.
- Fully Customizable Inputs: Modify revenue growth, profit margins, WACC, tax rates, and capital expenditures as needed.
- Dynamic Valuation Model: Automatically updates Net Present Value (NPV) and intrinsic value based on your customized inputs.
- Scenario Testing: Develop multiple forecasting scenarios to evaluate various valuation outcomes.
- User-Friendly Interface: Intuitive, organized, and designed for both professionals and newcomers.
How It Works
- Step 1: Download the prebuilt Excel template with Global Partners LP’s (GLP) 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 Global Partners LP’s (GLP) intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose This Calculator for Global Partners LP (GLP)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your specific analysis needs.
- Real-Time Feedback: Witness immediate updates to Global Partners LP’s valuation as you modify inputs.
- Preloaded Data: Comes equipped with Global Partners LP’s latest financial information for swift evaluations.
- Relied Upon by Experts: A preferred tool for investors and analysts aiming for well-informed choices.
Who Should Use This Product?
- Finance Students: Explore financial modeling techniques and practice with real-world data related to Global Partners LP (GLP).
- Academics: Utilize advanced models in your curriculum or research focusing on energy and logistics sectors.
- Investors: Validate your investment strategies and evaluate valuation metrics for Global Partners LP (GLP).
- Analysts: Enhance your analysis process with a ready-to-use, customizable DCF model tailored for Global Partners LP (GLP).
- Small Business Owners: Understand the analytical approaches used for large companies like Global Partners LP (GLP) to inform your own business decisions.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for Global Partners LP (GLP).
- Real-World Data: Historical and projected financials for Global Partners LP (GLP) preloaded for in-depth analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into Global Partners LP (GLP).
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to Global Partners LP (GLP).
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results relevant to Global Partners LP (GLP).