|
Rexford Industrial Realty, Inc. (REXR) Valoración de DCF
US | Real Estate | REIT - Industrial | NYSE
|
- ✓ 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
Rexford Industrial Realty, Inc. (REXR) Bundle
¡Mejore sus estrategias de inversión con la calculadora DCF de Rexford Industrial Realty, Inc. (REXR)! Explore los auténticos datos financieros de Rexford, ajuste las proyecciones y gastos de crecimiento, y observe instantáneamente cómo estos cambios afectan el valor intrínseco de Rexford Industrial Realty, Inc. (REXR).
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 | 267.2 | 330.1 | 452.2 | 631.2 | 797.8 | 1,050.1 | 1,382.3 | 1,819.4 | 2,394.8 | 3,152.2 |
| Revenue Growth, % | 0 | 23.55 | 36.99 | 39.57 | 26.4 | 31.63 | 31.63 | 31.63 | 31.63 | 31.63 |
| EBITDA | 173.6 | 213.6 | 327.7 | 414.9 | 538.3 | 704.3 | 927.1 | 1,220.3 | 1,606.2 | 2,114.2 |
| EBITDA, % | 64.98 | 64.71 | 72.45 | 65.73 | 67.47 | 67.07 | 67.07 | 67.07 | 67.07 | 67.07 |
| Depreciation | 193.2 | 236.8 | 308.5 | 411.8 | 214.6 | 639.3 | 841.4 | 1,107.6 | 1,457.8 | 1,918.9 |
| Depreciation, % | 72.29 | 71.72 | 68.21 | 65.25 | 26.9 | 60.87 | 60.87 | 60.87 | 60.87 | 60.87 |
| EBIT | -19.5 | -23.2 | 19.2 | 3.0 | 323.7 | 65.1 | 85.6 | 112.7 | 148.4 | 195.3 |
| EBIT, % | -7.31 | -7.01 | 4.24 | 0.48241 | 40.57 | 6.19 | 6.19 | 6.19 | 6.19 | 6.19 |
| Total Cash | 78.9 | 176.3 | 44.0 | 36.8 | 33.4 | 215.6 | 283.8 | 373.6 | 491.7 | 647.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 35.6 | 51.1 | 72.5 | 103.4 | 263.6 | 197.9 | 260.5 | 342.9 | 451.4 | 594.2 |
| Account Receivables, % | 13.31 | 15.48 | 16.04 | 16.38 | 33.04 | 18.85 | 18.85 | 18.85 | 18.85 | 18.85 |
| Inventories | -.8 | .0 | 132.2 | -11.4 | .0 | 57.0 | 75.0 | 98.7 | 130.0 | 171.1 |
| Inventories, % | -0.28666 | 0.000000303 | 29.23 | -1.81 | 0 | 5.43 | 5.43 | 5.43 | 5.43 | 5.43 |
| Accounts Payable | 31.1 | 9.2 | 20.7 | 97.5 | 128.8 | 106.3 | 139.9 | 184.2 | 242.4 | 319.1 |
| Accounts Payable, % | 11.64 | 2.8 | 4.58 | 15.45 | 16.15 | 10.12 | 10.12 | 10.12 | 10.12 | 10.12 |
| Capital Expenditure | -47.2 | -78.8 | -102.5 | -135.1 | -266.6 | -249.9 | -328.9 | -433.0 | -569.9 | -750.1 |
| Capital Expenditure, % | -17.65 | -23.86 | -22.66 | -21.4 | -33.41 | -23.8 | -23.8 | -23.8 | -23.8 | -23.8 |
| Tax Rate, % | 4.64 | 4.64 | 4.64 | 4.64 | 4.64 | 4.64 | 4.64 | 4.64 | 4.64 | 4.64 |
| EBITAT | -10.7 | -13.0 | 12.6 | 2.9 | 308.7 | 47.7 | 62.8 | 82.7 | 108.8 | 143.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 131.6 | 106.8 | 76.4 | 469.2 | 116.4 | 423.2 | 528.3 | 695.4 | 915.3 | 1,204.8 |
| WACC, % | 7.52 | 7.54 | 7.63 | 7.91 | 7.92 | 7.71 | 7.71 | 7.71 | 7.71 | 7.71 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2,916.3 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 1,253 | |||||||||
| Terminal Value | 33,818 | |||||||||
| Present Terminal Value | 23,333 | |||||||||
| Enterprise Value | 26,249 | |||||||||
| Net Debt | 2,192 | |||||||||
| Equity Value | 24,057 | |||||||||
| Diluted Shares Outstanding, MM | 203 | |||||||||
| Equity Value Per Share | 118.44 |
What You Will Get
- Real Rexford Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Rexford Industrial Realty, Inc. (REXR).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on Rexford’s fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and detailed projections specific to Rexford Industrial Realty, Inc. (REXR).
- Time-Saving and Accurate: Avoid building models from scratch while ensuring precision and flexibility in your evaluations.
Key Features
- Accurate REXR Financials: Gain access to reliable pre-loaded historical data and future projections for Rexford Industrial Realty, Inc. (REXR).
- Tailorable Forecast Assumptions: Modify yellow-highlighted cells such as WACC, growth rates, and margins to fit your analysis.
- Automated Calculations: Enjoy real-time updates to DCF, Net Present Value (NPV), and cash flow assessments.
- Intuitive Dashboard: Utilize easy-to-understand charts and summaries to visualize your valuation findings.
- Designed for All Users: A straightforward, user-friendly layout ideal for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Rexford Industrial Realty data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Rexford Industrial Realty’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Rexford Industrial Realty, Inc. (REXR)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Valuation: Monitor immediate updates to Rexford's valuation as you change inputs.
- Pre-Loaded Data: Comes with Rexford’s current financial metrics for swift evaluations.
- Industry-Endorsed: Preferred by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Investors: Evaluate Rexford Industrial Realty’s valuation prior to making stock transactions.
- CFOs and Financial Analysts: Enhance valuation methodologies and assess financial forecasts.
- Real Estate Developers: Understand how publicly traded companies like Rexford Industrial Realty are appraised.
- Consultants: Produce comprehensive valuation reports for clientele.
- Students and Educators: Utilize current data to practice and instruct on valuation strategies.
What the Template Contains
- Pre-Filled DCF Model: Rexford Industrial Realty, Inc.’s (REXR) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital specific to Rexford Industrial Realty, Inc. (REXR).
- Financial Ratios: Evaluate Rexford Industrial Realty, Inc.’s (REXR) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios for Rexford Industrial Realty, Inc. (REXR).
- Financial Statements: Annual and quarterly reports to support detailed analysis of Rexford Industrial Realty, Inc. (REXR).
- Interactive Dashboard: Easily visualize key valuation metrics and results for Rexford Industrial Realty, Inc. (REXR).