Adams Resources & Energy, Inc. (AE) 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
Adams Resources & Energy, Inc. (AE) Bundle
Engineered for accuracy, our (AE) DCF Calculator empowers you to evaluate Adams Resources & Energy, Inc. valuation using real-world financial data, offering complete flexibility to modify all essential parameters for enhanced projections.
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,811.2 | 1,022.4 | 2,025.2 | 3,366.9 | 2,745.3 | 3,447.5 | 4,329.3 | 5,436.7 | 6,827.4 | 8,573.8 |
Revenue Growth, % | 0 | -43.55 | 98.08 | 66.25 | -18.46 | 25.58 | 25.58 | 25.58 | 25.58 | 25.58 |
EBITDA | 24.4 | 12.8 | 36.0 | 29.0 | 31.7 | 44.1 | 55.4 | 69.5 | 87.3 | 109.7 |
EBITDA, % | 1.35 | 1.25 | 1.78 | 0.86067 | 1.16 | 1.28 | 1.28 | 1.28 | 1.28 | 1.28 |
Depreciation | 16.8 | 19.2 | 20.6 | 23.9 | 27.9 | 38.2 | 48.0 | 60.3 | 75.7 | 95.1 |
Depreciation, % | 0.9298 | 1.88 | 1.02 | 0.70937 | 1.01 | 1.11 | 1.11 | 1.11 | 1.11 | 1.11 |
EBIT | 7.6 | -6.3 | 15.4 | 5.1 | 3.9 | 5.9 | 7.4 | 9.2 | 11.6 | 14.6 |
EBIT, % | 0.4196 | -0.62078 | 0.75839 | 0.1513 | 0.14097 | 0.1699 | 0.1699 | 0.1699 | 0.1699 | 0.1699 |
Total Cash | 113.0 | 39.3 | 97.8 | 20.5 | 33.3 | 115.4 | 144.9 | 181.9 | 228.5 | 286.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 97.1 | 113.1 | 144.2 | 189.0 | 164.3 | 242.3 | 304.3 | 382.1 | 479.9 | 602.6 |
Account Receivables, % | 5.36 | 11.06 | 7.12 | 5.61 | 5.98 | 7.03 | 7.03 | 7.03 | 7.03 | 7.03 |
Inventories | 26.4 | 19.3 | 18.9 | 26.9 | 19.8 | 40.0 | 50.3 | 63.1 | 79.3 | 99.6 |
Inventories, % | 1.46 | 1.89 | 0.93531 | 0.79951 | 0.72222 | 1.16 | 1.16 | 1.16 | 1.16 | 1.16 |
Accounts Payable | 147.9 | 86.0 | 168.2 | 204.4 | 183.1 | 259.4 | 325.7 | 409.1 | 513.7 | 645.1 |
Accounts Payable, % | 8.16 | 8.41 | 8.31 | 6.07 | 6.67 | 7.52 | 7.52 | 7.52 | 7.52 | 7.52 |
Capital Expenditure | -35.7 | -5.0 | -12.4 | -7.5 | -11.9 | -25.7 | -32.3 | -40.6 | -50.9 | -64.0 |
Capital Expenditure, % | -1.97 | -0.48982 | -0.6114 | -0.22249 | -0.43336 | -0.74609 | -0.74609 | -0.74609 | -0.74609 | -0.74609 |
Tax Rate, % | 56.38 | 56.38 | 56.38 | 56.38 | 56.38 | 56.38 | 56.38 | 56.38 | 56.38 | 56.38 |
EBITAT | 5.9 | 1.1 | 11.7 | 3.3 | 1.7 | 3.1 | 3.9 | 4.8 | 6.1 | 7.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 11.4 | -55.5 | 71.4 | 3.1 | 28.2 | -6.3 | 13.7 | 17.2 | 21.6 | 27.2 |
WACC, % | 7.05 | 5.28 | 7 | 6.74 | 6.27 | 6.47 | 6.47 | 6.47 | 6.47 | 6.47 |
PV UFCF | ||||||||||
SUM PV UFCF | 57.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 28 | |||||||||
Terminal Value | 620 | |||||||||
Present Terminal Value | 453 | |||||||||
Enterprise Value | 510 | |||||||||
Net Debt | 20 | |||||||||
Equity Value | 490 | |||||||||
Diluted Shares Outstanding, MM | 3 | |||||||||
Equity Value Per Share | 190.69 |
What You Will Get
- Genuine AE Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Real-Time Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Evaluate various scenarios to assess Adams Resources & Energy’s future performance.
- User-Friendly Interface: Designed for professionals while remaining easy to use for newcomers.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Adams Resources & Energy, Inc. (AE).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to the energy sector.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to suit your analysis of Adams Resources & Energy, Inc. (AE).
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios pertinent to Adams Resources & Energy, Inc. (AE).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Download: Obtain the pre-formatted Excel file containing Adams Resources & Energy, Inc.'s (AE) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC to suit your analysis.
- Update Automatically: Watch as the intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various forecasts and compare results instantly.
- Make Decisions: Leverage the valuation findings to inform your investment approach.
Why Choose This Calculator for Adams Resources & Energy, Inc. (AE)?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for AE.
- Flexible Inputs: Modify the highlighted cells to explore different financial scenarios for AE.
- In-Depth Analysis: Automatically computes the intrinsic value and Net Present Value for Adams Resources & Energy.
- Preloaded Information: Access historical and projected data for precise analysis.
- Expert-Level Tool: Perfect for financial analysts, investors, and consultants focused on AE.
Who Should Use This Product?
- Investors: Evaluate Adams Resources & Energy, Inc.'s (AE) market position before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts for Adams Resources & Energy, Inc. (AE).
- Startup Founders: Understand the valuation strategies employed by established companies like Adams Resources & Energy, Inc. (AE).
- Consultants: Create comprehensive valuation reports tailored for clients interested in Adams Resources & Energy, Inc. (AE).
- Students and Educators: Utilize real-time data to explore and teach valuation principles related to Adams Resources & Energy, Inc. (AE).
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations for Adams Resources & Energy, Inc. (AE).
- Real-World Data: Historical and projected financials for Adams Resources & Energy, Inc. (AE) preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into Adams Resources & Energy, Inc. (AE).
- Key Ratios: Integrated analysis covering profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable insights.