Avalon Holdings Corporation (AWX) 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
Avalon Holdings Corporation (AWX) Bundle
Evaluate Avalon Holdings Corporation's (AWX) financial outlook like a professional! This (AWX) DCF Calculator provides you with pre-filled financial data along with the full flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your 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 | 68.4 | 58.7 | 70.4 | 81.2 | 80.5 | 84.6 | 88.9 | 93.4 | 98.1 | 103.1 |
| Revenue Growth, % | 0 | -14.1 | 19.86 | 15.34 | -0.81917 | 5.07 | 5.07 | 5.07 | 5.07 | 5.07 |
| EBITDA | 3.0 | 3.0 | 3.7 | 4.1 | 3.9 | 4.2 | 4.4 | 4.6 | 4.8 | 5.1 |
| EBITDA, % | 4.37 | 5.17 | 5.22 | 5 | 4.89 | 4.93 | 4.93 | 4.93 | 4.93 | 4.93 |
| Depreciation | 2.5 | 2.9 | 3.1 | 3.5 | 3.8 | 3.7 | 3.9 | 4.1 | 4.3 | 4.6 |
| Depreciation, % | 3.69 | 4.95 | 4.42 | 4.29 | 4.75 | 4.42 | 4.42 | 4.42 | 4.42 | 4.42 |
| EBIT | .5 | .1 | .6 | .6 | .1 | .4 | .5 | .5 | .5 | .5 |
| EBIT, % | 0.67586 | 0.21117 | 0.79707 | 0.712 | 0.13786 | 0.50679 | 0.50679 | 0.50679 | 0.50679 | 0.50679 |
| Total Cash | 1.4 | 4.2 | 3.3 | 1.6 | 1.2 | 2.9 | 3.1 | 3.2 | 3.4 | 3.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 12.6 | 9.3 | 10.5 | 11.7 | 10.1 | 12.9 | 13.5 | 14.2 | 15.0 | 15.7 |
| Account Receivables, % | 18.45 | 15.89 | 14.93 | 14.44 | 12.5 | 15.24 | 15.24 | 15.24 | 15.24 | 15.24 |
| Inventories | .8 | .9 | 1.1 | 1.5 | 1.7 | 1.4 | 1.5 | 1.5 | 1.6 | 1.7 |
| Inventories, % | 1.19 | 1.55 | 1.57 | 1.8 | 2.06 | 1.63 | 1.63 | 1.63 | 1.63 | 1.63 |
| Accounts Payable | 11.7 | 9.1 | 10.2 | 11.0 | 9.7 | 12.3 | 12.9 | 13.6 | 14.3 | 15.0 |
| Accounts Payable, % | 17.14 | 15.49 | 14.44 | 13.54 | 11.99 | 14.52 | 14.52 | 14.52 | 14.52 | 14.52 |
| Capital Expenditure | -7.2 | -4.5 | -4.4 | -6.4 | -3.9 | -6.3 | -6.6 | -7.0 | -7.3 | -7.7 |
| Capital Expenditure, % | -10.6 | -7.75 | -6.29 | -7.88 | -4.84 | -7.47 | -7.47 | -7.47 | -7.47 | -7.47 |
| Tax Rate, % | 10.67 | 10.67 | 10.67 | 10.67 | 10.67 | 10.67 | 10.67 | 10.67 | 10.67 | 10.67 |
| EBITAT | .7 | -.1 | .6 | .6 | .1 | .3 | .4 | .4 | .4 | .4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -5.8 | -1.2 | -1.0 | -3.0 | .1 | -2.2 | -2.5 | -2.6 | -2.7 | -2.9 |
| WACC, % | 6.59 | 2.21 | 6.59 | 6.59 | 6.13 | 5.62 | 5.62 | 5.62 | 5.62 | 5.62 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -10.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -3 | |||||||||
| Terminal Value | -80 | |||||||||
| Present Terminal Value | -61 | |||||||||
| Enterprise Value | -72 | |||||||||
| Net Debt | 34 | |||||||||
| Equity Value | -106 | |||||||||
| Diluted Shares Outstanding, MM | 4 | |||||||||
| Equity Value Per Share | -27.12 |
What You Will Get
- Real AWX Financial Data: Pre-filled with Avalon Holdings Corporation’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Avalon Holdings Corporation’s 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
- Real-Time AWX Data: Pre-loaded with Avalon Holdings Corporation's historical performance metrics and future projections.
- Comprehensive Input Customization: Tailor revenue growth, profit margins, WACC, tax rates, and capital expenditure assumptions.
- Interactive Valuation Model: Automatically recalculates Net Present Value (NPV) and intrinsic value based on your specified parameters.
- Scenario Analysis: Develop multiple forecasting scenarios to explore various valuation possibilities.
- Intuitive User Interface: Designed to be straightforward and accessible for both experienced professionals and newcomers.
How It Works
- Download: Get the comprehensive Excel file featuring Avalon Holdings Corporation’s (AWX) financial data.
- Customize: Modify projections, including revenue growth, EBITDA %, and WACC to fit your analysis.
- Update Automatically: Watch as the intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and instantly compare the results.
- Make Decisions: Leverage the valuation insights to inform your investment strategy.
Why Choose This Calculator for Avalon Holdings Corporation (AWX)?
- Accurate Data: Utilize real Avalon financials for dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants alike.
- User-Friendly: Easy-to-navigate design and clear instructions ensure accessibility for all users.
Who Should Use This Product?
- Investors: Evaluate Avalon Holdings Corporation’s (AWX) valuation before making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and validate financial forecasts for AWX.
- Startup Founders: Gain insights into how companies like Avalon Holdings Corporation (AWX) are assessed in the market.
- Consultants: Provide detailed valuation analyses and reports for clients considering AWX.
- Students and Educators: Utilize real-time data from Avalon Holdings Corporation (AWX) to practice and teach valuation concepts.
What the Avalon Holdings Corporation (AWX) Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations specific to Avalon Holdings Corporation.
- Real-World Data: Historical and projected financials for Avalon Holdings Corporation preloaded for thorough analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into performance.
- Key Ratios: Integrated analysis for assessing profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables presenting clear, actionable insights for decision-making.