Regional Health Properties, Inc. (RHE) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Regional Health Properties, Inc. (RHE) Bundle
Designed for accuracy, our (RHE) DCF Calculator empowers you to evaluate the valuation of Regional Health Properties, Inc. using real-world financial data and provides complete flexibility to modify all essential parameters for enhanced 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 | 20.1 | 17.6 | 26.7 | 35.9 | 17.2 | 18.1 | 19.1 | 20.1 | 21.2 | 22.3 |
| Revenue Growth, % | 0 | -12.69 | 51.83 | 34.6 | -52.22 | 5.38 | 5.38 | 5.38 | 5.38 | 5.38 |
| EBITDA | 3.6 | 5.2 | 4.0 | 6.3 | 1.5 | 3.2 | 3.4 | 3.6 | 3.7 | 3.9 |
| EBITDA, % | 18.05 | 29.51 | 14.9 | 17.5 | 8.45 | 17.68 | 17.68 | 17.68 | 17.68 | 17.68 |
| Depreciation | 19.9 | 15.3 | 24.2 | 39.9 | 2.3 | 14.1 | 14.9 | 15.7 | 16.5 | 17.4 |
| Depreciation, % | 99.02 | 86.95 | 90.51 | 111.05 | 13.14 | 77.92 | 77.92 | 77.92 | 77.92 | 77.92 |
| EBIT | -16.3 | -10.1 | -20.2 | -33.6 | -.8 | -11.3 | -11.9 | -12.5 | -13.2 | -13.9 |
| EBIT, % | -80.97 | -57.44 | -75.61 | -93.55 | -4.68 | -62.45 | -62.45 | -62.45 | -62.45 | -62.45 |
| Total Cash | 4.4 | 4.2 | 6.8 | .8 | 1.0 | 2.9 | 3.0 | 3.2 | 3.3 | 3.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 8.5 | 9.2 | 10.8 | 10.3 | 5.3 | 7.0 | 7.4 | 7.8 | 8.2 | 8.7 |
| Account Receivables, % | 42.1 | 52.36 | 40.33 | 28.67 | 31.16 | 38.92 | 38.92 | 38.92 | 38.92 | 38.92 |
| Inventories | 18.4 | 20.5 | .0 | 17.3 | .0 | 8.7 | 9.1 | 9.6 | 10.1 | 10.7 |
| Inventories, % | 91.23 | 116.71 | 0.000003746722 | 48.09 | 0 | 47.86 | 47.86 | 47.86 | 47.86 | 47.86 |
| Accounts Payable | 3.7 | 3.0 | 3.7 | 3.3 | 2.5 | 2.6 | 2.8 | 2.9 | 3.1 | 3.3 |
| Accounts Payable, % | 18.37 | 17.11 | 14.05 | 9.17 | 14.52 | 14.64 | 14.64 | 14.64 | 14.64 | 14.64 |
| Capital Expenditure | -.1 | -.5 | -.1 | -.3 | -1.0 | -.3 | -.4 | -.4 | -.4 | -.4 |
| Capital Expenditure, % | -0.28807 | -2.56 | -0.46085 | -0.78219 | -5.58 | -1.93 | -1.93 | -1.93 | -1.93 | -1.93 |
| Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| EBITAT | -.8 | -55.9 | -47.2 | -73.8 | -.8 | -9.1 | -9.6 | -10.2 | -10.7 | -11.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -4.1 | -44.6 | -3.5 | -51.5 | 21.9 | -5.6 | 4.1 | 4.4 | 4.6 | 4.8 |
| WACC, % | 0.70027 | 5.32 | 5.32 | 5.32 | 5.32 | 4.4 | 4.4 | 4.4 | 4.4 | 4.4 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 10.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 5 | |||||||||
| Terminal Value | 206 | |||||||||
| Present Terminal Value | 166 | |||||||||
| Enterprise Value | 176 | |||||||||
| Net Debt | 53 | |||||||||
| Equity Value | 124 | |||||||||
| Diluted Shares Outstanding, MM | 2 | |||||||||
| Equity Value Per Share | 65.81 |
What You Will Get
- Comprehensive RHE Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Regional Health Properties, Inc. (RHE).
- Full Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates to suit your analysis.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on Regional Health Properties, Inc.'s (RHE) fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and detailed projections tailored for RHE.
- Time-Saving and Accurate: Avoid building models from scratch while ensuring precision and flexibility in your analysis.
Key Features
- Customizable Financial Inputs: Adjust essential variables such as occupancy rates, rental income, and operational expenses.
- Instant DCF Valuation: Quickly computes intrinsic value, net present value (NPV), and additional financial metrics.
- High-Precision Results: Leverages Regional Health Properties, Inc.'s (RHE) actual financial data for accurate valuation insights.
- Effortless Scenario Testing: Evaluate various assumptions and easily compare the resulting outcomes.
- Efficiency Booster: Streamlines the valuation process, removing the necessity to create intricate models from the ground up.
How It Works
- Download the Template: Gain immediate access to the Excel-based RHE DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Regional Health Properties’ intrinsic value.
- Test Scenarios: Experiment with different assumptions to see how they affect valuation outcomes.
- Analyze and Decide: Utilize the results to inform your investment or financial strategies.
Why Choose This Calculator for Regional Health Properties, Inc. (RHE)?
- Accurate Data: Utilize real financials from Regional Health Properties, 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-designed calculations save you from starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the healthcare sector.
- User-Friendly: Easy-to-navigate interface and clear instructions ensure accessibility for all users.
Who Should Use This Product?
- Investors: Effectively assess the fair value of Regional Health Properties, Inc. (RHE) prior to making investment choices.
- CFOs: Utilize a top-tier DCF model for comprehensive financial reporting and analysis.
- Consultants: Efficiently modify the template for client valuation reports.
- Entrepreneurs: Acquire knowledge about financial modeling practices employed by leading health care companies.
- Educators: Implement it as a resource for teaching valuation techniques.
What the Template Contains
- Pre-Filled DCF Model: Regional Health Properties, Inc.'s (RHE) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital tailored for (RHE).
- Financial Ratios: Assess Regional Health Properties, Inc.'s (RHE) profitability, leverage, and efficiency.
- Editable Inputs: Modify assumptions such as growth, margins, and CAPEX to suit your scenarios for (RHE).
- Financial Statements: Annual and quarterly reports for Regional Health Properties, Inc. (RHE) to support thorough analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results for (RHE).