|
AMREP Corporation (AXR) DCF Valoración
US | Real Estate | Real Estate - Development | NYSE
|
- ✓ 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
¿Busca determinar el valor intrínseco de Amrep Corporation? Nuestra calculadora AXR DCF integra datos del mundo real con características integrales de personalización, lo que le permite ajustar los pronósticos y mejorar sus opciones de inversión.
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.