The Cato Corporation (CATO) 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
The Cato Corporation (CATO) Bundle
Explore The Cato Corporation's (CATO) financial future with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate The Cato Corporation's (CATO) intrinsic value and inform your investment decisions.
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 | 825.3 | 575.1 | 769.3 | 759.3 | 708.1 | 699.9 | 691.9 | 683.9 | 676.0 | 668.3 |
| Revenue Growth, % | 0 | -30.32 | 33.76 | -1.3 | -6.74 | -1.15 | -1.15 | -1.15 | -1.15 | -1.15 |
| EBITDA | 53.1 | -57.9 | 49.3 | 12.9 | -3.9 | 5.5 | 5.4 | 5.4 | 5.3 | 5.2 |
| EBITDA, % | 6.44 | -10.07 | 6.4 | 1.7 | -0.5501 | 0.78378 | 0.78378 | 0.78378 | 0.78378 | 0.78378 |
| Depreciation | 15.5 | 14.7 | 12.4 | 11.1 | 9.9 | 12.4 | 12.3 | 12.2 | 12.0 | 11.9 |
| Depreciation, % | 1.88 | 2.55 | 1.61 | 1.46 | 1.39 | 1.78 | 1.78 | 1.78 | 1.78 | 1.78 |
| EBIT | 37.6 | -72.6 | 36.9 | 1.9 | -13.8 | -7.0 | -6.9 | -6.8 | -6.7 | -6.6 |
| EBIT, % | 4.56 | -12.63 | 4.8 | 0.24458 | -1.94 | -0.99393 | -0.99393 | -0.99393 | -0.99393 | -0.99393 |
| Total Cash | 212.2 | 143.9 | 165.8 | 128.7 | 103.0 | 145.3 | 143.6 | 141.9 | 140.3 | 138.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 26.1 | 52.7 | 55.8 | 26.5 | 29.8 | 38.2 | 37.7 | 37.3 | 36.9 | 36.5 |
| Account Receivables, % | 3.16 | 9.17 | 7.26 | 3.49 | 4.2 | 5.46 | 5.46 | 5.46 | 5.46 | 5.46 |
| Inventories | 115.4 | 84.1 | 124.9 | 112.1 | 98.6 | 102.9 | 101.7 | 100.6 | 99.4 | 98.3 |
| Inventories, % | 13.98 | 14.63 | 16.24 | 14.76 | 13.93 | 14.71 | 14.71 | 14.71 | 14.71 | 14.71 |
| Accounts Payable | 68.4 | 73.8 | 109.5 | 92.0 | 87.8 | 83.8 | 82.8 | 81.9 | 81.0 | 80.0 |
| Accounts Payable, % | 8.29 | 12.83 | 14.24 | 12.11 | 12.4 | 11.97 | 11.97 | 11.97 | 11.97 | 11.97 |
| Capital Expenditure | -8.3 | -14.0 | -4.1 | -19.4 | -12.5 | -11.6 | -11.5 | -11.3 | -11.2 | -11.1 |
| Capital Expenditure, % | -1.01 | -2.43 | -0.53362 | -2.56 | -1.77 | -1.66 | -1.66 | -1.66 | -1.66 | -1.66 |
| Tax Rate, % | -73.47 | -73.47 | -73.47 | -73.47 | -73.47 | -73.47 | -73.47 | -73.47 | -73.47 | -73.47 |
| EBITAT | 31.3 | -47.4 | 34.9 | .0 | -23.9 | -4.8 | -4.7 | -4.7 | -4.6 | -4.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -34.6 | -36.7 | 35.1 | 16.3 | -20.5 | -20.7 | -3.3 | -3.2 | -3.2 | -3.1 |
| WACC, % | 5.69 | 5.16 | 6.03 | 3.27 | 6.19 | 5.27 | 5.27 | 5.27 | 5.27 | 5.27 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -30.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -3 | |||||||||
| Terminal Value | -98 | |||||||||
| Present Terminal Value | -76 | |||||||||
| Enterprise Value | -106 | |||||||||
| Net Debt | 129 | |||||||||
| Equity Value | -236 | |||||||||
| Diluted Shares Outstanding, MM | 19 | |||||||||
| Equity Value Per Share | -12.15 |
What You Will Receive
- Genuine CATO Financial Data: Pre-loaded with The Cato Corporation’s historical and projected metrics for thorough analysis.
- Completely Customizable Template: Easily adjust key parameters such as revenue growth, WACC, and EBITDA %.
- Instant Calculations: Watch the intrinsic value of CATO update in real-time as you make changes.
- Expert Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF outcomes.
- Intuitive Design: Straightforward layout and clear guidance suitable for all skill levels.
Key Features
- Real-Life CATO Data: Pre-filled with The Cato Corporation’s historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
- User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.
How It Works
- Download the Template: Gain immediate access to the Excel-based CATO DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Cato’s intrinsic value.
- Test Scenarios: Experiment with different assumptions to see how valuations might change.
- Analyze and Decide: Utilize the results to inform your investment or financial strategies.
Why Choose This Calculator for The Cato Corporation (CATO)?
- Accurate Data: Utilize real financials from The Cato Corporation for dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of building from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants focused on The Cato Corporation.
- User-Friendly: Easy-to-navigate design and clear instructions make it accessible for all users.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for assessing Cato Corporation (CATO) in their portfolios.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Cato Corporation (CATO) stock.
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling focused on Cato Corporation (CATO).
- Retail Investors: Gain insights into how retail companies like Cato Corporation (CATO) are valued in the marketplace.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled The Cato Corporation (CATO) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for The Cato Corporation (CATO).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.