Central Pacific Financial Corp. (CPF) DCF Valuation

Central Pacific Financial Corp. (CPF) 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

Central Pacific Financial Corp. (CPF) 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:

Gain insight into your Central Pacific Financial Corp. (CPF) valuation analysis with our state-of-the-art DCF Calculator! Preloaded with up-to-date CPF data, this Excel template enables you to adjust forecasts and assumptions, allowing for a precise calculation of Central Pacific Financial Corp.'s intrinsic value.


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 221.8 238.5 254.1 263.5 241.0 246.5 252.2 258.0 264.0 270.1
Revenue Growth, % 0 7.53 6.56 3.69 -8.55 2.31 2.31 2.31 2.31 2.31
EBITDA 41.8 45.2 43.1 47.9 .0 36.0 36.8 37.6 38.5 39.4
EBITDA, % 18.85 18.95 16.95 18.19 0 14.59 14.59 14.59 14.59 14.59
Depreciation 6.1 6.2 7.0 6.9 7.6 6.9 7.0 7.2 7.3 7.5
Depreciation, % 2.77 2.61 2.75 2.61 3.17 2.78 2.78 2.78 2.78 2.78
EBIT 35.7 39.0 36.1 41.1 -7.6 29.1 29.8 30.5 31.2 31.9
EBIT, % 16.08 16.34 14.2 15.58 -3.17 11.81 11.81 11.81 11.81 11.81
Total Cash 1,230.0 1,286.7 1,960.6 783.8 763.4 246.5 252.2 258.0 264.0 270.1
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables .0 .0 .0 .0 21.5
Account Receivables, % 0 0 0 0 8.93
Inventories -119.6 -124.3 -345.6 -132.4 .0 -126.4 -129.3 -132.3 -135.3 -138.4
Inventories, % -53.95 -52.12 -136.01 -50.25 0 -51.26 -51.26 -51.26 -51.26 -51.26
Accounts Payable .0 .0 .0 4.7 18.9 4.8 4.9 5.0 5.1 5.2
Accounts Payable, % 0 0 0 1.8 7.86 1.93 1.93 1.93 1.93 1.93
Capital Expenditure -7.2 -26.0 -22.2 -18.4 -12.7 -17.3 -17.7 -18.1 -18.5 -19.0
Capital Expenditure, % -3.25 -10.9 -8.72 -7 -5.25 -7.02 -7.02 -7.02 -7.02 -7.02
Tax Rate, % 23.63 23.63 23.63 23.63 23.63 23.63 23.63 23.63 23.63 23.63
EBITAT 26.7 29.6 27.3 30.7 -5.8 22.0 22.5 23.0 23.5 24.1
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 145.3 14.5 233.4 -189.3 -150.5 140.8 14.7 15.1 15.4 15.8
WACC, % 13.49 13.58 13.55 13.49 13.6 13.54 13.54 13.54 13.54 13.54
PV UFCF
SUM PV UFCF 163.3
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 16
Terminal Value 139
Present Terminal Value 74
Enterprise Value 237
Net Debt -336
Equity Value 573
Diluted Shares Outstanding, MM 27
Equity Value Per Share 21.15

What You Will Get

  • Real CPF Financials: Access to historical and projected data for precise valuation.
  • Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
  • Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
  • Scenario Analysis: Explore various scenarios to assess Central Pacific Financial Corp.'s future performance.
  • User-Friendly Interface: Designed for professionals while remaining approachable for newcomers.

Key Features

  • Pre-Loaded Data: Central Pacific Financial Corp.'s (CPF) historical financial statements and pre-filled forecasts.
  • Fully Adjustable Inputs: Customize WACC, tax rates, revenue growth, and EBITDA margins.
  • Instant Results: View Central Pacific Financial Corp.'s (CPF) intrinsic value recalculating in real time.
  • Clear Visual Outputs: Dashboard charts illustrate valuation results and key metrics.
  • Built for Accuracy: A professional tool tailored for analysts, investors, and finance experts.

How It Works

  • Step 1: Download the prebuilt Excel template featuring Central Pacific Financial Corp.'s (CPF) 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 observe the recalculated results, including Central Pacific Financial Corp.'s (CPF) intrinsic value.
  • Step 5: Make well-informed investment decisions or create reports based on the outputs.

Why Choose This Calculator for Central Pacific Financial Corp. (CPF)?

  • Accurate Data: Utilize real Central Pacific Financial Corp. (CPF) financials for dependable valuation outcomes.
  • Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
  • Time-Saving: Built-in calculations save you from starting from the ground up.
  • Professional-Grade Tool: Crafted for investors, analysts, and financial consultants.
  • User-Friendly: Clear layout and guided instructions ensure accessibility for all users.

Who Should Use This Product?

  • Investors: Assess Central Pacific Financial Corp.'s (CPF) valuation before making investment decisions.
  • CFOs and Financial Analysts: Optimize valuation methods and evaluate financial forecasts.
  • Startup Founders: Understand the valuation processes of established financial institutions like Central Pacific Financial Corp. (CPF).
  • Consultants: Create comprehensive valuation reports for your clients based on Central Pacific Financial Corp. (CPF).
  • Students and Educators: Utilize real-time data from Central Pacific Financial Corp. (CPF) to learn and teach valuation strategies.

What the Template Contains

  • Operating and Balance Sheet Data: Pre-filled Central Pacific Financial Corp. (CPF) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
  • WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
  • DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
  • Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
  • Key Ratios: Includes profitability, leverage, and efficiency ratios for Central Pacific Financial Corp. (CPF).
  • Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.

No products were found matching.