Premium Membership - Holiday Season Special - 75% off

investorscraft@gmail.com

Investor's Craft

Stock Screeners
Stock Indices
Stock Valuation

Intrinsic Value of Alphabet Inc. (GOOG)

Previous Close$173.89
Intrinsic Value$87.32
Upside potential  -50%
Previous Close
$173.89
Intrinsic Value
$87.32
Potential        
-50%

VALUATION INPUT DATA

This valuation is based on fiscal year data as of 2022-12-31 and quarterly data as of 2023-09-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 year(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
HomeMenuAccount