Commercial Vehicle Group, Inc. (CVGI) 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
Commercial Vehicle Group, Inc. (CVGI) Bundle
Assess the financial outlook of Commercial Vehicle Group, Inc. (CVGI) with expert precision! This (CVGI) DCF Calculator provides you with pre-populated financial data and total flexibility to modify revenue growth, WACC, margins, and other crucial assumptions to align with your 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 | 901.2 | 717.7 | 971.6 | 981.6 | 994.7 | 1,037.9 | 1,083.0 | 1,130.0 | 1,179.1 | 1,230.3 |
Revenue Growth, % | 0 | -20.37 | 35.37 | 1.03 | 1.34 | 4.34 | 4.34 | 4.34 | 4.34 | 4.34 |
EBITDA | 53.7 | -6.4 | 68.5 | 33.8 | 64.5 | 45.7 | 47.7 | 49.8 | 52.0 | 54.2 |
EBITDA, % | 5.95 | -0.89662 | 7.05 | 3.44 | 6.48 | 4.41 | 4.41 | 4.41 | 4.41 | 4.41 |
Depreciation | 15.5 | 18.5 | 18.5 | 18.2 | 17.6 | 20.4 | 21.3 | 22.2 | 23.2 | 24.2 |
Depreciation, % | 1.72 | 2.58 | 1.9 | 1.85 | 1.77 | 1.97 | 1.97 | 1.97 | 1.97 | 1.97 |
EBIT | 38.1 | -24.9 | 50.0 | 15.6 | 46.9 | 25.3 | 26.4 | 27.6 | 28.8 | 30.0 |
EBIT, % | 4.23 | -3.47 | 5.15 | 1.59 | 4.71 | 2.44 | 2.44 | 2.44 | 2.44 | 2.44 |
Total Cash | 39.5 | 50.5 | 35.0 | 31.8 | 37.8 | 45.8 | 47.8 | 49.9 | 52.0 | 54.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 115.1 | 151.1 | 174.5 | 152.6 | 133.9 | 167.7 | 175.0 | 182.6 | 190.5 | 198.8 |
Account Receivables, % | 12.77 | 21.05 | 17.96 | 15.55 | 13.47 | 16.16 | 16.16 | 16.16 | 16.16 | 16.16 |
Inventories | 82.9 | 91.2 | 141.0 | 142.5 | 128.1 | 132.5 | 138.2 | 144.2 | 150.5 | 157.0 |
Inventories, % | 9.2 | 12.71 | 14.52 | 14.52 | 12.88 | 12.77 | 12.77 | 12.77 | 12.77 | 12.77 |
Accounts Payable | 63.1 | 112.4 | 101.9 | 122.1 | 77.3 | 110.8 | 115.6 | 120.6 | 125.8 | 131.3 |
Accounts Payable, % | 7 | 15.66 | 10.49 | 12.44 | 7.77 | 10.67 | 10.67 | 10.67 | 10.67 | 10.67 |
Capital Expenditure | -24.0 | -7.1 | -17.7 | -19.7 | -19.7 | -19.6 | -20.5 | -21.4 | -22.3 | -23.3 |
Capital Expenditure, % | -2.66 | -0.99512 | -1.82 | -2.01 | -1.98 | -1.89 | -1.89 | -1.89 | -1.89 | -1.89 |
Tax Rate, % | -36.59 | -36.59 | -36.59 | -36.59 | -36.59 | -36.59 | -36.59 | -36.59 | -36.59 | -36.59 |
EBITAT | 27.9 | -20.8 | 37.0 | 321.4 | 64.0 | 21.8 | 22.8 | 23.7 | 24.8 | 25.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -115.5 | -4.4 | -45.9 | 360.4 | 50.3 | 17.8 | 15.3 | 16.0 | 16.7 | 17.4 |
WACC, % | 8.11 | 8.54 | 8.14 | 9.25 | 9.25 | 8.66 | 8.66 | 8.66 | 8.66 | 8.66 |
PV UFCF | ||||||||||
SUM PV UFCF | 65.3 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 18 | |||||||||
Terminal Value | 317 | |||||||||
Present Terminal Value | 209 | |||||||||
Enterprise Value | 275 | |||||||||
Net Debt | 136 | |||||||||
Equity Value | 139 | |||||||||
Diluted Shares Outstanding, MM | 34 | |||||||||
Equity Value Per Share | 4.13 |
What You Will Get
- Comprehensive CVGI Financials: Access to both 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: Evaluate various scenarios to assess Commercial Vehicle Group's future performance.
- User-Friendly Interface: Designed for professionals while remaining easy to navigate for newcomers.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Commercial Vehicle Group, Inc. (CVGI).
- WACC Calculator: Pre-designed Weighted Average Cost of Capital sheet with adjustable inputs specific to CVGI.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit CVGI's financial projections.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Commercial Vehicle Group, Inc. (CVGI).
- Interactive Dashboard and Charts: Visual representations summarize key valuation metrics for straightforward analysis of CVGI.
How It Works
- Download: Obtain the pre-formatted Excel file containing Commercial Vehicle Group, Inc. (CVGI) financial data.
- Customize: Modify projections, including sales growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various forecasts and analyze results instantly.
- Make Decisions: Leverage the valuation insights to inform your investment choices.
Why Choose Commercial Vehicle Group, Inc. (CVGI)?
- Streamlined Solutions: Access comprehensive tools without the hassle of starting from scratch.
- Enhanced Precision: Dependable data and calculations minimize discrepancies in your assessments.
- Fully Adaptable: Customize offerings to align with your specific needs and forecasts.
- User-Friendly Interface: Intuitive visuals and outputs simplify data interpretation.
- Endorsed by Industry Leaders: Crafted for professionals who prioritize accuracy and efficiency.
Who Should Use This Product?
- Transportation Students: Understand industry-specific valuation methods and practice with real-world data.
- Researchers: Utilize comprehensive models in your studies or publications related to commercial vehicles.
- Investors: Evaluate your investment strategies and assess valuation scenarios for Commercial Vehicle Group, Inc. (CVGI).
- Market Analysts: Enhance your analysis process with a tailored, ready-to-use DCF model.
- Fleet Managers: Discover how large-scale commercial vehicle operations are evaluated and managed.
What the Template Contains
- Historical Data: Includes Commercial Vehicle Group, Inc.'s (CVGI) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Commercial Vehicle Group, Inc.'s (CVGI) 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 Commercial Vehicle Group, Inc.'s (CVGI) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.