Sunshine Biopharma, Inc. (SBFM) 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
Sunshine Biopharma, Inc. (SBFM) Bundle
As an investor or analyst, this (SBFM) DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from Sunshine Biopharma, Inc., you can easily adjust forecasts and observe the effects in real time.
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 | .0 | .1 | .2 | 4.3 | 24.1 | 48.2 | 96.4 | 192.7 | 385.5 | 771.0 |
Revenue Growth, % | 0 | 238.1 | 219.88 | 1802.41 | 454.42 | 100 | 100 | 100 | 100 | 100 |
EBITDA | -.9 | -2.6 | -12.1 | -26.4 | -3.8 | -40.1 | -80.2 | -160.3 | -320.6 | -641.3 |
EBITDA, % | -4490.22 | -3643.64 | -5294.88 | -608.58 | -15.87 | -83.17 | -83.17 | -83.17 | -83.17 | -83.17 |
Depreciation | .0 | .0 | .0 | .0 | .1 | 8.8 | 17.7 | 35.3 | 70.7 | 141.4 |
Depreciation, % | 65.21 | 19.7 | 5.58 | 0.57905 | 0.61905 | 18.34 | 18.34 | 18.34 | 18.34 | 18.34 |
EBIT | -1.0 | -2.6 | -12.1 | -26.5 | -4.0 | -40.1 | -80.3 | -160.6 | -321.1 | -642.2 |
EBIT, % | -4555.44 | -3663.33 | -5300.46 | -609.16 | -16.49 | -83.3 | -83.3 | -83.3 | -83.3 | -83.3 |
Total Cash | .0 | 1.0 | 2.0 | 21.8 | 16.3 | 45.1 | 90.1 | 180.3 | 360.5 | 721.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .0 | 1.9 | 2.6 | 6.0 | 12.1 | 24.2 | 48.4 | 96.7 |
Account Receivables, % | 2.04 | 2.68 | 3.41 | 44 | 10.59 | 12.55 | 12.55 | 12.55 | 12.55 | 12.55 |
Inventories | .0 | .0 | .1 | 3.3 | 5.7 | 24.5 | 49.0 | 98.1 | 196.1 | 392.2 |
Inventories, % | 75.33 | 33.29 | 46.25 | 75.71 | 23.8 | 50.88 | 50.88 | 50.88 | 50.88 | 50.88 |
Accounts Payable | .1 | .1 | .0 | 2.8 | 2.6 | 27.2 | 54.4 | 108.7 | 217.5 | 434.9 |
Accounts Payable, % | 458.7 | 88.04 | 18.8 | 64.5 | 10.73 | 56.41 | 56.41 | 56.41 | 56.41 | 56.41 |
Capital Expenditure | .0 | .0 | .0 | -.3 | -.8 | -1.5 | -3.1 | -6.2 | -12.4 | -24.7 |
Capital Expenditure, % | -4.07 | -1.67 | 0 | -7.02 | -3.27 | -3.21 | -3.21 | -3.21 | -3.21 | -3.21 |
Tax Rate, % | -9.61 | -9.61 | -9.61 | -9.61 | -9.61 | -9.61 | -9.61 | -9.61 | -9.61 | -9.61 |
EBITAT | -1.3 | -.8 | -12.4 | -26.7 | -4.4 | -34.7 | -69.4 | -138.8 | -277.6 | -555.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -1.2 | -.9 | -12.5 | -29.3 | -8.3 | -25.1 | -58.2 | -116.4 | -232.8 | -465.5 |
WACC, % | 20.05 | 6.66 | 20.05 | 20.05 | 20.05 | 17.37 | 17.37 | 17.37 | 17.37 | 17.37 |
PV UFCF | ||||||||||
SUM PV UFCF | -467.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -475 | |||||||||
Terminal Value | -3,089 | |||||||||
Present Terminal Value | -1,387 | |||||||||
Enterprise Value | -1,854 | |||||||||
Net Debt | -16 | |||||||||
Equity Value | -1,839 | |||||||||
Diluted Shares Outstanding, MM | 0 | |||||||||
Equity Value Per Share | -151,144.50 |
What You Will Get
- Pre-Filled Financial Model: Sunshine Biopharma's actual data facilitates accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, profit margins, WACC, and other essential factors.
- Instant Calculations: Real-time updates provide immediate results as you adjust inputs.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation presentations.
- Customizable and Reusable: Designed for adaptability, allowing multiple uses for comprehensive forecasts.
Key Features
- 🔍 Real-Life SBFM Financials: Pre-filled historical and projected data for Sunshine Biopharma, Inc. (SBFM).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Sunshine Biopharma’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Sunshine Biopharma’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download the Template: Obtain immediate access to the Excel-based SBFM DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, profit margins, and more.
- Instant Calculations: The model automatically recalculates Sunshine Biopharma’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Leverage the results to inform your investment or financial analysis.
Why Choose This Calculator?
- Designed for Experts: A sophisticated tool utilized by researchers, executives, and financial analysts.
- Accurate Data: Sunshine Biopharma’s historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance ensures a smooth experience throughout the process.
Who Should Use Sunshine Biopharma, Inc. (SBFM)?
- Biotechnology Students: Explore drug development processes and apply theoretical knowledge with real-world data.
- Researchers: Utilize cutting-edge models and data for innovative studies in pharmaceutical sciences.
- Investors: Evaluate your investment strategies and analyze the potential of Sunshine Biopharma's pipeline.
- Market Analysts: Enhance your analysis with a customizable financial model tailored for biotech companies.
- Healthcare Entrepreneurs: Understand the evaluation methods used for biotech firms like Sunshine Biopharma, Inc. (SBFM).
What the Template Contains
- Pre-Filled DCF Model: Sunshine Biopharma’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Sunshine Biopharma’s profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.