Energy Focus, Inc. (EFOI) 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
Energy Focus, Inc. (EFOI) Bundle
Engineered for accuracy, our (EFOI) DCF Calculator empowers you to evaluate Energy Focus, Inc. valuation using real-world financial data while providing complete flexibility to modify all essential 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 | 12.7 | 16.8 | 9.9 | 6.0 | 5.7 | 5.0 | 4.3 | 3.7 | 3.3 | 2.8 |
Revenue Growth, % | 0 | 32.45 | -41.38 | -39.5 | -4.21 | -13.16 | -13.16 | -13.16 | -13.16 | -13.16 |
EBITDA | -6.7 | -5.3 | -6.9 | -9.2 | -3.9 | -3.2 | -2.8 | -2.4 | -2.1 | -1.8 |
EBITDA, % | -52.89 | -31.62 | -70.02 | -153.52 | -67.82 | -64.47 | -64.47 | -64.47 | -64.47 | -64.47 |
Depreciation | .3 | .2 | .2 | .2 | .0 | .1 | .1 | .1 | .1 | .0 |
Depreciation, % | 2.57 | 1.09 | 1.91 | 2.66 | 0.57723 | 1.76 | 1.76 | 1.76 | 1.76 | 1.76 |
EBIT | -7.0 | -5.5 | -7.1 | -9.3 | -3.9 | -3.3 | -2.8 | -2.5 | -2.1 | -1.9 |
EBIT, % | -55.46 | -32.71 | -71.92 | -156.18 | -68.39 | -65.7 | -65.7 | -65.7 | -65.7 | -65.7 |
Total Cash | .4 | 2.6 | 3.4 | .6 | 2.8 | 1.1 | 1.0 | .8 | .7 | .6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 2.3 | 2.0 | 1.2 | .9 | 1.8 | .9 | .8 | .7 | .6 | .5 |
Account Receivables, % | 18.39 | 12.01 | 12.57 | 14.91 | 31 | 17.78 | 17.78 | 17.78 | 17.78 | 17.78 |
Inventories | 6.2 | 5.6 | 7.9 | 5.5 | 4.4 | 3.3 | 2.9 | 2.5 | 2.2 | 1.9 |
Inventories, % | 48.55 | 33.52 | 79.74 | 91.76 | 77.65 | 66.24 | 66.24 | 66.24 | 66.24 | 66.24 |
Accounts Payable | 1.3 | 2.5 | 2.2 | 2.2 | 3.8 | 1.5 | 1.3 | 1.1 | 1.0 | .9 |
Accounts Payable, % | 10.55 | 14.72 | 22.66 | 36.93 | 65.94 | 30.16 | 30.16 | 30.16 | 30.16 | 30.16 |
Capital Expenditure | -.1 | -.2 | -.4 | .0 | -.1 | -.1 | -.1 | -.1 | -.1 | .0 |
Capital Expenditure, % | -1.04 | -1.33 | -4.49 | -0.687 | -1.21 | -1.75 | -1.75 | -1.75 | -1.75 | -1.75 |
Tax Rate, % | -0.06993007 | -0.06993007 | -0.06993007 | -0.06993007 | -0.06993007 | -0.06993007 | -0.06993007 | -0.06993007 | -0.06993007 | -0.06993007 |
EBITAT | -7.1 | -5.5 | -7.1 | -9.3 | -3.9 | -3.3 | -2.8 | -2.5 | -2.1 | -1.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -14.0 | -3.6 | -9.0 | -6.5 | -2.2 | -3.5 | -2.5 | -2.2 | -1.9 | -1.6 |
WACC, % | 14.07 | 14.06 | 14.06 | 14.07 | 14.07 | 14.06 | 14.06 | 14.06 | 14.06 | 14.06 |
PV UFCF | ||||||||||
SUM PV UFCF | -8.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -2 | |||||||||
Terminal Value | -14 | |||||||||
Present Terminal Value | -7 | |||||||||
Enterprise Value | -15 | |||||||||
Net Debt | 0 | |||||||||
Equity Value | -16 | |||||||||
Diluted Shares Outstanding, MM | 3 | |||||||||
Equity Value Per Share | -4.87 |
What You Will Get
- Pre-Filled Financial Model: Energy Focus, Inc. (EFOI)’s actual data enables precise DCF valuation.
- Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers for accurate projections.
- Instant Calculations: Automatic updates ensure you see results in real-time as you make adjustments.
- Investor-Ready Template: A polished Excel file crafted for professional-grade valuation presentations.
- Customizable and Reusable: Designed for flexibility, allowing repeated use for comprehensive forecasts.
Key Features
- Comprehensive Data: Energy Focus, Inc.'s historical financial statements and pre-filled projections.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Results: Watch Energy Focus, Inc.'s intrinsic value update instantly.
- Intuitive Visual Outputs: Dashboard graphs illustrate valuation results and essential metrics.
- Designed for Precision: A reliable tool for analysts, investors, and finance professionals.
How It Works
- Download: Get the pre-built Excel file featuring Energy Focus, Inc. (EFOI) financial data.
- Customize: Modify forecasts, including projected revenue growth, EBITDA %, and WACC.
- Update Automatically: Real-time updates for intrinsic value and NPV calculations.
- Test Scenarios: Generate various projections and instantly compare results.
- Make Decisions: Leverage valuation insights to inform your investment choices.
Why Choose This Calculator for Energy Focus, Inc. (EFOI)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters to suit your specific analysis needs.
- Real-Time Adjustments: Witness immediate updates to Energy Focus’s valuation as you tweak inputs.
- Pre-Configured Data: Comes with Energy Focus’s up-to-date financial information for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Investors: Accurately assess Energy Focus, Inc.'s (EFOI) fair value before making investment choices.
- CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis.
- Consultants: Efficiently customize the template for valuation reports tailored to clients.
- Entrepreneurs: Discover insights into financial modeling practices employed by leading energy firms.
- Educators: Implement it as a teaching resource to illustrate valuation techniques.
What the Template Contains
- Historical Data: Includes Energy Focus, Inc. (EFOI)’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Energy Focus, Inc. (EFOI)’s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Energy Focus, Inc. (EFOI)’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.