Covenant Logistics Group, Inc. (CVLG) 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
Covenant Logistics Group, Inc. (CVLG) Bundle
Looking to determine the intrinsic value of Covenant Logistics Group, Inc.? Our CVLG DCF Calculator integrates real-world data with extensive customization features, allowing you to refine forecasts and enhance your investment strategies.
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 | 894.5 | 838.6 | 1,046.0 | 1,216.9 | 1,103.6 | 1,173.9 | 1,248.8 | 1,328.4 | 1,413.1 | 1,503.2 |
Revenue Growth, % | 0 | -6.26 | 24.74 | 16.33 | -9.31 | 6.38 | 6.38 | 6.38 | 6.38 | 6.38 |
EBITDA | 16.0 | 55.4 | 78.1 | 105.6 | 116.2 | 82.3 | 87.6 | 93.2 | 99.1 | 105.4 |
EBITDA, % | 1.79 | 6.61 | 7.47 | 8.67 | 10.53 | 7.01 | 7.01 | 7.01 | 7.01 | 7.01 |
Depreciation | 80.5 | 64.1 | 53.9 | 57.5 | 69.9 | 77.2 | 82.1 | 87.3 | 92.9 | 98.8 |
Depreciation, % | 9 | 7.65 | 5.15 | 4.73 | 6.34 | 6.57 | 6.57 | 6.57 | 6.57 | 6.57 |
EBIT | -64.5 | -8.7 | 24.3 | 48.0 | 46.2 | 5.2 | 5.5 | 5.9 | 6.2 | 6.6 |
EBIT, % | -7.21 | -1.04 | 2.32 | 3.95 | 4.19 | 0.44156 | 0.44156 | 0.44156 | 0.44156 | 0.44156 |
Total Cash | 43.6 | 8.4 | 8.4 | 68.7 | 2.3 | 29.4 | 31.3 | 33.3 | 35.4 | 37.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 95.1 | 109.1 | 161.3 | 128.4 | 153.6 | 149.2 | 158.7 | 168.8 | 179.6 | 191.0 |
Account Receivables, % | 10.63 | 13.01 | 15.42 | 10.55 | 13.92 | 12.71 | 12.71 | 12.71 | 12.71 | 12.71 |
Inventories | 4.2 | 3.1 | 3.3 | 3.5 | 4.8 | 4.4 | 4.7 | 5.0 | 5.3 | 5.7 |
Inventories, % | 0.47064 | 0.37195 | 0.31769 | 0.28894 | 0.4393 | 0.3777 | 0.3777 | 0.3777 | 0.3777 | 0.3777 |
Accounts Payable | 19.5 | 31.7 | 29.9 | 33.9 | 33.2 | 34.3 | 36.5 | 38.8 | 41.3 | 43.9 |
Accounts Payable, % | 2.18 | 3.78 | 2.86 | 2.79 | 3 | 2.92 | 2.92 | 2.92 | 2.92 | 2.92 |
Capital Expenditure | -138.3 | -94.0 | -35.3 | -100.5 | -217.6 | -136.2 | -144.9 | -154.2 | -164.0 | -174.4 |
Capital Expenditure, % | -15.46 | -11.22 | -3.37 | -8.26 | -19.72 | -11.6 | -11.6 | -11.6 | -11.6 | -11.6 |
Tax Rate, % | 23.55 | 23.55 | 23.55 | 23.55 | 23.55 | 23.55 | 23.55 | 23.55 | 23.55 | 23.55 |
EBITAT | -45.8 | -7.3 | 18.6 | 36.6 | 35.3 | 4.0 | 4.2 | 4.5 | 4.8 | 5.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -183.4 | -37.9 | -17.0 | 30.3 | -139.6 | -49.1 | -66.2 | -70.4 | -74.9 | -79.7 |
WACC, % | 8.69 | 8.84 | 8.76 | 8.75 | 8.75 | 8.76 | 8.76 | 8.76 | 8.76 | 8.76 |
PV UFCF | ||||||||||
SUM PV UFCF | -261.8 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | -82 | |||||||||
Terminal Value | -1,426 | |||||||||
Present Terminal Value | -937 | |||||||||
Enterprise Value | -1,199 | |||||||||
Net Debt | 291 | |||||||||
Equity Value | -1,490 | |||||||||
Diluted Shares Outstanding, MM | 14 | |||||||||
Equity Value Per Share | -107.71 |
What You Will Get
- Real CVLG Financial Data: Pre-filled with Covenant Logistics Group’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 Covenant Logistics Group’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
- Comprehensive Data: Covenant Logistics Group’s (CVLG) historical financial statements and pre-filled projections.
- Customizable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Insights: Monitor Covenant Logistics Group’s intrinsic value updates instantly.
- Visualized Outputs: Dashboard graphs illustrate valuation results and essential metrics.
- Designed for Precision: A reliable tool for analysts, investors, and finance professionals.
How It Works
- 1. Open the Template: Download and open the Excel file containing Covenant Logistics Group, Inc. (CVLG)’s preloaded data.
- 2. Edit Assumptions: Modify key inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV based on your inputs.
- 4. Test Scenarios: Evaluate multiple forecasts to explore various valuation outcomes.
- 5. Use with Confidence: Present professional valuation insights to enhance your decision-making process.
Why Choose This Calculator for Covenant Logistics Group, Inc. (CVLG)?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for CVLG.
- Flexible Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Covenant Logistics’ intrinsic value and Net Present Value.
- Preloaded Information: Access to historical and projected data guarantees reliable starting points.
- High-Quality Standards: Perfect for financial analysts, investors, and business consultants focusing on CVLG.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing portfolios related to Covenant Logistics Group, Inc. (CVLG).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Covenant Logistics Group, Inc. (CVLG).
- Students and Educators: Utilize real-world data for practicing and teaching financial modeling techniques.
- Logistics and Transportation Enthusiasts: Gain insights into how companies like Covenant Logistics Group, Inc. (CVLG) are valued in the industry.
What the Template Contains
- Preloaded CVLG 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.