AxoGen, Inc. (AXGN) 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
AxoGen, Inc. (AXGN) Bundle
Discover the true value of AxoGen, Inc. (AXGN) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and evaluate how changes affect AxoGen, Inc. (AXGN) valuation – all within a single Excel template.
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 | 106.7 | 112.3 | 127.4 | 138.6 | 159.0 | 175.8 | 194.3 | 214.8 | 237.5 | 262.6 |
Revenue Growth, % | 0 | 5.24 | 13.41 | 8.81 | 14.74 | 10.55 | 10.55 | 10.55 | 10.55 | 10.55 |
EBITDA | -26.2 | -19.3 | -20.9 | -23.5 | -13.3 | -29.3 | -32.4 | -35.9 | -39.6 | -43.8 |
EBITDA, % | -24.57 | -17.16 | -16.4 | -16.94 | -8.38 | -16.69 | -16.69 | -16.69 | -16.69 | -16.69 |
Depreciation | 2.9 | 3.5 | 4.7 | 4.9 | 5.6 | 5.8 | 6.4 | 7.1 | 7.8 | 8.7 |
Depreciation, % | 2.7 | 3.08 | 3.72 | 3.5 | 3.49 | 3.3 | 3.3 | 3.3 | 3.3 | 3.3 |
EBIT | -29.1 | -22.7 | -25.6 | -28.3 | -18.9 | -35.1 | -38.8 | -42.9 | -47.5 | -52.5 |
EBIT, % | -27.26 | -20.24 | -20.12 | -20.44 | -11.87 | -19.99 | -19.99 | -19.99 | -19.99 | -19.99 |
Total Cash | 96.5 | 104.0 | 84.1 | 48.8 | 31.0 | 106.8 | 118.1 | 130.5 | 144.3 | 159.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 16.9 | 17.6 | 18.2 | 22.2 | 25.1 | 27.3 | 30.2 | 33.4 | 36.9 | 40.8 |
Account Receivables, % | 15.88 | 15.69 | 14.26 | 16.01 | 15.81 | 15.53 | 15.53 | 15.53 | 15.53 | 15.53 |
Inventories | 13.9 | 12.5 | 16.7 | 18.9 | 23.0 | 23.0 | 25.4 | 28.1 | 31.1 | 34.3 |
Inventories, % | 12.99 | 11.16 | 13.11 | 13.64 | 14.48 | 13.07 | 13.07 | 13.07 | 13.07 | 13.07 |
Accounts Payable | 8.3 | 4.6 | 5.9 | 9.0 | 11.8 | 10.7 | 11.8 | 13.0 | 14.4 | 15.9 |
Accounts Payable, % | 7.74 | 4.09 | 4.65 | 6.47 | 7.4 | 6.07 | 6.07 | 6.07 | 6.07 | 6.07 |
Capital Expenditure | -121.6 | -22.6 | -28.4 | -21.3 | -14.9 | -58.8 | -65.0 | -71.8 | -79.4 | -87.8 |
Capital Expenditure, % | -113.99 | -20.12 | -22.3 | -15.34 | -9.38 | -33.43 | -33.43 | -33.43 | -33.43 | -33.43 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | -29.1 | -23.7 | -26.7 | -26.7 | -18.9 | -34.7 | -38.4 | -42.5 | -46.9 | -51.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -170.4 | -45.8 | -53.7 | -46.3 | -32.5 | -90.9 | -101.1 | -111.8 | -123.6 | -136.6 |
WACC, % | 9.31 | 9.31 | 9.31 | 9.29 | 9.31 | 9.3 | 9.3 | 9.3 | 9.3 | 9.3 |
PV UFCF | ||||||||||
SUM PV UFCF | -427.6 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -139 | |||||||||
Terminal Value | -1,908 | |||||||||
Present Terminal Value | -1,223 | |||||||||
Enterprise Value | -1,651 | |||||||||
Net Debt | 38 | |||||||||
Equity Value | -1,689 | |||||||||
Diluted Shares Outstanding, MM | 43 | |||||||||
Equity Value Per Share | -39.39 |
What You Will Get
- Real AxoGen Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on AxoGen’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- Pre-Loaded Data: AxoGen, Inc.'s historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
- Instant Results: View AxoGen, Inc.'s intrinsic value recalculating in real time.
- Clear Visual Outputs: Dashboard charts present valuation results and essential metrics.
- Built for Accuracy: A professional tool tailored for analysts, investors, and finance professionals.
How It Works
- Download: Obtain the pre-prepared Excel file featuring AxoGen, Inc.'s (AXGN) financial data.
- Customize: Modify projections, including revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various forecasts and instantly compare results.
- Make Decisions: Utilize the valuation findings to inform your investment approach.
Why Choose This Calculator for AxoGen, Inc. (AXGN)?
- Accurate Data: Utilize real AxoGen financials for trustworthy valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you from starting from ground zero.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the healthcare sector.
- User-Friendly: An intuitive design and step-by-step guidance ensure accessibility for all users.
Who Should Use AxoGen, Inc. (AXGN)?
- Medical Students: Understand nerve regeneration techniques and apply them in clinical scenarios.
- Researchers: Utilize advanced models in your studies on nerve repair and regeneration.
- Healthcare Investors: Evaluate your investment strategies and analyze market trends for AxoGen, Inc. (AXGN).
- Industry Analysts: Enhance your analysis with a comprehensive, customizable valuation model specific to the biotech sector.
- Surgeons: Discover how innovative technologies are transforming surgical practices in nerve repair.
What the Template Contains
- Pre-Filled DCF Model: AxoGen, Inc.’s (AXGN) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate AxoGen, Inc.’s (AXGN) 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.