CBIZ, Inc. (CBZ) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
CBIZ, Inc. (CBZ) Bundle
Explore CBIZ, Inc.'s (CBZ) financial prospects with our user-friendly DCF Calculator! Enter your assumptions about growth, margins, and expenses to calculate CBIZ, Inc.'s (CBZ) intrinsic value and enhance your investment strategy.
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 | 948.4 | 963.9 | 1,104.9 | 1,412.0 | 1,591.2 | 1,816.9 | 2,074.7 | 2,369.0 | 2,705.1 | 3,088.8 |
Revenue Growth, % | 0 | 1.63 | 14.63 | 27.79 | 12.69 | 14.19 | 14.19 | 14.19 | 14.19 | 14.19 |
EBITDA | 102.9 | 115.6 | 122.8 | 211.1 | 227.0 | 229.6 | 262.1 | 299.3 | 341.8 | 390.3 |
EBITDA, % | 10.85 | 11.99 | 11.12 | 14.95 | 14.27 | 12.64 | 12.64 | 12.64 | 12.64 | 12.64 |
Depreciation | 22.3 | 23.1 | 27.1 | 32.9 | 36.3 | 42.9 | 49.0 | 56.0 | 63.9 | 73.0 |
Depreciation, % | 2.36 | 2.4 | 2.45 | 2.33 | 2.28 | 2.36 | 2.36 | 2.36 | 2.36 | 2.36 |
EBIT | 80.5 | 92.5 | 95.8 | 178.2 | 190.7 | 186.6 | 213.1 | 243.3 | 277.9 | 317.3 |
EBIT, % | 8.49 | 9.59 | 8.67 | 12.62 | 11.99 | 10.27 | 10.27 | 10.27 | 10.27 | 10.27 |
Total Cash | .6 | 4.7 | 2.0 | 4.7 | 8.1 | 5.7 | 6.5 | 7.4 | 8.5 | 9.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 222.0 | 216.2 | 242.2 | 334.5 | 380.2 | 419.1 | 478.6 | 546.5 | 624.0 | 712.5 |
Account Receivables, % | 23.41 | 22.43 | 21.92 | 23.69 | 23.89 | 23.07 | 23.07 | 23.07 | 23.07 | 23.07 |
Inventories | 209.1 | 191.4 | 188.3 | 199.8 | .0 | 265.6 | 303.3 | 346.3 | 395.4 | 451.5 |
Inventories, % | 22.05 | 19.86 | 17.04 | 14.15 | 0 | 14.62 | 14.62 | 14.62 | 14.62 | 14.62 |
Accounts Payable | 68.5 | 64.1 | 65.8 | 80.7 | 82.8 | 111.7 | 127.6 | 145.7 | 166.4 | 190.0 |
Accounts Payable, % | 7.22 | 6.65 | 5.95 | 5.72 | 5.21 | 6.15 | 6.15 | 6.15 | 6.15 | 6.15 |
Capital Expenditure | -13.9 | -11.6 | -9.0 | -8.6 | -23.1 | -20.1 | -23.0 | -26.2 | -30.0 | -34.2 |
Capital Expenditure, % | -1.46 | -1.2 | -0.81309 | -0.61198 | -1.45 | -1.11 | -1.11 | -1.11 | -1.11 | -1.11 |
Tax Rate, % | 27.26 | 27.26 | 27.26 | 27.26 | 27.26 | 27.26 | 27.26 | 27.26 | 27.26 | 27.26 |
EBITAT | 61.3 | 70.0 | 73.0 | 132.7 | 138.7 | 140.0 | 159.9 | 182.6 | 208.5 | 238.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -292.8 | 100.7 | 69.8 | 68.1 | 308.2 | -112.8 | 104.7 | 119.5 | 136.5 | 155.8 |
WACC, % | 8.1 | 8.1 | 8.1 | 8.1 | 8.09 | 8.1 | 8.1 | 8.1 | 8.1 | 8.1 |
PV UFCF | ||||||||||
SUM PV UFCF | 285.4 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 161 | |||||||||
Terminal Value | 3,148 | |||||||||
Present Terminal Value | 2,133 | |||||||||
Enterprise Value | 2,418 | |||||||||
Net Debt | 543 | |||||||||
Equity Value | 1,875 | |||||||||
Diluted Shares Outstanding, MM | 51 | |||||||||
Equity Value Per Share | 37.09 |
What You Will Get
- Real CBIZ Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for CBIZ, Inc. (CBZ).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to CBIZ, Inc. (CBZ).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on CBIZ, Inc. (CBZ)’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for CBIZ, Inc. (CBZ).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for CBIZ, Inc. (CBZ).
Key Features
- 🔍 Real-Life CBZ Financials: Pre-filled historical and projected data for CBIZ, Inc. (CBZ).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate CBIZ’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize CBIZ’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file for CBIZ, Inc. (CBZ).
- Step 2: Examine the pre-filled financial data and forecasts for CBIZ, Inc. (CBZ).
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells) for CBIZ, Inc. (CBZ).
- Step 4: Observe the DCF model update in real-time as you modify your assumptions for CBIZ, Inc. (CBZ).
- Step 5: Evaluate the outputs and leverage the results for your investment strategies regarding CBIZ, Inc. (CBZ).
Why Choose CBIZ, Inc. (CBZ) Calculator?
- Accuracy: Reliable CBIZ financials guarantee precise data.
- Flexibility: Tailored for users to easily adjust and test various inputs.
- Time-Saving: Avoid the complexities of constructing a financial model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected by CFOs.
- User-Friendly: Intuitive design makes it accessible for those lacking advanced financial modeling skills.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling CBIZ, Inc. (CBZ) stock.
- Financial Analysts: Enhance valuation processes with ready-to-use financial models for CBIZ, Inc. (CBZ).
- Consultants: Provide professional valuation insights for CBIZ, Inc. (CBZ) to clients efficiently and accurately.
- Business Owners: Gain insights into how companies like CBIZ, Inc. (CBZ) are valued to inform your own business strategy.
- Finance Students: Master valuation techniques using real-world data and scenarios related to CBIZ, Inc. (CBZ).
What the Template Contains
- Preloaded CBZ 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.