Dermata Therapeutics, Inc. (DRMA) 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
Dermata Therapeutics, Inc. (DRMA) Bundle
Explore Dermata Therapeutics, Inc. (DRMA) financial future with our user-friendly DCF Calculator! Enter your assumptions for growth, margins, and costs to calculate Dermata Therapeutics, Inc. (DRMA) intrinsic value and refine your investment approach.
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 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Revenue Growth, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITDA | -4.5 | -3.2 | -7.9 | .0 | .2 | .0 | .0 | .0 | .0 | .0 |
EBITDA, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Depreciation | .0 | .0 | .0 | 9.7 | 8.0 | .0 | .0 | .0 | .0 | .0 |
Depreciation, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
EBIT | -4.5 | -3.2 | -7.9 | -9.7 | -7.8 | .0 | .0 | .0 | .0 | .0 |
EBIT, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Total Cash | 2.0 | .5 | 10.8 | 6.2 | 7.4 | .0 | .0 | .0 | .0 | .0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Accounts Payable | .3 | .1 | .5 | .5 | .9 | .0 | .0 | .0 | .0 | .0 |
Accounts Payable, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Capital Expenditure | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Capital Expenditure, % | 100 | 100 | 100 | 100 | 100 | 0 | 0 | 0 | 0 | 0 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | -4.7 | -3.4 | -7.9 | -9.7 | -7.8 | .0 | .0 | .0 | .0 | .0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -4.4 | -3.6 | -7.5 | .0 | .6 | -.9 | .0 | .0 | .0 | .0 |
WACC, % | 8.19 | 8.19 | 8.19 | 8.19 | 8.19 | 8.19 | 8.19 | 8.19 | 8.19 | 8.19 |
PV UFCF | ||||||||||
SUM PV UFCF | -.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 0 | |||||||||
Terminal Value | 0 | |||||||||
Present Terminal Value | 0 | |||||||||
Enterprise Value | -1 | |||||||||
Net Debt | -7 | |||||||||
Equity Value | 7 | |||||||||
Diluted Shares Outstanding, MM | 0 | |||||||||
Equity Value Per Share | 34.09 |
What You Will Get
- Real Dermata Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Dermata Therapeutics, Inc. (DRMA).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis needs.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Dermata's fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections specific to Dermata Therapeutics, Inc. (DRMA).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for your financial assessments.
Key Features
- Comprehensive DCF Calculator: Features extensive unlevered and levered DCF valuation frameworks.
- WACC Calculator: Includes a pre-configured Weighted Average Cost of Capital sheet with adjustable inputs.
- Customizable Forecast Assumptions: Tailor growth rates, capital expenditures, and discount rates to your needs.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Dermata Therapeutics, Inc. (DRMA).
- Interactive Dashboard and Charts: Visual representations highlight essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file for Dermata Therapeutics, Inc. (DRMA).
- Step 2: Review Dermata's pre-filled financial data and projections.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model refresh in real-time as you modify assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose Dermata Therapeutics, Inc. (DRMA) Calculator?
- Comprehensive Tool: Integrates DCF, WACC, and financial ratio analyses tailored for Dermata Therapeutics.
- Customizable Inputs: Modify yellow-highlighted fields to explore different financial scenarios.
- Detailed Insights: Automatically computes Dermata's intrinsic value and Net Present Value for informed decision-making.
- Preloaded Data: Access to historical and projected data for precise analysis.
- Professional Quality: Perfect for financial analysts, investors, and healthcare consultants focusing on biotech.
Who Should Use This Product?
- Individual Investors: Gain insights for informed decisions when trading Dermata Therapeutics (DRMA) stock.
- Financial Analysts: Enhance valuation methodologies with accessible financial models specific to Dermata Therapeutics.
- Consultants: Provide clients with accurate and timely valuation insights related to Dermata Therapeutics (DRMA).
- Business Owners: Learn how biotechnology companies like Dermata Therapeutics are valued to inform your strategic planning.
- Finance Students: Explore valuation techniques through real-world examples involving Dermata Therapeutics (DRMA).
What the Template Contains
- Preloaded DRMA 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.