investorscraft@gmail.com

Investor's Craft

Stock Screeners
Stock Indices
Stock Valuation

Intrinsic Value of Alphabet Inc. (GOOGL)

Previous Close$132.43
Intrinsic Value$142.65
Upside potential  +8%
Previous Close
$132.43
Intrinsic Value
$142.65
Potential        
+8%

VALUATION INPUT DATA

This valuation is based on fiscal year data as of 2022-12-31 and quarterly data as of 2023-06-30.

  1. Annual
  2. Quarterly YoY
  3. Quarterly QoQ

Annual revenue growth rates, % (past and forecasted)

Intrinsic Value Stock Screener
Artificial intelligence value of

show cash flow forecast

FINANCIAL STATEMENTS FORECAST and PRESENT VALUE CALCULATION

Fiscal year2022(a)2023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047

INCOME STATEMENT

Revenue growth rate, %9.8NaN
Revenue, $282836NaN
Variable operating expenses, $mNaN
Fixed operating expenses, $mNaN
Total operating expenses, $m207994NaN
Operating income, $m74842NaN
EBITDA, $m90770NaN
Interest expense (income), $mNaN
Earnings before tax, $m71328NaN
Tax expense, $m11356NaN
Net income, $m59972NaN

BALANCE SHEET

Cash and short-term investments, $m113762NaN
Total assets, $m365264NaN
Adjusted assets (=assets-cash), $m251502NaN
Average production assets, $m132842NaN
Working capital, $m95495NaN
Total debt, $m17476NaN
Total liabilities, $m109120NaN
Total equity, $m256144NaN
Debt-to-equity ratio0.068NaN
Adjusted equity ratio0.577NaN

CASH FLOW

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

Company description

Alphabet Inc. offers various products and platforms in the United States, Europe, the Middle East, Africa, the Asia-Pacific, Canada, and Latin America. It operates through Google Services, Google Cloud, and Other Bets segments. The Google Services segment provides products and services, including ads, Android, Chrome, hardware, Gmail, Google Drive, Google Maps, Google Photos, Google Play, Search, and YouTube. It is also involved in the sale of apps and in-app purchases and digital content in the Google Play store; and Fitbit wearable devices, Google Nest home products, Pixel phones, and other devices, as well as in the provision of YouTube non-advertising services. The Google Cloud segment offers infrastructure, cybersecurity, data, analytics, AI, and machine learning, and other services; Google Workspace that include cloud-based collaboration tools for enterprises, such as Gmail, Docs, Drive, Calendar, and Meet; and other services for enterprise customers. The Other Bets segment sells health technology and internet services. The company was founded in 1998 and is headquartered in Mountain View, California.
HomeMenuAccount