Investor’s Craft

Intrinsic value of Horizon Bancorp (IN) (HBNC)

[per Chepakovich valuation model]

➔ other valuations of HBNC

[per Chepakovich valuation model]  ➔ See other valuations of HBNC stock

Previous Close$15.98
Intrinsic Value$4.20
Upside potential  -74%
Previous Close
$15.98
Intrinsic Value
$4.20
Potential        
-74%

VALUATION INPUT DATA

Revenue, mln $
Initial revenue growth rate (norm.), %
Variable cost ratio, %
Fixed operating expenses, mln $
Production assets / Revenue, %
Working capital / Revenue, %
Interest rate on debt, %
Life of production assets, yrs
Initial discount rate, %
Shares outstanding, mln
Adjusted equity ratio
Adjusted assets / Revenue
Based on fiscal year data as of 2020-12-31 and quarterly data as of 2021-03-31.
NOTE: The bar chart shows historic and forecasted yearly revenue growth rates. Its purpose is to help you in determining what initial revenue rate you want to base your stock valuation on. Please make sure that you are confident in the value you select - for most stocks it is by far the most important parameter in valuation.
  1. Annual
  2. Quarterly YoY
  3. Quarterly QoQ

Annual revenue growth rates, % (past and forecasted)

show cash flow forecast

FINANCIAL STATEMENTS FORECAST and PRESENT VALUE CALCULATION

Fiscal year2020(a)2021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045

INCOME STATEMENT

Revenue growth rate, %5.4NaN
Revenue, $265NaN
Variable operating expenses, $mNaN
Fixed operating expenses, $mNaN
Total operating expenses, $m187NaN
Operating income, $m78NaN
EBITDA, $m98NaN
Interest expense (income), $mNaN
Earnings before tax, $m78NaN
Tax expense, $m10NaN
Net income, $m68NaN

BALANCE SHEET

Cash and short-term investments, $m259NaN
Total assets, $m5887NaN
Adjusted assets (=assets-cash), $m5628NaN
Average production assets, $m268NaN
Working capital, $m-430NaN
Total debt, $m590NaN
Total liabilities, $m5194NaN
Total equity, $m692NaN
Debt-to-equity ratio0.853NaN
Adjusted equity ratio0.077NaN

CASH FLOW

Net income, $m68NaN
Depreciation, amort., depletion, $m20NaN
Funds from operations, $mNaN
Change in working capital, $mNaN
Cash from operations, $m79NaN
Maintenance CAPEX, $mNaN
New CAPEX, $mNaN
Total CAPEX, $m-6NaN
Free cash flow, $m85NaN
Issuance/(repurchase) of shares, $mNaN
Retained Cash Flow, $mNaN
Pot'l extraordinary dividend, $m-430
Cash available for distribution, $mNaN
Discount rate, %NaN
PV of cash for distribution, $mNaN
Current shareholders' claim on cash, %NaN
CONTACT USAboutSite newsQ&A
Valuation modelValuation theoryInvesting
Privacy policyTerms of use
Copyright © InvestorsCraft.com 2005-2021. All rigths reserved.