Alliance Resource Partners, L.P. (ARLP) 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
Alliance Resource Partners, L.P. (ARLP) Bundle
Looking to gauge the intrinsic value of Alliance Resource Partners, L.P.? Our (ARLP) DCF Calculator integrates real-world data with extensive customization features, enabling you to refine your forecasts and enhance your investment choices.
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 | 1,961.7 | 1,328.1 | 1,570.0 | 2,406.5 | 2,566.7 | 2,860.9 | 3,188.9 | 3,554.4 | 3,961.8 | 4,416.0 |
| Revenue Growth, % | 0 | -32.3 | 18.21 | 53.28 | 6.66 | 11.46 | 11.46 | 11.46 | 11.46 | 11.46 |
| EBITDA | 765.8 | 234.0 | 483.5 | 934.2 | 948.5 | 933.9 | 1,041.0 | 1,160.3 | 1,293.3 | 1,441.6 |
| EBITDA, % | 39.03 | 17.62 | 30.79 | 38.82 | 36.95 | 32.64 | 32.64 | 32.64 | 32.64 | 32.64 |
| Depreciation | 313.2 | 317.4 | 265.1 | 276.7 | 268.0 | 450.2 | 501.8 | 559.4 | 623.5 | 694.9 |
| Depreciation, % | 15.96 | 23.9 | 16.88 | 11.5 | 10.44 | 15.74 | 15.74 | 15.74 | 15.74 | 15.74 |
| EBIT | 452.6 | -83.4 | 218.4 | 657.5 | 680.5 | 483.7 | 539.2 | 601.0 | 669.9 | 746.6 |
| EBIT, % | 23.07 | -6.28 | 13.91 | 27.32 | 26.51 | 16.91 | 16.91 | 16.91 | 16.91 | 16.91 |
| Total Cash | 36.5 | 55.6 | 122.4 | 296.0 | 59.8 | 162.9 | 181.6 | 202.4 | 225.6 | 251.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 161.9 | 108.1 | 130.2 | 250.0 | 292.3 | 265.8 | 296.3 | 330.3 | 368.2 | 410.4 |
| Account Receivables, % | 8.25 | 8.14 | 8.29 | 10.39 | 11.39 | 9.29 | 9.29 | 9.29 | 9.29 | 9.29 |
| Inventories | 101.3 | 56.4 | 60.3 | 77.3 | 127.6 | 122.6 | 136.7 | 152.4 | 169.8 | 189.3 |
| Inventories, % | 5.16 | 4.25 | 3.84 | 3.21 | 4.97 | 4.29 | 4.29 | 4.29 | 4.29 | 4.29 |
| Accounts Payable | 80.6 | 47.5 | 69.6 | 95.1 | 108.3 | 116.1 | 129.4 | 144.2 | 160.8 | 179.2 |
| Accounts Payable, % | 4.11 | 3.58 | 4.43 | 3.95 | 4.22 | 4.06 | 4.06 | 4.06 | 4.06 | 4.06 |
| Capital Expenditure | -305.9 | -121.1 | -123.0 | -286.4 | -379.3 | -338.9 | -377.7 | -421.0 | -469.3 | -523.1 |
| Capital Expenditure, % | -15.59 | -9.12 | -7.83 | -11.9 | -14.78 | -11.84 | -11.84 | -11.84 | -11.84 | -11.84 |
| Tax Rate, % | 2.22 | 2.22 | 2.22 | 2.22 | 2.22 | 2.22 | 2.22 | 2.22 | 2.22 | 2.22 |
| EBITAT | 444.5 | -83.4 | 222.8 | 608.8 | 665.4 | 472.7 | 526.8 | 587.2 | 654.5 | 729.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 269.1 | 178.6 | 360.9 | 487.7 | 474.7 | 623.2 | 619.7 | 690.8 | 769.9 | 858.2 |
| WACC, % | 9.95 | 9.96 | 9.96 | 9.89 | 9.94 | 9.94 | 9.94 | 9.94 | 9.94 | 9.94 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2,660.6 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 862 | |||||||||
| Terminal Value | 9,135 | |||||||||
| Present Terminal Value | 5,687 | |||||||||
| Enterprise Value | 8,348 | |||||||||
| Net Debt | 291 | |||||||||
| Equity Value | 8,057 | |||||||||
| Diluted Shares Outstanding, MM | 127 | |||||||||
| Equity Value Per Share | 63.35 |
What You Will Get
- Real ARLP Financial Data: Pre-filled with Alliance Resource Partners’ historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Alliance Resource Partners’ intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive ARLP Data: Pre-loaded with Alliance Resource Partners’ historical performance and future projections.
- Customizable Parameters: Tailor revenue growth, profit margins, discount rates, tax implications, and capital investments.
- Interactive Valuation Framework: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on user inputs.
- Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation possibilities.
- Intuitive Interface: Designed to be straightforward and accessible for both experienced users and newcomers.
How It Works
- Download the Template: Get instant access to the Excel-based ARLP DCF Calculator.
- Input Your Assumptions: Adjust yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically updates Alliance Resource Partners’ intrinsic value.
- Test Scenarios: Simulate different assumptions to evaluate potential valuation changes.
- Analyze and Decide: Use the results to guide your investment or financial analysis.
Why Choose This Calculator for Alliance Resource Partners, L.P. (ARLP)?
- Accuracy: Utilizes real Alliance Resource Partners financials for precise data.
- Flexibility: Allows users to easily test and adjust inputs as needed.
- Time-Saving: Eliminate the complexities of creating a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected by CFOs.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Finance Students: Explore the intricacies of coal mining valuation and apply your knowledge using real market data for Alliance Resource Partners, L.P. (ARLP).
- Academics: Integrate industry-specific financial models into your research or teaching materials related to energy and resources.
- Investors: Validate your investment strategies and evaluate the financial performance of Alliance Resource Partners, L.P. (ARLP).
- Analysts: Enhance your analytical capabilities with a ready-to-use, customizable DCF model tailored for the energy sector.
- Small Business Owners: Understand the valuation methodologies used to assess large energy companies like Alliance Resource Partners, L.P. (ARLP).
What the Template Contains
- Preloaded ARLP Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.