investorscraft@gmail.com

Investor's Craft

S&P 500 Health CareS&P 500 EnergyS&P 500 Information Tech.S&P 500 Communic. ServicesS&P 500 Consumer Discret.S&P 500 Consumer StaplesS&P 500 IndustrialsS&P 500 Materials
IntroductionThe concept of valuationRevenue and revenue growthVariable costsFixed costsProduction assets

Intrinsic value of Comcast Corporation (CMCSA)

Previous Close$35.65
Intrinsic Value$37.45
Upside potential  +5%
Previous Close
$35.65
Intrinsic Value
$37.45
Potential        
+5%

VALUATION INPUT DATA (original, your and others' valuations)

ParameterOrig.Your
Date of valuation (DoV)  
Intrinsic value (IV) at DoV, $/sh  
IV at current val. algorithm, $/sh37.45 37.45

The original valuation is based on fiscal year data as of 2021-12-31 and quarterly data as of 2022-03-31.

Registered users can save their valuation input data

  1. Annual
  2. Quarterly YoY
  3. Quarterly QoQ

Annual revenue growth rates, % (past and forecasted)

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.

Company description

Comcast Corporation operates as a media and technology company worldwide. It operates through Cable Communications, Cable Networks, Broadcast Television, Filmed Entertainment, Theme Parks, and Sky segments. The Cable Communications segment offers cable services, including high-speed Internet, video, voice, wireless, and security and automation services to residential and business customers under the Xfinity brand; and advertising services. The Cable Networks segment operates national cable networks that provide various entertainment, news and information, and sports content; regional sports and news networks; international cable networks; and various digital properties, including brand-aligned Websites, as well as engages in the cable television studio production operations. The Broadcast Television segment operates NBC and Telemundo broadcast networks, NBC and Telemundo local broadcast television stations, broadcast television studio production operations, and various digital properties. The Filmed Entertainment segment produces, acquires, markets, and distributes filmed entertainment under the Universal Pictures, Illumination, DreamWorks Animation, and Focus Features names. It also develops, produces, and licenses stage plays; and distributes filmed entertainment produced by third parties. The Theme Parks segment operates Universal theme parks in Orlando, Florida; Hollywood, California; and Osaka, Japan. The Sky segment offers direct-to-consumer services, such as video, high-speed Internet, voice, and wireless phone services; and content services comprising operating entertainment networks, the Sky News broadcast network, and Sky Sports networks. The company also owns the Philadelphia Flyers, as well as the Wells Fargo Center arena in Philadelphia, Pennsylvania. Comcast Corporation was founded in 1963 and is headquartered in Philadelphia, Pennsylvania.

show cash flow forecast

FINANCIAL STATEMENTS FORECAST and PRESENT VALUE CALCULATION

Fiscal year2021(a)2022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046

INCOME STATEMENT

Revenue growth rate, %12.4NaN
Revenue, $116385NaN
Variable operating expenses, $mNaN
Fixed operating expenses, $mNaN
Total operating expenses, $m95568NaN
Operating income, $m20817NaN
EBITDA, $m34621NaN
Interest expense (income), $mNaN
Earnings before tax, $m19419NaN
Tax expense, $m5260NaN
Net income, $m14159NaN

BALANCE SHEET

Cash and short-term investments, $m8767NaN
Total assets, $m275905NaN
Adjusted assets (=assets-cash), $m267138NaN
Average production assets, $m222425NaN
Working capital, $m-4541NaN
Total debt, $m107259NaN
Total liabilities, $m179813NaN
Total equity, $m96092NaN
Debt-to-equity ratio1.116NaN
Adjusted equity ratio0.338NaN

CASH FLOW

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