Global Medical REIT Inc. (GMRE) 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
Global Medical REIT Inc. (GMRE) Bundle
Simplify Global Medical REIT Inc. (GMRE) valuation with this customizable DCF Calculator! Featuring real Global Medical REIT Inc. (GMRE) financials and adjustable forecast inputs, you can test scenarios and uncover Global Medical REIT Inc. (GMRE) fair value in minutes.
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 | 70.7 | 93.7 | 115.9 | 137.3 | 140.9 | 168.2 | 200.7 | 239.4 | 285.7 | 340.9 |
Revenue Growth, % | 0 | 32.53 | 23.69 | 18.41 | 2.66 | 19.32 | 19.32 | 19.32 | 19.32 | 19.32 |
EBITDA | 50.8 | 53.0 | 84.0 | 96.5 | 111.6 | 117.8 | 140.6 | 167.8 | 200.2 | 238.9 |
EBITDA, % | 71.86 | 56.54 | 72.45 | 70.28 | 79.21 | 70.07 | 70.07 | 70.07 | 70.07 | 70.07 |
Depreciation | 43.7 | 77.5 | 79.0 | 98.8 | 59.0 | 109.8 | 131.0 | 156.3 | 186.5 | 222.6 |
Depreciation, % | 61.79 | 82.69 | 68.11 | 71.98 | 41.87 | 65.29 | 65.29 | 65.29 | 65.29 | 65.29 |
EBIT | 7.1 | -24.5 | 5.0 | -2.3 | 52.6 | 8.0 | 9.6 | 11.4 | 13.7 | 16.3 |
EBIT, % | 10.07 | -26.15 | 4.34 | -1.69 | 37.34 | 4.78 | 4.78 | 4.78 | 4.78 | 4.78 |
Total Cash | 2.8 | 5.5 | 7.2 | 4.0 | 26.4 | 12.7 | 15.1 | 18.0 | 21.5 | 25.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 5.0 | 5.7 | 6.2 | 8.2 | 33.5 | 16.3 | 19.4 | 23.1 | 27.6 | 32.9 |
Account Receivables, % | 7.08 | 6.08 | 5.38 | 6 | 23.78 | 9.66 | 9.66 | 9.66 | 9.66 | 9.66 |
Inventories | 37.7 | 51.5 | -1.2 | -34.7 | .0 | 27.5 | 32.9 | 39.2 | 46.8 | 55.8 |
Inventories, % | 53.23 | 54.97 | -1.07 | -25.28 | 0 | 16.37 | 16.37 | 16.37 | 16.37 | 16.37 |
Accounts Payable | 5.1 | 7.3 | 10.3 | 13.8 | 12.8 | 14.5 | 17.3 | 20.6 | 24.6 | 29.3 |
Accounts Payable, % | 7.17 | 7.77 | 8.92 | 10.07 | 9.07 | 8.6 | 8.6 | 8.6 | 8.6 | 8.6 |
Capital Expenditure | -256.8 | -218.8 | -201.7 | -156.2 | -10.0 | -136.9 | -163.4 | -195.0 | -232.6 | -277.6 |
Capital Expenditure, % | -363.1 | -233.42 | -173.94 | -113.78 | -7.13 | -81.43 | -81.43 | -81.43 | -81.43 | -81.43 |
Tax Rate, % | 5.16 | 5.16 | 5.16 | 5.16 | 5.16 | 5.16 | 5.16 | 5.16 | 5.16 | 5.16 |
EBITAT | -6.1 | -202.1 | -.6 | .6 | 49.9 | 3.1 | 3.7 | 4.5 | 5.3 | 6.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -256.8 | -355.7 | -68.0 | -21.8 | 37.9 | -32.6 | -34.3 | -40.9 | -48.8 | -58.3 |
WACC, % | 4.68 | 7.45 | 4.68 | 4.68 | 7.31 | 5.76 | 5.76 | 5.76 | 5.76 | 5.76 |
PV UFCF | ||||||||||
SUM PV UFCF | -179.2 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -59 | |||||||||
Terminal Value | -1,581 | |||||||||
Present Terminal Value | -1,195 | |||||||||
Enterprise Value | -1,374 | |||||||||
Net Debt | 617 | |||||||||
Equity Value | -1,991 | |||||||||
Diluted Shares Outstanding, MM | 66 | |||||||||
Equity Value Per Share | -30.37 |
What You Will Receive
- Adjustable Forecast Inputs: Easily modify key assumptions (growth %, margins, WACC) to explore various scenarios.
- Comprehensive Market Data: Global Medical REIT Inc.’s (GMRE) financial information pre-loaded to enhance your analysis.
- Automated DCF Calculations: The template computes Net Present Value (NPV) and intrinsic value automatically for your convenience.
- Customizable and Professional Design: A refined Excel model that meets your valuation requirements.
- Tailored for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and optimizing your time.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Global Medical REIT Inc. (GMRE).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to GMRE.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit GMRE's financial outlook.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Global Medical REIT Inc. (GMRE).
- Interactive Dashboard and Charts: Visual representations that summarize essential valuation metrics for streamlined analysis.
How It Works
- Step 1: Download the Excel file for Global Medical REIT Inc. (GMRE).
- Step 2: Review GMRE’s pre-filled financial data and projections.
- Step 3: Adjust key inputs such as rental income growth, capitalization rates, and operating expenses (highlighted cells).
- Step 4: Observe the DCF model refresh in real-time as you modify your assumptions.
- Step 5: Evaluate the results and leverage the insights for your investment strategies.
Why Choose This Calculator for Global Medical REIT Inc. (GMRE)?
- Accurate Data: Utilize real financials from Global Medical REIT Inc. for trustworthy valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured 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: An intuitive design and clear, step-by-step guidance make it accessible for everyone.
Who Should Use This Product?
- Investors: Evaluate Global Medical REIT Inc.'s (GMRE) performance before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts for GMRE.
- Real Estate Developers: Understand how healthcare-focused REITs like GMRE are valued in the market.
- Consultants: Provide comprehensive valuation analyses and reports for healthcare real estate clients.
- Students and Educators: Utilize current data to learn and teach real estate valuation principles with a focus on GMRE.
What the Template Contains
- Pre-Filled Data: Includes Global Medical REIT Inc.'s (GMRE) historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Global Medical REIT Inc.'s (GMRE) profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.