Wintrust Financial Corporation (WTFC) DCF Valuation

Wintrust Financial Corporation (WTFC) 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

Wintrust Financial Corporation (WTFC) 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:

Evaluate Wintrust Financial Corporation's (WTFC) financial outlook like an expert! This (WTFC) DCF Calculator provides you with pre-filled financial data and the flexibility to customize revenue growth, WACC, margins, and other essential assumptions to align with your predictions.


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,459.2 1,641.0 1,707.6 1,956.0 2,156.4 2,379.1 2,624.8 2,895.9 3,195.0 3,525.0
Revenue Growth, % 0 12.46 4.06 14.55 10.24 10.33 10.33 10.33 10.33 10.33
EBITDA 568.5 486.2 697.1 .0 .0 520.6 574.3 633.7 699.1 771.3
EBITDA, % 38.96 29.63 40.82 0 0 21.88 21.88 21.88 21.88 21.88
Depreciation 88.4 95.3 102.6 97.2 84.8 127.4 140.6 155.1 171.1 188.8
Depreciation, % 6.06 5.81 6.01 4.97 3.93 5.36 5.36 5.36 5.36 5.36
EBIT 480.1 390.8 594.5 -97.2 -84.8 393.2 433.8 478.6 528.0 582.5
EBIT, % 32.9 23.82 34.81 -4.97 -3.93 16.53 16.53 16.53 16.53 16.53
Total Cash 5,556.9 8,180.8 8,111.5 5,722.6 3,926.3 2,379.1 2,624.8 2,895.9 3,195.0 3,525.0
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 1,077.7 1,368.9 2,564.3 938.1 .0
Account Receivables, % 73.86 83.42 150.17 47.96 0
Inventories -2,786.9 -5,432.0 -6,632.6 .0 .0 -1,427.5 -1,574.9 -1,737.5 -1,917.0 -2,115.0
Inventories, % -190.99 -331.02 -388.42 0 0 -60 -60 -60 -60 -60
Accounts Payable 1,039.5 200.9 1,122.2 1,646.6 1,799.9 1,507.6 1,663.3 1,835.1 2,024.7 2,233.8
Accounts Payable, % 71.24 12.24 65.72 84.18 83.47 63.37 63.37 63.37 63.37 63.37
Capital Expenditure -82.0 -63.6 -57.1 -53.4 -46.4 -84.3 -93.1 -102.7 -113.3 -125.0
Capital Expenditure, % -5.62 -3.88 -3.34 -2.73 -2.15 -3.55 -3.55 -3.55 -3.55 -3.55
Tax Rate, % 26.32 26.32 26.32 26.32 26.32 26.32 26.32 26.32 26.32 26.32
EBITAT 355.7 293.8 434.5 -70.7 -62.5 290.0 319.9 353.0 389.4 429.7
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 3,110.8 1,840.8 1,406.5 -4,508.9 1,067.3 15.8 520.6 574.3 633.7 699.1
WACC, % 13.57 13.67 13.47 13.44 13.53 13.53 13.53 13.53 13.53 13.53
PV UFCF
SUM PV UFCF 1,562.2
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 713
Terminal Value 6,182
Present Terminal Value 3,277
Enterprise Value 4,839
Net Debt 1,142
Equity Value 3,697
Diluted Shares Outstanding, MM 62
Equity Value Per Share 59.55

What You Will Get

  • Editable Forecast Inputs: Easily adjust assumptions (growth %, margins, WACC) to explore various scenarios.
  • Real-World Data: Wintrust Financial Corporation’s (WTFC) financial data pre-filled to accelerate your analysis.
  • Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value effortlessly.
  • Customizable and Professional: A sleek Excel model that tailors to your valuation requirements.
  • Built for Analysts and Investors: Perfect for testing projections, validating strategies, and enhancing efficiency.

Key Features

  • Customizable Financial Inputs: Adjust essential metrics such as loan growth, net interest margin, and operating expenses.
  • Instant DCF Calculations: Provides quick assessments of intrinsic value, NPV, and additional financial metrics.
  • High-Precision Valuations: Leverages Wintrust’s actual financial data for accurate valuation results.
  • Streamlined Scenario Analysis: Easily explore various scenarios and evaluate their impacts side by side.
  • Efficiency Booster: Avoid the hassle of constructing intricate valuation models from the ground up.

How It Works

  • 1. Access the Template: Download and open the Excel file containing Wintrust Financial Corporation’s (WTFC) preloaded data.
  • 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
  • 3. Instant Results: The DCF model automatically calculates intrinsic value and NPV in real-time.
  • 4. Explore Scenarios: Evaluate various forecasts to assess different valuation outcomes.
  • 5. Present with Assurance: Deliver professional valuation insights to back your financial decisions.

Why Choose Wintrust Financial Corporation (WTFC)?

  • Save Time: Quickly access comprehensive financial solutions without the hassle of starting from scratch.
  • Enhance Precision: Our reliable data and methodologies minimize errors in your financial assessments.
  • Completely Customizable: Adjust our services to meet your specific financial goals and projections.
  • User-Friendly Interface: Intuitive tools and visualizations simplify the analysis of your financial results.
  • Trusted by Professionals: Endorsed by industry experts who prioritize accuracy and efficiency.

Who Should Use Wintrust Financial Corporation (WTFC)?

  • Professional Investors: Develop comprehensive and accurate valuation models for investment analysis.
  • Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decision-making.
  • Consultants and Advisors: Deliver precise valuation insights for Wintrust Financial Corporation (WTFC) to clients.
  • Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
  • Banking Enthusiasts: Gain insights into how financial institutions like Wintrust Financial Corporation (WTFC) are valued in the market.

What the Template Contains

  • Comprehensive DCF Model: Editable template featuring detailed valuation calculations.
  • Real-World Data: Wintrust Financial Corporation’s (WTFC) historical and projected financials preloaded for analysis.
  • Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore different scenarios.
  • Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
  • Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
  • Dashboard with Visual Outputs: Charts and tables for clear, actionable insights.

No products were found matching.