Plains GP Holdings, L.P. (PAGP) DCF Valuation

Plains GP Holdings, L.P. (PAGP) 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

Plains GP Holdings, L.P. (PAGP) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Gain insights into your Plains GP Holdings, L.P. (PAGP) valuation analysis using our sophisticated DCF Calculator! Preloaded with current PAGP data, this Excel template enables you to adjust forecasts and assumptions to accurately determine the intrinsic value of Plains GP Holdings, L.P. (PAGP).


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 33,669.0 23,290.0 42,043.0 57,342.0 48,712.0 46,674.1 44,721.4 42,850.4 41,057.7 39,339.9
Revenue Growth, % 0 -30.83 80.52 36.39 -15.05 -4.18 -4.18 -4.18 -4.18 -4.18
EBITDA 3,258.0 -1,515.0 1,914.0 2,782.0 3,051.0 1,758.6 1,685.0 1,614.5 1,547.0 1,482.3
EBITDA, % 9.68 -6.5 4.55 4.85 6.26 3.77 3.77 3.77 3.77 3.77
Depreciation 604.0 656.0 777.0 968.0 1,051.0 961.9 921.7 883.1 846.1 810.7
Depreciation, % 1.79 2.82 1.85 1.69 2.16 2.06 2.06 2.06 2.06 2.06
EBIT 2,654.0 -2,171.0 1,137.0 1,814.0 2,000.0 796.7 763.4 731.4 700.8 671.5
EBIT, % 7.88 -9.32 2.7 3.16 4.11 1.71 1.71 1.71 1.71 1.71
Total Cash 47.0 25.0 452.0 404.0 453.0 276.0 264.4 253.4 242.8 232.6
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 3,614.0 2,553.0 4,705.0 3,907.0 3,760.0
Account Receivables, % 10.73 10.96 11.19 6.81 7.72
Inventories 604.0 647.0 783.0 729.0 548.0 824.3 789.8 756.8 725.1 694.8
Inventories, % 1.79 2.78 1.86 1.27 1.12 1.77 1.77 1.77 1.77 1.77
Accounts Payable 3,687.0 2,425.0 4,811.0 4,045.0 3,845.0 4,457.7 4,271.2 4,092.5 3,921.3 3,757.2
Accounts Payable, % 10.95 10.41 11.44 7.05 7.89 9.55 9.55 9.55 9.55 9.55
Capital Expenditure -1,181.0 -738.0 -336.0 -455.0 -559.0 -879.0 -842.3 -807.0 -773.3 -740.9
Capital Expenditure, % -3.51 -3.17 -0.79918 -0.79348 -1.15 -1.88 -1.88 -1.88 -1.88 -1.88
Tax Rate, % 87.73 87.73 87.73 87.73 87.73 87.73 87.73 87.73 87.73 87.73
EBITAT 2,445.3 -2,031.9 958.1 1,497.3 245.4 581.3 557.0 533.7 511.3 489.9
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 1,337.3 -2,357.9 1,497.1 2,096.3 865.4 334.1 669.5 641.5 614.7 589.0
WACC, % 6.63 6.68 6.36 6.31 3.96 5.99 5.99 5.99 5.99 5.99
PV UFCF
SUM PV UFCF 2,377.6
Long Term Growth Rate, % 0.50
Free cash flow (T + 1) 592
Terminal Value 10,788
Present Terminal Value 8,067
Enterprise Value 10,444
Net Debt 7,572
Equity Value 2,872
Diluted Shares Outstanding, MM 195
Equity Value Per Share 14.73

What You Will Get

  • Real Plains GP Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Plains GP Holdings, L.P. (PAGP).
  • Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis needs.
  • Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Plains GP Holdings, L.P.'s (PAGP) fair value.
  • Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections specific to Plains GP Holdings, L.P. (PAGP).
  • Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility in your financial assessments.

Key Features

  • Customizable Financial Inputs: Adjust key metrics such as revenue projections, EBITDA margins, and capital expenditure estimates.
  • Instant DCF Valuation: Automatically computes intrinsic value, NPV, and additional financial metrics in real-time.
  • High-Precision Analysis: Leverages Plains GP Holdings, L.P.’s [PAGP] actual financial data for accurate valuation results.
  • Effortless Scenario Testing: Easily evaluate various assumptions and analyze different outcomes.
  • Efficiency Booster: Streamlines the valuation process, eliminating the need for complex model creation from the ground up.

How It Works

  • Step 1: Download the prebuilt Excel template featuring Plains GP Holdings, L.P. (PAGP) data.
  • Step 2: Review the pre-filled sheets to familiarize yourself with the essential metrics.
  • Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
  • Step 4: Instantly see the recalculated results, including the intrinsic value of Plains GP Holdings, L.P. (PAGP).
  • Step 5: Make well-informed investment decisions or create reports based on the outputs.

Why Choose This Calculator for Plains GP Holdings, L.P. (PAGP)?

  • Designed for Experts: A sophisticated tool tailored for analysts, CFOs, and financial consultants.
  • Accurate Financial Data: Historical and projected financials for Plains GP Holdings, L.P. preloaded for precision.
  • Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
  • Comprehensive 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?

  • Professional Investors: Develop comprehensive and accurate valuation models for analyzing Plains GP Holdings, L.P. (PAGP).
  • Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
  • Consultants and Advisors: Deliver precise valuation insights to clients regarding Plains GP Holdings, L.P. (PAGP).
  • Students and Educators: Utilize real-world data for practicing and teaching financial modeling techniques.
  • Energy Sector Enthusiasts: Gain insights into how midstream energy companies like Plains GP Holdings, L.P. (PAGP) are valued in the market.

What the Template Contains

  • Historical Data: Includes Plains GP Holdings, L.P.’s (PAGP) past financials and baseline forecasts.
  • DCF and Levered DCF Models: Detailed templates to calculate Plains GP Holdings, L.P.’s (PAGP) intrinsic value.
  • WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital for Plains GP Holdings, L.P. (PAGP).
  • Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions for Plains GP Holdings, L.P. (PAGP).
  • Quarterly and Annual Statements: A complete breakdown of Plains GP Holdings, L.P.’s (PAGP) financials.
  • Interactive Dashboard: Visualize valuation results and projections for Plains GP Holdings, L.P. (PAGP) dynamically.