The Real Good Food Company, Inc. (RGF) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
The Real Good Food Company, Inc. (RGF) Bundle
Discover the true value of The Real Good Food Company, Inc. (RGF) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and evaluate how changes affect The Real Good Food Company, Inc. (RGF) valuation – all within a single Excel template.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
FY1 2023 |
FY2 2024 |
FY3 2025 |
FY4 2026 |
FY5 2027 |
|
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 38.7 | 39.0 | 84.1 | 141.6 | 221.4 | 346.1 | 541.0 | 845.8 | 1,322.3 | |
Revenue Growth, % | 0 | 0.62205 | 115.69 | 68.39 | 56.34 | 56.34 | 56.34 | 56.34 | 56.34 | |
EBITDA | -8.3 | -9.3 | -60.6 | -35.0 | -78.6 | -122.8 | -192.0 | -300.2 | -469.3 | |
EBITDA, % | -21.4 | -23.78 | -72.06 | -24.75 | -35.5 | -35.5 | -35.5 | -35.5 | -35.5 | |
Depreciation | .5 | .6 | 1.1 | 3.2 | 3.6 | 5.6 | 8.7 | 13.7 | 21.4 | |
Depreciation, % | 1.33 | 1.51 | 1.36 | 2.26 | 1.61 | 1.61 | 1.61 | 1.61 | 1.61 | |
EBIT | -8.8 | -9.9 | -61.7 | -38.2 | -82.1 | -128.4 | -200.8 | -313.9 | -490.7 | |
EBIT, % | -22.73 | -25.29 | -73.41 | -27.01 | -37.11 | -37.11 | -37.11 | -37.11 | -37.11 | |
Total Cash | .4 | .0 | 27.4 | 5.3 | 20.7 | 32.4 | 50.6 | 79.1 | 123.7 | |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | |
Account Receivables | 2.5 | 3.5 | 9.0 | 20.3 | 22.5 | 35.1 | 54.9 | 85.9 | 134.2 | |
Account Receivables, % | 6.53 | 9.06 | 10.67 | 14.35 | 10.15 | 10.15 | 10.15 | 10.15 | 10.15 | |
Inventories | 9.0 | 8.4 | 16.6 | 39.5 | 51.1 | 79.8 | 124.8 | 195.1 | 305.1 | |
Inventories, % | 23.16 | 21.48 | 19.77 | 27.88 | 23.07 | 23.07 | 23.07 | 23.07 | 23.07 | |
Accounts Payable | 2.7 | 4.8 | 15.2 | 23.4 | 29.8 | 46.7 | 72.9 | 114.0 | 178.3 | |
Accounts Payable, % | 6.94 | 12.36 | 18.08 | 16.54 | 13.48 | 13.48 | 13.48 | 13.48 | 13.48 | |
Capital Expenditure | -.5 | -.1 | -2.5 | -3.7 | -4.0 | -6.3 | -9.9 | -15.5 | -24.2 | |
Capital Expenditure, % | -1.29 | -0.38221 | -3.01 | -2.63 | -1.83 | -1.83 | -1.83 | -1.83 | -1.83 | |
Tax Rate, % | 75.95 | 75.95 | 75.95 | 75.95 | 75.95 | 75.95 | 75.95 | 75.95 | 75.95 | |
EBITAT | -12.1 | -9.9 | -28.1 | -9.2 | -55.4 | -86.6 | -135.3 | -211.6 | -330.8 | |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -20.9 | -7.7 | -32.8 | -35.7 | -63.2 | -111.9 | -175.0 | -273.5 | -427.7 | |
WACC, % | 6.83 | 6.83 | 3.17 | 1.72 | 4.63 | 4.63 | 4.63 | 4.63 | 4.63 | |
PV UFCF | ||||||||||
SUM PV UFCF | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | -884.5 | |
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -436 | |||||||||
Terminal Value | -16,557 | |||||||||
Present Terminal Value | -13,201 | |||||||||
Enterprise Value | -14,085 | |||||||||
Net Debt | 103 | |||||||||
Equity Value | -14,189 | |||||||||
Diluted Shares Outstanding, MM | 6 | |||||||||
Equity Value Per Share | -2,291.07 |
What You Will Get
- Authentic RGF Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for The Real Good Food Company, Inc. (RGF).
- Comprehensive Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates.
- Immediate Valuation Updates: Automatic recalculations to assess the effects of changes on RGF’s fair value.
- Flexible Excel Template: Designed for quick modifications, scenario analysis, and thorough projections.
- Efficient and Precise: Avoid starting from scratch while ensuring accuracy and adaptability.
Key Features
- Authentic Financial Data: Gain access to precise pre-loaded historical figures and future forecasts for The Real Good Food Company, Inc. (RGF).
- Adjustable Forecast Parameters: Modify yellow-highlighted cells 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: Clear charts and summaries to help you visualize your valuation outcomes.
- Designed for All Levels: An easy-to-navigate layout tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the prebuilt Excel template featuring The Real Good Food Company, Inc. (RGF)'s data.
- Step 2: Review 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 see recalculated results, including The Real Good Food Company, Inc. (RGF)'s intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose This Calculator for The Real Good Food Company, Inc. (RGF)?
- Accuracy: Utilizes authentic RGF financials for precise data representation.
- Flexibility: Tailored for users to explore and adjust inputs at their convenience.
- Time-Saving: Eliminate the need to construct a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected by CFOs.
- User-Friendly: Intuitive design makes it accessible for users with varying levels of financial modeling skills.
Who Should Use This Product?
- Investors: Accurately estimate The Real Good Food Company, Inc.’s (RGF) fair value before making investment decisions.
- CFOs: Leverage a professional-grade DCF model for financial reporting and analysis specific to RGF.
- Consultants: Quickly adapt the template for valuation reports tailored to RGF clients.
- Entrepreneurs: Gain insights into financial modeling practices utilized by leading food companies like RGF.
- Educators: Use it as a teaching tool to demonstrate valuation methodologies applicable to RGF.
What the Template Contains
- Historical Data: Includes The Real Good Food Company’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate The Real Good Food Company’s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of The Real Good Food Company’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.