USA Compression Partners, LP (USAC) 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
USA Compression Partners, LP (USAC) Bundle
Whether you’re an investor or analyst, this USA Compression Partners, LP (USAC) DCF Calculator is your go-to tool for accurate valuation. Preloaded with real data from USA Compression Partners, you can adjust forecasts and instantly observe the effects.
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 | 698.4 | 667.7 | 632.6 | 704.6 | 846.2 | 892.3 | 941.0 | 992.4 | 1,046.5 | 1,103.6 |
| Revenue Growth, % | 0 | -4.39 | -5.25 | 11.37 | 20.09 | 5.46 | 5.46 | 5.46 | 5.46 | 5.46 |
| EBITDA | 400.6 | -225.4 | 379.8 | 406.1 | 485.7 | 354.6 | 373.9 | 394.3 | 415.8 | 438.5 |
| EBITDA, % | 57.36 | -33.76 | 60.04 | 57.63 | 57.39 | 39.73 | 39.73 | 39.73 | 39.73 | 39.73 |
| Depreciation | 231.4 | 239.0 | 238.8 | 236.7 | 246.1 | 302.2 | 318.7 | 336.1 | 354.5 | 373.8 |
| Depreciation, % | 33.14 | 35.79 | 37.74 | 33.59 | 29.08 | 33.87 | 33.87 | 33.87 | 33.87 | 33.87 |
| EBIT | 169.2 | -464.4 | 141.1 | 169.4 | 239.6 | 52.3 | 55.2 | 58.2 | 61.4 | 64.7 |
| EBIT, % | 24.22 | -69.55 | 22.3 | 24.04 | 28.31 | 5.86 | 5.86 | 5.86 | 5.86 | 5.86 |
| Total Cash | .0 | .0 | -18.6 | .0 | .0 | -5.2 | -5.5 | -5.8 | -6.1 | -6.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 136.8 | 112.5 | 113.2 | 83.9 | 95.4 | 138.3 | 145.9 | 153.8 | 162.2 | 171.1 |
| Account Receivables, % | 19.59 | 16.85 | 17.89 | 11.9 | 11.28 | 15.5 | 15.5 | 15.5 | 15.5 | 15.5 |
| Inventories | 91.9 | 84.6 | 85.8 | 93.8 | 114.7 | 118.3 | 124.7 | 131.5 | 138.7 | 146.3 |
| Inventories, % | 13.16 | 12.68 | 13.56 | 13.31 | 13.56 | 13.25 | 13.25 | 13.25 | 13.25 | 13.25 |
| Accounts Payable | 21.7 | 13.5 | 22.5 | 35.3 | 39.8 | 32.9 | 34.6 | 36.5 | 38.5 | 40.6 |
| Accounts Payable, % | 3.11 | 2.03 | 3.56 | 5.01 | 4.7 | 3.68 | 3.68 | 3.68 | 3.68 | 3.68 |
| Capital Expenditure | -171.1 | -109.1 | -45.2 | -134.2 | -238.5 | -170.0 | -179.2 | -189.0 | -199.3 | -210.2 |
| Capital Expenditure, % | -24.51 | -16.34 | -7.15 | -19.05 | -28.19 | -19.05 | -19.05 | -19.05 | -19.05 | -19.05 |
| Tax Rate, % | 1.96 | 1.96 | 1.96 | 1.96 | 1.96 | 1.96 | 1.96 | 1.96 | 1.96 | 1.96 |
| EBITAT | 160.2 | -465.4 | 130.0 | 163.9 | 234.9 | 50.4 | 53.2 | 56.1 | 59.1 | 62.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 13.5 | -312.1 | 330.7 | 300.5 | 214.4 | 129.3 | 180.5 | 190.3 | 200.7 | 211.6 |
| WACC, % | 8.57 | 8.76 | 8.47 | 8.64 | 8.69 | 8.63 | 8.63 | 8.63 | 8.63 | 8.63 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 704.5 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 220 | |||||||||
| Terminal Value | 4,757 | |||||||||
| Present Terminal Value | 3,145 | |||||||||
| Enterprise Value | 3,850 | |||||||||
| Net Debt | 2,351 | |||||||||
| Equity Value | 1,499 | |||||||||
| Diluted Shares Outstanding, MM | 101 | |||||||||
| Equity Value Per Share | 14.89 |
What You Will Receive
- Customizable Excel Template: A fully editable Excel-based DCF Calculator featuring pre-populated financial data for USA Compression Partners, LP (USAC).
- Actual Data: Access to historical data and forward-looking projections (displayed in the highlighted cells).
- Flexible Forecasting: Adjust forecast parameters such as revenue growth, EBITDA margin, and WACC.
- Instant Calculations: Quickly observe how your inputs affect the valuation of USA Compression Partners, LP (USAC).
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for easy navigation and user-friendliness, complete with step-by-step guidance.
Key Features
- Comprehensive Data: USA Compression Partners, LP’s (USAC) historical financial statements and pre-filled projections.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
- Real-Time Insights: View USA Compression's (USAC) intrinsic value recalculating instantly.
- Intuitive Visualizations: Dashboard graphs showcase valuation outcomes and essential metrics.
- Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.
How It Works
- Download the Template: Get immediate access to the Excel-based USAC DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates USA Compression Partners' intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the findings to inform your investment or financial strategy.
Why Choose This Calculator for USA Compression Partners, LP (USAC)?
- Accurate Data: Utilize real financials from USA Compression Partners for trustworthy valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-built calculations save you from starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the energy sector.
- User-Friendly: Easy-to-navigate layout and clear instructions make it accessible for all users.
Who Should Use This Product?
- Investors: Accurately estimate USA Compression Partners, LP’s (USAC) fair value before making investment decisions.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis of USA Compression Partners, LP (USAC).
- Consultants: Quickly adapt the template for valuation reports tailored for USA Compression Partners, LP (USAC) clients.
- Entrepreneurs: Gain insights into financial modeling practices employed by leading companies like USA Compression Partners, LP (USAC).
- Educators: Use it as a teaching tool to illustrate valuation methodologies relevant to USA Compression Partners, LP (USAC).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled USA Compression Partners 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 USA Compression Partners (USAC).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.