The RMR Group Inc. (RMR) 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
The RMR Group Inc. (RMR) Bundle
Evaluate The RMR Group Inc. (RMR) financial outlook with expert precision! This (RMR) DCF Calculator comes with pre-filled financial data and allows you full control to modify revenue growth, WACC, margins, and other essential assumptions to align with your projections.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 589.5 | 607.2 | 832.5 | 962.3 | 897.6 | 930.8 | 965.2 | 1,000.9 | 1,037.9 | 1,076.3 |
Revenue Growth, % | 0 | 3.01 | 37.1 | 15.59 | -6.72 | 3.7 | 3.7 | 3.7 | 3.7 | 3.7 |
EBITDA | 73.2 | 78.6 | 90.8 | 121.1 | 69.1 | 105.3 | 109.1 | 113.2 | 117.4 | 121.7 |
EBITDA, % | 12.42 | 12.94 | 10.91 | 12.58 | 7.7 | 11.31 | 11.31 | 11.31 | 11.31 | 11.31 |
Depreciation | 516.0 | 515.4 | 743.0 | 10.5 | 4.7 | 490.1 | 508.2 | 527.0 | 546.5 | 566.7 |
Depreciation, % | 87.53 | 84.87 | 89.25 | 1.09 | 0.52506 | 52.65 | 52.65 | 52.65 | 52.65 | 52.65 |
EBIT | -442.8 | -436.8 | -652.2 | 110.5 | 64.4 | -384.8 | -399.1 | -413.8 | -429.1 | -445.0 |
EBIT, % | -75.11 | -71.93 | -78.34 | 11.49 | 7.17 | -41.34 | -41.34 | -41.34 | -41.34 | -41.34 |
Total Cash | 369.7 | 159.8 | 189.1 | 268.0 | 23.2 | 264.7 | 274.5 | 284.6 | 295.1 | 306.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 78.3 | 82.6 | 101.3 | 107.9 | 18.4 | 97.4 | 101.0 | 104.7 | 108.6 | 112.6 |
Account Receivables, % | 13.28 | 13.6 | 12.17 | 11.21 | 2.05 | 10.46 | 10.46 | 10.46 | 10.46 | 10.46 |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 0.00000017 | 0.000000165 | 0 | 0.000000104 | 0 | 0.0000000876 | 0.0000000876 | 0.0000000876 | 0.0000000876 | 0.0000000876 |
Accounts Payable | 17.0 | 15.0 | 16.7 | 16.8 | 29.2 | 23.0 | 23.9 | 24.7 | 25.7 | 26.6 |
Accounts Payable, % | 2.88 | 2.47 | 2.01 | 1.75 | 3.25 | 2.47 | 2.47 | 2.47 | 2.47 | 2.47 |
Capital Expenditure | -.6 | -1.1 | -1.1 | -4.0 | -3.9 | -2.4 | -2.5 | -2.5 | -2.6 | -2.7 |
Capital Expenditure, % | -0.10195 | -0.18806 | -0.13465 | -0.4139 | -0.43059 | -0.25383 | -0.25383 | -0.25383 | -0.25383 | -0.25383 |
Tax Rate, % | 64.11 | 64.11 | 64.11 | 64.11 | 64.11 | 64.11 | 64.11 | 64.11 | 64.11 | 64.11 |
EBITAT | -377.1 | -375.8 | -557.0 | 42.2 | 23.1 | -254.5 | -264.0 | -273.7 | -283.8 | -294.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 77.0 | 132.2 | 167.8 | 42.2 | 125.8 | 148.1 | 239.1 | 247.9 | 257.1 | 266.6 |
WACC, % | 8.9 | 8.91 | 8.9 | 8.37 | 8.35 | 8.69 | 8.69 | 8.69 | 8.69 | 8.69 |
PV UFCF | ||||||||||
SUM PV UFCF | 891.7 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 268 | |||||||||
Terminal Value | 3,273 | |||||||||
Present Terminal Value | 2,158 | |||||||||
Enterprise Value | 3,050 | |||||||||
Net Debt | -27 | |||||||||
Equity Value | 3,077 | |||||||||
Diluted Shares Outstanding, MM | 17 | |||||||||
Equity Value Per Share | 186.12 |
What You Will Get
- Real RMR Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on RMR’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- Pre-Loaded Data: The RMR Group Inc.'s (RMR) historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Instant Results: Watch The RMR Group Inc.'s (RMR) intrinsic value recalculate in real time.
- Clear Visual Outputs: Dashboard charts illustrate valuation results and key metrics clearly.
- Built for Accuracy: A professional tool designed for analysts, investors, and finance experts.
How It Works
- 1. Access the Template: Download and open the Excel file containing The RMR Group Inc.'s (RMR) preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV for The RMR Group Inc. (RMR).
- 4. Explore Scenarios: Evaluate various forecasts to understand different valuation outcomes for The RMR Group Inc. (RMR).
- 5. Present with Confidence: Deliver professional valuation insights to back your strategic decisions regarding The RMR Group Inc. (RMR).
Why Choose The RMR Group Inc. (RMR) Calculator?
- Accuracy: Utilizes real RMR financial data to ensure precise calculations.
- Flexibility: Allows users to easily test and adjust inputs as needed.
- Time-Saving: Eliminate the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected by CFOs.
- User-Friendly: Designed for ease of use, suitable for users with varying levels of financial expertise.
Who Should Use The RMR Group Inc. (RMR)?
- Investors: Gain insights and make informed decisions with a comprehensive investment platform.
- Financial Analysts: Streamline your analysis with tools designed for efficiency and precision.
- Consultants: Tailor presentations and reports quickly using adaptable templates from RMR.
- Finance Enthusiasts: Enhance your knowledge of real estate investment strategies through practical examples.
- Educators and Students: Utilize RMR resources as an effective educational tool in finance and real estate courses.
What the Template Contains
- Pre-Filled Data: Includes The RMR Group Inc.'s (RMR) 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 The RMR Group Inc.'s (RMR) profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.