Beyond Air, Inc. (XAIR) 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
Beyond Air, Inc. (XAIR) Bundle
Explore the financial potential of Beyond Air, Inc. (XAIR) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of Beyond Air, Inc. (XAIR) and inform your investment approach.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 1.4 | .9 | .0 | .0 | 1.2 | .8 | .5 | .3 | .2 | .1 |
Revenue Growth, % | 0 | -37.2 | -100 | 0 | 0 | -34.3 | -34.3 | -34.3 | -34.3 | -34.3 |
EBITDA | -19.8 | -22.0 | -42.7 | -58.2 | -59.0 | -.2 | -.1 | -.1 | .0 | .0 |
EBITDA, % | -1427.52 | -2522.57 | 100 | 100 | -5093.27 | -20 | -20 | -20 | -20 | -20 |
Depreciation | .2 | .2 | .6 | 1.2 | 2.4 | .5 | .3 | .2 | .1 | .1 |
Depreciation, % | 15.99 | 28.56 | 100 | 100 | 202.93 | 68.91 | 68.91 | 68.91 | 68.91 | 68.91 |
EBIT | -20.1 | -22.3 | -43.3 | -59.4 | -61.4 | -.2 | -.1 | -.1 | .0 | .0 |
EBIT, % | -1443.51 | -2551.13 | 100 | 100 | -5296.2 | -20 | -20 | -20 | -20 | -20 |
Total Cash | 19.8 | 34.6 | 80.2 | 45.9 | 34.5 | .8 | .5 | .3 | .2 | .1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .6 | .7 | .5 | .4 | .2 | .2 | .1 | .1 |
Account Receivables, % | 0 | 0 | 100 | 100 | 47.28 | 49.46 | 49.46 | 49.46 | 49.46 | 49.46 |
Inventories | 6.5 | 1.9 | .4 | 1.1 | 2.1 | .8 | .5 | .3 | .2 | .1 |
Inventories, % | 469.73 | 215.35 | 100 | 100 | 183.52 | 100 | 100 | 100 | 100 | 100 |
Accounts Payable | 2.3 | 1.3 | 1.1 | 2.0 | 1.9 | .8 | .5 | .3 | .2 | .1 |
Accounts Payable, % | 162.31 | 151.78 | 100 | 100 | 168.08 | 100 | 100 | 100 | 100 | 100 |
Capital Expenditure | .0 | -.9 | -1.4 | -3.9 | -5.7 | -.3 | -.2 | -.1 | -.1 | -.1 |
Capital Expenditure, % | -3.14 | -101.95 | 100 | 100 | -495.69 | -40.63 | -40.63 | -40.63 | -40.63 | -40.63 |
Tax Rate, % | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 | 6.3 |
EBITAT | -19.9 | -22.3 | -42.4 | -55.8 | -57.5 | -.1 | -.1 | -.1 | .0 | .0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -24.0 | -19.2 | -42.5 | -58.4 | -61.9 | .4 | .2 | .1 | .1 | .0 |
WACC, % | 11.34 | 11.41 | 11.23 | 10.87 | 10.84 | 11.14 | 11.14 | 11.14 | 11.14 | 11.14 |
PV UFCF | ||||||||||
SUM PV UFCF | .7 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 0 | |||||||||
Terminal Value | 1 | |||||||||
Present Terminal Value | 0 | |||||||||
Enterprise Value | 1 | |||||||||
Net Debt | 6 | |||||||||
Equity Value | -5 | |||||||||
Diluted Shares Outstanding, MM | 33 | |||||||||
Equity Value Per Share | -0.16 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Beyond Air, Inc. (XAIR) financial data pre-filled to accelerate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A sleek Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for testing projections, validating strategies, and enhancing efficiency.
Key Features
- Accurate Financial Data: Gain access to reliable pre-loaded historical figures and future forecasts for Beyond Air, Inc. (XAIR).
- Adjustable Forecast Parameters: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Instant updates to DCF, Net Present Value (NPV), and cash flow analyses.
- User-Friendly Dashboard: Clear and concise charts and summaries to help you visualize valuation outcomes.
- Designed for All Users: A straightforward, intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the prebuilt Excel template featuring Beyond Air, Inc. (XAIR) data.
- Step 2: Navigate through 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 the recalculated results, including the intrinsic value of Beyond Air, Inc. (XAIR).
- Step 5: Make well-informed investment decisions or create reports based on the results.
Why Choose Beyond Air, Inc. (XAIR)?
- Innovative Solutions: Leverage cutting-edge technologies for enhanced respiratory care.
- Proven Results: Our products have demonstrated significant clinical benefits in real-world settings.
- Patient-Centric Approach: Focused on improving patient outcomes and quality of life.
- Expert Support: Our team of professionals is dedicated to providing exceptional service and guidance.
- Industry Recognition: A trusted name in the healthcare sector, backed by numerous accolades.
Who Should Use Beyond Air, Inc. (XAIR)?
- Healthcare Professionals: Explore innovative treatment options and their financial implications.
- Researchers: Integrate advanced models into studies focused on respiratory therapies.
- Investors: Evaluate your investment strategies and assess the market potential of Beyond Air, Inc. (XAIR).
- Analysts: Enhance your analysis with a customizable financial model tailored for biotech firms.
- Entrepreneurs: Understand how public companies like Beyond Air, Inc. (XAIR) navigate the healthcare landscape.
What the Template Contains
- Pre-Filled Data: Includes Beyond Air, Inc.’s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Beyond Air, Inc.'s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.