Presidio Property Trust, Inc. (SQFT) 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
Presidio Property Trust, Inc. (SQFT) Bundle
Unlock a professional analysis of Presidio Property Trust, Inc.'s financial future! This (SQFT) DCF Calculator comes with pre-filled financial data and offers you the flexibility to modify revenue growth, WACC, margins, and other crucial assumptions to align with your projections.
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 | 28.6 | 24.4 | 19.2 | 17.8 | 17.6 | 15.7 | 13.9 | 12.4 | 11.0 | 9.8 |
| Revenue Growth, % | 0 | -14.98 | -21.03 | -7.63 | -0.7243 | -11.09 | -11.09 | -11.09 | -11.09 | -11.09 |
| EBITDA | 19.3 | 9.3 | 6.8 | 7.8 | 4.9 | 6.7 | 5.9 | 5.3 | 4.7 | 4.2 |
| EBITDA, % | 67.24 | 37.99 | 35.48 | 43.9 | 27.66 | 42.45 | 42.45 | 42.45 | 42.45 | 42.45 |
| Depreciation | 23.0 | 20.8 | 17.8 | 17.5 | 5.4 | 12.2 | 10.8 | 9.6 | 8.5 | 7.6 |
| Depreciation, % | 80.46 | 85.6 | 92.59 | 98.34 | 30.74 | 77.55 | 77.55 | 77.55 | 77.55 | 77.55 |
| EBIT | -3.8 | -11.6 | -11.0 | -9.7 | -.5 | -5.5 | -4.9 | -4.3 | -3.9 | -3.4 |
| EBIT, % | -13.22 | -47.61 | -57.11 | -54.44 | -3.08 | -35.09 | -35.09 | -35.09 | -35.09 | -35.09 |
| Total Cash | 10.4 | 11.5 | 14.7 | 16.5 | 6.5 | 9.1 | 8.1 | 7.2 | 6.4 | 5.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 4.3 | .0 | 2.4 | 2.0 | 3.0 | 1.8 | 1.6 | 1.4 | 1.2 | 1.1 |
| Account Receivables, % | 15.13 | 0 | 12.37 | 11.4 | 16.93 | 11.17 | 11.17 | 11.17 | 11.17 | 11.17 |
| Inventories | 41.3 | 42.5 | 11.4 | 2.0 | .0 | 8.5 | 7.6 | 6.7 | 6.0 | 5.3 |
| Inventories, % | 144.16 | 174.52 | 59.44 | 11.35 | 0 | 54.16 | 54.16 | 54.16 | 54.16 | 54.16 |
| Accounts Payable | 5.7 | 5.1 | 4.6 | 9.1 | 4.8 | 4.5 | 4.0 | 3.5 | 3.2 | 2.8 |
| Accounts Payable, % | 19.81 | 21.05 | 23.84 | 51.09 | 27.17 | 28.59 | 28.59 | 28.59 | 28.59 | 28.59 |
| Capital Expenditure | -6.4 | -2.8 | -1.6 | -2.1 | .0 | -1.7 | -1.5 | -1.3 | -1.2 | -1.1 |
| Capital Expenditure, % | -22.32 | -11.64 | -8.31 | -11.86 | 0 | -10.83 | -10.83 | -10.83 | -10.83 | -10.83 |
| Tax Rate, % | 20.99 | 20.99 | 20.99 | 20.99 | 20.99 | 20.99 | 20.99 | 20.99 | 20.99 | 20.99 |
| EBITAT | -2.1 | -12.3 | -10.6 | -5.3 | -.4 | -4.3 | -3.8 | -3.4 | -3.0 | -2.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -25.4 | 8.3 | 33.7 | 24.3 | 1.8 | -1.4 | 6.2 | 5.5 | 4.9 | 4.3 |
| WACC, % | 3.35 | 5.23 | 5.1 | 3.31 | 4.34 | 4.26 | 4.26 | 4.26 | 4.26 | 4.26 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 16.8 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | 4 | |||||||||
| Terminal Value | 586 | |||||||||
| Present Terminal Value | 476 | |||||||||
| Enterprise Value | 493 | |||||||||
| Net Debt | 101 | |||||||||
| Equity Value | 391 | |||||||||
| Diluted Shares Outstanding, MM | 12 | |||||||||
| Equity Value Per Share | 33.03 |
What You Will Get
- Real SQFT Financials: Access historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are automatically computed.
- Scenario Analysis: Evaluate various scenarios to assess Presidio Property Trust’s future performance.
- User-Friendly Design: Designed for professionals but easy for beginners to navigate.
Key Features
- Customizable Investment Metrics: Adjust essential variables such as rental income growth, occupancy rates, and operating expenses.
- Instant Property Valuation: Provides immediate calculations for market value, cash flow projections, and other key metrics.
- Industry-Leading Precision: Utilizes Presidio Property Trust’s (SQFT) actual financial data for accurate valuation results.
- Effortless Scenario Testing: Explore various investment scenarios and analyze results with ease.
- Efficiency Booster: Remove the hassle of constructing intricate valuation models from the ground up.
How It Works
- Download the Template: Gain instant access to the Excel-based SQFT DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional factors.
- Instant Calculations: The model automatically recalculates Presidio Property Trust’s intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for Presidio Property Trust, Inc. (SQFT)?
- Accuracy: Utilizes real Presidio Property Trust financials for precise data.
- Flexibility: Tailored for users to easily test and adjust inputs as needed.
- Time-Saving: Avoid the complexities of creating a financial model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected by CFOs.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Presidio Property Trust, Inc. (SQFT) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Presidio Property Trust, Inc. (SQFT).
- Consultants: Deliver professional valuation insights on Presidio Property Trust, Inc. (SQFT) to clients quickly and accurately.
- Real Estate Developers: Understand how real estate investment trusts like Presidio Property Trust, Inc. (SQFT) are valued to guide your own development strategies.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Presidio Property Trust, Inc. (SQFT).
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for Presidio Property Trust, Inc. (SQFT).
- Real-World Data: Presidio’s historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results.