Equity Commonwealth (EQC) 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
Equity Commonwealth (EQC) Bundle
Evaluate Equity Commonwealth's financial prospects like an expert! This (EQC) DCF Calculator provides pre-filled financial data and complete flexibility to modify revenue growth, WACC, margins, and other essential assumptions to match your predictions.
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 | 127.9 | 66.3 | 58.0 | 63.1 | 60.5 | 52.1 | 44.8 | 38.5 | 33.1 | 28.5 |
| Revenue Growth, % | 0 | -48.16 | -12.49 | 8.86 | -4.14 | -13.98 | -13.98 | -13.98 | -13.98 | -13.98 |
| EBITDA | 43.0 | 4.2 | -5.3 | 8.6 | -3.9 | 3.9 | 3.4 | 2.9 | 2.5 | 2.2 |
| EBITDA, % | 33.63 | 6.32 | -9.2 | 13.59 | -6.46 | 7.57 | 7.57 | 7.57 | 7.57 | 7.57 |
| Depreciation | 113.0 | 81.4 | 81.1 | 72.4 | 17.4 | 43.4 | 37.4 | 32.1 | 27.6 | 23.8 |
| Depreciation, % | 88.37 | 122.85 | 139.84 | 114.62 | 28.82 | 83.44 | 83.44 | 83.44 | 83.44 | 83.44 |
| EBIT | -70.0 | -77.2 | -86.4 | -63.8 | -21.4 | -40.6 | -34.9 | -30.0 | -25.8 | -22.2 |
| EBIT, % | -54.75 | -116.53 | -149.04 | -101.04 | -35.29 | -78.01 | -78.01 | -78.01 | -78.01 | -78.01 |
| Total Cash | 2,795.6 | 2,987.2 | 2,801.0 | 2,582.2 | 2,160.5 | 52.1 | 44.8 | 38.5 | 33.1 | 28.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 19.6 | 14.7 | 15.5 | 16.0 | 15.7 | 12.0 | 10.4 | 8.9 | 7.7 | 6.6 |
| Account Receivables, % | 15.29 | 22.18 | 26.81 | 25.35 | 26 | 23.13 | 23.13 | 23.13 | 23.13 | 23.13 |
| Inventories | 2,825.2 | .0 | .0 | .0 | .0 | 10.4 | 9.0 | 7.7 | 6.6 | 5.7 |
| Inventories, % | 2209.78 | 0 | 0 | 0 | 0 | 20 | 20 | 20 | 20 | 20 |
| Accounts Payable | 37.2 | 20.6 | 19.8 | 25.9 | 27.3 | 18.8 | 16.2 | 13.9 | 12.0 | 10.3 |
| Accounts Payable, % | 29.06 | 31.06 | 34.07 | 41.08 | 45.1 | 36.07 | 36.07 | 36.07 | 36.07 | 36.07 |
| Capital Expenditure | -26.1 | -12.0 | -6.8 | -3.6 | .0 | -5.8 | -5.0 | -4.3 | -3.7 | -3.2 |
| Capital Expenditure, % | -20.38 | -18.16 | -11.73 | -5.67 | 0 | -11.19 | -11.19 | -11.19 | -11.19 | -11.19 |
| Tax Rate, % | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 |
| EBITAT | -69.8 | -77.1 | -87.1 | -49.4 | -20.9 | -38.5 | -33.2 | -28.5 | -24.5 | -21.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -2,790.5 | 2,805.8 | -14.4 | 25.1 | -1.8 | -16.2 | -.3 | -.2 | -.2 | -.2 |
| WACC, % | 6.15 | 6.15 | 6.15 | 6.12 | 6.15 | 6.14 | 6.14 | 6.14 | 6.14 | 6.14 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -16.0 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 0 | |||||||||
| Terminal Value | -9 | |||||||||
| Present Terminal Value | -7 | |||||||||
| Enterprise Value | -23 | |||||||||
| Net Debt | -2,161 | |||||||||
| Equity Value | 2,138 | |||||||||
| Diluted Shares Outstanding, MM | 110 | |||||||||
| Equity Value Per Share | 19.40 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real EQC financials.
- Real-World Data: Historical data and forward-looking estimates (highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe how your inputs affect Equity Commonwealth’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Customizable Financial Inputs: Adjust essential metrics such as revenue growth, operating margins, and capital investments.
- Instant DCF Valuation: Computes intrinsic value, net present value (NPV), and additional metrics in real-time.
- High-Precision Accuracy: Leverages Equity Commonwealth’s (EQC) actual financial data for dependable valuation results.
- Simplified Scenario Analysis: Evaluate various assumptions and effortlessly compare results.
- Efficiency Booster: Remove the necessity of constructing intricate valuation models from the ground up.
How It Works
- 1. Access the Template: Download and open the Excel file featuring Equity Commonwealth’s (EQC) preloaded data.
- 2. Adjust Key Inputs: Modify essential parameters such as growth rates, WACC, and capital expenditures.
- 3. Instant Results: The DCF model automatically computes intrinsic value and NPV in real-time.
- 4. Explore Scenarios: Evaluate various forecasts to investigate different valuation possibilities.
- 5. Present with Assurance: Deliver professional valuation insights to enhance your decision-making process.
Why Choose This Calculator for Equity Commonwealth (EQC)?
- Designed for Industry Experts: A sophisticated tool tailored for analysts, CFOs, and real estate consultants.
- Accurate Financial Insights: Equity Commonwealth’s historical and projected financial data preloaded for precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly Interface: Step-by-step guidance ensures a smooth experience throughout the process.
Who Should Use This Product?
- Real Estate Students: Understand property valuation methods and apply them with real-time data.
- Researchers: Integrate industry-standard models into academic studies or papers.
- Investors: Validate your predictions and evaluate valuation scenarios for Equity Commonwealth (EQC).
- Market Analysts: Enhance your analysis with a ready-to-use, adaptable DCF model.
- Property Developers: Discover how major REITs like Equity Commonwealth (EQC) are assessed and valued.
What the Template Contains
- Preloaded EQC 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.