CACI International Inc (CACI) 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
CACI International Inc (CACI) Bundle
Evaluate CACI International Inc's (CACI) financial outlook like an expert! This (CACI) DCF Calculator provides pre-filled financial data along with full flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your projections.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 5,720.0 | 6,044.1 | 6,202.9 | 6,702.5 | 7,659.8 | 8,246.4 | 8,877.9 | 9,557.7 | 10,289.6 | 11,077.5 |
Revenue Growth, % | 0 | 5.67 | 2.63 | 8.05 | 14.28 | 7.66 | 7.66 | 7.66 | 7.66 | 7.66 |
EBITDA | 568.4 | 664.8 | 631.0 | 709.1 | 791.9 | 858.0 | 923.8 | 994.5 | 1,070.6 | 1,152.6 |
EBITDA, % | 9.94 | 11 | 10.17 | 10.58 | 10.34 | 10.41 | 10.41 | 10.41 | 10.41 | 10.41 |
Depreciation | 183.9 | 202.5 | 204.1 | 211.0 | 142.1 | 245.1 | 263.8 | 284.0 | 305.8 | 329.2 |
Depreciation, % | 3.22 | 3.35 | 3.29 | 3.15 | 1.86 | 2.97 | 2.97 | 2.97 | 2.97 | 2.97 |
EBIT | 384.4 | 462.3 | 426.9 | 498.1 | 649.7 | 613.0 | 659.9 | 710.4 | 764.9 | 823.4 |
EBIT, % | 6.72 | 7.65 | 6.88 | 7.43 | 8.48 | 7.43 | 7.43 | 7.43 | 7.43 | 7.43 |
Total Cash | 107.2 | 88.0 | 114.8 | 115.8 | 134.0 | 142.8 | 153.7 | 165.5 | 178.2 | 191.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 841.2 | 879.9 | 926.1 | 894.9 | 1,031.3 | 1,171.2 | 1,260.8 | 1,357.4 | 1,461.3 | 1,573.2 |
Account Receivables, % | 14.71 | 14.56 | 14.93 | 13.35 | 13.46 | 14.2 | 14.2 | 14.2 | 14.2 | 14.2 |
Inventories | 65.2 | 79.7 | 99.4 | 130.6 | 118.4 | 124.6 | 134.1 | 144.4 | 155.5 | 167.4 |
Inventories, % | 1.14 | 1.32 | 1.6 | 1.95 | 1.55 | 1.51 | 1.51 | 1.51 | 1.51 | 1.51 |
Accounts Payable | 90.0 | 148.6 | 303.4 | 198.2 | 287.1 | 257.8 | 277.5 | 298.8 | 321.6 | 346.3 |
Accounts Payable, % | 1.57 | 2.46 | 4.89 | 2.96 | 3.75 | 3.13 | 3.13 | 3.13 | 3.13 | 3.13 |
Capital Expenditure | -72.3 | -73.1 | -74.6 | -63.7 | -63.7 | -90.0 | -96.9 | -104.3 | -112.3 | -120.9 |
Capital Expenditure, % | -1.26 | -1.21 | -1.2 | -0.95064 | -0.83143 | -1.09 | -1.09 | -1.09 | -1.09 | -1.09 |
Tax Rate, % | 22.9 | 22.9 | 22.9 | 22.9 | 22.9 | 22.9 | 22.9 | 22.9 | 22.9 | 22.9 |
EBITAT | 307.7 | 423.3 | 344.5 | 396.2 | 500.9 | 501.3 | 539.7 | 581.1 | 625.6 | 673.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -397.1 | 558.2 | 562.9 | 438.2 | 544.1 | 481.0 | 627.2 | 675.2 | 726.9 | 782.6 |
WACC, % | 8.02 | 8.13 | 8.03 | 8.02 | 7.99 | 8.04 | 8.04 | 8.04 | 8.04 | 8.04 |
PV UFCF | ||||||||||
SUM PV UFCF | 2,583.2 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 806 | |||||||||
Terminal Value | 16,000 | |||||||||
Present Terminal Value | 10,870 | |||||||||
Enterprise Value | 13,453 | |||||||||
Net Debt | 1,785 | |||||||||
Equity Value | 11,668 | |||||||||
Diluted Shares Outstanding, MM | 23 | |||||||||
Equity Value Per Share | 516.91 |
What You Will Receive
- Customizable Excel Template: A fully adaptable Excel-based DCF Calculator featuring pre-filled financial data for CACI International Inc (CACI).
- Comprehensive Data: Access to historical performance metrics and forward-looking projections (highlighted in the yellow cells).
- Assumption Flexibility: Modify forecast parameters such as revenue growth, EBITDA percentage, and WACC.
- Instant Calculations: Quickly observe how your inputs influence CACI's valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for clarity and ease of navigation, complete with step-by-step guidance.
Key Features
- Real-Life CACI Data: Pre-filled with CACI International Inc’s historical financials and future projections.
- Fully Customizable Inputs: Modify revenue growth, margins, WACC, tax rates, and capital expenditures as needed.
- Dynamic Valuation Model: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Testing: Develop various forecast scenarios to evaluate different valuation results.
- User-Friendly Design: Intuitive, organized, and tailored for both professionals and novices.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered CACI data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for CACI’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for CACI International Inc (CACI)?
- Accuracy: Utilizes actual CACI financial data to ensure precise calculations.
- Flexibility: Tailored for users to easily test and adjust inputs as needed.
- Time-Saving: Avoid the complexities of creating a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and precision expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling CACI International Inc (CACI) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for CACI International Inc (CACI).
- Consultants: Deliver professional valuation insights on CACI International Inc (CACI) to clients quickly and accurately.
- Business Owners: Understand how companies like CACI International Inc (CACI) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to CACI International Inc (CACI).
What the Template Contains
- Historical Data: Includes CACI’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate CACI’s 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 CACI’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.