Cullen/Frost Bankers, Inc. (CFR) 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
Cullen/Frost Bankers, Inc. (CFR) Bundle
Streamline your analysis and improve precision with our (CFR) DCF Calculator! Utilizing real data from Cullen/Frost Bankers, Inc. and customizable assumptions, this tool enables you to forecast, analyze, and assess (CFR) just like a seasoned investor.
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 | 1,367.9 | 1,441.5 | 1,371.6 | 220.4 | 1,941.0 | 2,021.6 | 2,105.5 | 2,192.8 | 2,283.8 | 2,378.6 |
| Revenue Growth, % | 0 | 5.38 | -4.85 | -83.93 | 780.77 | 4.15 | 4.15 | 4.15 | 4.15 | 4.15 |
| EBITDA | 553.6 | 415.7 | 558.8 | 740.2 | .0 | 849.3 | 884.5 | 921.2 | 959.4 | 999.2 |
| EBITDA, % | 40.47 | 28.84 | 40.74 | 335.86 | 0 | 42.01 | 42.01 | 42.01 | 42.01 | 42.01 |
| Depreciation | 69.8 | 83.6 | 88.6 | 91.2 | .0 | 237.4 | 247.3 | 257.6 | 268.2 | 279.4 |
| Depreciation, % | 5.1 | 5.8 | 6.46 | 41.37 | 0 | 11.75 | 11.75 | 11.75 | 11.75 | 11.75 |
| EBIT | 483.8 | 332.1 | 470.2 | 649.0 | .0 | 779.1 | 811.4 | 845.1 | 880.1 | 916.7 |
| EBIT, % | 35.37 | 23.04 | 34.28 | 294.49 | 0 | 38.54 | 38.54 | 38.54 | 38.54 | 38.54 |
| Total Cash | 14,701.4 | 20,725.6 | 30,465.7 | 18,935.2 | 17,195.9 | 2,021.6 | 2,105.5 | 2,192.8 | 2,283.8 | 2,378.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Inventories | -3,997.4 | -10,495.6 | -16,790.7 | -12,300.8 | .0 | -1,617.3 | -1,684.4 | -1,754.3 | -1,827.1 | -1,902.9 |
| Inventories, % | -292.23 | -728.12 | -1224.17 | -5581.64 | 0 | -80 | -80 | -80 | -80 | -80 |
| Accounts Payable | 545.7 | 730.2 | 754.3 | 866.3 | .0 | 992.8 | 1,034.0 | 1,076.9 | 1,121.5 | 1,168.1 |
| Accounts Payable, % | 39.89 | 50.65 | 55 | 393.07 | 0 | 49.11 | 49.11 | 49.11 | 49.11 | 49.11 |
| Capital Expenditure | -206.7 | -95.4 | -65.9 | -102.5 | -158.6 | -328.4 | -342.0 | -356.2 | -371.0 | -386.4 |
| Capital Expenditure, % | -15.11 | -6.62 | -4.8 | -46.51 | -8.17 | -16.24 | -16.24 | -16.24 | -16.24 | -16.24 |
| Tax Rate, % | 16.06 | 16.06 | 16.06 | 16.06 | 16.06 | 16.06 | 16.06 | 16.06 | 16.06 | 16.06 |
| EBITAT | 429.7 | 313.0 | 425.6 | 562.0 | .0 | 692.0 | 720.7 | 750.6 | 781.8 | 814.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 4,835.8 | 6,983.9 | 6,767.6 | -3,827.3 | -13,325.7 | 3,211.1 | 734.3 | 764.8 | 796.5 | 829.6 |
| WACC, % | 15.37 | 15.77 | 15.49 | 15.21 | 15.01 | 15.37 | 15.37 | 15.37 | 15.37 | 15.37 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 4,688.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 846 | |||||||||
| Terminal Value | 6,329 | |||||||||
| Present Terminal Value | 3,096 | |||||||||
| Enterprise Value | 7,785 | |||||||||
| Net Debt | -8,380 | |||||||||
| Equity Value | 16,165 | |||||||||
| Diluted Shares Outstanding, MM | 64 | |||||||||
| Equity Value Per Share | 250.98 |
What You Will Receive
- Comprehensive Financial Model: Utilizes Cullen/Frost Bankers, Inc.'s (CFR) actual data for accurate DCF valuation.
- Complete Forecast Flexibility: Modify key metrics such as revenue growth, profit margins, WACC, and more.
- Real-Time Calculations: Automatic updates provide immediate feedback as you adjust inputs.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Adaptable and Reusable: Designed for versatility, enabling repeated application for in-depth financial forecasts.
Key Features
- Comprehensive Financial Models: Offers detailed unlevered and levered DCF valuation frameworks tailored for Cullen/Frost Bankers, Inc. (CFR).
- WACC Calculation Tool: Features a pre-configured Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Inputs: Easily update growth projections, capital outlays, and discount rates.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency metrics specific to Cullen/Frost Bankers, Inc. (CFR).
- Interactive Dashboard and Visuals: Graphical representations highlight essential valuation indicators for straightforward analysis.
How It Works
- Download the Template: Gain immediate access to the Excel-based CFR DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates Cullen/Frost Bankers, Inc.'s intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation variations.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis.
Why Choose This Calculator for Cullen/Frost Bankers, Inc. (CFR)?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored specifically for CFR.
- Flexible Inputs: Modify the highlighted fields to explore different financial scenarios for Cullen/Frost.
- In-Depth Analysis: Automatically computes the intrinsic value and Net Present Value for Cullen/Frost Bankers, Inc.
- Preloaded Information: Access to historical and projected data for accurate financial assessments.
- High-Quality Standards: Designed for use by financial analysts, investors, and consultants focusing on CFR.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Cullen/Frost Bankers, Inc. (CFR) stock.
- Financial Analysts: Enhance valuation processes with ready-to-use financial models specific to Cullen/Frost Bankers, Inc. (CFR).
- Consultants: Provide clients with professional valuation insights on Cullen/Frost Bankers, Inc. (CFR) quickly and accurately.
- Business Owners: Gain insights into how banks like Cullen/Frost Bankers, Inc. (CFR) are valued to inform your own business strategies.
- Finance Students: Master valuation techniques using real-world data and scenarios related to Cullen/Frost Bankers, Inc. (CFR).
What the Template Contains
- Pre-Filled DCF Model: Cullen/Frost Bankers, Inc.’s (CFR) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital specific to Cullen/Frost Bankers, Inc. (CFR).
- Financial Ratios: Assess Cullen/Frost Bankers, Inc.’s (CFR) profitability, leverage, and efficiency metrics.
- Editable Inputs: Adjust assumptions like growth rates, profit margins, and CAPEX to suit your analysis.
- Financial Statements: Access annual and quarterly reports for comprehensive evaluation.
- Interactive Dashboard: Visualize key valuation metrics and outcomes with ease.