ICC Holdings, Inc. (ICCH) DCF Valuation

ICC Holdings, Inc. (ICCH) 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

ICC Holdings, Inc. (ICCH) 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 ICC Holdings, Inc. (ICCH) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and examine how changes affect ICC Holdings, Inc. (ICCH) valuation – all within a single 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 59.5 54.9 61.4 69.7 82.9 90.5 98.8 107.9 117.7 128.5
Revenue Growth, % 0 -7.81 11.96 13.41 19.03 9.15 9.15 9.15 9.15 9.15
EBITDA 5.9 5.5 5.3 .2 6.5 6.6 7.2 7.9 8.6 9.4
EBITDA, % 9.96 9.97 8.65 0.24011 7.8 7.33 7.33 7.33 7.33 7.33
Depreciation .8 .7 .7 .7 .8 1.0 1.1 1.2 1.3 1.5
Depreciation, % 1.33 1.25 1.15 0.99464 0.9209 1.13 1.13 1.13 1.13 1.13
EBIT 5.1 4.8 4.6 -.5 5.7 5.6 6.1 6.7 7.3 8.0
EBIT, % 8.63 8.72 7.5 -0.75453 6.88 6.19 6.19 6.19 6.19 6.19
Total Cash 98.7 112.3 110.4 96.5 1.5 72.7 79.4 86.7 94.6 103.3
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 33.6 36.9 41.9 .0 .0
Account Receivables, % 56.44 67.24 68.22 0 0
Inventories -33.1 -32.2 -34.8 -15.2 .0 -34.9 -38.1 -41.5 -45.3 -49.5
Inventories, % -55.57 -58.6 -56.64 -21.77 0 -38.52 -38.52 -38.52 -38.52 -38.52
Accounts Payable .4 .4 1.4 1.4 1.1 1.3 1.4 1.5 1.6 1.8
Accounts Payable, % 0.62999 0.6764 2.23 2.02 1.37 1.38 1.38 1.38 1.38 1.38
Capital Expenditure -.4 -.4 -1.0 -.7 -.6 -.9 -1.0 -1.0 -1.1 -1.2
Capital Expenditure, % -0.74663 -0.70332 -1.62 -1.02 -0.74428 -0.96598 -0.96598 -0.96598 -0.96598 -0.96598
Tax Rate, % 22.91 22.91 22.91 22.91 22.91 22.91 22.91 22.91 22.91 22.91
EBITAT 4.3 3.7 3.9 -.3 4.4 4.3 4.7 5.2 5.7 6.2
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 4.5 -.2 2.2 22.0 -10.9 4.7 5.0 5.5 6.0 6.5
WACC, % 5.58 5.52 5.57 5.43 5.52 5.53 5.53 5.53 5.53 5.53
PV UFCF
SUM PV UFCF 23.5
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 7
Terminal Value 189
Present Terminal Value 145
Enterprise Value 168
Net Debt 14
Equity Value 155
Diluted Shares Outstanding, MM 3
Equity Value Per Share 52.14

What You Will Get

  • Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real ICC Holdings, Inc. (ICCH) financials.
  • Real-World Data: Historical data and forward-looking estimates (highlighted in the yellow cells).
  • Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
  • Automatic Calculations: Instantly observe how your inputs affect ICC Holdings, Inc. (ICCH)’s valuation.
  • Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
  • User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.

Key Features

  • Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for ICC Holdings, Inc. (ICCH).
  • WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs specific to ICC Holdings, Inc. (ICCH).
  • Customizable Forecast Assumptions: Allows users to adjust growth rates, capital expenditures, and discount rates for accurate projections.
  • Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to ICC Holdings, Inc. (ICCH).
  • Interactive Dashboard and Charts: Provides visual representations that summarize essential valuation metrics for straightforward analysis.

How It Works

  • Step 1: Download the prebuilt Excel template featuring ICC Holdings, Inc. (ICCH) data.
  • Step 2: Review 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 view updated results, including ICC Holdings, Inc. (ICCH)'s intrinsic value.
  • Step 5: Make well-informed investment decisions or create reports based on the outputs.

Why Choose ICC Holdings, Inc. (ICCH) Calculator?

  • All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for ICC Holdings.
  • Flexible Parameters: Modify the highlighted cells to explore different investment scenarios.
  • In-Depth Analysis: Automatically computes ICC Holdings’ intrinsic value and Net Present Value.
  • Preloaded Information: Access historical and projected data for precise calculations.
  • High-Quality Standards: Perfect for financial analysts, investors, and business advisors focused on ICC Holdings.

Who Should Use This Product?

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

What the Template Contains

  • Operating and Balance Sheet Data: Pre-filled ICC Holdings, Inc. (ICCH) 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 ICC Holdings, Inc. (ICCH).
  • Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.

No products were found matching.