East West Bancorp, Inc. (EWBC) DCF Valuation

East West Bancorp, Inc. (EWBC) 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

East West Bancorp, Inc. (EWBC) 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:

Make more informed investment choices with the (EWBC) DCF Calculator! Explore real financial data for East West Bancorp, Inc., adjust growth projections and expenses, and instantly observe how these changes affect the intrinsic value of (EWBC).


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,662.9 1,599.2 1,801.3 2,319.0 2,362.2 2,595.0 2,850.6 3,131.5 3,440.0 3,779.0
Revenue Growth, % 0 -3.83 12.64 28.74 1.86 9.85 9.85 9.85 9.85 9.85
EBITDA 988.1 805.7 1,213.2 1,571.5 1,623.2 1,627.7 1,788.1 1,964.3 2,157.8 2,370.4
EBITDA, % 59.42 50.38 67.35 67.77 68.72 62.73 62.73 62.73 62.73 62.73
Depreciation 144.2 119.9 156.8 159.9 163.5 200.8 220.6 242.3 266.2 292.4
Depreciation, % 8.67 7.5 8.7 6.89 6.92 7.74 7.74 7.74 7.74 7.74
EBIT 843.9 685.8 1,056.4 1,411.7 1,459.8 1,426.9 1,567.5 1,722.0 1,891.6 2,078.0
EBIT, % 50.75 42.88 58.64 60.87 61.8 54.99 54.99 54.99 54.99 54.99
Total Cash 6,774.5 10,372.4 14,614.8 9,655.8 4,615.0 2,595.0 2,850.6 3,131.5 3,440.0 3,779.0
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 .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Inventories, % 0 0 0 0 0 0 0 0 0 0
Accounts Payable .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Accounts Payable, % 0 0 0 0 0 0 0 0 0 0
Capital Expenditure -9.9 -2.7 -6.0 -.7 .0 -5.8 -6.4 -7.0 -7.7 -8.5
Capital Expenditure, % -0.59288 -0.16608 -0.33403 -0.03165104 0 -0.22493 -0.22493 -0.22493 -0.22493 -0.22493
Tax Rate, % 20.46 20.46 20.46 20.46 20.46 20.46 20.46 20.46 20.46 20.46
EBITAT 674.0 567.8 873.0 1,128.1 1,161.2 1,155.1 1,269.0 1,394.0 1,531.3 1,682.2
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 808.4 685.0 1,023.8 1,287.2 1,324.6 1,350.1 1,483.1 1,629.2 1,789.8 1,966.1
WACC, % 13.71 13.93 13.92 13.71 13.69 13.79 13.79 13.79 13.79 13.79
PV UFCF
SUM PV UFCF 5,535.5
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 2,005
Terminal Value 17,006
Present Terminal Value 8,913
Enterprise Value 14,449
Net Debt 140
Equity Value 14,309
Diluted Shares Outstanding, MM 142
Equity Value Per Share 100.83

What You Will Get

  • Editable Forecast Inputs: Effortlessly modify assumptions (growth %, margins, WACC) to generate various scenarios.
  • Real-World Data: East West Bancorp, Inc. (EWBC)’s financial data pre-filled to kickstart your analysis.
  • Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
  • Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
  • Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.

Key Features

  • Customizable Financial Metrics: Adjust essential variables such as loan growth, net interest margin, and operating expenses.
  • Instant DCF Valuation: Quickly derives intrinsic value, NPV, and additional financial metrics.
  • High-Precision Accuracy: Incorporates East West Bancorp's actual financial data for credible valuation results.
  • Streamlined Scenario Analysis: Effortlessly evaluate various assumptions and analyze results side by side.
  • Efficiency Booster: Avoid the hassle of constructing intricate valuation models from the ground up.

How It Works

  • Step 1: Download the prebuilt Excel template featuring East West Bancorp, Inc. (EWBC) data.
  • Step 2: Navigate through the pre-filled sheets to 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 recalculated results, including East West Bancorp, Inc.’s (EWBC) intrinsic value.
  • Step 5: Utilize the outputs to make informed investment decisions or create comprehensive reports.

Why Choose This Calculator for East West Bancorp, Inc. (EWBC)?

  • Designed for Experts: A sophisticated tool utilized by financial analysts, CFOs, and consultants.
  • Accurate Financial Data: East West Bancorp’s historical and projected financials are preloaded for precision.
  • Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
  • Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
  • User-Friendly: Step-by-step guidance ensures a smooth calculation process.

Who Should Use This Product?

  • Investors: Evaluate East West Bancorp, Inc.'s (EWBC) performance before making investment decisions.
  • CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
  • Startup Founders: Understand the valuation processes of established financial institutions like East West Bancorp, Inc.
  • Consultants: Provide comprehensive valuation analyses and reports to clients in the banking sector.
  • Students and Educators: Utilize current financial data to enhance learning about valuation practices.

What the Template Contains

  • Pre-Filled DCF Model: East West Bancorp’s financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
  • Financial Ratios: Evaluate East West Bancorp’s profitability, leverage, and efficiency.
  • Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
  • Financial Statements: Annual and quarterly reports to support detailed analysis.
  • Interactive Dashboard: Easily visualize key valuation metrics and results.