Cullen/Frost Bankers, Inc. (CFR) DCF Valuation

Cullen/Frost Bankers, Inc. (CFR) 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

Cullen/Frost Bankers, Inc. (CFR) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 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

  1. Download the Template: Gain immediate access to the Excel-based CFR DCF Calculator.
  2. Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
  3. Instant Calculations: The model automatically recalculates Cullen/Frost Bankers, Inc.'s intrinsic value.
  4. Test Scenarios: Experiment with different assumptions to assess potential valuation variations.
  5. 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.