Chesapeake Utilities Corporation (CPK) DCF Valuation

Chesapeake Utilities Corporation (CPK) DCF Valuation
  • ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
  • ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
  • ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
  • ✓ No Se Necesita Experiencia; Fáciles De Seguir

Chesapeake Utilities Corporation (CPK) 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 Chesapeake Utilities Corporation's (CPK) financial outlook like an expert! This (CPK) DCF Calculator comes with pre-filled financial data and offers full flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your projections.


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 479.6 488.2 570.0 680.7 670.6 731.8 798.5 871.4 950.8 1,037.6
Revenue Growth, % 0 1.79 16.75 19.43 -1.48 9.12 9.12 9.12 9.12 9.12
EBITDA 158.6 180.1 205.7 224.1 230.2 253.6 276.8 302.0 329.6 359.6
EBITDA, % 33.08 36.89 36.09 32.92 34.33 34.66 34.66 34.66 34.66 34.66
Depreciation 54.2 67.7 72.9 80.0 77.4 89.7 97.8 106.8 116.5 127.1
Depreciation, % 11.3 13.87 12.79 11.76 11.55 12.25 12.25 12.25 12.25 12.25
EBIT 104.5 112.4 132.8 144.0 152.8 164.0 178.9 195.3 213.1 232.5
EBIT, % 21.78 23.02 23.3 21.16 22.78 22.41 22.41 22.41 22.41 22.41
Total Cash 7.0 3.5 5.0 6.2 4.9 6.9 7.5 8.2 8.9 9.7
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 90.5 91.3 98.5 94.6 108.2
Account Receivables, % 18.86 18.7 17.27 13.9 16.14
Inventories 11.9 11.4 21.0 26.3 29.2 24.5 26.7 29.1 31.8 34.7
Inventories, % 2.48 2.34 3.68 3.86 4.36 3.34 3.34 3.34 3.34 3.34
Accounts Payable 54.1 60.3 52.6 61.5 77.5 78.2 85.3 93.1 101.6 110.9
Accounts Payable, % 11.27 12.34 9.23 9.03 11.55 10.69 10.69 10.69 10.69 10.69
Capital Expenditure -184.7 -165.5 -186.9 -128.3 -188.6 -222.7 -243.0 -265.2 -289.4 -315.8
Capital Expenditure, % -38.52 -33.9 -32.8 -18.84 -28.13 -30.44 -30.44 -30.44 -30.44 -30.44
Tax Rate, % 24.35 24.35 24.35 24.35 24.35 24.35 24.35 24.35 24.35 24.35
EBITAT 82.8 85.3 98.4 104.6 115.6 123.8 135.1 147.4 160.9 175.5
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -96.1 -6.7 -40.0 63.8 3.8 -19.8 -16.6 -18.1 -19.7 -21.5
WACC, % 5.9 5.84 5.81 5.78 5.83 5.83 5.83 5.83 5.83 5.83
PV UFCF
SUM PV UFCF -80.7
Long Term Growth Rate, % 3.00
Free cash flow (T + 1) -22
Terminal Value -783
Present Terminal Value -589
Enterprise Value -670
Net Debt 1,391
Equity Value -2,061
Diluted Shares Outstanding, MM 18
Equity Value Per Share -111.81

What You Will Get

  • Real CPK Financial Data: Pre-filled with Chesapeake Utilities Corporation’s historical and projected data for precise analysis.
  • Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
  • Automatic Calculations: See CPK’s intrinsic value update instantly based on your changes.
  • Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
  • User-Friendly Design: Simple structure and clear instructions for all experience levels.

Key Features

  • Pre-Loaded Data: Chesapeake Utilities Corporation’s historical financial statements and pre-filled forecasts.
  • Fully Adjustable Inputs: Customize WACC, tax rates, revenue growth, and EBITDA margins.
  • Instant Results: View Chesapeake Utilities Corporation’s intrinsic value recalculating in real time.
  • Clear Visual Outputs: Dashboard charts present valuation results and essential metrics.
  • Built for Accuracy: A professional tool designed for analysts, investors, and finance professionals.

How It Works

  • Download: Obtain the pre-formatted Excel file featuring Chesapeake Utilities Corporation’s (CPK) financial data.
  • Customize: Tailor forecasts such as revenue growth, EBITDA %, and WACC to fit your analysis.
  • Update Automatically: Watch as intrinsic value and NPV calculations refresh in real-time.
  • Test Scenarios: Generate various projections and instantly compare the results.
  • Make Decisions: Leverage the valuation findings to inform your investment strategy.

Why Choose This Calculator for Chesapeake Utilities Corporation (CPK)?

  • Reliable Data: Access to real Chesapeake Utilities financials ensures trustworthy valuation outcomes.
  • Flexible Options: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
  • Efficiency Boost: Built-in calculations save you time and prevent the hassle of starting from scratch.
  • Expert-Level Tool: Crafted for investors, analysts, and consultants focusing on Chesapeake Utilities.
  • Easy to Use: User-friendly design and clear instructions allow all users to navigate with ease.

Who Should Use This Product?

  • Individual Investors: Make informed decisions about buying or selling Chesapeake Utilities Corporation (CPK) stock.
  • Financial Analysts: Streamline valuation processes with ready-to-use financial models for Chesapeake Utilities Corporation (CPK).
  • Consultants: Deliver professional valuation insights on Chesapeake Utilities Corporation (CPK) to clients quickly and accurately.
  • Business Owners: Understand how utility companies like Chesapeake Utilities Corporation (CPK) are valued to guide your own strategy.
  • Finance Students: Learn valuation techniques using real-world data and scenarios related to Chesapeake Utilities Corporation (CPK).

What the Template Contains

  • Historical Data: Includes Chesapeake Utilities Corporation’s past financials and baseline forecasts.
  • DCF and Levered DCF Models: Detailed templates to calculate Chesapeake Utilities Corporation’s 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 Chesapeake Utilities Corporation’s financials.
  • Interactive Dashboard: Visualize valuation results and projections dynamically.

No products were found matching.