Gentex Corporation (GNTX) 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
Gentex Corporation (GNTX) Bundle
Evaluate the financial outlook of Gentex Corporation (GNTX) like an expert! This (GNTX) DCF Calculator provides pre-filled financial data and offers full flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your predictions.
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,858.9 | 1,688.2 | 1,731.2 | 1,919.0 | 2,299.2 | 2,437.3 | 2,583.7 | 2,738.9 | 2,903.4 | 3,077.8 |
Revenue Growth, % | 0 | -9.18 | 2.55 | 10.85 | 19.82 | 6.01 | 6.01 | 6.01 | 6.01 | 6.01 |
EBITDA | 593.2 | 399.6 | 409.8 | 466.6 | 589.1 | 629.7 | 667.6 | 707.7 | 750.2 | 795.2 |
EBITDA, % | 31.91 | 23.67 | 23.67 | 24.31 | 25.62 | 25.84 | 25.84 | 25.84 | 25.84 | 25.84 |
Depreciation | 104.7 | 104.7 | 99.1 | 96.6 | 93.3 | 129.9 | 137.7 | 146.0 | 154.8 | 164.1 |
Depreciation, % | 5.63 | 6.2 | 5.73 | 5.03 | 4.06 | 5.33 | 5.33 | 5.33 | 5.33 | 5.33 |
EBIT | 488.5 | 294.8 | 310.7 | 370.0 | 495.7 | 499.8 | 529.8 | 561.7 | 595.4 | 631.2 |
EBIT, % | 26.28 | 17.46 | 17.95 | 19.28 | 21.56 | 20.51 | 20.51 | 20.51 | 20.51 | 20.51 |
Total Cash | 436.7 | 450.5 | 267.7 | 237.8 | 240.8 | 431.4 | 457.4 | 484.8 | 514.0 | 544.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 235.4 | 284.9 | 249.8 | 276.5 | 321.8 | 352.8 | 374.0 | 396.5 | 420.3 | 445.5 |
Account Receivables, % | 12.66 | 16.88 | 14.43 | 14.41 | 14 | 14.48 | 14.48 | 14.48 | 14.48 | 14.48 |
Inventories | 248.9 | 226.3 | 316.3 | 404.4 | 402.5 | 407.7 | 432.2 | 458.2 | 485.7 | 514.9 |
Inventories, % | 13.39 | 13.4 | 18.27 | 21.07 | 17.5 | 16.73 | 16.73 | 16.73 | 16.73 | 16.73 |
Accounts Payable | 97.6 | 84.8 | 98.3 | 151.7 | 184.4 | 155.4 | 164.7 | 174.6 | 185.1 | 196.2 |
Accounts Payable, % | 5.25 | 5.02 | 5.68 | 7.91 | 8.02 | 6.38 | 6.38 | 6.38 | 6.38 | 6.38 |
Capital Expenditure | -84.6 | -51.7 | -68.8 | -146.4 | -183.7 | -132.6 | -140.6 | -149.0 | -158.0 | -167.5 |
Capital Expenditure, % | -4.55 | -3.06 | -3.98 | -7.63 | -7.99 | -5.44 | -5.44 | -5.44 | -5.44 | -5.44 |
Tax Rate, % | 15.16 | 15.16 | 15.16 | 15.16 | 15.16 | 15.16 | 15.16 | 15.16 | 15.16 | 15.16 |
EBITAT | 414.6 | 248.8 | 269.2 | 319.0 | 420.6 | 426.8 | 452.4 | 479.6 | 508.4 | 539.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 47.9 | 262.2 | 258.2 | 207.7 | 319.4 | 358.9 | 413.2 | 438.0 | 464.4 | 492.3 |
WACC, % | 8.74 | 8.74 | 8.74 | 8.74 | 8.74 | 8.74 | 8.74 | 8.74 | 8.74 | 8.74 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,675.9 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 507 | |||||||||
Terminal Value | 8,829 | |||||||||
Present Terminal Value | 5,807 | |||||||||
Enterprise Value | 7,483 | |||||||||
Net Debt | -223 | |||||||||
Equity Value | 7,705 | |||||||||
Diluted Shares Outstanding, MM | 230 | |||||||||
Equity Value Per Share | 33.54 |
What You Will Get
- Real GNTX Financial Data: Pre-filled with Gentex Corporation’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Gentex Corporation’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Pre-Loaded Data: Gentex Corporation’s historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Instant Results: Observe Gentex Corporation’s intrinsic value recalculating in real time.
- Clear Visual Outputs: Dashboard charts illustrate valuation results and essential metrics.
- Built for Accuracy: A professional tool designed for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file for Gentex Corporation (GNTX).
- Step 2: Review Gentex's pre-filled financial data and projections.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify your assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose This Calculator for Gentex Corporation (GNTX)?
- Designed for Experts: A sophisticated tool utilized by financial analysts, CFOs, and industry consultants.
- Comprehensive Data: Gentex's historical and forecasted financial information preloaded for precise analysis.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Detailed Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance simplifies the calculation process.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for assessing Gentex Corporation (GNTX) investments.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions for Gentex Corporation (GNTX).
- Consultants and Advisors: Offer clients precise valuation insights related to Gentex Corporation (GNTX) stock.
- Students and Educators: Utilize real-time data to enhance learning and practice in financial modeling focused on Gentex Corporation (GNTX).
- Tech Enthusiasts: Gain insights into how companies like Gentex Corporation (GNTX) are valued within the technology sector.
What the Template Contains
- Preloaded GNTX 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.