CareTrust REIT, Inc. (CTRE) 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
CareTrust REIT, Inc. (CTRE) Bundle
Looking to determine the intrinsic value of CareTrust REIT, Inc. (CTRE)? Our (CTRE) DCF Calculator integrates real-world data with complete customization features, allowing you to refine 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 | 159.1 | 175.7 | 190.2 | 187.5 | 217.8 | 236.0 | 255.7 | 277.1 | 300.2 | 325.3 |
| Revenue Growth, % | 0 | 10.46 | 8.26 | -1.41 | 16.14 | 8.36 | 8.36 | 8.36 | 8.36 | 8.36 |
| EBITDA | 141.3 | 157.4 | 162.0 | 162.8 | 145.8 | 197.0 | 213.4 | 231.3 | 250.6 | 271.6 |
| EBITDA, % | 88.81 | 89.58 | 85.15 | 86.83 | 66.95 | 83.47 | 83.47 | 83.47 | 83.47 | 83.47 |
| Depreciation | 102.1 | 97.4 | 85.8 | 83.7 | 51.2 | 109.9 | 119.1 | 129.1 | 139.9 | 151.6 |
| Depreciation, % | 64.21 | 55.45 | 45.11 | 44.64 | 23.51 | 46.58 | 46.58 | 46.58 | 46.58 | 46.58 |
| EBIT | 39.1 | 60.0 | 76.2 | 79.1 | 94.6 | 87.0 | 94.3 | 102.2 | 110.7 | 120.0 |
| EBIT, % | 24.61 | 34.13 | 40.05 | 42.19 | 43.44 | 36.88 | 36.88 | 36.88 | 36.88 | 36.88 |
| Total Cash | 20.3 | 18.9 | 19.9 | 13.2 | 294.4 | 66.6 | 72.1 | 78.2 | 84.7 | 91.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 2.6 | 1.8 | 2.4 | .4 | .4 | 2.0 | 2.2 | 2.4 | 2.6 | 2.8 |
| Account Receivables, % | 1.62 | 1.04 | 1.27 | 0.22186 | 0.18138 | 0.86572 | 0.86572 | 0.86572 | 0.86572 | 0.86572 |
| Inventories | 34.6 | 7.2 | 4.8 | .6 | .0 | 13.6 | 14.7 | 15.9 | 17.2 | 18.7 |
| Inventories, % | 21.75 | 4.11 | 2.54 | 0.32052 | 0 | 5.74 | 5.74 | 5.74 | 5.74 | 5.74 |
| Accounts Payable | 15.0 | 19.6 | 25.4 | 24.4 | 34.0 | 29.5 | 32.0 | 34.6 | 37.5 | 40.7 |
| Accounts Payable, % | 9.41 | 11.14 | 13.36 | 12.99 | 15.61 | 12.5 | 12.5 | 12.5 | 12.5 | 12.5 |
| Capital Expenditure | -3.4 | -8.3 | -6.0 | -7.3 | -11.0 | -8.9 | -9.7 | -10.5 | -11.4 | -12.3 |
| Capital Expenditure, % | -2.11 | -4.72 | -3.16 | -3.89 | -5.04 | -3.78 | -3.78 | -3.78 | -3.78 | -3.78 |
| Tax Rate, % | -0.02419865 | -0.02419865 | -0.02419865 | -0.02419865 | -0.02419865 | -0.02419865 | -0.02419865 | -0.02419865 | -0.02419865 | -0.02419865 |
| EBITAT | 15.4 | 42.4 | 51.1 | -451.9 | 94.6 | 48.2 | 52.3 | 56.7 | 61.4 | 66.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 92.0 | 164.3 | 138.5 | -370.3 | 145.1 | 129.5 | 162.9 | 176.5 | 191.3 | 207.2 |
| WACC, % | 8.52 | 8.89 | 8.84 | 8.05 | 9.23 | 8.71 | 8.71 | 8.71 | 8.71 | 8.71 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 667.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 211 | |||||||||
| Terminal Value | 3,152 | |||||||||
| Present Terminal Value | 2,077 | |||||||||
| Enterprise Value | 2,744 | |||||||||
| Net Debt | 301 | |||||||||
| Equity Value | 2,443 | |||||||||
| Diluted Shares Outstanding, MM | 106 | |||||||||
| Equity Value Per Share | 23.02 |
What You Will Get
- Real CTRE Financials: Access to historical and forecasted data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Evaluate various scenarios to assess CareTrust’s future performance.
- User-Friendly Design: Designed for professionals but easy for beginners to navigate.
Key Features
- Comprehensive CareTrust REIT Financials: Gain access to precise pre-loaded historical data and future forecasts.
- Adjustable Forecast Parameters: Modify highlighted cells for metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Intuitive charts and summaries to help visualize your valuation insights.
- Designed for All Skill Levels: A straightforward, user-friendly layout tailored for investors, CFOs, and consultants alike.
How It Works
- 1. Access the Template: Download and open the Excel file featuring CareTrust REIT, Inc.'s (CTRE) preloaded data.
- 2. Adjust Assumptions: Modify essential inputs such as occupancy rates, dividend yields, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically computes intrinsic value and NPV for CareTrust REIT, Inc. (CTRE).
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation outcomes for CareTrust REIT, Inc. (CTRE).
- 5. Present with Confidence: Deliver professional valuation insights to reinforce your investment decisions regarding CareTrust REIT, Inc. (CTRE).
Why Choose CareTrust REIT, Inc. (CTRE)?
- Maximize Returns: Leverage our expertise in healthcare real estate for optimal investment outcomes.
- Reliable Data: Access accurate market insights and financial metrics to inform your decisions.
- Tailored Solutions: Customize your investment strategy to align with your financial goals.
- User-Friendly Interface: Navigate our platform easily with intuitive tools and resources.
- Endorsed by Industry Leaders: Join a network of professionals who trust our commitment to excellence.
Who Should Use CareTrust REIT, Inc. (CTRE)?
- Real Estate Investors: Enhance your investment strategies with reliable data from a trusted REIT.
- Financial Analysts: Streamline your analysis with comprehensive reports tailored for the healthcare real estate sector.
- Consultants: Effortlessly customize presentations and reports based on industry-leading insights.
- Healthcare Sector Enthusiasts: Gain a deeper understanding of healthcare real estate dynamics through detailed case studies.
- Educators and Students: Leverage it as a valuable resource in real estate and finance education.
What the Template Contains
- Preloaded CTRE Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.