Nutriband Inc. (NTRB) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Nutriband Inc. (NTRB) Bundle
Gain insight into your Nutriband Inc. (NTRB) valuation analysis with our sophisticated DCF Calculator! Preloaded with authentic (NTRB) data, this Excel template enables you to adjust forecasts and assumptions, allowing for precise calculations of Nutriband Inc.'s intrinsic value.
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 | .4 | .9 | 1.4 | 2.1 | 2.1 | 3.1 | 4.6 | 6.9 | 10.4 | 15.5 |
Revenue Growth, % | 0 | 154.61 | 50.7 | 46.23 | 0.27433 | 49.3 | 49.3 | 49.3 | 49.3 | 49.3 |
EBITDA | -2.6 | -2.5 | -5.7 | -4.1 | -5.1 | -3.1 | -4.6 | -6.9 | -10.4 | -15.5 |
EBITDA, % | -689.71 | -263.05 | -403.57 | -197.45 | -245.61 | -100 | -100 | -100 | -100 | -100 |
Depreciation | .1 | .2 | .3 | .4 | .3 | .6 | .9 | 1.3 | 2.0 | 3.0 |
Depreciation, % | 24.78 | 17.98 | 22.38 | 17.74 | 13.8 | 19.34 | 19.34 | 19.34 | 19.34 | 19.34 |
EBIT | -2.6 | -2.7 | -6.1 | -4.5 | -5.4 | -3.1 | -4.6 | -6.9 | -10.4 | -15.5 |
EBIT, % | -714.48 | -281.04 | -425.95 | -215.19 | -259.41 | -100 | -100 | -100 | -100 | -100 |
Total Cash | .0 | .2 | 4.9 | 2.0 | .5 | 1.5 | 2.2 | 3.3 | 4.9 | 7.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .1 | .1 | .1 | .1 | .2 | .3 | .5 | .7 | 1.0 |
Account Receivables, % | 3.46 | 11.59 | 5.02 | 5.44 | 7.13 | 6.53 | 6.53 | 6.53 | 6.53 | 6.53 |
Inventories | .0 | .1 | .1 | .2 | .2 | .2 | .3 | .5 | .7 | 1.1 |
Inventories, % | 0 | 5.6 | 9.26 | 11.03 | 8.09 | 6.79 | 6.79 | 6.79 | 6.79 | 6.79 |
Accounts Payable | .8 | .9 | .6 | .5 | .7 | 1.9 | 2.8 | 4.2 | 6.3 | 9.4 |
Accounts Payable, % | 208.27 | 99.67 | 44.97 | 25.71 | 32.62 | 60.59 | 60.59 | 60.59 | 60.59 | 60.59 |
Capital Expenditure | .0 | .0 | -.1 | -.1 | -.1 | -.1 | -.1 | -.2 | -.2 | -.4 |
Capital Expenditure, % | 0 | 0 | -5.74 | -3.81 | -2.48 | -2.41 | -2.41 | -2.41 | -2.41 | -2.41 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | -2.7 | -2.9 | -8.3 | -4.8 | -5.4 | -3.1 | -4.6 | -6.9 | -10.4 | -15.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -1.9 | -2.7 | -8.4 | -4.8 | -5.0 | -1.5 | -3.1 | -4.7 | -7.0 | -10.4 |
WACC, % | 6.61 | 6.61 | 6.61 | 6.61 | 6.61 | 6.61 | 6.61 | 6.61 | 6.61 | 6.61 |
PV UFCF | ||||||||||
SUM PV UFCF | -21.0 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -11 | |||||||||
Terminal Value | -231 | |||||||||
Present Terminal Value | -168 | |||||||||
Enterprise Value | -189 | |||||||||
Net Debt | 0 | |||||||||
Equity Value | -188 | |||||||||
Diluted Shares Outstanding, MM | 8 | |||||||||
Equity Value Per Share | -23.69 |
What You Will Get
- Real NTRB Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Instant Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess Nutriband's future performance.
- User-Friendly Design: Designed for industry experts while remaining easy for newcomers to navigate.
Key Features
- 🔍 Real-Life NTRB Financials: Pre-filled historical and projected data for Nutriband Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Nutriband’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Nutriband’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download: Obtain the pre-prepared Excel file containing Nutriband Inc.'s (NTRB) financial metrics.
- Customize: Tailor your projections, including revenue growth, EBITDA %, and WACC to fit your analysis.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time as you make changes.
- Test Scenarios: Generate various projections and swiftly compare the results.
- Make Decisions: Leverage the valuation insights to inform your investment choices.
Why Choose This Calculator for Nutriband Inc. (NTRB)?
- Designed for Industry Experts: A specialized tool tailored for nutritionists, investors, and health consultants.
- Up-to-Date Data: Nutriband’s current and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance makes the process straightforward.
Who Should Use Nutriband Inc. (NTRB)?
- Healthcare Professionals: Utilize advanced drug delivery systems for improved patient outcomes.
- Pharmaceutical Companies: Analyze innovative solutions to enhance product offerings and market reach.
- Investors: Gain insights into the potential of Nutriband Inc. (NTRB) for informed investment decisions.
- Researchers and Academics: Explore cutting-edge technologies in transdermal delivery for educational purposes.
- Health and Wellness Enthusiasts: Understand how Nutriband Inc. (NTRB) is revolutionizing drug administration methods.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Nutriband Inc. (NTRB) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Nutriband Inc. (NTRB).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.