Clipper Realty Inc. (CLPR) 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
Clipper Realty Inc. (CLPR) Bundle
Explore Clipper Realty Inc. (CLPR)'s financial outlook with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to determine Clipper Realty Inc. (CLPR)'s intrinsic value and shape your investment approach.
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 | 116.2 | 122.9 | 122.7 | 129.7 | 138.2 | 144.4 | 150.8 | 157.6 | 164.6 | 172.0 |
| Revenue Growth, % | 0 | 5.75 | -0.0984941 | 5.72 | 6.52 | 4.47 | 4.47 | 4.47 | 4.47 | 4.47 |
| EBITDA | 53.1 | 54.9 | 52.7 | 54.6 | 58.2 | 62.9 | 65.7 | 68.6 | 71.7 | 74.9 |
| EBITDA, % | 45.75 | 44.72 | 42.95 | 42.1 | 42.14 | 43.53 | 43.53 | 43.53 | 43.53 | 43.53 |
| Depreciation | 106.7 | 91.6 | 95.7 | 102.1 | 28.8 | 99.3 | 103.8 | 108.4 | 113.2 | 118.3 |
| Depreciation, % | 91.83 | 74.53 | 78.01 | 78.7 | 20.84 | 68.78 | 68.78 | 68.78 | 68.78 | 68.78 |
| EBIT | -53.5 | -36.6 | -43.0 | -47.5 | 29.4 | -36.5 | -38.1 | -39.8 | -41.6 | -43.4 |
| EBIT, % | -46.08 | -29.81 | -35.06 | -36.6 | 21.3 | -25.25 | -25.25 | -25.25 | -25.25 | -25.25 |
| Total Cash | 42.5 | 72.1 | 34.5 | 18.2 | 22.2 | 44.3 | 46.3 | 48.3 | 50.5 | 52.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 4.2 | 7.0 | 10.3 | 5.0 | 5.2 | 7.3 | 7.6 | 8.0 | 8.3 | 8.7 |
| Account Receivables, % | 3.6 | 5.7 | 8.36 | 3.86 | 3.75 | 5.05 | 5.05 | 5.05 | 5.05 | 5.05 |
| Inventories | 14.4 | 17.0 | 17.7 | 12.5 | .0 | 14.5 | 15.2 | 15.9 | 16.6 | 17.3 |
| Inventories, % | 12.42 | 13.82 | 14.42 | 9.64 | 0 | 10.06 | 10.06 | 10.06 | 10.06 | 10.06 |
| Accounts Payable | 13.0 | 11.7 | 19.6 | 17.1 | 21.0 | 18.8 | 19.6 | 20.5 | 21.4 | 22.4 |
| Accounts Payable, % | 11.22 | 9.54 | 15.94 | 13.17 | 15.19 | 13.01 | 13.01 | 13.01 | 13.01 | 13.01 |
| Capital Expenditure | -43.8 | -31.8 | -35.5 | -45.5 | .0 | -36.8 | -38.5 | -40.2 | -42.0 | -43.9 |
| Capital Expenditure, % | -37.68 | -25.89 | -28.95 | -35.03 | 0 | -25.51 | -25.51 | -25.51 | -25.51 | -25.51 |
| Tax Rate, % | 62.09 | 62.09 | 62.09 | 62.09 | 62.09 | 62.09 | 62.09 | 62.09 | 62.09 | 62.09 |
| EBITAT | -502.7 | -137.8 | -105.7 | -20.8 | 11.2 | -27.8 | -29.1 | -30.4 | -31.7 | -33.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -445.4 | -84.7 | -41.7 | 43.8 | 56.2 | 15.8 | 36.1 | 37.7 | 39.4 | 41.1 |
| WACC, % | 4.81 | 4.81 | 4.81 | 2.45 | 2.2 | 3.81 | 3.81 | 3.81 | 3.81 | 3.81 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 150.3 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 42 | |||||||||
| Terminal Value | 2,312 | |||||||||
| Present Terminal Value | 1,917 | |||||||||
| Enterprise Value | 2,068 | |||||||||
| Net Debt | 1,183 | |||||||||
| Equity Value | 884 | |||||||||
| Diluted Shares Outstanding, MM | 16 | |||||||||
| Equity Value Per Share | 55.05 |
What You Will Get
- Real Clipper Realty Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Clipper Realty Inc. (CLPR).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to Clipper Realty Inc. (CLPR).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Clipper Realty Inc.'s (CLPR) fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for Clipper Realty Inc. (CLPR).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Clipper Realty Inc. (CLPR).
Key Features
- Comprehensive Clipper Realty Data: Gain access to reliable historical performance and future outlooks.
- Adjustable Forecast Parameters: Modify highlighted cells for metrics like cap rates, occupancy rates, and revenue growth.
- Real-Time Calculations: Instant updates to DCF, Net Present Value (NPV), and revenue analysis.
- User-Friendly Dashboard: Clear charts and summaries to help you interpret your valuation findings.
- Suitable for All Skill Levels: An intuitive design tailored for investors, analysts, and real estate professionals.
How It Works
- Download the Template: Gain immediate access to the Excel-based CLPR DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other factors.
- Instant Calculations: The model automatically recalculates Clipper Realty Inc.'s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation shifts.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis.
Why Choose Clipper Realty Inc. (CLPR) Calculator?
- User-Friendly Interface: Ideal for both novice and seasoned investors.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Valuation: Observe immediate updates to Clipper Realty’s valuation as you modify inputs.
- Preloaded Data: Comes with Clipper Realty’s actual financial metrics for swift evaluations.
- Endorsed by Experts: Favored by analysts and investors for making strategic choices.
Who Should Use Clipper Realty Inc. (CLPR)?
- Real Estate Students: Explore property valuation methods and apply them to real market data.
- Researchers: Integrate advanced models into academic studies or real estate research.
- Investors: Validate your investment strategies and evaluate valuation metrics for Clipper Realty Inc. (CLPR).
- Financial Analysts: Enhance your analysis with a ready-to-use, customizable DCF model tailored for real estate.
- Property Managers: Understand how publicly traded real estate companies like Clipper Realty Inc. (CLPR) are assessed.
What the Template Contains
- Pre-Filled Data: Contains Clipper Realty Inc.'s historical financials and future projections.
- Discounted Cash Flow Model: Interactive DCF valuation model with real-time calculations.
- Weighted Average Cost of Capital (WACC): A specific sheet for calculating WACC using personalized inputs.
- Key Financial Ratios: Evaluate Clipper Realty Inc.'s profitability, efficiency, and financial leverage.
- Customizable Inputs: Easily modify revenue growth, profit margins, and tax rates.
- Clear Dashboard: Visual representations and tables summarizing essential valuation outcomes.