CVB Financial Corp. (CVBF) DCF Valuation

CVB Financial Corp. (CVBF) DCF Valuation
  • ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
  • ✓ Design Profissional: Modelos Confiáveis ​​E Padrão Da Indústria
  • ✓ Pré-Construídos Para Uso Rápido E Eficiente
  • ✓ Não É Necessária Experiência; Fácil De Seguir

CVB Financial Corp. (CVBF) 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:

Discover the true value of CVB Financial Corp. (CVBF) with our advanced DCF Calculator! Adjust essential assumptions, explore various scenarios, and examine how different factors affect CVB Financial Corp. (CVBF) valuation – all within one convenient Excel template.


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 484.4 464.2 461.9 555.5 547.3 566.7 586.7 607.4 628.9 651.1
Revenue Growth, % 0 -4.15 -0.49715 20.26 -1.47 3.53 3.53 3.53 3.53 3.53
EBITDA 313.1 .0 .0 342.0 328.5 211.1 218.5 226.2 234.2 242.5
EBITDA, % 64.65 0 0 61.57 60.02 37.25 37.25 37.25 37.25 37.25
Depreciation 22.0 16.3 14.6 14.5 18.2 19.4 20.1 20.8 21.6 22.3
Depreciation, % 4.55 3.5 3.17 2.6 3.32 3.43 3.43 3.43 3.43 3.43
EBIT 291.1 -16.3 -14.6 327.5 310.3 191.6 198.4 205.4 212.7 220.2
EBIT, % 60.1 -3.5 -3.17 58.96 56.7 33.82 33.82 33.82 33.82 33.82
Total Cash 1,928.7 4,400.6 4,942.5 3,468.2 281.3 511.6 529.6 548.4 567.7 587.8
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 53.1 45.5 45.9 81.1 .0
Account Receivables, % 10.97 9.81 9.94 14.6 0
Inventories -263.6 -2,072.9 -1,833.3 -455.1 .0 -381.2 -394.7 -408.6 -423.0 -438.0
Inventories, % -54.43 -446.51 -396.88 -81.93 0 -67.27 -67.27 -67.27 -67.27 -67.27
Accounts Payable .0 .0 .0 .4 23.3 4.9 5.1 5.3 5.4 5.6
Accounts Payable, % 0 0 0 0.07794751 4.25 0.86584 0.86584 0.86584 0.86584 0.86584
Capital Expenditure -5.5 -4.7 -4.7 -5.4 -4.5 -5.6 -5.8 -6.0 -6.2 -6.4
Capital Expenditure, % -1.14 -1.01 -1.01 -0.96471 -0.82602 -0.98993 -0.98993 -0.98993 -0.98993 -0.98993
Tax Rate, % 29.8 29.8 29.8 29.8 29.8 29.8 29.8 29.8 29.8 29.8
EBITAT 207.8 -11.5 -10.5 234.8 217.8 136.3 141.1 146.1 151.3 156.6
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 434.8 1,816.9 -240.5 -1,169.0 -119.6 461.6 167.3 173.2 179.3 185.6
WACC, % 5.53 5.52 5.53 5.54 5.5 5.52 5.52 5.52 5.52 5.52
PV UFCF
SUM PV UFCF 1,021.5
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 189
Terminal Value 5,372
Present Terminal Value 4,106
Enterprise Value 5,127
Net Debt 1,780
Equity Value 3,347
Diluted Shares Outstanding, MM 138
Equity Value Per Share 24.17

What You Will Receive

  • Pre-Filled Financial Model: CVB Financial Corp.’s (CVBF) actual data provides an accurate DCF valuation.
  • Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential metrics.
  • Real-Time Calculations: Automatic updates allow you to view results instantly as adjustments are made.
  • Professional-Grade Template: A polished Excel file crafted for high-quality valuation analysis.
  • Flexible and Reusable: Designed for adaptability, enabling repeated use for in-depth forecasts.

Key Features

  • Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for CVB Financial Corp. (CVBF).
  • WACC Calculator: Includes a pre-built Weighted Average Cost of Capital sheet with adjustable inputs specific to CVBF.
  • Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates according to CVB Financial Corp.'s (CVBF) projections.
  • Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios for CVB Financial Corp. (CVBF).
  • Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis of CVBF.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review CVB Financial Corp.'s (CVBF) pre-filled financial data and forecasts.
  3. Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
  4. Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
  5. Step 5: Analyze the outputs and leverage the results for your investment decisions.

Why Choose CVB Financial Corp. (CVBF) Calculator?

  • Accuracy: Utilizes real CVB Financial Corp. data to ensure precision.
  • Flexibility: Allows users to easily test and alter inputs as needed.
  • Time-Saving: Avoid the complexities of creating a financial model from the ground up.
  • Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
  • User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.

Who Should Use CVB Financial Corp. (CVBF)?

  • Investors: Make informed choices with a reliable resource for understanding CVBF's financial performance.
  • Financial Analysts: Streamline your analysis with comprehensive data and insights specific to CVBF.
  • Consultants: Easily tailor reports and presentations focused on CVB Financial Corp. (CVBF) for your clients.
  • Finance Enthusiasts: Enhance your knowledge of banking and finance through case studies involving CVB Financial Corp. (CVBF).
  • Educators and Students: Utilize CVBF as a practical example in finance and investment courses.

What the Template Contains

  • Historical Data: Includes CVB Financial Corp.'s (CVBF) past financials and baseline forecasts.
  • DCF and Levered DCF Models: Detailed templates to calculate CVB Financial Corp.'s (CVBF) intrinsic value.
  • WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
  • Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
  • Quarterly and Annual Statements: A complete breakdown of CVB Financial Corp.'s (CVBF) financials.
  • Interactive Dashboard: Visualize valuation results and projections dynamically.

No products were found matching.