Rocky Mountain Chocolate Factory, Inc. (RMCF) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Rocky Mountain Chocolate Factory, Inc. (RMCF) Bundle
Streamline your analysis and improve precision with our [RMCF] DCF Calculator! Utilizing authentic data from Rocky Mountain Chocolate Factory, Inc. and customizable assumptions, this tool empowers you to forecast, assess, and value RMCF like a seasoned investor.
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 | 31.9 | 23.5 | 32.3 | 30.4 | 28.0 | 27.8 | 27.6 | 27.4 | 27.2 | 27.1 |
| Revenue Growth, % | 0 | -26.28 | 37.74 | -5.91 | -8.15 | -0.64933 | -0.64933 | -0.64933 | -0.64933 | -0.64933 |
| EBITDA | 2.9 | -.4 | .2 | -4.1 | -3.9 | -1.1 | -1.1 | -1.1 | -1.0 | -1.0 |
| EBITDA, % | 9.15 | -1.54 | 0.69148 | -13.47 | -14.08 | -3.85 | -3.85 | -3.85 | -3.85 | -3.85 |
| Depreciation | 1.5 | 1.3 | .7 | .8 | .9 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
| Depreciation, % | 4.69 | 5.69 | 2.29 | 2.51 | 3.17 | 3.67 | 3.67 | 3.67 | 3.67 | 3.67 |
| EBIT | 1.4 | -1.7 | -.5 | -4.9 | -4.8 | -2.1 | -2.1 | -2.1 | -2.0 | -2.0 |
| EBIT, % | 4.46 | -7.23 | -1.6 | -15.98 | -17.25 | -7.52 | -7.52 | -7.52 | -7.52 | -7.52 |
| Total Cash | 4.8 | 5.6 | 7.6 | 4,717.1 | 2.1 | 9.4 | 9.4 | 9.3 | 9.3 | 9.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 4.6 | 2.9 | 1.9 | 2.1 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 |
| Account Receivables, % | 14.53 | 12.21 | 5.89 | 6.76 | 9.73 | 9.82 | 9.82 | 9.82 | 9.82 | 9.82 |
| Inventories | 3.8 | 4.1 | 4.4 | 3,639.8 | 4.4 | 8.8 | 8.7 | 8.7 | 8.6 | 8.6 |
| Inventories, % | 11.78 | 17.3 | 13.46 | 11960.37 | 15.59 | 31.63 | 31.63 | 31.63 | 31.63 | 31.63 |
| Accounts Payable | 2.2 | 1.3 | 1.5 | 2.2 | 3.4 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 |
| Accounts Payable, % | 7.04 | 5.52 | 4.63 | 7.2 | 12.2 | 7.32 | 7.32 | 7.32 | 7.32 | 7.32 |
| Capital Expenditure | -1.1 | -.3 | -.9 | -1.0 | -3.0 | -1.2 | -1.2 | -1.2 | -1.2 | -1.2 |
| Capital Expenditure, % | -3.32 | -1.08 | -2.93 | -3.29 | -10.8 | -4.28 | -4.28 | -4.28 | -4.28 | -4.28 |
| Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| EBITAT | 1.0 | -.9 | -.6 | -5.5 | -4.8 | -1.8 | -1.8 | -1.7 | -1.7 | -1.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -4.7 | .7 | .1 | -3,640.6 | 3,629.0 | -7.8 | -1.9 | -1.9 | -1.8 | -1.8 |
| WACC, % | 8.24 | 8.07 | 8.43 | 8.43 | 8.43 | 8.32 | 8.32 | 8.32 | 8.32 | 8.32 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -12.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -2 | |||||||||
| Terminal Value | -30 | |||||||||
| Present Terminal Value | -20 | |||||||||
| Enterprise Value | -33 | |||||||||
| Net Debt | 1 | |||||||||
| Equity Value | -33 | |||||||||
| Diluted Shares Outstanding, MM | 6 | |||||||||
| Equity Value Per Share | -5.31 |
What You Will Get
- Real RMCF Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Rocky Mountain Chocolate Factory, Inc. (RMCF).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates tailored for RMCF.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on RMCF’s fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and detailed projections specific to RMCF.
- Time-Saving and Accurate: Avoid building models from scratch while ensuring precision and flexibility for RMCF.
Key Features
- Authentic RMCF Financials: Gain access to precise pre-loaded historical data and future forecasts.
- Adjustable Forecast Parameters: Modify highlighted cells for key metrics like WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic adjustments to DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to effectively visualize your valuation outcomes.
- Designed for All Skill Levels: A straightforward, intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- 1. Access the Template: Download and open the Excel file featuring Rocky Mountain Chocolate Factory, Inc.'s (RMCF) preloaded data.
- 2. Adjust Assumptions: Modify essential inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV in real-time.
- 4. Evaluate Scenarios: Analyze various forecasts to explore different valuation possibilities.
- 5. Present with Confidence: Share expert valuation insights to bolster your decision-making process.
Why Choose This Calculator?
- Accurate Data: Real Rocky Mountain Chocolate Factory, Inc. (RMCF) financials ensure reliable valuation results.
- Customizable: Adjust key parameters like growth rates, WACC, and tax rates to align with your projections.
- Time-Saving: Pre-built calculations save you the hassle of starting from scratch.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the confectionery industry.
- User-Friendly: Intuitive design and step-by-step guidance make it accessible for all users.
Who Should Use This Product?
- Investors: Evaluate Rocky Mountain Chocolate Factory’s valuation before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
- Startup Founders: Understand the valuation strategies of established companies like Rocky Mountain Chocolate Factory.
- Consultants: Provide expert valuation analyses and reports for clients in the confectionery industry.
- Students and Educators: Utilize real data to practice and teach valuation concepts in finance courses.
What the Template Contains
- Pre-Filled Data: Includes Rocky Mountain Chocolate Factory, Inc.'s 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 Rocky Mountain Chocolate Factory, Inc.'s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.