Phillips Edison & Company, Inc. (PECO) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Phillips Edison & Company, Inc. (PECO) Bundle
Maximize efficiency and improve precision with our (PECO) DCF Calculator! Utilizing real data from Phillips Edison & Company, Inc. and customizable assumptions, this tool empowers you to forecast, analyze, and assess (PECO) like an expert investor.
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 | 536.7 | 498.0 | 532.8 | 575.4 | 610.1 | 631.2 | 653.0 | 675.5 | 698.8 | 722.9 |
| Revenue Growth, % | 0 | -7.21 | 6.99 | 7.98 | 6.04 | 3.45 | 3.45 | 3.45 | 3.45 | 3.45 |
| EBITDA | 326.4 | 315.4 | 315.0 | 354.8 | 390.6 | 390.0 | 403.5 | 417.4 | 431.8 | 446.7 |
| EBITDA, % | 60.82 | 63.34 | 59.12 | 61.66 | 64.03 | 61.79 | 61.79 | 61.79 | 61.79 | 61.79 |
| Depreciation | 446.5 | 448.4 | 426.8 | 446.7 | 236.4 | 466.7 | 482.8 | 499.5 | 516.7 | 534.6 |
| Depreciation, % | 83.19 | 90.04 | 80.1 | 77.63 | 38.75 | 73.94 | 73.94 | 73.94 | 73.94 | 73.94 |
| EBIT | -120.0 | -133.0 | -111.8 | -91.9 | 154.2 | -76.7 | -79.3 | -82.1 | -84.9 | -87.8 |
| EBIT, % | -22.36 | -26.7 | -20.98 | -15.98 | 25.27 | -12.15 | -12.15 | -12.15 | -12.15 | -12.15 |
| Total Cash | 17.8 | 104.3 | 92.6 | 5.5 | 4.9 | 54.8 | 56.7 | 58.6 | 60.6 | 62.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 76.1 | 79.7 | 77.7 | 89.9 | 107.6 | 98.5 | 101.9 | 105.4 | 109.1 | 112.8 |
| Account Receivables, % | 14.19 | 16.01 | 14.58 | 15.63 | 17.64 | 15.61 | 15.61 | 15.61 | 15.61 | 15.61 |
| Inventories | 6.0 | 159.6 | 1.6 | 29.2 | .0 | 48.6 | 50.3 | 52.1 | 53.9 | 55.7 |
| Inventories, % | 1.13 | 32.04 | 0.2922 | 5.08 | 0 | 7.71 | 7.71 | 7.71 | 7.71 | 7.71 |
| Accounts Payable | 124.1 | 176.9 | 97.2 | 113.2 | 116.5 | 146.0 | 151.0 | 156.2 | 161.6 | 167.2 |
| Accounts Payable, % | 23.11 | 35.53 | 18.25 | 19.67 | 19.09 | 23.13 | 23.13 | 23.13 | 23.13 | 23.13 |
| Capital Expenditure | -75.5 | -64.0 | -75.0 | -104.5 | -95.3 | -94.4 | -97.6 | -101.0 | -104.5 | -108.1 |
| Capital Expenditure, % | -14.07 | -12.84 | -14.08 | -18.16 | -15.61 | -14.95 | -14.95 | -14.95 | -14.95 | -14.95 |
| Tax Rate, % | 10.84 | 10.84 | 10.84 | 10.84 | 10.84 | 10.84 | 10.84 | 10.84 | 10.84 | 10.84 |
| EBITAT | -273.6 | -116.2 | -98.1 | -81.5 | 137.5 | -69.5 | -71.9 | -74.3 | -76.9 | -79.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 139.2 | 164.0 | 334.1 | 236.8 | 293.4 | 292.9 | 313.3 | 324.1 | 335.3 | 346.9 |
| WACC, % | 5.55 | 5.39 | 5.39 | 5.4 | 5.41 | 5.43 | 5.43 | 5.43 | 5.43 | 5.43 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,373.9 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 361 | |||||||||
| Terminal Value | 25,259 | |||||||||
| Present Terminal Value | 19,392 | |||||||||
| Enterprise Value | 20,766 | |||||||||
| Net Debt | 2,073 | |||||||||
| Equity Value | 18,693 | |||||||||
| Diluted Shares Outstanding, MM | 133 | |||||||||
| Equity Value Per Share | 140.58 |
What You Will Get
- Real PECO Financial Data: Pre-filled with Phillips Edison & Company’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See PECO’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Real-Life PECO Data: Pre-filled with Phillips Edison & Company’s historical financials and future projections.
- Fully Customizable Inputs: Modify revenue growth, profit margins, WACC, tax rates, and capital expenditures as needed.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your customized inputs.
- Scenario Testing: Develop multiple forecasting scenarios to examine various valuation outcomes.
- User-Friendly Design: Intuitive, organized, and suitable for both professionals and newcomers.
How It Works
- Download the Template: Gain immediate access to the Excel-based PECO DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model will automatically refresh to display Phillips Edison & Company, Inc.'s (PECO) intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis.
Why Choose This Calculator?
- Designed for Industry Experts: A sophisticated tool tailored for real estate analysts, portfolio managers, and investors.
- Comprehensive Data: Phillips Edison & Company, Inc. (PECO)’s historical and projected financials included for precision.
- Flexible Scenario Analysis: Effortlessly test various investment scenarios and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential performance metrics.
- User-Friendly Interface: Clear, step-by-step guidance throughout the calculation process.
Who Should Use This Product?
- Real Estate Students: Explore property valuation methods and apply them to current market data.
- Academics: Integrate industry-standard models into your studies or research projects.
- Investors: Validate your investment strategies and assess valuation results for Phillips Edison & Company, Inc. (PECO).
- Analysts: Enhance your analysis process with a ready-to-use, customizable DCF model.
- Property Managers: Understand the evaluation techniques used for major real estate firms like Phillips Edison & Company, Inc. (PECO).
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for Phillips Edison & Company, Inc. (PECO).
- Real-World Data: Phillips Edison’s historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore different scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results specific to Phillips Edison & Company, Inc. (PECO).