National Vision Holdings, Inc. (EYE) 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
National Vision Holdings, Inc. (EYE) Bundle
Looking to assess the intrinsic value of National Vision Holdings, Inc.? Our (EYE) DCF Calculator integrates real-world data with extensive customization features, enabling you to adjust forecasts and enhance your investment choices.
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,724.3 | 1,711.8 | 2,079.5 | 2,005.4 | 2,126.5 | 2,250.0 | 2,380.6 | 2,518.9 | 2,665.1 | 2,819.9 |
| Revenue Growth, % | 0 | -0.72904 | 21.48 | -3.56 | 6.04 | 5.81 | 5.81 | 5.81 | 5.81 | 5.81 |
| EBITDA | 169.7 | 178.6 | 272.0 | 161.2 | 53.1 | 197.5 | 209.0 | 221.1 | 234.0 | 247.6 |
| EBITDA, % | 9.84 | 10.43 | 13.08 | 8.04 | 2.5 | 8.78 | 8.78 | 8.78 | 8.78 | 8.78 |
| Depreciation | 87.2 | 91.6 | 97.1 | 100.0 | 98.3 | 111.1 | 117.5 | 124.3 | 131.6 | 139.2 |
| Depreciation, % | 5.06 | 5.35 | 4.67 | 4.98 | 4.62 | 4.94 | 4.94 | 4.94 | 4.94 | 4.94 |
| EBIT | 82.5 | 87.0 | 174.9 | 61.3 | -45.1 | 86.4 | 91.5 | 96.8 | 102.4 | 108.3 |
| EBIT, % | 4.78 | 5.08 | 8.41 | 3.06 | -2.12 | 3.84 | 3.84 | 3.84 | 3.84 | 3.84 |
| Total Cash | 39.3 | 373.9 | 305.8 | 229.4 | 149.9 | 257.9 | 272.9 | 288.8 | 305.5 | 323.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 44.5 | 58.0 | 55.7 | 79.9 | 86.9 | 75.2 | 79.6 | 84.2 | 89.1 | 94.3 |
| Account Receivables, % | 2.58 | 3.39 | 2.68 | 3.98 | 4.08 | 3.34 | 3.34 | 3.34 | 3.34 | 3.34 |
| Inventories | 127.6 | 111.3 | 123.7 | 123.2 | 119.9 | 142.3 | 150.6 | 159.3 | 168.6 | 178.4 |
| Inventories, % | 7.4 | 6.5 | 5.95 | 6.14 | 5.64 | 6.33 | 6.33 | 6.33 | 6.33 | 6.33 |
| Accounts Payable | 40.8 | 64.9 | 64.3 | 65.3 | 67.6 | 70.6 | 74.7 | 79.0 | 83.6 | 88.4 |
| Accounts Payable, % | 2.37 | 3.79 | 3.09 | 3.26 | 3.18 | 3.14 | 3.14 | 3.14 | 3.14 | 3.14 |
| Capital Expenditure | -101.3 | -76.8 | -95.5 | -113.5 | -114.8 | -117.1 | -123.9 | -131.1 | -138.7 | -146.7 |
| Capital Expenditure, % | -5.88 | -4.49 | -4.59 | -5.66 | -5.4 | -5.2 | -5.2 | -5.2 | -5.2 | -5.2 |
| Tax Rate, % | -6.7 | -6.7 | -6.7 | -6.7 | -6.7 | -6.7 | -6.7 | -6.7 | -6.7 | -6.7 |
| EBITAT | 88.7 | 81.6 | 150.2 | 42.4 | -48.2 | 77.6 | 82.1 | 86.9 | 91.9 | 97.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -56.6 | 123.2 | 141.2 | 6.1 | -66.1 | 63.9 | 67.2 | 71.1 | 75.3 | 79.7 |
| WACC, % | 7.61 | 7.47 | 7.28 | 6.89 | 7.61 | 7.37 | 7.37 | 7.37 | 7.37 | 7.37 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 287.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 81 | |||||||||
| Terminal Value | 1,512 | |||||||||
| Present Terminal Value | 1,060 | |||||||||
| Enterprise Value | 1,348 | |||||||||
| Net Debt | 774 | |||||||||
| Equity Value | 574 | |||||||||
| Diluted Shares Outstanding, MM | 78 | |||||||||
| Equity Value Per Share | 7.33 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real EYE financials.
- Real-World Data: Historical data and forward-looking estimates (as highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effect of your inputs on National Vision Holdings' valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- 🔍 Real-Life EYE Financials: Pre-filled historical and projected data for National Vision Holdings, Inc. (EYE).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate National Vision's intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize National Vision's valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the prebuilt Excel template featuring National Vision Holdings, Inc. (EYE) data.
- Step 2: Review the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including National Vision Holdings, Inc. (EYE)'s intrinsic value.
- Step 5: Use the outputs to make informed investment decisions or create detailed reports.
Why Choose This Calculator for National Vision Holdings, Inc. (EYE)?
- Accurate Data: Utilize real financials from National Vision Holdings for dependable valuation outcomes.
- Customizable: Tailor critical parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Built-in calculations streamline the process, allowing you to avoid starting from scratch.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants focused on National Vision Holdings.
- User-Friendly: Easy-to-navigate design and clear instructions ensure accessibility for all users.
Who Should Use This Product?
- Optometry Students: Master financial assessment techniques and apply them using real data from National Vision Holdings, Inc. (EYE).
- Researchers: Use industry-standard models in your studies related to vision care and retail.
- Investors: Evaluate your investment strategies and analyze valuation results for National Vision Holdings, Inc. (EYE).
- Market Analysts: Enhance your analysis with a customizable DCF model tailored for the optical retail sector.
- Entrepreneurs: Understand how major companies like National Vision Holdings, Inc. (EYE) are evaluated in the market.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled National Vision Holdings, Inc. (EYE) 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 National Vision Holdings, Inc. (EYE).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.