Friday, November 14, 2014

Valuation of Large Cap Tech companies > $50 billion Value

NOTE : Stocks in this page are valued using the Discounted Cash Flow (DCF) technique. The 3 components of the valuation are : (A) Base FCF. (B) FCF Multiple. (C) Net book value for val. Total value (T) = (A x B) + C . Value per share = (T) / Shares oustanding (S).

Please refer to the post Discounted cash flow basics to understand this valuation technique.

Company list   Apple   Microsoft   Google   Oracle   IBM   Cisco   Intel   Qualcom   Verizon   Facebook   HP   Ebay   EMC   Yahoo

5yr  AAPL  

Updated - 10/22/2014  AAPL Valuation : $104.13 / share , Total value : $630 billions
(Base FCF : $45 billions , multiple 12 , Net book value for val : $90 billion)
Shares oustanding :6,050 millions  LINKS SEC  Company

5yr  MSFT  

Updated - 10/22/2014  MSFT Valuation : $41.07 / share , Total value : $345 billions
(Base FCF : $22 billions , multiple 15 , Net book value for val : $25 billion)
Shares oustanding :8,400 millions  LINKS SEC  Company

5yr  GOOG  

Updated - 10/22/2014  GOOG Valuation : $295/ share , Total value : $200 billions
(Base FCF : $10 billions , multiple 15 , Net book value for val : $50 billion)
Shares oustanding :678 millions  LINKS SEC  Company

5yr  ORCL  

Updated - 10/22/2014  ORCL Valuation : $40.43 / share , Total value : $186 billions
(Base FCF : $14 billions , multiple 13 , Net book value for val : $4 billion)
Shares oustanding :4,600 millions  LINKS SEC  Company

5yr  IBM  

Updated - 10/22/2014  IBM Valuation : $150 / share , Total value : $165 billions
(Base FCF : $15 billions , multiple 13 , Net book value for val : -$30 billion)
Shares oustanding :1,100 millions  LINKS SEC  Company

5yr  CSCO  

Updated - 10/22/2014  CSCO Valuation : $26.70 / share , Total value : $141 billions
(Base FCF : $11 billions , multiple 11 , Net book value for val : $20 billion)
Shares oustanding :5,280 millions  LINKS SEC  Company

5yr  INTC  

Updated - 10/22/2014  INTC Valuation : $27.50 / share , Total value : $140 billions
(Base FCF : $10 billions , multiple 12 , Net book value for val : $20 billion)
Shares oustanding :5,090 millions  LINKS SEC  Company

5yr  QCOM  

Updated - 10/22/2014  QCOM Valuation : $65.10 / share , Total value : $114 billions
(Base FCF : $7 billions , multiple 12 , Net book value for val : $30 billion)
Shares oustanding :1,750 millions  LINKS SEC  Company

5yr  VZ  

Updated - 10/22/2014  VZ Valuation : $29.62 / share , Total value : $85 billions
(Base FCF : $20 billions , multiple 13 , Net book value for val : -$175 billion)
Shares oustanding :2,870 millions  LINKS SEC  Company

5yr  FB  

Updated - 10/22/2014  FB Valuation : $32.69 / share , Total value : $85 billions
(Base FCF : $3 billions , multiple 25 , Net book value for val : $10 billion)
Shares oustanding :2,600 millions  LINKS SEC  Company

5yr  HPQ  

Updated - 10/22/2014  HPQ Valuation : $39 / share , Total value : $78 billions
(Base FCF : $8 billions , multiple 13 , Net book value for val : -$26 billion)
Shares oustanding :2,000 millions  LINKS SEC  Company

5yr  EBAY  

Updated - 10/22/2014  EBAY Valuation : $53.85 / share , Total value : $70 billions
(Base FCF : $4 billions , multiple 16 , Net book value for val : $6 billion)
Shares oustanding :1,300 millions  LINKS SEC  Company

5yr  EMC  

Updated - 10/22/2014  EMC Valuation : $30.09 / share , Total value : $65 billions
(Base FCF : $5 billions , multiple 12 , Net book value for val : $5 billion)
Shares oustanding :2,160 millions  LINKS SEC  Company

5yr  YHOO  

Updated - 10/22/2014  YHOO Valuation : $48.33 / share , Total value : $62.50 billions
(Base FCF : $0.5 billions , multiple 12 , Net book value for val : $56.50 billion)
Shares oustanding :1,280 millions  LINKS SEC  Company

NOTE   At $95/share , Alibaba is valued at $235 billions. Its total shares outstanding is 2.47 billion.As of Dec-31-2013 Yahoo owned 24% of shares of Alibaba. Thus its value of Alibaba's stake is around $56 billion. (Refer to Note-8 of Yahoo's 2013 10k report for further details.