|
ARES Commercial Real Estate Corporation (ACRE) DCF Valoración
US | Real Estate | REIT - Mortgage | 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
Ares Commercial Real Estate Corporation (ACRE) Bundle
¡Mejore sus opciones de inversión con la calculadora DCF (acre)! Explore las finanzas y gastos de crecimiento genuino Ares Commercial Real Estate Corporation, ajuste las proyecciones y gastos de crecimiento, y observe instantáneamente cómo estas modificaciones afectan el valor intrínseco de (acre).
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 | 77.3 | 78.7 | 102.1 | 109.0 | 1.1 | .9 | .8 | .7 | .6 | .5 |
| Revenue Growth, % | 0 | 1.85 | 29.71 | 6.84 | -98.99 | -15.15 | -15.15 | -15.15 | -15.15 | -15.15 |
| EBITDA | 38.2 | .0 | 61.2 | 95.2 | -11.7 | .2 | .2 | .1 | .1 | .1 |
| EBITDA, % | 49.41 | 0 | 59.94 | 87.32 | -1064.03 | 19.33 | 19.33 | 19.33 | 19.33 | 19.33 |
| Depreciation | 102.3 | 54.8 | 39.2 | 78.1 | .0 | .5 | .4 | .4 | .3 | .3 |
| Depreciation, % | 132.46 | 69.68 | 38.43 | 71.63 | 0 | 55.95 | 55.95 | 55.95 | 55.95 | 55.95 |
| EBIT | -64.2 | -54.8 | 22.0 | 17.1 | -11.7 | -.4 | -.3 | -.3 | -.2 | -.2 |
| EBIT, % | -83.05 | -69.68 | 21.51 | 15.69 | -1064.03 | -43.1 | -43.1 | -43.1 | -43.1 | -43.1 |
| Total Cash | 5.3 | 74.8 | 50.6 | 2,405.3 | 110.5 | .7 | .6 | .5 | .4 | .3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 42.4 | 7.5 | 131.2 | 155.7 | 35.7 | .7 | .6 | .5 | .4 | .4 |
| Account Receivables, % | 54.9 | 9.52 | 128.52 | 142.83 | 3241.78 | 72.88 | 72.88 | 72.88 | 72.88 | 72.88 |
| Inventories | .0 | .0 | -3.0 | -6.6 | .0 | .0 | .0 | .0 | .0 | .0 |
| Inventories, % | 0.000001294348 | 0.000001270842 | -2.92 | -6.02 | 0 | -1.79 | -1.79 | -1.79 | -1.79 | -1.79 |
| Accounts Payable | .7 | .4 | .6 | 1.9 | 2.3 | .2 | .2 | .1 | .1 | .1 |
| Accounts Payable, % | 0.92934 | 0.4969 | 0.55845 | 1.75 | 205.54 | 20.75 | 20.75 | 20.75 | 20.75 | 20.75 |
| Capital Expenditure | -1.7 | -.3 | -.1 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Capital Expenditure, % | -2.18 | -0.34821 | -0.14108 | 0 | 0 | -0.53431 | -0.53431 | -0.53431 | -0.53431 | -0.53431 |
| Tax Rate, % | 0.10024 | 0.10024 | 0.10024 | 0.10024 | 0.10024 | 0.10024 | 0.10024 | 0.10024 | 0.10024 | 0.10024 |
| EBITAT | -63.3 | -54.0 | 21.7 | 16.8 | -11.7 | -.4 | -.3 | -.3 | -.2 | -.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -4.3 | 35.2 | -59.8 | 75.3 | 102.1 | 33.1 | .2 | .1 | .1 | .1 |
| WACC, % | 7.9 | 7.88 | 7.91 | 7.89 | 7.97 | 7.91 | 7.91 | 7.91 | 7.91 | 7.91 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 31.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 0 | |||||||||
| Terminal Value | 2 | |||||||||
| Present Terminal Value | 1 | |||||||||
| Enterprise Value | 32 | |||||||||
| Net Debt | 1,507 | |||||||||
| Equity Value | -1,474 | |||||||||
| Diluted Shares Outstanding, MM | 54 | |||||||||
| Equity Value Per Share | -27.16 |
What You Will Receive
- Adjustable Financial Inputs: Modify key assumptions (growth %, cap rates, discount rates) to explore various scenarios.
- Comprehensive Market Data: Ares Commercial Real Estate Corporation’s (ACRE) financial metrics pre-loaded for efficient analysis.
- Automated DCF Calculations: The model computes Net Present Value (NPV) and intrinsic value seamlessly.
- Tailored and Professional Design: A refined Excel model that aligns with your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating forecasts, confirming strategies, and maximizing efficiency.
Key Features
- Comprehensive ACRE Data: Pre-loaded with Ares Commercial Real Estate Corporation’s historical performance metrics and future projections.
- Customizable Financial Inputs: Tailor revenue growth rates, operating margins, WACC, tax considerations, and capital expenditures.
- Adaptive Valuation Framework: Real-time updates to Net Present Value (NPV) and intrinsic value based on your specified inputs.
- Scenario Analysis: Develop various forecasting scenarios to explore different valuation possibilities.
- Intuitive User Interface: Easy to navigate, structured for both industry professionals and newcomers.
How It Works
- 1. Access the Template: Download and open the Excel file containing Ares Commercial Real Estate Corporation's (ACRE) preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures to fit your analysis.
- 3. Analyze Results Instantly: The DCF model automatically computes intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Evaluate various forecasts to assess different valuation possibilities.
- 5. Present with Assurance: Deliver professional valuation insights to bolster your decision-making process.
Why Choose This Calculator for Ares Commercial Real Estate Corporation (ACRE)?
- Accurate Data: Up-to-date ACRE financials provide 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 from starting from square one.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the real estate sector.
- User-Friendly: Easy-to-navigate design and clear instructions ensure accessibility for all users.
Who Should Use This Product?
- Real Estate Investors: Develop comprehensive valuation models for analyzing ACRE's market performance.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in ACRE's stock.
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Market Analysts: Gain insights into the valuation metrics of commercial real estate companies like ACRE.
What the Template Contains
- Preloaded ACRE Data: Historical and projected financial data, including revenue, net income, and property acquisitions.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting rental growth, occupancy rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for in-depth analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to assess performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and key assumptions.