Postal Realty Trust, Inc. (PSTL) 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
Postal Realty Trust, Inc. (PSTL) Bundle
Evaluate Postal Realty Trust, Inc.'s (PSTL) financial outlook like an expert! This (PSTL) DCF Calculator comes with pre-filled financial data and offers full flexibility to modify revenue growth, WACC, margins, and other crucial assumptions to align with 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 | 11.3 | 24.7 | 39.9 | 53.3 | 63.7 | 97.9 | 150.5 | 231.4 | 355.7 | 546.7 |
Revenue Growth, % | 0 | 118.58 | 61.85 | 33.53 | 19.47 | 53.71 | 53.71 | 53.71 | 53.71 | 53.71 |
EBITDA | 3.4 | 11.0 | 19.4 | 27.9 | 33.7 | 44.8 | 68.8 | 105.8 | 162.6 | 250.0 |
EBITDA, % | 30.53 | 44.4 | 48.57 | 52.24 | 52.87 | 45.72 | 45.72 | 45.72 | 45.72 | 45.72 |
Depreciation | 11.2 | 22.4 | 34.0 | 43.6 | 19.7 | 76.0 | 116.8 | 179.6 | 276.1 | 424.4 |
Depreciation, % | 99.39 | 90.83 | 85.18 | 81.81 | 30.9 | 77.62 | 77.62 | 77.62 | 77.62 | 77.62 |
EBIT | -7.8 | -11.5 | -14.6 | -15.8 | 14.0 | -31.2 | -48.0 | -73.8 | -113.5 | -174.4 |
EBIT, % | -68.87 | -46.42 | -36.61 | -29.57 | 21.97 | -31.9 | -31.9 | -31.9 | -31.9 | -31.9 |
Total Cash | 12.5 | 2.2 | 5.9 | 1.5 | 2.2 | 25.5 | 39.1 | 60.1 | 92.4 | 142.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1.7 | .2 | 4.8 | 5.8 | 6.3 | 9.6 | 14.8 | 22.8 | 35.0 | 53.8 |
Account Receivables, % | 15.45 | 0.8749 | 12.11 | 10.89 | 9.88 | 9.84 | 9.84 | 9.84 | 9.84 | 9.84 |
Inventories | .7 | 1.1 | 1.2 | .5 | .0 | 2.8 | 4.4 | 6.7 | 10.3 | 15.9 |
Inventories, % | 6.27 | 4.29 | 2.93 | 1.03 | 0 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 |
Accounts Payable | 3.1 | 3.9 | 8.2 | 9.1 | 10.3 | 19.0 | 29.2 | 44.8 | 68.9 | 105.9 |
Accounts Payable, % | 27.4 | 15.74 | 20.49 | 17.08 | 16.17 | 19.38 | 19.38 | 19.38 | 19.38 | 19.38 |
Capital Expenditure | -.2 | -1.0 | -1.9 | -3.7 | -2.9 | -4.2 | -6.5 | -9.9 | -15.3 | -23.4 |
Capital Expenditure, % | -1.34 | -3.93 | -4.76 | -6.91 | -4.5 | -4.29 | -4.29 | -4.29 | -4.29 | -4.29 |
Tax Rate, % | 20.32 | 20.32 | 20.32 | 20.32 | 20.32 | 20.32 | 20.32 | 20.32 | 20.32 | 20.32 |
EBITAT | -8.0 | -13.3 | -11.3 | -12.8 | 11.2 | -27.4 | -42.0 | -64.6 | -99.3 | -152.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 3.7 | 10.1 | 20.4 | 27.7 | 29.2 | 47.0 | 71.8 | 110.4 | 169.7 | 260.9 |
WACC, % | 6.08 | 6.08 | 5.59 | 5.68 | 5.65 | 5.82 | 5.82 | 5.82 | 5.82 | 5.82 |
PV UFCF | ||||||||||
SUM PV UFCF | 533.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 266 | |||||||||
Terminal Value | 6,972 | |||||||||
Present Terminal Value | 5,256 | |||||||||
Enterprise Value | 5,789 | |||||||||
Net Debt | 238 | |||||||||
Equity Value | 5,551 | |||||||||
Diluted Shares Outstanding, MM | 20 | |||||||||
Equity Value Per Share | 275.54 |
What You Will Get
- Real PSTL 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 computed automatically.
- Scenario Analysis: Evaluate various scenarios to assess Postal Realty Trust's future performance.
- User-Friendly Design: Designed for professionals while remaining accessible to novices.
Key Features
- 🔍 Real-Life PSTL Financials: Pre-filled historical and projected data for Postal Realty Trust, Inc. (PSTL).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Postal Realty Trust’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Postal Realty Trust’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 Postal Realty Trust, Inc.'s (PSTL) financial data.
- Customize: Modify projections, such as rental income growth, occupancy rates, and cap rates.
- Update Automatically: The intrinsic value and cash flow calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and analyze results immediately.
- Make Decisions: Leverage the valuation insights to inform your investment choices.
Why Choose This Calculator for Postal Realty Trust, Inc. (PSTL)?
- User-Friendly Interface: Tailored for both novice and seasoned users.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Valuation: Observe immediate updates to Postal Realty Trust’s valuation as you change inputs.
- Preloaded Data: Comes equipped with Postal Realty Trust’s current financial metrics for swift evaluations.
- Preferred by Experts: A go-to tool for investors and analysts seeking to make well-informed choices.
Who Should Use This Product?
- Investors: Accurately assess Postal Realty Trust, Inc.'s (PSTL) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis related to (PSTL).
- Consultants: Efficiently customize the template for valuation reports tailored to (PSTL) clients.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading real estate investment trusts.
- Educators: Implement it as an educational resource to illustrate valuation techniques specific to (PSTL).
What the Template Contains
- Pre-Filled Data: Contains Postal Realty Trust's historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model with automated calculations.
- Weighted Average Cost of Capital (WACC): A specific sheet for calculating WACC based on user-defined inputs.
- Key Financial Ratios: Assess Postal Realty Trust's profitability, efficiency, and leverage metrics.
- Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
- Clear Dashboard: Visuals and tables summarizing essential valuation outcomes.