Innovative Industrial Properties, Inc. (IIPR) 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
Innovative Industrial Properties, Inc. (IIPR) Bundle
Designed for accuracy, our IIPR (IIPR) DCF Calculator enables you to evaluate Innovative Industrial Properties, Inc. (IIPR) valuation using up-to-date financial data, offering complete flexibility to modify all key parameters for improved projections.
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 | 44.7 | 116.9 | 204.6 | 276.4 | 309.5 | 481.3 | 748.6 | 1,164.2 | 1,810.6 | 2,815.9 |
| Revenue Growth, % | 0 | 161.71 | 74.99 | 35.11 | 11.99 | 55.52 | 55.52 | 55.52 | 55.52 | 55.52 |
| EBITDA | 33.5 | 97.8 | 177.1 | 230.9 | 241.8 | 391.8 | 609.3 | 947.6 | 1,473.8 | 2,292.1 |
| EBITDA, % | 75.08 | 83.63 | 86.6 | 83.56 | 78.12 | 81.4 | 81.4 | 81.4 | 81.4 | 81.4 |
| Depreciation | 19.7 | 47.2 | 69.2 | 110.3 | 67.2 | 173.3 | 269.5 | 419.1 | 651.7 | 1,013.6 |
| Depreciation, % | 44.18 | 40.34 | 33.82 | 39.93 | 21.71 | 36 | 36 | 36 | 36 | 36 |
| EBIT | 13.8 | 50.6 | 108.0 | 120.6 | 174.6 | 218.5 | 339.9 | 528.6 | 822.1 | 1,278.5 |
| EBIT, % | 30.9 | 43.29 | 52.78 | 43.63 | 56.41 | 45.4 | 45.4 | 45.4 | 45.4 | 45.4 |
| Total Cash | 82.2 | 126.0 | 81.1 | 87.1 | 140.2 | 304.7 | 473.8 | 736.9 | 1,146.1 | 1,782.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | 12.9 | 16.9 | .0 | 12.0 | 18.6 | 28.9 | 45.0 | 70.0 |
| Account Receivables, % | 0 | 0 | 6.31 | 6.12 | 0 | 2.49 | 2.49 | 2.49 | 2.49 | 2.49 |
| Inventories | .0 | .0 | 416.6 | .0 | .0 | 96.3 | 149.7 | 232.8 | 362.1 | 563.2 |
| Inventories, % | 0 | 0 | 203.68 | 0 | 0 | 20 | 20 | 20 | 20 | 20 |
| Accounts Payable | 28.4 | 41.1 | 54.0 | 40.0 | 21.0 | 140.9 | 219.2 | 340.9 | 530.1 | 824.5 |
| Accounts Payable, % | 63.55 | 35.19 | 26.4 | 14.47 | 6.78 | 29.28 | 29.28 | 29.28 | 29.28 | 29.28 |
| Capital Expenditure | -343.9 | -529.8 | -374.5 | -373.9 | .0 | -385.1 | -598.9 | -931.4 | -1,448.5 | -2,252.7 |
| Capital Expenditure, % | -769.96 | -453.25 | -183.1 | -135.29 | 0 | -80 | -80 | -80 | -80 | -80 |
| Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| EBITAT | 10.1 | 50.6 | 108.0 | 120.6 | 174.6 | 206.8 | 321.6 | 500.2 | 777.9 | 1,209.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -285.7 | -419.3 | -614.1 | 255.7 | 239.7 | 6.7 | 10.4 | 16.1 | 25.0 | 38.9 |
| WACC, % | 10.04 | 10.23 | 10.23 | 10.23 | 10.23 | 10.19 | 10.19 | 10.19 | 10.19 | 10.19 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 67.6 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 40 | |||||||||
| Terminal Value | 485 | |||||||||
| Present Terminal Value | 298 | |||||||||
| Enterprise Value | 366 | |||||||||
| Net Debt | 161 | |||||||||
| Equity Value | 205 | |||||||||
| Diluted Shares Outstanding, MM | 28 | |||||||||
| Equity Value Per Share | 7.27 |
What You Will Get
- Editable Forecast Inputs: Easily modify key assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Innovative Industrial Properties, Inc. (IIPR) financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model tailored to meet your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, validating strategies, and enhancing efficiency.
Key Features
- Real-Life IIPR Data: Pre-filled with Innovative Industrial Properties’ historical financials and future projections.
- Fully Customizable Inputs: Adjust rental income, operating expenses, cap rates, and growth rates.
- 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
- Step 1: Download the Excel file.
- Step 2: Review Innovative Industrial Properties, Inc.'s (IIPR) pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model refresh in real-time as you adjust your assumptions.
- Step 5: Evaluate the outputs and utilize the findings for your investment strategies.
Why Choose This Calculator for Innovative Industrial Properties, Inc. (IIPR)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Valuation: Observe immediate updates to IIPR’s valuation as you tweak inputs.
- Quick Setup: Comes pre-equipped with IIPR’s latest financial metrics for swift evaluations.
- Relied Upon by Experts: Utilized by investors and analysts for making strategic decisions.
Who Should Use This Product?
- Investors: Accurately assess the fair value of Innovative Industrial Properties, Inc. (IIPR) before making investment decisions.
- CFOs: Utilize a professional-grade DCF model for enhanced financial reporting and analysis for IIPR.
- Consultants: Efficiently customize the template for valuation reports tailored to IIPR clients.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading real estate firms like IIPR.
- Educators: Implement it as a teaching resource to illustrate valuation methodologies relevant to IIPR.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Innovative Industrial Properties, Inc. (IIPR) 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 Innovative Industrial Properties, Inc. (IIPR).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.