MEDIROM Healthcare Technologies Inc. (MRM) 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
MEDIROM Healthcare Technologies Inc. (MRM) Bundle
Explore the financial future of MEDIROM Healthcare Technologies Inc. (MRM) with our user-friendly DCF Calculator! Enter your assumptions regarding growth, margins, and costs to calculate the intrinsic value of MEDIROM Healthcare Technologies Inc. (MRM) and refine your investment strategy.
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 | 24.8 | 21.2 | 34.3 | 44.1 | 43.3 | 51.3 | 60.8 | 72.1 | 85.4 | 101.2 |
| Revenue Growth, % | 0 | -14.5 | 61.89 | 28.54 | -1.81 | 18.53 | 18.53 | 18.53 | 18.53 | 18.53 |
| EBITDA | .8 | -3.7 | -1.7 | 1.8 | 2.0 | -1.1 | -1.3 | -1.5 | -1.8 | -2.1 |
| EBITDA, % | 3.2 | -17.28 | -4.97 | 4.04 | 4.54 | -2.09 | -2.09 | -2.09 | -2.09 | -2.09 |
| Depreciation | .3 | .4 | .8 | 1.2 | 1.6 | 1.2 | 1.4 | 1.7 | 2.0 | 2.4 |
| Depreciation, % | 1.18 | 1.86 | 2.33 | 2.65 | 3.7 | 2.35 | 2.35 | 2.35 | 2.35 | 2.35 |
| EBIT | .5 | -4.1 | -2.5 | .6 | .4 | -2.3 | -2.7 | -3.2 | -3.8 | -4.5 |
| EBIT, % | 2.02 | -19.14 | -7.31 | 1.39 | 0.84198 | -4.44 | -4.44 | -4.44 | -4.44 | -4.44 |
| Total Cash | 3.5 | 9.3 | 2.4 | 3.8 | .7 | 7.7 | 9.2 | 10.9 | 12.9 | 15.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 2.1 | .9 | 2.0 | 3.4 | 3.9 | 3.7 | 4.3 | 5.1 | 6.1 | 7.2 |
| Account Receivables, % | 8.62 | 4.45 | 5.77 | 7.69 | 9.11 | 7.13 | 7.13 | 7.13 | 7.13 | 7.13 |
| Inventories | .0 | .1 | .1 | .7 | .9 | .5 | .5 | .6 | .8 | .9 |
| Inventories, % | 0.14101 | 0.23809 | 0.34572 | 1.64 | 2.05 | 0.88317 | 0.88317 | 0.88317 | 0.88317 | 0.88317 |
| Accounts Payable | .8 | .4 | 1.5 | 1.3 | .9 | 1.5 | 1.8 | 2.1 | 2.5 | 2.9 |
| Accounts Payable, % | 3.14 | 2.01 | 4.27 | 2.99 | 2.02 | 2.88 | 2.88 | 2.88 | 2.88 | 2.88 |
| Capital Expenditure | .0 | -.5 | -.6 | -.8 | -.9 | -.8 | -1.0 | -1.1 | -1.3 | -1.6 |
| Capital Expenditure, % | -0.1895 | -2.2 | -1.77 | -1.74 | -1.99 | -1.58 | -1.58 | -1.58 | -1.58 | -1.58 |
| Tax Rate, % | -457.89 | -457.89 | -457.89 | -457.89 | -457.89 | -457.89 | -457.89 | -457.89 | -457.89 | -457.89 |
| EBITAT | .3 | -3.5 | -6.0 | .5 | 2.0 | -1.9 | -2.3 | -2.7 | -3.2 | -3.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -.9 | -2.7 | -5.9 | -1.3 | 1.6 | -.2 | -2.3 | -2.7 | -3.2 | -3.8 |
| WACC, % | 2.9 | 4.13 | 4.63 | 4.01 | 4.63 | 4.06 | 4.06 | 4.06 | 4.06 | 4.06 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -10.6 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -4 | |||||||||
| Terminal Value | -189 | |||||||||
| Present Terminal Value | -155 | |||||||||
| Enterprise Value | -166 | |||||||||
| Net Debt | 22 | |||||||||
| Equity Value | -188 | |||||||||
| Diluted Shares Outstanding, MM | 5 | |||||||||
| Equity Value Per Share | -36.38 |
What You Will Get
- Real MEDIROM Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for MEDIROM Healthcare Technologies Inc. (MRM).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to MEDIROM.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on MEDIROM’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for MEDIROM.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for MEDIROM Healthcare Technologies Inc. (MRM).
Key Features
- Comprehensive MRM Data: Pre-loaded with MEDIROM's historical performance metrics and future projections.
- Customizable Variables: Tailor inputs for revenue growth, profit margins, discount rates, tax implications, and capital investments.
- Interactive Valuation Framework: Instant recalculations of Net Present Value (NPV) and intrinsic value based on your adjustments.
- Multiple Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation possibilities.
- Intuitive User Interface: Clean, organized design suitable for both seasoned professionals and newcomers.
How It Works
- Step 1: Download the prebuilt Excel template featuring MEDIROM Healthcare Technologies Inc. (MRM) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view updated results, including MEDIROM's intrinsic value.
- Step 5: Make well-informed investment choices or create reports based on the outputs.
Why Choose MEDIROM Healthcare Technologies Inc. (MRM) Calculator?
- Designed for Experts: A sophisticated tool utilized by healthcare analysts, financial officers, and industry consultants.
- Comprehensive Data: MEDIROM’s historical and projected financials are preloaded for precise analysis.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance simplifies the entire process.
Who Should Use MEDIROM Healthcare Technologies Inc. (MRM)?
- Healthcare Professionals: Explore innovative healthcare solutions and their implementation in practice.
- Researchers: Utilize MEDIROM's technologies in studies focused on health and wellness.
- Investors: Evaluate market potential and investment opportunities within the healthcare sector.
- Analysts: Access comprehensive data to enhance your analysis of MEDIROM's market performance.
- Entrepreneurs: Discover how MEDIROM's technologies can inspire new business ventures in healthcare.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations specific to MEDIROM Healthcare Technologies Inc. (MRM).
- Real-World Data: MEDIROM's historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results tailored to MEDIROM Healthcare Technologies Inc. (MRM).