One Liberty Properties, Inc. (OLP) 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
One Liberty Properties, Inc. (OLP) Bundle
Whether you’re an investor or analyst, this (OLP) DCF Calculator is your go-to resource for accurate valuation. Preloaded with One Liberty Properties, Inc. real data, you can adjust forecasts and observe the effects in real-time.
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 | 84.7 | 81.9 | 82.7 | 92.2 | 90.6 | 92.3 | 94.0 | 95.8 | 97.6 | 99.4 |
Revenue Growth, % | 0 | -3.34 | 1.02 | 11.45 | -1.7 | 1.86 | 1.86 | 1.86 | 1.86 | 1.86 |
EBITDA | 60.4 | 71.1 | 79.8 | 77.9 | 73.5 | 77.6 | 79.0 | 80.5 | 82.0 | 83.5 |
EBITDA, % | 71.28 | 86.86 | 96.45 | 84.5 | 81.07 | 84.03 | 84.03 | 84.03 | 84.03 | 84.03 |
Depreciation | 48.9 | 50.6 | 51.2 | 54.8 | 24.9 | 49.5 | 50.5 | 51.4 | 52.4 | 53.3 |
Depreciation, % | 57.7 | 61.75 | 61.92 | 59.46 | 27.48 | 53.66 | 53.66 | 53.66 | 53.66 | 53.66 |
EBIT | 11.5 | 20.6 | 28.6 | 23.1 | 48.6 | 28.0 | 28.6 | 29.1 | 29.6 | 30.2 |
EBIT, % | 13.58 | 25.1 | 34.52 | 25.04 | 53.59 | 30.37 | 30.37 | 30.37 | 30.37 | 30.37 |
Total Cash | 11.0 | 12.7 | 16.2 | 6.7 | 26.4 | 15.6 | 15.9 | 16.2 | 16.5 | 16.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 15.0 | 15.4 | 14.3 | 16.1 | 16.7 | 16.6 | 16.9 | 17.2 | 17.5 | 17.8 |
Account Receivables, % | 17.75 | 18.85 | 17.32 | 17.44 | 18.38 | 17.95 | 17.95 | 17.95 | 17.95 | 17.95 |
Inventories | -.1 | .0 | 1.3 | -23.8 | .0 | -4.5 | -4.6 | -4.7 | -4.7 | -4.8 |
Inventories, % | -0.10267 | 0 | 1.53 | -25.77 | 0 | -4.87 | -4.87 | -4.87 | -4.87 | -4.87 |
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 | -3.5 | -1.0 | -4.1 | -4.6 | .0 | -2.8 | -2.9 | -2.9 | -3.0 | -3.0 |
Capital Expenditure, % | -4.15 | -1.27 | -4.96 | -4.96 | 0 | -3.07 | -3.07 | -3.07 | -3.07 | -3.07 |
Tax Rate, % | 1.02 | 1.02 | 1.02 | 1.02 | 1.02 | 1.02 | 1.02 | 1.02 | 1.02 | 1.02 |
EBITAT | -.6 | 6.5 | 14.6 | 23.1 | 48.1 | 15.8 | 16.1 | 16.4 | 16.7 | 17.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 29.8 | 55.6 | 61.6 | 96.6 | 48.6 | 67.1 | 63.5 | 64.6 | 65.8 | 67.1 |
WACC, % | 6.17 | 6.79 | 7.17 | 8.13 | 8.11 | 7.28 | 7.28 | 7.28 | 7.28 | 7.28 |
PV UFCF | ||||||||||
SUM PV UFCF | 266.9 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 68 | |||||||||
Terminal Value | 1,296 | |||||||||
Present Terminal Value | 912 | |||||||||
Enterprise Value | 1,179 | |||||||||
Net Debt | 405 | |||||||||
Equity Value | 774 | |||||||||
Diluted Shares Outstanding, MM | 21 | |||||||||
Equity Value Per Share | 37.65 |
What You Will Get
- Real OLP Financial Data: Pre-filled with One Liberty Properties, Inc.'s historical and projected data for precise analysis.
- Fully Editable Template: Easily modify key inputs such as revenue growth, WACC, and EBITDA %.
- Automatic Calculations: Watch OLP's intrinsic value update instantly based on your adjustments.
- Professional Valuation Tool: Crafted for investors, analysts, and consultants aiming for accurate DCF results.
- User-Friendly Design: Intuitive structure and clear instructions suitable for all experience levels.
Key Features
- Real-Life OLP Data: Pre-filled with One Liberty Properties’ historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust rental income growth, operating expenses, capitalization rates, tax rates, and property investments.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
- User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.
How It Works
- Download: Get the pre-formatted Excel file containing One Liberty Properties, Inc. (OLP) financial data.
- Customize: Modify projections such as rental income growth, operating expenses, and discount rates.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and instantly compare the results.
- Make Decisions: Utilize the valuation findings to inform your investment choices.
Why Choose One Liberty Properties, Inc. (OLP)?
- Save Time: Skip the hassle of building a real estate model from the ground up – it’s ready for immediate use.
- Enhance Accuracy: Dependable market data and calculations minimize errors in property valuation.
- Fully Customizable: Adjust the model to align with your investment strategies and forecasts.
- User-Friendly: Intuitive visuals and outputs simplify the analysis of results.
- Preferred by Professionals: Crafted for investors who prioritize precision and functionality.
Who Should Use One Liberty Properties, Inc. (OLP)?
- Real Estate Investors: Make informed investment choices with our comprehensive property analysis tools.
- Market Analysts: Streamline your research with our ready-to-use market trend reports.
- Consultants: Easily customize our resources for client pitches or strategic assessments.
- Real Estate Enthusiasts: Enhance your knowledge of property valuation with practical case studies.
- Educators and Students: Utilize our materials as a hands-on resource in real estate and finance courses.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled One Liberty Properties, Inc. (OLP) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for One Liberty Properties, Inc. (OLP).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.