Intrinsic Value of Google Cl C (GOOG)

STOCK VALUATION MODEL INPUTS

Initial revenue growth rate, %
Terminal revenue growth, %
Revenue decline factor
 
Initial discount rate, %
Discount rate multiplier
definition of terms  
 
Step 1

Manual adjustment of revenue growth rates (RGR) and discount rates (DR) for the next 18 years:
Year 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032
RGR, %
DR, %
 
Revenue (in 2014), US$ mln
Variable Cost Ratio, %
Fixed operating expenses, US$ mln
Interest rate on debt, %
Corporate tax rate, %
Stock options cost / Revenue, %
Inflation, %
 
Production assets / Revenue
Working capital / Revenue
Life of production assets, years
Net debt, US$ mln
Equity, US$ mln
Target Net debt / Equity ratio
Goodwill, US$ mln
 
Market price of stock, US$ (Mar 20 )
Number of shares outstanding, mln
Market capitalization, US$ bln 381.0
   
   
Step 2

Stock valuation results will appear here after you hit the Calculate button above.

Please check/change the model input data first. The most important discretionary inputs are highlighted.

Business Summary

Google Inc., a technology company, builds products and provides services to organize the information. The company offers Google Search, which provides information online; Google Now that offers information to users when they need it; AdWords, an auction-based advertising program; AdSense, which enables Websites that are part of the Google network to deliver ads; DoubleClick Ad Exchange, a marketplace for the trading display ad space; and other advertising platforms, such as AdExchange and AdMob. It also offers YouTube that offers video, interactive, and other ad formats; Android, an open source mobile software platform; hardware products, including Chromebook, Chrome OS devices, Chromecast, and Nexus devices; Google Play, a cloud-based digital entertainment store for apps, music, books, and movies; Google Drive, a place for users to create, share, collaborate, and keep their stuff; and Google Wallet, a virtual wallet for in-store contactless payments. In addition, the company provides Google Apps, which include Gmail, Docs, Slides, Drawings, Calendar, Sheets, Forms, Sites, etc. for people to work anywhere, anytime, on any device without loss of security or control; Google Maps Application Programming Interface; and Google Earth Enterprise, a software solution for imagery and data visualization. Further, it offers Google+ to share things online with people; Groups to create mailing lists and discussion groups; Blogger to share the life online with a blog; and Hangouts for group conversations. Additionally, Google provides App Engine, a platform as a service offering; Google Cloud Storage; Google BigQuery for real time analytics; Google Cloud SQL to store and manage data using a relational MySQL database; Google Compute Engine, an infrastructure as a service platform; and Google Developers to find all Google developer documentation, resources, events, and products. Google Inc. was founded in 1998 and is headquartered in Mountain View, California.

 

FINANCIAL RATIOS  of  Google Cl C (GOOG)

Valuation Ratios
 
Financial Strength
 
Profitability Ratios
P/E Ratio
26.4
  Quick Ratio
32
  Gross Margin
61.6%
Price to Sales
5.8
  Current Ratio
0.1
  Gross Margin - 3 Yr. Avg.
61.6%
Price to Book
3.6
  LT Debt to Equity
3.1%
  EBITDA Margin
33.8%
Price to Tangible Book
  Total Debt to Equity
5%
  EBITDA Margin - 3 Yr. Avg.
35.9%
Price to Cash Flow
17
  Interest Coverage
202
  Operating Margin
25%
Price to Free Cash Flow
33.4
 
Management Effectiveness
  Oper. Margin - 3 Yr. Avg.
27.6%
Growth Rates
  Return On Assets
12%
  Pre-Tax Margin
26.1%
Sales Growth Rate
18.9%
  Ret/ On Assets - 3 Yr. Avg.
12.6%
  Pre-Tax Margin - 3 Yr. Avg.
28.7%
Sales - 3 Yr. Growth Rate
%
  Return On Total Capital
14.3%
  Net Profit Margin
21.9%
EPS Growth Rate
%
  Ret/ On T. Cap. - 3 Yr. Avg.
15%
  Net Profit Margin - 3 Yr. Avg.
22.8%
EPS - 3 Yr. Growth Rate
%
  Return On Equity
15.1%
  Effective Tax Rate
19.3%
Capital Spending Gr. Rate
48.9%
  Return On Equity - 3 Yr. Avg.
15.9%
  Eff/ Tax Rate - 3 Yr. Avg.
18.5%
Cap. Spend. - 3 Yr. Gr. Rate
26.1%
  Asset Turnover
0.5
  Payout Ratio
0%
Financial statements of GOOG
 

Do you have an opinion or information about the company and its stock? Share it with everybody!

Please kindly note that messages containing links will not be posted. This is a spam prevention measure.

(to add a comment, please register and log in)