Cass Information Systems, Inc. (CASS) 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
Cass Information Systems, Inc. (CASS) Bundle
Whether you’re an investor or analyst, this (CASS) DCF Calculator is your go-to tool for accurate valuation. Loaded with real data from Cass Information Systems, Inc., you can adjust forecasts and instantly see the effects.
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 | 157.2 | 145.0 | 154.0 | 183.8 | 213.2 | 231.2 | 250.8 | 272.0 | 294.9 | 319.8 |
Revenue Growth, % | 0 | -7.81 | 6.25 | 19.35 | 15.99 | 8.45 | 8.45 | 8.45 | 8.45 | 8.45 |
EBITDA | .0 | 41.6 | .0 | .0 | 58.6 | 26.0 | 28.2 | 30.6 | 33.1 | 35.9 |
EBITDA, % | 0 | 28.71 | 0 | 0 | 27.48 | 11.24 | 11.24 | 11.24 | 11.24 | 11.24 |
Depreciation | 125.2 | 117.8 | 121.4 | 144.4 | 5.0 | 148.3 | 160.8 | 174.4 | 189.1 | 205.1 |
Depreciation, % | 79.63 | 81.26 | 78.8 | 78.56 | 2.33 | 64.12 | 64.12 | 64.12 | 64.12 | 64.12 |
EBIT | -125.2 | -76.2 | -121.4 | -144.4 | 53.6 | -122.3 | -132.6 | -143.8 | -156.0 | -169.1 |
EBIT, % | -79.63 | -52.55 | -78.8 | -78.56 | 25.15 | -52.88 | -52.88 | -52.88 | -52.88 | -52.88 |
Total Cash | 613.2 | 782.5 | 1,188.4 | 955.4 | 372.5 | 231.2 | 250.8 | 272.0 | 294.9 | 319.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | 5.0 | 95.8 | 110.7 | 49.6 | 53.8 | 58.3 | 63.3 | 68.6 |
Account Receivables, % | 0 | 0 | 3.24 | 52.1 | 51.89 | 21.45 | 21.45 | 21.45 | 21.45 | 21.45 |
Inventories | -558.1 | -209.2 | 514.9 | 296.7 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | -354.96 | -144.32 | 334.33 | 161.41 | 0 | 0 | 0 | 0 | 0 | 0 |
Accounts Payable | 684.3 | 835.4 | 1,050.4 | 1,067.6 | 1,071.4 | 231.2 | 250.8 | 272.0 | 294.9 | 319.8 |
Accounts Payable, % | 435.21 | 576.3 | 682 | 580.77 | 502.45 | 100 | 100 | 100 | 100 | 100 |
Capital Expenditure | -2.7 | -2.0 | -4.4 | -5.9 | -14.3 | -7.3 | -8.0 | -8.6 | -9.4 | -10.1 |
Capital Expenditure, % | -1.73 | -1.38 | -2.84 | -3.19 | -6.72 | -3.17 | -3.17 | -3.17 | -3.17 | -3.17 |
Tax Rate, % | 19.53 | 19.53 | 19.53 | 19.53 | 19.53 | 19.53 | 19.53 | 19.53 | 19.53 | 19.53 |
EBITAT | -101.6 | -63.2 | -102.6 | -117.5 | 43.1 | -100.4 | -108.9 | -118.1 | -128.0 | -138.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 1,263.3 | -145.3 | -499.8 | 165.7 | 319.4 | -738.5 | 59.3 | 64.3 | 69.7 | 75.6 |
WACC, % | 9.99 | 10.04 | 10.08 | 9.99 | 9.97 | 10.01 | 10.01 | 10.01 | 10.01 | 10.01 |
PV UFCF | ||||||||||
SUM PV UFCF | -479.5 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 77 | |||||||||
Terminal Value | 963 | |||||||||
Present Terminal Value | 598 | |||||||||
Enterprise Value | 118 | |||||||||
Net Debt | -12 | |||||||||
Equity Value | 130 | |||||||||
Diluted Shares Outstanding, MM | 14 | |||||||||
Equity Value Per Share | 9.44 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real CASS financials.
- Real-World Data: Historical data and forward-looking estimates (as highlighted in the yellow cells).
- Forecast Flexibility: Modify forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effects of your inputs on Cass Information Systems’ 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
- Pre-Loaded Data: Cass Information Systems' historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Instant Results: View CASS's intrinsic value recalculated in real time.
- Clear Visual Outputs: Dashboard charts present valuation results and essential metrics.
- Built for Accuracy: A professional tool designed for analysts, investors, and finance experts.
How It Works
- Step 1: Download the prebuilt Excel template featuring Cass Information Systems, Inc.'s (CASS) data.
- Step 2: Review the pre-filled sheets and familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalibrated results, including Cass Information Systems, Inc.'s (CASS) intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose This Calculator for Cass Information Systems, Inc. (CASS)?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for CASS.
- Flexible Inputs: Modify the yellow-highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Cass Information Systems' intrinsic value and Net Present Value.
- Preloaded Information: Access to historical and projected data for accurate analysis.
- High-Quality Standards: Designed for financial analysts, investors, and business consultants focused on CASS.
Who Should Use This Product?
- Investors: Accurately assess the fair value of Cass Information Systems, Inc. (CASS) prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis.
- Consultants: Easily customize the template for valuation reports tailored to clients' needs.
- Entrepreneurs: Acquire knowledge on financial modeling practices employed by leading firms.
- Educators: Implement it as a resource for teaching valuation techniques and methodologies.
What the Template Contains
- Preloaded CASS 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.