Inogen, Inc. (INGN) 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
Inogen, Inc. (INGN) Bundle
Engineered for accuracy, our Inogen, Inc. (INGN) DCF Calculator empowers you to evaluate Inogen's valuation with real-world financial data, offering complete flexibility to modify all key parameters for enhanced projections.
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 | 361.9 | 308.5 | 358.0 | 377.2 | 315.7 | 308.0 | 300.6 | 293.3 | 286.2 | 279.3 |
Revenue Growth, % | 0 | -14.77 | 16.05 | 5.37 | -16.32 | -2.42 | -2.42 | -2.42 | -2.42 | -2.42 |
EBITDA | 33.6 | 6.6 | 30.9 | -25.0 | -58.3 | -3.1 | -3.0 | -3.0 | -2.9 | -2.8 |
EBITDA, % | 9.29 | 2.13 | 8.62 | -6.61 | -18.48 | -1.01 | -1.01 | -1.01 | -1.01 | -1.01 |
Depreciation | 13.8 | 18.6 | 21.6 | 23.5 | 18.2 | 17.2 | 16.8 | 16.3 | 16.0 | 15.6 |
Depreciation, % | 3.82 | 6.02 | 6.04 | 6.23 | 5.75 | 5.57 | 5.57 | 5.57 | 5.57 | 5.57 |
EBIT | 19.8 | -12.0 | 9.2 | -48.5 | -76.5 | -20.3 | -19.8 | -19.3 | -18.9 | -18.4 |
EBIT, % | 5.47 | -3.9 | 2.58 | -12.85 | -24.23 | -6.59 | -6.59 | -6.59 | -6.59 | -6.59 |
Total Cash | 209.1 | 231.2 | 245.5 | 187.0 | 128.5 | 179.6 | 175.3 | 171.0 | 166.9 | 162.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 37.3 | 31.8 | 25.8 | 64.4 | 42.9 | 36.0 | 35.1 | 34.3 | 33.5 | 32.7 |
Account Receivables, % | 10.31 | 10.3 | 7.21 | 17.06 | 13.59 | 11.69 | 11.69 | 11.69 | 11.69 | 11.69 |
Inventories | 35.7 | 24.8 | 31.9 | 34.1 | 21.8 | 26.3 | 25.7 | 25.1 | 24.5 | 23.9 |
Inventories, % | 9.85 | 8.04 | 8.9 | 9.04 | 6.92 | 8.55 | 8.55 | 8.55 | 8.55 | 8.55 |
Accounts Payable | 16.4 | 12.5 | 10.3 | 18.2 | 13.5 | 12.7 | 12.4 | 12.1 | 11.8 | 11.5 |
Accounts Payable, % | 4.53 | 4.06 | 2.87 | 4.83 | 4.26 | 4.11 | 4.11 | 4.11 | 4.11 | 4.11 |
Capital Expenditure | -6.5 | -17.6 | -24.1 | -21.2 | -27.0 | -17.5 | -17.1 | -16.7 | -16.3 | -15.9 |
Capital Expenditure, % | -1.8 | -5.7 | -6.72 | -5.63 | -8.56 | -5.68 | -5.68 | -5.68 | -5.68 | -5.68 |
Tax Rate, % | -0.1026 | -0.1026 | -0.1026 | -0.1026 | -0.1026 | -0.1026 | -0.1026 | -0.1026 | -0.1026 | -0.1026 |
EBITAT | 17.1 | -13.3 | -6.8 | -48.8 | -76.6 | -15.7 | -15.3 | -14.9 | -14.6 | -14.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -32.2 | .2 | -12.5 | -79.3 | -56.5 | -14.4 | -14.4 | -14.1 | -13.7 | -13.4 |
WACC, % | 8.83 | 8.89 | 8.45 | 8.89 | 8.89 | 8.79 | 8.79 | 8.79 | 8.79 | 8.79 |
PV UFCF | ||||||||||
SUM PV UFCF | -54.9 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -14 | |||||||||
Terminal Value | -201 | |||||||||
Present Terminal Value | -132 | |||||||||
Enterprise Value | -187 | |||||||||
Net Debt | -104 | |||||||||
Equity Value | -83 | |||||||||
Diluted Shares Outstanding, MM | 23 | |||||||||
Equity Value Per Share | -3.60 |
What You Will Get
- Real INGN Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Evaluate various scenarios to assess Inogen's future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Customizable Financial Inputs: Adjust key metrics such as revenue growth, EBITDA %, and capital expenditures for accurate forecasting.
- Instant DCF Valuation: Quickly calculates intrinsic value, NPV, and other essential financial outputs.
- High-Precision Accuracy: Incorporates Inogen, Inc.'s (INGN) actual financial data for credible valuation results.
- Effortless Scenario Testing: Easily explore various assumptions and analyze different outcomes.
- Efficiency Booster: Streamlines the valuation process, eliminating the need for complex model building from the ground up.
How It Works
- Download: Obtain the pre-configured Excel file containing Inogen, Inc.'s (INGN) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various forecasts and compare results instantly.
- Make Decisions: Leverage the valuation findings to inform your investment strategy.
Why Choose This Calculator for Inogen, Inc. (INGN)?
- Designed for Experts: A sophisticated tool tailored for analysts, CFOs, and financial consultants.
- Comprehensive Data: Inogen's historical and projected financials are preloaded for precise analysis.
- Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and other essential metrics.
- User-Friendly: Clear, step-by-step instructions facilitate the entire process.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Inogen, Inc. (INGN) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Inogen, Inc. (INGN).
- Consultants: Deliver professional valuation insights on Inogen, Inc. (INGN) to clients quickly and accurately.
- Business Owners: Understand how companies like Inogen, Inc. (INGN) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Inogen, Inc. (INGN).
What the Template Contains
- Pre-Filled DCF Model: Inogen, Inc.’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Inogen, Inc.’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.