AMREP Corporation (AXR) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
AMREP Corporation (AXR) Bundle
Looking to determine the intrinsic value of AMREP Corporation? Our AXR DCF Calculator integrates real-world data with comprehensive customization features, enabling you to adjust 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 | 18.8 | 40.1 | 62.5 | 48.7 | 51.4 | 69.3 | 93.4 | 125.9 | 169.8 | 229.0 |
Revenue Growth, % | 0 | 113.33 | 55.93 | -22.09 | 5.53 | 34.84 | 34.84 | 34.84 | 34.84 | 34.84 |
EBITDA | -2.0 | 9.0 | 21.5 | 5.9 | 7.8 | 10.2 | 13.7 | 18.5 | 24.9 | 33.6 |
EBITDA, % | -10.87 | 22.58 | 34.46 | 12.11 | 15.09 | 14.67 | 14.67 | 14.67 | 14.67 | 14.67 |
Depreciation | 21.7 | 31.0 | 37.6 | 35.2 | .1 | 43.0 | 58.0 | 78.2 | 105.4 | 142.1 |
Depreciation, % | 115.51 | 77.42 | 60.22 | 72.42 | 0.29006 | 62.07 | 62.07 | 62.07 | 62.07 | 62.07 |
EBIT | -23.7 | -22.0 | -16.1 | -29.4 | 7.6 | -31.3 | -42.2 | -57.0 | -76.8 | -103.6 |
EBIT, % | -126.38 | -54.84 | -25.76 | -60.31 | 14.8 | -45.22 | -45.22 | -45.22 | -45.22 | -45.22 |
Total Cash | 17.5 | 24.8 | 15.7 | 20.0 | 29.7 | 38.7 | 52.1 | 70.3 | 94.8 | 127.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .2 | .0 | .0 | .0 | .0 | .2 | .3 | .3 | .5 | .6 |
Account Receivables, % | 1.13 | 0.09234071 | 0 | 0.08423042 | 0.05256088 | 0.27263 | 0.27263 | 0.27263 | 0.27263 | 0.27263 |
Inventories | 53.4 | 55.6 | 67.2 | 65.6 | 66.0 | 69.3 | 93.4 | 125.9 | 169.8 | 229.0 |
Inventories, % | 284.56 | 138.73 | 107.63 | 134.82 | 128.45 | 100 | 100 | 100 | 100 | 100 |
Accounts Payable | 1.1 | 1.4 | 3.0 | 1.9 | 2.1 | 3.1 | 4.2 | 5.6 | 7.6 | 10.2 |
Accounts Payable, % | 6.1 | 3.44 | 4.84 | 3.84 | 4.07 | 4.46 | 4.46 | 4.46 | 4.46 | 4.46 |
Capital Expenditure | .0 | .0 | -1.3 | -.1 | -.5 | -.5 | -.6 | -.8 | -1.1 | -1.5 |
Capital Expenditure, % | -0.04791567 | -0.01247847 | -2.06 | -0.26913 | -0.88964 | -0.65581 | -0.65581 | -0.65581 | -0.65581 | -0.65581 |
Tax Rate, % | 20.59 | 20.59 | 20.59 | 20.59 | 20.59 | 20.59 | 20.59 | 20.59 | 20.59 | 20.59 |
EBITAT | -18.4 | -16.2 | -11.8 | -83.7 | 6.0 | -25.3 | -34.1 | -46.0 | -62.1 | -83.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -49.2 | 13.1 | 14.5 | -48.2 | 5.6 | 14.8 | .1 | .1 | .2 | .3 |
WACC, % | 8.67 | 8.67 | 8.67 | 8.67 | 8.67 | 8.67 | 8.67 | 8.67 | 8.67 | 8.67 |
PV UFCF | ||||||||||
SUM PV UFCF | 14.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 0 | |||||||||
Terminal Value | 4 | |||||||||
Present Terminal Value | 3 | |||||||||
Enterprise Value | 17 | |||||||||
Net Debt | -30 | |||||||||
Equity Value | 46 | |||||||||
Diluted Shares Outstanding, MM | 5 | |||||||||
Equity Value Per Share | 8.67 |
What You Will Get
- Real AMREP Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for AMREP Corporation (AXR).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to AMREP Corporation (AXR).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on AMREP Corporation (AXR)'s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for AMREP Corporation (AXR).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for AMREP Corporation (AXR).
Key Features
- 🔍 Real-Life AXR Financials: Pre-filled historical and projected data for AMREP Corporation.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate AMREP’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize AMREP’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review AMREP Corporation’s (AXR) pre-filled financial data and forecasts.
- Step 3: Modify critical inputs like revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Watch the DCF model update instantly as you tweak assumptions.
- Step 5: Analyze the outputs and use the results for investment decisions.
Why Choose AMREP Corporation (AXR)?
- Time Efficiency: Skip the hassle of building a financial model from the ground up – our solutions are readily available.
- Enhanced Accuracy: Dependable financial insights and calculations minimize valuation errors.
- Completely Customizable: Adjust the model to align with your specific assumptions and forecasts.
- User-Friendly: Intuitive charts and outputs facilitate straightforward analysis of results.
- Preferred by Professionals: Developed for experts who prioritize accuracy and functionality.
Who Should Use This Product?
- Investors: Evaluate AMREP Corporation’s (AXR) market position before making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and assess financial forecasts for AMREP Corporation (AXR).
- Startup Founders: Discover valuation strategies employed by established companies like AMREP Corporation (AXR).
- Consultants: Provide comprehensive valuation analyses and reports for clients involving AMREP Corporation (AXR).
- Students and Educators: Utilize current data on AMREP Corporation (AXR) to practice and teach valuation principles.
What the Template Contains
- Historical Data: Includes AMREP Corporation’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate AMREP Corporation’s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of AMREP Corporation’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.