Generation Income Properties, Inc. (GIPR) 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
Generation Income Properties, Inc. (GIPR) Bundle
Looking to assess the intrinsic value of Generation Income Properties, Inc.? Our GIPR DCF Calculator integrates real-world data with comprehensive customization features, allowing you to refine your forecasts and enhance your investment choices.
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 | 1.7 | 3.5 | 3.9 | 5.4 | 7.6 | 11.3 | 16.6 | 24.6 | 36.3 | 53.5 |
| Revenue Growth, % | 0 | 103.39 | 10.79 | 39.29 | 40.5 | 47.64 | 47.64 | 47.64 | 47.64 | 47.64 |
| EBITDA | .3 | 1.5 | 1.2 | 3.4 | 2.4 | 4.2 | 6.2 | 9.2 | 13.6 | 20.1 |
| EBITDA, % | 19.31 | 42.84 | 30.35 | 63.13 | 31.77 | 37.48 | 37.48 | 37.48 | 37.48 | 37.48 |
| Depreciation | 2.0 | 3.5 | 4.2 | 6.3 | 3.5 | 10.0 | 14.8 | 21.9 | 32.3 | 47.6 |
| Depreciation, % | 114.24 | 98.42 | 108.64 | 115.56 | 46.36 | 88.96 | 88.96 | 88.96 | 88.96 | 88.96 |
| EBIT | -1.6 | -2.0 | -3.1 | -2.8 | -1.1 | -6.7 | -9.8 | -14.5 | -21.5 | -31.7 |
| EBIT, % | -94.93 | -55.58 | -78.29 | -52.43 | -14.59 | -59.17 | -59.17 | -59.17 | -59.17 | -59.17 |
| Total Cash | 1.0 | .9 | 10.6 | 3.7 | 3.1 | 6.6 | 9.7 | 14.4 | 21.2 | 31.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .1 | .1 | .1 | .1 | .2 | .3 | .5 | .7 | 1.0 | 1.5 |
| Account Receivables, % | 4.27 | 2.15 | 2.27 | 1.77 | 3.16 | 2.72 | 2.72 | 2.72 | 2.72 | 2.72 |
| Inventories | 2.0 | 1.6 | 11.3 | .0 | .0 | 5.5 | 8.2 | 12.0 | 17.8 | 26.3 |
| Inventories, % | 114.67 | 45.25 | 289.06 | 0.00001840786 | 0 | 49.05 | 49.05 | 49.05 | 49.05 | 49.05 |
| Accounts Payable | .1 | .1 | .2 | .2 | .4 | .5 | .7 | 1.1 | 1.6 | 2.3 |
| Accounts Payable, % | 4.79 | 3.37 | 5.17 | 3.19 | 5.33 | 4.37 | 4.37 | 4.37 | 4.37 | 4.37 |
| Capital Expenditure | -16.7 | -.3 | -8.3 | -12.9 | -32.0 | -9.2 | -13.6 | -20.0 | -29.6 | -43.7 |
| Capital Expenditure, % | -965.7 | -7.75 | -212.53 | -236.55 | -418.69 | -81.55 | -81.55 | -81.55 | -81.55 | -81.55 |
| Tax Rate, % | -28.72 | -28.72 | -28.72 | -28.72 | -28.72 | -28.72 | -28.72 | -28.72 | -28.72 | -28.72 |
| EBITAT | -3.5 | -4.9 | -11.0 | -2.4 | -1.4 | -6.5 | -9.5 | -14.1 | -20.8 | -30.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -20.2 | -1.2 | -24.7 | 2.3 | -29.8 | -11.1 | -10.8 | -16.0 | -23.6 | -34.9 |
| WACC, % | 4.51 | 4.51 | 4.51 | 3.84 | 4.51 | 4.38 | 4.38 | 4.38 | 4.38 | 4.38 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -82.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -36 | |||||||||
| Terminal Value | -1,499 | |||||||||
| Present Terminal Value | -1,210 | |||||||||
| Enterprise Value | -1,293 | |||||||||
| Net Debt | 66 | |||||||||
| Equity Value | -1,358 | |||||||||
| Diluted Shares Outstanding, MM | 3 | |||||||||
| Equity Value Per Share | -538.86 |
What You Will Get
- Editable Forecast Inputs: Effortlessly adjust assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Generation Income Properties, Inc. (GIPR) financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A refined Excel model that caters to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, validating strategies, and enhancing efficiency.
Key Features
- Real-Time GIPR Data: Pre-loaded with Generation Income Properties' historical performance metrics and future growth estimates.
- Comprehensive Input Customization: Modify rental income, operating expenses, capitalization rates, and investment assumptions.
- Interactive Valuation Framework: Instant recalculations of Net Present Value (NPV) and intrinsic value based on your customized inputs.
- Multiple Scenario Analysis: Develop various forecasting scenarios to evaluate diverse valuation possibilities.
- Intuitive User Interface: Clean, organized, and accessible for both industry experts and newcomers.
How It Works
- Download the Template: Gain immediate access to the Excel-based GIPR DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
- Instant Calculations: The model automatically refreshes the intrinsic value of Generation Income Properties, Inc. (GIPR).
- Test Scenarios: Experiment with various assumptions to assess potential valuation fluctuations.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis.
Why Choose This Calculator for Generation Income Properties, Inc. (GIPR)?
- Accurate Data: Up-to-date financials from GIPR provide trustworthy valuation outcomes.
- Customizable: Tailor key inputs such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Ready-made calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the real estate sector.
- User-Friendly: Simple layout and guided instructions make it accessible for all users.
Who Should Use Generation Income Properties, Inc. (GIPR)?
- Real Estate Investors: Assess GIPR's performance and potential before making investment decisions.
- Financial Analysts and Advisors: Enhance analysis processes and evaluate income-generating properties.
- Property Managers: Understand how public real estate companies like GIPR manage assets.
- Consultants: Provide clients with detailed reports on real estate valuations and market trends.
- Students and Educators: Utilize GIPR's data to teach and learn about real estate investment strategies.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Generation Income Properties, Inc. (GIPR) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), featuring parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models illustrating intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Generation Income Properties, Inc. (GIPR).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to simplify result analysis.