Research Frontiers Incorporated (REFR) 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
Research Frontiers Incorporated (REFR) Bundle
Whether you're an investor or an analyst, this REFR DCF Calculator is your go-to resource for accurate valuation. Equipped with real data from Research Frontiers Incorporated, you can adjust forecasts and observe the effects in real time.
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 | 1.6 | .8 | 1.3 | .5 | .9 | .9 | 1.0 | 1.0 | 1.1 | 1.1 |
Revenue Growth, % | 0 | -47.03 | 52.46 | -57.27 | 68.54 | 4.17 | 4.17 | 4.17 | 4.17 | 4.17 |
EBITDA | -3.0 | -2.5 | -1.8 | -2.5 | -1.9 | -.9 | -1.0 | -1.0 | -1.1 | -1.1 |
EBITDA, % | -188.87 | -303.01 | -144.19 | -462.16 | -204.61 | -100 | -100 | -100 | -100 | -100 |
Depreciation | .2 | .1 | .0 | .2 | .2 | .1 | .1 | .1 | .2 | .2 |
Depreciation, % | 12.49 | 8.1 | 0.80251 | 32.45 | 18.93 | 14.55 | 14.55 | 14.55 | 14.55 | 14.55 |
EBIT | -3.1 | -2.6 | -1.8 | -2.7 | -2.0 | -.9 | -1.0 | -1.0 | -1.1 | -1.1 |
EBIT, % | -201.36 | -311.11 | -144.99 | -494.61 | -223.54 | -100 | -100 | -100 | -100 | -100 |
Total Cash | 6.6 | 4.8 | 3.0 | 4.2 | 2.5 | .9 | 1.0 | 1.0 | 1.1 | 1.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .7 | .6 | .8 | .6 | 1.0 | .7 | .8 | .8 | .8 | .8 |
Account Receivables, % | 41.95 | 72.22 | 65.84 | 109.25 | 110.31 | 76 | 76 | 76 | 76 | 76 |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 0 | 0.000000000000114 | 0 | 0 | 0 | 3.33E-14 | 3.33E-14 | 3.33E-14 | 3.33E-14 | 3.33E-14 |
Accounts Payable | .2 | .0 | .1 | .1 | .1 | .1 | .1 | .1 | .1 | .1 |
Accounts Payable, % | 10.85 | 4.03 | 5.26 | 13.17 | 5.59 | 7.78 | 7.78 | 7.78 | 7.78 | 7.78 |
Capital Expenditure | -.1 | -.1 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Capital Expenditure, % | -4.17 | -6.82 | -0.08527086 | -0.23551 | -0.17128 | -2.3 | -2.3 | -2.3 | -2.3 | -2.3 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | -3.7 | -2.3 | -1.8 | -2.7 | -2.0 | -.9 | -1.0 | -1.0 | -1.0 | -1.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -4.1 | -2.4 | -2.0 | -2.3 | -2.3 | -.5 | -.9 | -.9 | -.9 | -1.0 |
WACC, % | 5.69 | 5.69 | 5.69 | 5.69 | 5.69 | 5.69 | 5.69 | 5.69 | 5.69 | 5.69 |
PV UFCF | ||||||||||
SUM PV UFCF | -3.5 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -1 | |||||||||
Terminal Value | -27 | |||||||||
Present Terminal Value | -21 | |||||||||
Enterprise Value | -24 | |||||||||
Net Debt | -2 | |||||||||
Equity Value | -22 | |||||||||
Diluted Shares Outstanding, MM | 33 | |||||||||
Equity Value Per Share | -0.66 |
What You Will Get
- Real REFR 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 in real-time.
- Scenario Analysis: Explore various scenarios to assess Research Frontiers' future performance.
- User-Friendly Design: Designed for professionals but easy to navigate for newcomers.
Key Features
- Comprehensive REFR Financials: Gain access to precise pre-loaded historical data and future forecasts.
- Adjustable Forecast Parameters: Modify yellow-highlighted fields such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to help visualize your valuation outcomes.
- Designed for All Levels: A straightforward, intuitive layout tailored for investors, CFOs, and consultants.
How It Operates
- Download: Obtain the pre-configured Excel file containing Research Frontiers Incorporated’s (REFR) 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: Develop various forecasts and instantly compare results.
- Make Decisions: Leverage the valuation findings to inform your investment strategy.
Why Choose This Calculator for Research Frontiers Incorporated (REFR)?
- Accuracy: Utilizes authentic Research Frontiers financial data for precise calculations.
- Flexibility: Allows users to easily adjust and test various input parameters.
- Time-Saving: Eliminate the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected by CFOs.
- User-Friendly: Intuitive interface suitable for all users, regardless of financial modeling expertise.
Who Should Use This Product?
- Investors: Accurately assess Research Frontiers Incorporated’s (REFR) fair value prior to making investment choices.
- CFOs: Utilize a top-tier DCF model for comprehensive financial reporting and analysis.
- Consultants: Easily modify the template for client valuation reports specific to (REFR).
- Entrepreneurs: Acquire knowledge of financial modeling techniques employed by leading companies.
- Educators: Implement it as a resource to illustrate valuation methods in the classroom.
What the Template Contains
- Preloaded REFR Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.