Plains All American Pipeline, L.P. (PAA) 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
Plains All American Pipeline, L.P. (PAA) Bundle
Gain insights into your Plains All American Pipeline, L.P. (PAA) valuation analysis with our state-of-the-art DCF Calculator! Equipped with up-to-date PAA data, this Excel template enables you to adjust forecasts and assumptions for an accurate calculation of Plains All American Pipeline, L.P. (PAA) intrinsic value.
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 | 50,239.4 | 51,814.7 | 53,439.4 | 55,115.0 | 56,843.2 |
| Revenue Growth, % | 0 | -30.83 | 80.52 | 36.39 | -15.05 | 3.14 | 3.14 | 3.14 | 3.14 | 3.14 |
| EBITDA | 2,628.0 | -1,510.0 | 2,234.0 | 2,526.0 | 2,406.0 | 1,605.6 | 1,656.0 | 1,707.9 | 1,761.5 | 1,816.7 |
| EBITDA, % | 7.81 | -6.48 | 5.31 | 4.41 | 4.94 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 |
| Depreciation | 601.0 | 653.0 | 774.0 | 965.0 | 1,048.0 | 1,031.3 | 1,063.7 | 1,097.0 | 1,131.4 | 1,166.9 |
| Depreciation, % | 1.79 | 2.8 | 1.84 | 1.68 | 2.15 | 2.05 | 2.05 | 2.05 | 2.05 | 2.05 |
| EBIT | 2,027.0 | -2,163.0 | 1,460.0 | 1,561.0 | 1,358.0 | 574.3 | 592.3 | 610.9 | 630.1 | 649.8 |
| EBIT, % | 6.02 | -9.29 | 3.47 | 2.72 | 2.79 | 1.14 | 1.14 | 1.14 | 1.14 | 1.14 |
| Total Cash | 45.0 | 22.0 | 449.0 | 401.0 | 450.0 | 293.3 | 302.5 | 312.0 | 321.8 | 331.9 |
| 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 | 4,764.6 | 4,914.0 | 5,068.1 | 5,227.0 | 5,390.9 |
| Account Receivables, % | 10.73 | 10.96 | 11.19 | 6.81 | 7.72 | 9.48 | 9.48 | 9.48 | 9.48 | 9.48 |
| Inventories | 604.0 | 647.0 | 783.0 | 729.0 | 548.0 | 887.3 | 915.1 | 943.8 | 973.4 | 1,003.9 |
| Inventories, % | 1.79 | 2.78 | 1.86 | 1.27 | 1.12 | 1.77 | 1.77 | 1.77 | 1.77 | 1.77 |
| Accounts Payable | 3,686.0 | 2,437.0 | 4,810.0 | 4,044.0 | 3,844.0 | 4,802.5 | 4,953.1 | 5,108.4 | 5,268.5 | 5,433.7 |
| Accounts Payable, % | 10.95 | 10.46 | 11.44 | 7.05 | 7.89 | 9.56 | 9.56 | 9.56 | 9.56 | 9.56 |
| Capital Expenditure | -1,181.0 | -738.0 | -336.0 | -455.0 | -559.0 | -946.2 | -975.8 | -1,006.4 | -1,038.0 | -1,070.5 |
| Capital Expenditure, % | -3.51 | -3.17 | -0.79918 | -0.79348 | -1.15 | -1.88 | -1.88 | -1.88 | -1.88 | -1.88 |
| Tax Rate, % | 24.21 | 24.21 | 24.21 | 24.21 | 24.21 | 24.21 | 24.21 | 24.21 | 24.21 | 24.21 |
| EBITAT | 1,959.3 | -2,147.2 | 1,200.8 | 1,142.4 | 1,029.2 | 490.6 | 506.0 | 521.9 | 538.3 | 555.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 847.3 | -2,463.2 | 1,723.8 | 1,738.4 | 1,646.2 | 190.4 | 567.2 | 585.0 | 603.3 | 622.3 |
| WACC, % | 8.91 | 8.96 | 8.63 | 8.46 | 8.51 | 8.69 | 8.69 | 8.69 | 8.69 | 8.69 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,953.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 635 | |||||||||
| Terminal Value | 9,481 | |||||||||
| Present Terminal Value | 6,249 | |||||||||
| Enterprise Value | 8,202 | |||||||||
| Net Debt | 7,707 | |||||||||
| Equity Value | 495 | |||||||||
| Diluted Shares Outstanding, MM | 699 | |||||||||
| Equity Value Per Share | 0.71 |
What You Will Receive
- Authentic PAA Financial Data: Pre-populated with Plains All American’s historical and forecasted data for accurate assessment.
- Completely Customizable Template: Easily adjust essential inputs such as revenue growth, WACC, and EBITDA %.
- Instantaneous Calculations: Watch the intrinsic value of PAA update in real-time as you make adjustments.
- Expert Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF outcomes.
- Intuitive Design: Clear layout and straightforward instructions suitable for all skill levels.
Key Features
- Real Plains All American Financials: Access precise pre-loaded historical data and future forecasts.
- Customizable Forecast Assumptions: Modify yellow-highlighted cells such as WACC, growth rates, and profit margins.
- Dynamic Calculations: Automatic updates to DCF, Net Present Value (NPV), and cash flow analyses.
- Visual Dashboard: User-friendly charts and summaries to help visualize your valuation outcomes.
- For Professionals and Beginners: An easy-to-navigate structure designed for investors, CFOs, and consultants.
How It Works
- Step 1: Download the Excel file for Plains All American Pipeline, L.P. (PAA).
- Step 2: Review the pre-filled financial data and forecasts for Plains All American Pipeline.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify your assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose This Calculator for Plains All American Pipeline, L.P. (PAA)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
- Real-Time Valuation: Observe immediate updates to Plains All American's valuation as you modify inputs.
- Preloaded Financials: Comes equipped with Plains All American's actual financial data for swift evaluations.
- Preferred by Experts: Widely utilized by investors and financial analysts for strategic decision-making.
Who Should Use Plains All American Pipeline, L.P. (PAA)?
- Investors: Make informed investment choices with a reliable assessment of pipeline operations.
- Financial Analysts: Streamline your analysis with comprehensive data on pipeline performance and market trends.
- Consultants: Easily modify reports for clients focused on energy and infrastructure sectors.
- Energy Enthusiasts: Enhance your knowledge of the pipeline industry through detailed insights and case studies.
- Educators and Students: Utilize it as a resource for practical applications in energy finance courses.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for Plains All American Pipeline, L.P. (PAA).
- Real-World Data: Plains All American’s historical and projected financials 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 providing deeper insights into performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to Plains All American Pipeline, L.P. (PAA).
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results related to Plains All American Pipeline, L.P. (PAA).