American Resources Corporation (AREC) 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
American Resources Corporation (AREC) Bundle
Simplify American Resources Corporation (AREC) valuation with this customizable DCF Calculator! Featuring real American Resources Corporation (AREC) financials and adjustable forecast inputs, you can test scenarios and uncover American Resources Corporation (AREC) fair value in minutes.
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 | 24.5 | 1.1 | 7.8 | 39.5 | 16.7 | 18.7 | 20.9 | 23.3 | 26.1 | 29.1 |
| Revenue Growth, % | 0 | -95.67 | 631.85 | 409 | -57.58 | 11.69 | 11.69 | 11.69 | 11.69 | 11.69 |
| EBITDA | -60.0 | -2.0 | -24.0 | 4.7 | -7.2 | -12.4 | -13.8 | -15.4 | -17.3 | -19.3 |
| EBITDA, % | -244.93 | -190.94 | -309.63 | 11.96 | -43.06 | -66.22 | -66.22 | -66.22 | -66.22 | -66.22 |
| Depreciation | 7.7 | 4.8 | 4.3 | 4.7 | 2.9 | 8.1 | 9.1 | 10.1 | 11.3 | 12.6 |
| Depreciation, % | 31.57 | 456.51 | 55.74 | 12.01 | 17.36 | 43.34 | 43.34 | 43.34 | 43.34 | 43.34 |
| EBIT | -67.7 | -6.9 | -28.3 | .0 | -10.1 | -13.5 | -15.1 | -16.8 | -18.8 | -21.0 |
| EBIT, % | -276.51 | -647.45 | -365.37 | -0.04945247 | -60.43 | -72.1 | -72.1 | -72.1 | -72.1 | -72.1 |
| Total Cash | .0 | 10.6 | 11.5 | 8.9 | 2.7 | 8.9 | 10.0 | 11.1 | 12.4 | 13.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 2.7 | .3 | 3.2 | .7 | .0 | 3.0 | 3.3 | 3.7 | 4.1 | 4.6 |
| Account Receivables, % | 10.86 | 25.75 | 40.95 | 1.67 | 0 | 15.85 | 15.85 | 15.85 | 15.85 | 15.85 |
| Inventories | .5 | .2 | .0 | .4 | .1 | .7 | .7 | .8 | .9 | 1.0 |
| Inventories, % | 2.11 | 14.2 | 0 | 1.13 | 0.3225 | 3.55 | 3.55 | 3.55 | 3.55 | 3.55 |
| Accounts Payable | 11.0 | 5.0 | 7.2 | 9.2 | 9.1 | 11.8 | 13.2 | 14.7 | 16.4 | 18.3 |
| Accounts Payable, % | 45.12 | 468.81 | 92.56 | 23.34 | 54.23 | 63.05 | 63.05 | 63.05 | 63.05 | 63.05 |
| Capital Expenditure | -.3 | .0 | -3.1 | .0 | .0 | -1.5 | -1.7 | -1.9 | -2.1 | -2.4 |
| Capital Expenditure, % | -1.34 | 0 | -39.57 | 0 | 0 | -8.18 | -8.18 | -8.18 | -8.18 | -8.18 |
| Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| EBITAT | -79.8 | -10.8 | -31.8 | .3 | -10.1 | -10.8 | -12.0 | -13.5 | -15.0 | -16.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -64.5 | -9.3 | -31.1 | 9.1 | -6.3 | -5.1 | -3.7 | -4.2 | -4.7 | -5.2 |
| WACC, % | 4.99 | 4.99 | 4.99 | 3.09 | 4.99 | 4.61 | 4.61 | 4.61 | 4.61 | 4.61 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -20.0 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | -5 | |||||||||
| Terminal Value | -487 | |||||||||
| Present Terminal Value | -388 | |||||||||
| Enterprise Value | -408 | |||||||||
| Net Debt | 55 | |||||||||
| Equity Value | -464 | |||||||||
| Diluted Shares Outstanding, MM | 75 | |||||||||
| Equity Value Per Share | -6.15 |
What You Will Receive
- Authentic AREC Financial Data: Pre-loaded with American Resources Corporation’s historical and projected data for in-depth analysis.
- Completely Customizable Template: Easily adjust key inputs such as revenue growth, WACC, and EBITDA %.
- Instant Calculations: Watch the intrinsic value of AREC update in real-time based on your modifications.
- Expert Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF outcomes.
- Intuitive Interface: Streamlined layout and straightforward instructions suitable for all skill levels.
Key Features
- 🔍 Real-Life AREC Financials: Pre-filled historical and projected data for American Resources Corporation (AREC).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate American Resources Corporation’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize American Resources Corporation’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- 1. Access the Template: Download and open the Excel file containing American Resources Corporation's (AREC) preloaded data.
- 2. Modify Assumptions: Adjust key parameters such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically computes intrinsic value and NPV in real-time.
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation results.
- 5. Present with Assurance: Deliver professional valuation insights to reinforce your decision-making.
Why Choose American Resources Corporation (AREC)?
- Innovative Solutions: Our cutting-edge technology streamlines resource management.
- Commitment to Sustainability: We prioritize environmentally responsible practices in all operations.
- Experienced Team: Our professionals bring years of industry knowledge to every project.
- Strong Financial Performance: Consistent growth and profitability ensure a solid investment.
- Community Focused: We invest in local communities and foster positive relationships.
Who Should Use This Product?
- Investors: Assess the true value of American Resources Corporation (AREC) before making investment choices.
- CFOs: Utilize a robust DCF model for financial reporting and analysis specific to AREC.
- Consultants: Easily modify the template for client valuation reports related to AREC.
- Entrepreneurs: Discover financial modeling techniques employed by leading companies like American Resources Corporation (AREC).
- Educators: Implement it as a teaching resource to illustrate valuation methods relevant to AREC.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled American Resources Corporation (AREC) 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 American Resources Corporation (AREC).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.