Intrinsic value of Cerner Corporation (CERN)

[per Chepakovich valuation model]

other valuations of CERN

[per Chepakovich valuation model]  See other valuations of CERN stock

Previous Close$76.69
Intrinsic Value
Upside potential
Previous Close
$76.69

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 2020-12-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, %-3.3NaN
Revenue, $5506NaN
Variable operating expenses, $mNaN
Fixed operating expenses, $mNaN
Total operating expenses, $m4591NaN
Operating income, $m915NaN
EBITDA, $m1612NaN
Interest expense (income), $mNaN
Earnings before tax, $m991NaN
Tax expense, $m211NaN
Net income, $m780NaN

BALANCE SHEET

Cash and short-term investments, $m1058NaN
Total assets, $m7521NaN
Adjusted assets (=assets-cash), $m6463NaN
Average production assets, $m3077NaN
Working capital, $m1482NaN
Total debt, $m1336NaN
Total liabilities, $m3039NaN
Total equity, $m4483NaN
Debt-to-equity ratio0.298NaN
Adjusted equity ratio0.530NaN

CASH FLOW

Net income, $m780NaN
Depreciation, amort., depletion, $m697NaN
Funds from operations, $mNaN
Change in working capital, $mNaN
Cash from operations, $m1437NaN
Maintenance CAPEX, $mNaN
New CAPEX, $mNaN
Total CAPEX, $m-579NaN
Free cash flow, $m2016NaN
Issuance/(repurchase) of shares, $mNaN
Retained Cash Flow, $mNaN
Pot'l extraordinary dividend, $m1482
Cash available for distribution, $mNaN
Discount rate, %NaN
PV of cash for distribution, $mNaN
Current shareholders' claim on cash, %NaN