SG Blocks, Inc. (SGBX) 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
SG Blocks, Inc. (SGBX) Bundle
Evaluate SG Blocks, Inc.'s (SGBX) financial outlook like an expert! This (SGBX) DCF Calculator provides you with pre-filled financial data and offers complete flexibility to modify revenue growth, WACC, margins, and other critical assumptions to align with your predictions.
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 | 3.0 | 8.8 | 38.3 | 24.4 | 16.5 | 21.9 | 29.2 | 38.7 | 51.5 | 68.3 |
| Revenue Growth, % | 0 | 193.34 | 337.91 | -36.38 | -32.27 | 32.84 | 32.84 | 32.84 | 32.84 | 32.84 |
| EBITDA | -6.6 | -4.3 | -5.3 | -6.1 | -21.1 | -12.6 | -16.8 | -22.3 | -29.6 | -39.3 |
| EBITDA, % | -220.68 | -48.64 | -13.83 | -25.16 | -127.8 | -57.53 | -57.53 | -57.53 | -57.53 | -57.53 |
| Depreciation | .2 | .2 | .6 | .6 | 3.0 | 1.3 | 1.8 | 2.3 | 3.1 | 4.1 |
| Depreciation, % | 5.18 | 2.74 | 1.58 | 2.52 | 18.11 | 6.03 | 6.03 | 6.03 | 6.03 | 6.03 |
| EBIT | -6.7 | -4.5 | -5.9 | -6.8 | -24.1 | -12.9 | -17.2 | -22.8 | -30.3 | -40.3 |
| EBIT, % | -225.86 | -51.38 | -15.41 | -27.68 | -145.91 | -58.89 | -58.89 | -58.89 | -58.89 | -58.89 |
| Total Cash | 1.6 | 13.0 | 13.0 | .6 | .0 | 8.4 | 11.1 | 14.8 | 19.6 | 26.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1.2 | 3.9 | 3.0 | 1.3 | .2 | 4.4 | 5.8 | 7.7 | 10.3 | 13.6 |
| Account Receivables, % | 40.44 | 44.99 | 7.72 | 5.4 | 1.17 | 19.94 | 19.94 | 19.94 | 19.94 | 19.94 |
| Inventories | .0 | .8 | 1.3 | .5 | .2 | .7 | .9 | 1.2 | 1.6 | 2.1 |
| Inventories, % | 0 | 8.89 | 3.32 | 1.91 | 0.94723 | 3.01 | 3.01 | 3.01 | 3.01 | 3.01 |
| Accounts Payable | 2.1 | 3.0 | 3.8 | 3.1 | 6.5 | 7.3 | 9.7 | 12.9 | 17.2 | 22.8 |
| Accounts Payable, % | 70.54 | 34.4 | 9.87 | 12.9 | 39.14 | 33.37 | 33.37 | 33.37 | 33.37 | 33.37 |
| Capital Expenditure | .0 | -1.6 | -4.9 | -2.8 | -.7 | -2.0 | -2.7 | -3.6 | -4.8 | -6.4 |
| Capital Expenditure, % | -0.06935057 | -17.91 | -12.69 | -11.59 | -4.24 | -9.3 | -9.3 | -9.3 | -9.3 | -9.3 |
| Tax Rate, % | 1.78 | 1.78 | 1.78 | 1.78 | 1.78 | 1.78 | 1.78 | 1.78 | 1.78 | 1.78 |
| EBITAT | -6.9 | -4.7 | -10.9 | -7.9 | -23.7 | -12.9 | -17.1 | -22.7 | -30.2 | -40.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -5.9 | -8.6 | -13.9 | -8.3 | -16.6 | -17.4 | -17.3 | -23.0 | -30.6 | -40.6 |
| WACC, % | 20.7 | 20.7 | 20.7 | 20.7 | 20.34 | 20.63 | 20.63 | 20.63 | 20.63 | 20.63 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -69.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -41 | |||||||||
| Terminal Value | -222 | |||||||||
| Present Terminal Value | -87 | |||||||||
| Enterprise Value | -157 | |||||||||
| Net Debt | 12 | |||||||||
| Equity Value | -169 | |||||||||
| Diluted Shares Outstanding, MM | 1 | |||||||||
| Equity Value Per Share | -218.97 |
What You Will Get
- Accurate SGBX Financial Data: Pre-filled with SG Blocks, Inc.'s historical and projected data for detailed analysis.
- Fully Customizable Template: Easily adjust key inputs like revenue growth, WACC, and EBITDA % to fit your analysis.
- Instant Calculations: Watch SG Blocks, Inc.'s intrinsic value update automatically as you make changes.
- Professional Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF results.
- User-Friendly Interface: Designed with a straightforward layout and clear instructions suitable for all skill levels.
Key Features
- Comprehensive SGBX Data: Pre-loaded with SG Blocks’ historical performance metrics and future growth estimates.
- Flexible Input Options: Modify parameters such as revenue growth, profit margins, weighted average cost of capital (WACC), tax rates, and capital expenditures.
- Interactive Valuation Model: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on your customized inputs.
- Multiple Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation results.
- Intuitive User Interface: Designed for ease of use, catering to both industry professionals and newcomers.
How It Works
- Step 1: Download the prebuilt Excel template featuring SG Blocks, Inc. (SGBX) data.
- Step 2: Review the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Adjust forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see recalculated results, including SG Blocks, Inc. (SGBX) intrinsic value.
- Step 5: Make well-informed investment choices or create reports based on the outputs.
Why Choose This Calculator for SG Blocks, Inc. (SGBX)?
- Accurate Data: Utilize real financials from SG Blocks, Inc. for dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations streamline the process, eliminating the need to start from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the construction and modular building sectors.
- User-Friendly: Designed with an intuitive interface and clear instructions for ease of use by all experience levels.
Who Should Use This Product?
- Investors: Evaluate SG Blocks, Inc. (SGBX)’s market potential before making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methods and assess financial forecasts for SGBX.
- Startup Founders: Understand the valuation strategies of innovative companies like SG Blocks, Inc. (SGBX).
- Consultants: Provide comprehensive valuation analyses and reports for clients interested in SGBX.
- Students and Educators: Utilize real-time data from SG Blocks, Inc. (SGBX) to learn and teach valuation principles.
What the Template Contains
- Preloaded SGBX Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.