CI&T Inc (CINT) 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
CI&T Inc (CINT) Bundle
Simplify CI&T Inc (CINT) valuation with this customizable DCF Calculator! Featuring real CI&T Inc (CINT) financials and adjustable forecast inputs, you can test scenarios and uncover CI&T Inc (CINT) fair value in minutes.
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 | 109.2 | 154.3 | 232.9 | 352.8 | 360.2 | 491.5 | 670.7 | 915.2 | 1,248.8 | 1,704.1 |
Revenue Growth, % | 0 | 41.26 | 51 | 51.46 | 2.09 | 36.45 | 36.45 | 36.45 | 36.45 | 36.45 |
EBITDA | 19.3 | 37.6 | 46.5 | 59.5 | 62.3 | 94.5 | 128.9 | 175.9 | 240.0 | 327.5 |
EBITDA, % | 17.64 | 24.36 | 19.97 | 16.85 | 17.28 | 19.22 | 19.22 | 19.22 | 19.22 | 19.22 |
Depreciation | 4.1 | 4.8 | 7.8 | 15.2 | 15.0 | 18.4 | 25.1 | 34.3 | 46.8 | 63.9 |
Depreciation, % | 3.78 | 3.12 | 3.35 | 4.32 | 4.17 | 3.75 | 3.75 | 3.75 | 3.75 | 3.75 |
EBIT | 15.1 | 32.8 | 38.7 | 44.2 | 47.2 | 76.0 | 103.8 | 141.6 | 193.2 | 263.6 |
EBIT, % | 13.86 | 21.23 | 16.62 | 12.53 | 13.11 | 15.47 | 15.47 | 15.47 | 15.47 | 15.47 |
Total Cash | 12.8 | 26.3 | 150.7 | 45.5 | 34.6 | 114.0 | 155.6 | 212.3 | 289.7 | 395.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 26.9 | 40.3 | 78.3 | 115.9 | 99.9 | 142.6 | 194.5 | 265.5 | 362.2 | 494.3 |
Account Receivables, % | 24.68 | 26.14 | 33.61 | 32.86 | 27.74 | 29.01 | 29.01 | 29.01 | 29.01 | 29.01 |
Inventories | .5 | 1.4 | .1 | 5.0 | .0 | 2.8 | 3.8 | 5.2 | 7.1 | 9.7 |
Inventories, % | 0.44053 | 0.92387 | 0.06203354 | 1.41 | 0.0000000448 | 0.56714 | 0.56714 | 0.56714 | 0.56714 | 0.56714 |
Accounts Payable | 1.4 | 2.5 | 13.3 | 5.7 | 5.7 | 11.6 | 15.8 | 21.5 | 29.4 | 40.1 |
Accounts Payable, % | 1.27 | 1.6 | 5.71 | 1.6 | 1.57 | 2.35 | 2.35 | 2.35 | 2.35 | 2.35 |
Capital Expenditure | -3.2 | -3.4 | -4.8 | -3.7 | -3.9 | -9.2 | -12.6 | -17.2 | -23.4 | -31.9 |
Capital Expenditure, % | -2.94 | -2.24 | -2.07 | -1.05 | -1.08 | -1.87 | -1.87 | -1.87 | -1.87 | -1.87 |
Tax Rate, % | 36.66 | 36.66 | 36.66 | 36.66 | 36.66 | 36.66 | 36.66 | 36.66 | 36.66 | 36.66 |
EBITAT | 10.0 | 21.7 | 23.2 | 21.1 | 29.9 | 46.1 | 62.9 | 85.8 | 117.1 | 159.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -15.1 | 9.8 | .3 | -17.4 | 62.1 | 15.8 | 26.7 | 36.4 | 49.7 | 67.8 |
WACC, % | 9.55 | 9.55 | 9.47 | 9.3 | 9.51 | 9.48 | 9.48 | 9.48 | 9.48 | 9.48 |
PV UFCF | ||||||||||
SUM PV UFCF | 142.2 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 69 | |||||||||
Terminal Value | 926 | |||||||||
Present Terminal Value | 589 | |||||||||
Enterprise Value | 731 | |||||||||
Net Debt | 90 | |||||||||
Equity Value | 640 | |||||||||
Diluted Shares Outstanding, MM | 139 | |||||||||
Equity Value Per Share | 4.60 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real CI&T Inc (CINT) financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated 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 CI&T Inc (CINT)'s 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
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation frameworks.
- WACC Estimator: Pre-configured Weighted Average Cost of Capital tool with adjustable parameters.
- Customizable Forecast Assumptions: Adjust growth projections, capital expenditures, and discount rates as needed.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for CI&T Inc (CINT).
- User-Friendly Dashboard and Charts: Visual representations highlight essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered CI&T Inc (CINT) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for CI&T Inc (CINT)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose CI&T Inc (CINT)?
- Streamlined Processes: Quickly access comprehensive solutions without starting from zero.
- Enhanced Precision: Utilize dependable data and methodologies to minimize valuation discrepancies.
- Completely Adaptable: Modify the framework to align with your unique insights and forecasts.
- Intuitive Insights: User-friendly visuals and outputs facilitate straightforward analysis of results.
- Preferred by Professionals: Crafted for experts who prioritize accuracy and ease of use.
Who Should Use This Product?
- Finance Students: Master financial modeling techniques and apply them using real-time data for CI&T Inc (CINT).
- Academics: Integrate industry-standard models into your research or teaching related to CI&T Inc (CINT).
- Investors: Validate your investment strategies and assess valuation projections for CI&T Inc (CINT).
- Analysts: Enhance your analysis with a ready-to-use, adaptable DCF model tailored for CI&T Inc (CINT).
- Small Business Owners: Understand the valuation practices used for public companies like CI&T Inc (CINT).
What the Template Contains
- Preloaded CINT Data: Historical and projected financial information, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Advanced sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for modifying revenue growth, tax rates, and discount rates.
- Financial Statements: Detailed annual and quarterly financials for in-depth analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios for performance evaluation.
- Dashboard and Charts: Visual representations of valuation results and underlying assumptions.