Plymouth Industrial REIT, Inc. (PLYM) 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
Plymouth Industrial REIT, Inc. (PLYM) Bundle
Engineered for accuracy, our (PLYM) DCF Calculator enables you to evaluate Plymouth Industrial REIT, Inc. valuation using real-world financial data, while offering complete flexibility to modify all essential parameters for improved 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 | 75.3 | 109.9 | 140.6 | 183.5 | 199.8 | 256.5 | 329.1 | 422.4 | 542.0 | 695.6 |
Revenue Growth, % | 0 | 45.9 | 28.01 | 30.52 | 8.89 | 28.33 | 28.33 | 28.33 | 28.33 | 28.33 |
EBITDA | 39.4 | 60.4 | 75.3 | 108.3 | 142.8 | 149.4 | 191.8 | 246.1 | 315.8 | 405.3 |
EBITDA, % | 52.28 | 55.01 | 53.58 | 58.99 | 71.45 | 58.26 | 58.26 | 58.26 | 58.26 | 58.26 |
Depreciation | 72.3 | 105.1 | 136.3 | 166.1 | 92.9 | 218.3 | 280.1 | 359.5 | 461.3 | 592.0 |
Depreciation, % | 96 | 95.63 | 96.94 | 90.5 | 46.48 | 85.11 | 85.11 | 85.11 | 85.11 | 85.11 |
EBIT | -32.9 | -44.6 | -61.0 | -57.8 | 49.9 | -68.9 | -88.4 | -113.4 | -145.5 | -186.7 |
EBIT, % | -43.72 | -40.62 | -43.36 | -31.5 | 24.97 | -26.85 | -26.85 | -26.85 | -26.85 | -26.85 |
Total Cash | 10.5 | 15.7 | 43.4 | 11.0 | 14.5 | 37.1 | 47.6 | 61.0 | 78.3 | 100.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Accounts Payable | 36.3 | 49.3 | 66.9 | 72.6 | 67.7 | 109.8 | 140.9 | 180.8 | 232.1 | 297.8 |
Accounts Payable, % | 48.19 | 44.91 | 47.56 | 39.53 | 33.88 | 42.82 | 42.82 | 42.82 | 42.82 | 42.82 |
Capital Expenditure | -5.3 | -6.1 | -25.3 | -55.5 | .0 | -31.2 | -40.0 | -51.4 | -65.9 | -84.6 |
Capital Expenditure, % | -7.07 | -5.52 | -18 | -30.24 | 0 | -12.17 | -12.17 | -12.17 | -12.17 | -12.17 |
Tax Rate, % | 1.06 | 1.06 | 1.06 | 1.06 | 1.06 | 1.06 | 1.06 | 1.06 | 1.06 | 1.06 |
EBITAT | -70.0 | -102.8 | -136.3 | -58.5 | 49.4 | -68.7 | -88.2 | -113.2 | -145.2 | -186.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 33.3 | 9.2 | -7.7 | 57.8 | 137.4 | 160.5 | 183.0 | 234.9 | 301.4 | 386.8 |
WACC, % | 7.57 | 7.57 | 7.57 | 7.57 | 7.55 | 7.57 | 7.57 | 7.57 | 7.57 | 7.57 |
PV UFCF | ||||||||||
SUM PV UFCF | 989.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 395 | |||||||||
Terminal Value | 7,088 | |||||||||
Present Terminal Value | 4,922 | |||||||||
Enterprise Value | 5,912 | |||||||||
Net Debt | 858 | |||||||||
Equity Value | 5,054 | |||||||||
Diluted Shares Outstanding, MM | 44 | |||||||||
Equity Value Per Share | 115.83 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real PLYM financials.
- Accurate Data: Historical performance data and forward-looking estimates (highlighted in the yellow cells).
- Flexible Forecasting: Modify forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect Plymouth Industrial REIT's valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Design: Organized for clarity and ease of navigation, complete with step-by-step guidance.
Key Features
- 🔍 Real-Life PLYM Financials: Pre-filled historical and projected data for Plymouth Industrial REIT, Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Plymouth's intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Plymouth's valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download: Obtain the pre-formatted Excel file containing Plymouth Industrial REIT, Inc.'s (PLYM) financial information.
- Customize: Tailor your forecasts, such as rental income growth, NOI margin, and cap rates.
- Update Automatically: The intrinsic value and cash flow projections refresh in real-time.
- Test Scenarios: Develop various projections and analyze results immediately.
- Make Decisions: Leverage the valuation insights to shape your investment approach.
Why Choose This Calculator for Plymouth Industrial REIT, Inc. (PLYM)?
- Accurate Data: Real Plymouth Industrial financials provide dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you from starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in real estate.
- User-Friendly: Easy-to-navigate layout and clear instructions make it accessible for all users.
Who Should Use This Product?
- Real Estate Students: Understand property valuation methods and apply them with real market data.
- Academics: Integrate industry-standard models into your research or teaching materials.
- Investors: Evaluate your investment strategies and analyze the valuation metrics for Plymouth Industrial REIT, Inc. (PLYM).
- Analysts: Enhance your analysis process with a customizable DCF model tailored for real estate.
- Property Managers: Learn how large industrial REITs like Plymouth are assessed and valued in the market.
What the Template Contains
- Historical Data: Includes Plymouth Industrial REIT's past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Plymouth Industrial REIT's intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Plymouth Industrial REIT's financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.