Trinity Place Holdings Inc. (TPHS) 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
Trinity Place Holdings Inc. (TPHS) Bundle
Looking to evaluate Trinity Place Holdings Inc.'s (TPHS) intrinsic value? Our (TPHS) DCF Calculator integrates real-world data with extensive customization options, allowing you to adjust forecasts and make more informed investment choices.
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 | 4.1 | 1.0 | 27.4 | 42.8 | 33.6 | 38.6 | 44.3 | 50.8 | 58.3 | 67.0 |
Revenue Growth, % | 0 | -75.55 | 2659.52 | 56.2 | -21.49 | 14.79 | 14.79 | 14.79 | 14.79 | 14.79 |
EBITDA | 5.8 | 10.7 | -5.6 | 4.2 | 1.7 | 15.0 | 17.2 | 19.8 | 22.7 | 26.1 |
EBITDA, % | 141.75 | 1074.02 | -20.33 | 9.87 | 5.04 | 38.91 | 38.91 | 38.91 | 38.91 | 38.91 |
Depreciation | 14.9 | 18.0 | 37.8 | 50.5 | 6.8 | 32.4 | 37.2 | 42.7 | 49.0 | 56.3 |
Depreciation, % | 366.37 | 1813.8 | 137.97 | 118.05 | 20.15 | 84.03 | 84.03 | 84.03 | 84.03 | 84.03 |
EBIT | -9.1 | -7.3 | -43.4 | -46.3 | -5.1 | -32.0 | -36.8 | -42.2 | -48.4 | -55.6 |
EBIT, % | -224.62 | -739.78 | -158.3 | -108.18 | -15.11 | -83.02 | -83.02 | -83.02 | -83.02 | -83.02 |
Total Cash | 9.2 | 6.5 | 4.3 | 1.5 | .3 | 17.0 | 19.5 | 22.4 | 25.7 | 29.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1.8 | 1.1 | .2 | .4 | .7 | 11.5 | 13.2 | 15.1 | 17.4 | 20.0 |
Account Receivables, % | 45.35 | 106.34 | 0.72257 | 0.99294 | 1.97 | 29.81 | 29.81 | 29.81 | 29.81 | 29.81 |
Inventories | 30.8 | 27.1 | 46.3 | 45.5 | .0 | 30.9 | 35.4 | 40.7 | 46.7 | 53.6 |
Inventories, % | 757.83 | 2732.43 | 168.79 | 106.26 | 0 | 80 | 80 | 80 | 80 | 80 |
Accounts Payable | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Accounts Payable, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Capital Expenditure | .0 | .0 | .0 | -17.3 | .0 | -3.1 | -3.6 | -4.1 | -4.7 | -5.4 |
Capital Expenditure, % | 0 | 0 | 0 | -40.48 | 0 | -8.1 | -8.1 | -8.1 | -8.1 | -8.1 |
Tax Rate, % | -0.47121 | -0.47121 | -0.47121 | -0.47121 | -0.47121 | -0.47121 | -0.47121 | -0.47121 | -0.47121 | -0.47121 |
EBITAT | -9.7 | -7.0 | -44.1 | -47.0 | -5.1 | -31.7 | -36.4 | -41.8 | -48.0 | -55.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -27.4 | 15.4 | -24.5 | -13.2 | 46.9 | -44.1 | -9.1 | -10.4 | -12.0 | -13.7 |
WACC, % | 12.96 | 12.38 | 12.96 | 12.96 | 12.96 | 12.85 | 12.85 | 12.85 | 12.85 | 12.85 |
PV UFCF | ||||||||||
SUM PV UFCF | -68.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -14 | |||||||||
Terminal Value | -129 | |||||||||
Present Terminal Value | -70 | |||||||||
Enterprise Value | -139 | |||||||||
Net Debt | 247 | |||||||||
Equity Value | -386 | |||||||||
Diluted Shares Outstanding, MM | 38 | |||||||||
Equity Value Per Share | -10.07 |
What You Will Get
- Real Trinity Place Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Trinity Place Holdings Inc. (TPHS).
- Full Customization: Adjust all critical parameters (yellow cells) such as WACC, growth %, and tax rates to fit your analysis.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on Trinity Place's fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and detailed projections specific to Trinity Place Holdings Inc. (TPHS).
- Time-Saving and Accurate: Eliminate the need to build models from scratch while ensuring accuracy and flexibility.
Key Features
- 🔍 Real-Life TPHS Financials: Pre-filled historical and projected data for Trinity Place Holdings Inc. (TPHS).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Trinity Place Holdings’ intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Trinity Place Holdings’ valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Trinity Place Holdings Inc. (TPHS) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Trinity Place Holdings Inc. (TPHS)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Trinity Place Holdings Inc. (TPHS)?
- Designed for Experts: A sophisticated tool utilized by investors, financial analysts, and portfolio managers.
- Accurate Financials: Trinity Place Holdings Inc.’s historical and anticipated financial data preloaded for precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Comprehensive Outputs: Instantly computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance to navigate through the calculations seamlessly.
Who Should Use This Product?
- Investors: Evaluate Trinity Place Holdings Inc. (TPHS)’s market position before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methods and assess financial forecasts for better accuracy.
- Startup Founders: Understand the valuation strategies of established companies like Trinity Place Holdings Inc. (TPHS).
- Consultants: Provide detailed valuation analyses and reports to enhance client services.
- Students and Educators: Utilize current data to learn and teach effective valuation practices.
What the Template Contains
- Pre-Filled DCF Model: Trinity Place Holdings Inc.'s (TPHS) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Trinity Place Holdings Inc.'s (TPHS) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.