First Industrial Realty Trust, Inc. (FR) 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
First Industrial Realty Trust, Inc. (FR) Bundle
Whether you’re an investor or analyst, this (FR) DCF Calculator is your go-to tool for accurate valuation. Loaded with real data from First Industrial Realty Trust, Inc., 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 | 426.0 | 448.0 | 476.3 | 539.9 | 614.0 | 673.2 | 738.1 | 809.3 | 887.4 | 972.9 |
Revenue Growth, % | 0 | 5.17 | 6.31 | 13.36 | 13.72 | 9.64 | 9.64 | 9.64 | 9.64 | 9.64 |
EBITDA | 277.6 | 292.6 | 307.0 | 358.2 | 413.3 | 442.4 | 485.1 | 531.8 | 583.1 | 639.3 |
EBITDA, % | 65.17 | 65.3 | 64.45 | 66.34 | 67.31 | 65.71 | 65.71 | 65.71 | 65.71 | 65.71 |
Depreciation | 266.4 | 281.7 | 296.9 | 326.0 | 164.5 | 370.1 | 405.8 | 445.0 | 487.9 | 534.9 |
Depreciation, % | 62.53 | 62.87 | 62.33 | 60.37 | 26.79 | 54.98 | 54.98 | 54.98 | 54.98 | 54.98 |
EBIT | 11.2 | 10.9 | 10.1 | 32.2 | 248.8 | 72.3 | 79.2 | 86.9 | 95.3 | 104.4 |
EBIT, % | 2.64 | 2.43 | 2.12 | 5.97 | 40.52 | 10.73 | 10.73 | 10.73 | 10.73 | 10.73 |
Total Cash | 21.1 | 162.1 | 58.6 | 133.2 | 43.8 | 114.8 | 125.9 | 138.0 | 151.3 | 165.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 86.2 | 90.3 | 103.8 | 130.1 | 155.0 | 150.2 | 164.6 | 180.5 | 197.9 | 217.0 |
Account Receivables, % | 20.24 | 20.15 | 21.8 | 24.09 | 25.25 | 22.31 | 22.31 | 22.31 | 22.31 | 22.31 |
Inventories | .0 | 15.7 | 318.8 | 11.9 | .0 | 97.8 | 107.2 | 117.6 | 128.9 | 141.3 |
Inventories, % | 0.000000235 | 3.5 | 66.94 | 2.2 | 0 | 14.53 | 14.53 | 14.53 | 14.53 | 14.53 |
Accounts Payable | 111.4 | 106.3 | 153.1 | 194.0 | 130.8 | 187.5 | 205.6 | 225.4 | 247.2 | 271.0 |
Accounts Payable, % | 26.16 | 23.72 | 32.14 | 35.94 | 21.3 | 27.85 | 27.85 | 27.85 | 27.85 | 27.85 |
Capital Expenditure | -254.2 | -161.1 | -233.2 | -522.4 | .0 | -325.0 | -356.3 | -390.6 | -428.3 | -469.6 |
Capital Expenditure, % | -59.68 | -35.96 | -48.96 | -96.75 | 0 | -48.27 | -48.27 | -48.27 | -48.27 | -48.27 |
Tax Rate, % | -4.76 | -4.76 | -4.76 | -4.76 | -4.76 | -4.76 | -4.76 | -4.76 | -4.76 | -4.76 |
EBITAT | 11.6 | 10.7 | 9.7 | 29.6 | 260.7 | 70.4 | 77.1 | 84.6 | 92.7 | 101.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 49.0 | 106.4 | -196.6 | 154.9 | 348.8 | 79.3 | 120.8 | 132.5 | 145.3 | 159.3 |
WACC, % | 8.31 | 8.3 | 8.26 | 8.22 | 8.31 | 8.28 | 8.28 | 8.28 | 8.28 | 8.28 |
PV UFCF | ||||||||||
SUM PV UFCF | 493.4 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 166 | |||||||||
Terminal Value | 3,871 | |||||||||
Present Terminal Value | 2,601 | |||||||||
Enterprise Value | 3,094 | |||||||||
Net Debt | 2,202 | |||||||||
Equity Value | 892 | |||||||||
Diluted Shares Outstanding, MM | 132 | |||||||||
Equity Value Per Share | 6.74 |
What You Will Get
- Real FR Financial Data: Pre-filled with First Industrial Realty Trust’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 First Industrial Realty Trust’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
- Customizable Investment Metrics: Adjust essential variables such as rental income growth, occupancy rates, and capital expenditures.
- Instant Property Valuation: Automatically computes intrinsic value, net present value, and other key financial metrics.
- Industry-Leading Precision: Leverages First Industrial Realty Trust, Inc.’s (FR) actual financial data for accurate valuation results.
- Effortless Scenario Planning: Evaluate various assumptions and easily compare different outcomes.
- Efficiency Booster: Avoid the complexities of creating detailed valuation models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered First Industrial Realty Trust, Inc. (FR) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for First Industrial Realty Trust, Inc. (FR)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for First Industrial Realty Trust, Inc. (FR)?
- Comprehensive Tool: Features DCF, WACC, and financial ratio analyses all in one convenient package.
- Customizable Inputs: Modify the yellow-highlighted cells to explore different investment scenarios.
- Detailed Insights: Automatically computes First Industrial Realty Trust’s intrinsic value and Net Present Value.
- Preloaded Data: Access historical and projected data for reliable starting points in your analysis.
- Professional Quality: Perfect for financial analysts, investors, and real estate consultants.
Who Should Use This Product?
- Investors: Accurately assess First Industrial Realty Trust, Inc.'s (FR) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis related to First Industrial Realty Trust, Inc. (FR).
- Consultants: Efficiently modify the template for valuation reports tailored to clients interested in First Industrial Realty Trust, Inc. (FR).
- Entrepreneurs: Acquire insights into financial modeling practices utilized by leading real estate investment trusts.
- Educators: Employ it as a teaching resource to illustrate valuation methodologies specific to the real estate sector.
What the Template Contains
- Pre-Filled Data: Contains First Industrial Realty Trust, Inc.'s historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model featuring automatic calculations.
- Weighted Average Cost of Capital (WACC): A specific sheet for calculating WACC using customized inputs.
- Key Financial Ratios: Assess First Industrial Realty Trust, Inc.'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.