ACRES Commercial Realty Corp. (ACR) 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
ACRES Commercial Realty Corp. (ACR) Bundle
Explore the financial prospects of ACRES Commercial Realty Corp. (ACR) with our easy-to-use DCF Calculator! Enter your growth, margins, and cost assumptions to calculate the intrinsic value of ACRES Commercial Realty Corp. (ACR) and refine your investment strategy.
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 | 47.5 | 19.5 | 44.9 | 70.0 | 80.2 | 102.6 | 131.3 | 167.9 | 214.8 | 274.7 |
| Revenue Growth, % | 0 | -58.99 | 130.24 | 56.04 | 14.6 | 27.91 | 27.91 | 27.91 | 27.91 | 27.91 |
| EBITDA | 38.2 | -136.8 | .0 | 88.4 | 150.0 | 37.0 | 47.4 | 60.6 | 77.5 | 99.1 |
| EBITDA, % | 80.41 | -702.01 | 0 | 126.33 | 186.92 | 36.08 | 36.08 | 36.08 | 36.08 | 36.08 |
| Depreciation | 110.0 | 62.5 | 4.6 | 65.1 | .1 | 62.3 | 79.6 | 101.9 | 130.3 | 166.7 |
| Depreciation, % | 231.58 | 320.53 | 10.26 | 93.01 | 0.11343 | 60.68 | 60.68 | 60.68 | 60.68 | 60.68 |
| EBIT | -71.8 | -199.3 | -4.6 | 23.3 | 149.9 | -15.8 | -20.2 | -25.8 | -33.0 | -42.3 |
| EBIT, % | -151.18 | -1022.54 | -10.26 | 33.33 | 186.8 | -15.39 | -15.39 | -15.39 | -15.39 | -15.39 |
| Total Cash | 600.7 | 31.4 | 35.5 | 67.8 | 83.4 | 97.7 | 125.0 | 159.8 | 204.4 | 261.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 27.6 | 14.9 | 24.7 | 13.3 | 12.6 | 46.0 | 58.8 | 75.2 | 96.2 | 123.0 |
| Account Receivables, % | 58 | 76.21 | 55.06 | 18.97 | 15.66 | 44.78 | 44.78 | 44.78 | 44.78 | 44.78 |
| Inventories | .0 | .0 | 17.8 | 53.8 | .0 | 23.9 | 30.6 | 39.1 | 50.1 | 64.0 |
| Inventories, % | -0.06313187 | 0.00000513189 | 39.78 | 76.81 | 0 | 23.3 | 23.3 | 23.3 | 23.3 | 23.3 |
| Accounts Payable | 4.4 | 6.0 | 5.8 | 6.9 | 8.5 | 15.1 | 19.3 | 24.7 | 31.6 | 40.5 |
| Accounts Payable, % | 9.28 | 30.98 | 12.98 | 9.89 | 10.54 | 14.73 | 14.73 | 14.73 | 14.73 | 14.73 |
| Capital Expenditure | .0 | .0 | -.1 | -.7 | .0 | -.3 | -.3 | -.4 | -.5 | -.7 |
| Capital Expenditure, % | 0 | -0.02565945 | -0.13597 | -1.06 | 0 | -0.24402 | -0.24402 | -0.24402 | -0.24402 | -0.24402 |
| Tax Rate, % | -2.03 | -2.03 | -2.03 | -2.03 | -2.03 | -2.03 | -2.03 | -2.03 | -2.03 | -2.03 |
| EBITAT | -71.3 | -199.3 | -4.6 | 23.0 | 152.9 | -15.7 | -20.1 | -25.7 | -32.9 | -42.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 15.6 | -122.5 | -28.0 | 64.0 | 209.0 | -4.4 | 43.9 | 56.2 | 71.9 | 91.9 |
| WACC, % | 8.04 | 8.09 | 8.09 | 8 | 8.09 | 8.06 | 8.06 | 8.06 | 8.06 | 8.06 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 193.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 94 | |||||||||
| Terminal Value | 1,546 | |||||||||
| Present Terminal Value | 1,049 | |||||||||
| Enterprise Value | 1,243 | |||||||||
| Net Debt | 1,637 | |||||||||
| Equity Value | -394 | |||||||||
| Diluted Shares Outstanding, MM | 9 | |||||||||
| Equity Value Per Share | -46.04 |
What You Will Get
- Real ACR Financial Data: Pre-filled with ACRES Commercial Realty Corp.'s historical and projected data for precise analysis.
- Fully Editable Template: Easily modify key inputs such as revenue growth, WACC, and EBITDA %.
- Automatic Calculations: Instantly see ACR's intrinsic value update based on your adjustments.
- Professional Valuation Tool: Tailored for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Intuitive structure and clear instructions suitable for all experience levels.
Key Features
- 🔍 Real-Life ACR Financials: Pre-filled historical and projected data for ACRES Commercial Realty Corp. (ACR).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate ACRES’ intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize ACRES’ valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- 1. Open the Template: Download and open the Excel file containing ACRES Commercial Realty Corp.'s (ACR) financial data.
- 2. Edit Assumptions: Modify key inputs such as occupancy rates, revenue growth, and operating expenses.
- 3. View Results Instantly: The DCF model automatically calculates the intrinsic value and NPV for ACRES Commercial Realty Corp. (ACR).
- 4. Test Scenarios: Analyze various forecasts to evaluate different valuation scenarios for ACRES Commercial Realty Corp. (ACR).
- 5. Use with Confidence: Share professional valuation insights to enhance your investment decisions regarding ACRES Commercial Realty Corp. (ACR).
Why Choose ACRES Commercial Realty Corp. (ACR) Calculator?
- Accuracy: Utilizes real ACRES financial data for precise calculations.
- Flexibility: Allows users to easily adjust and experiment with various inputs.
- Time-Saving: Eliminate the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability that CFOs demand.
- User-Friendly: Intuitive interface suitable for users without extensive financial modeling skills.
Who Should Use This Product?
- Investors: Evaluate ACRES Commercial Realty Corp.'s (ACR) performance before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts for ACRES Commercial Realty Corp. (ACR).
- Real Estate Developers: Understand how commercial real estate companies like ACRES Commercial Realty Corp. (ACR) are valued.
- Consultants: Provide detailed valuation analyses and reports for clients interested in ACRES Commercial Realty Corp. (ACR).
- Students and Educators: Utilize industry-specific data to practice and teach valuation principles related to ACRES Commercial Realty Corp. (ACR).
What the Template Contains
- Preloaded ACR Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.