Alphabet Inc Stock Research

Market Summary

USD104.00+2.68

Market Closed

2.65%

GOOG Alerts

1 major insider sales recently.
Big fall in earnings (Y/Y)

GOOG Stock Price

GOOG RSI Chart

GOOG Valuation

Market Cap

1.3T

Price/Earnings (Trailing)

22.28

Price/Sales (Trailing)

4.72

EV/EBITDA

18.54

Price/Free Cashflow

22.27

GOOG Price/Sales (Trailing)

GOOG Profitability

Operating Margin

55.38%

EBT Margin

25.22%

Return on Equity

23.41%

Return on Assets

16.42%

Free Cashflow Yield

4.49%

GOOG Fundamentals

GOOG Revenue

Revenue (TTM)

282.8B

Revenue Y/Y

0.96%

Revenue Q/Q

10.07%

GOOG Earnings

Earnings (TTM)

60.0B

Earnings Y/Y

-34%

Earnings Q/Q

-2.06%

Price Action

52 Week Range

83.45144.04

(Low)(High)

Last 7 days

-1.9%

Last 30 days

14.9%

Last 90 days

17.2%

Trailing 12 Months

-25.5%

GOOG Financial Health

Current Ratio

2.38

Debt/Equity

0.06

Debt/Cashflow

6.22

GOOG Investor Care

Buy Backs (1Y)

2.97%

Diluted EPS (TTM)

4.56

Peers (Alternatives to Alphabet)

View All Peers In Detail

Name	Mkt Capsorted ascending	Revenue	Price %, 1M	Returns, 1Y	P/E	P/S	Rev 1-Yr	Inc 1-Yr
LARGE-CAP
GOOG	1.3T	282.8B	14.90%	-25.53%	22.28	4.72	9.78%	-21.12%
TWTR	41.4B	5.2B	27.58%	-2.03%	-370.37	7.92	17.45%	-129.08%
PINS	18.2B	2.8B	9.21%	10.81%	-189.99	6.51	8.71%	-130.35%
SNAP	18.2B	4.6B	10.55%	-68.85%	-12.74	3.96	11.78%	-192.99%
MID-CAP
TRIP	2.5B	1.5B	-7.20%	-26.77%	127.15	1.7	65.41%	113.51%
SMALL-CAP
CARG	2.2B	1.7B	2.98%	-56.01%	26.27	1.34	73.96%	-22.75%
YELP	2.1B	1.2B	2.88%	-10.00%	58.95	1.8	15.67%	-8.38%
TTGT	1.0B	297.5M	-5.54%	-55.56%	25.19	3.52	12.93%	4284.51%
EB	850.9M	260.9M	-12.89%	-41.91%	-15.36	3.26	39.43%	60.18%
TRUE	203.4M	161.5M	-0.43%	-41.77%	-1.71	1.26	-30.29%	-209.65%
CDLX	111.9M	298.5M	-36.18%	-93.83%	-0.24	0.37	11.76%	-261.89%
TZOO	75.4M	65.7M	19.84%	-7.93%	84	1.15	6.69%	-81.76%
ZDGE	29.8M	27.4M	-30.60%	-67.98%	3.89	1.22	25.56%	-19.10%
AUTO	5.5M	71.2M	0.91%	-85.52%	-0.38	0.08	-0.63%	-945.76%

Financials for Alphabet

* denotes actual numbers (not divided by Millions)
Income Statement (Last 12 Months)					(In Millions)
Description	(%) Q/Q	2022Q4	2022Q3	2022Q2	2022Q1	2021Q4
Revenue	0.3%	282,836	282,113	278,139	270,334	257,637
S&GA Expenses	-1.6%	26,567	26,988	25,575	24,221	22,912
R&D Expenses	4.1%	39,500	37,941	35,362	33,196	31,562
EBITDA	-9.2%	71,685	78,967	85,774	88,385	90,734
EBITDA Margin	-9.5%	0.25*	0.28*	0.32*	0.33*	0.35*
Earnings Before Taxes	-9.2%	71,328	78,583	85,414	88,385	90,734
EBT Margin	-9.5%	0.25*	0.28*	0.32*	0.33*	0.35*
Interest Expenses	-7.0%	357	384	360	353	346
Net Income	-10.5%	59,972	66,990	72,016	74,539	76,033
Net Income Margin	-10.7%	0.21*	0.24*	0.27*	0.28*	0.30*
Free Cahsflow	-4.0%	60,010	62,542	65,185	68,985	67,012

* denotes actual numbers (not divided by Millions)
Balance Sheet					(In Millions)
Description	(%) Q/Q	2022Q4	2022Q3	2022Q2	2022Q1	2021Q4
Assets	2.0%	365,264	358,255	355,185	357,096	359,268
Current Assets	-0.8%	164,795	166,109	172,371	177,853	188,143
Cash Equivalents	-0.5%	21,879	21,984	17,936	20,886	20,945
Inventory	-15.4%	2,670	3,156	1,980	1,369	1,170
Net PPE	15.4%	112,668	97,599	-	-	-
Goodwill	0.4%	28,960	28,834	23,949	23,010	22,956
Liabilities	4.3%	109,120	104,629	99,766	103,092	107,633
Current Liabilities	5.0%	69,300	65,979	61,354	61,948	64,254
Long Term Debt	0.3%	14,701	14,653	14,734	14,791	14,817
Shareholder's Equity	1.0%	256,144	253,626	255,419	254,004	251,635
Retained Earnings	-0.3%	195,563	196,220	196,845	195,221	191,484
Accumulated Depreciation	19.5%	59,042	49,414	-	-	-
Shares Outstanding	-0.9%	12,849	12,971	13,078	13,175	13,242

Cashflow (Last 12 Months)					(In Millions)
Description	(%) Q/Q	2022Q4	2022Q3	2022Q2	2022Q1	2021Q4
Cashflow From Operations	-1.4%	91,495	92,815	95,001	97,469	91,652
Share Based Compensation	6.3%	19,362	18,216	17,114	16,135	15,376
Cashflow From Investing	19.1%	-20,298	-25,087	-34,304	-39,191	-35,523
Cashflow From Financing	-1.6%	-69,757	-68,639	-65,796	-63,970	-61,362
Buy Backs	3.4%	59,296	57,362	54,580	52,179	50,274

Risks for GOOG

What is the probability of a big loss on GOOG?

50.4%

Probability that Alphabet stock will be more than 20% underwater in next one year

11.2%

Probability that Alphabet stock will be more than 30% underwater in next one year.

3.1%

Probability that Alphabet stock will be more than 40% underwater in next one year.

*Calculated based on probability distribution of losses observed in actual data in the last 5 years.

How does GOOG drawdown profile look like?

Y-axis is the maximum loss one would have experienced if Alphabet was unfortunately bought at previous high price.

Drawdowns

Returns for GOOG

Cumulative Returns on GOOG

15.7%

7-Year Cumulative Returns

15.1%

5-Year Cumulative Returns

21.4%

3-Year Cumulative Returns

What are the long-term rolling returns for GOOG?

FIve years rolling returns for Alphabet.

Annualized Returns

Which funds bought or sold GOOG recently?

View All Details

Datesorted ascending	Fund Name	Type	% Chg	$ Change	$ Held	% Portfolio
2023-03-30	LUTS & GREENLEIGH GROUP, INC	new	-	426,081	426,081	0.54%
2023-03-30	LUTS & GREENLEIGH GROUP, INC	new	-	468,325	468,325	0.59%
2023-03-30	REFRAME WEALTH, LLC	new	-	233,104	233,104	0.09%
2023-03-30	REFRAME WEALTH, LLC	new	-	289,260	289,260	0.11%
2023-03-29	Diametric Capital, LP	sold off	-100	-919,000	-	-%
2023-03-28	Werba Rubin Papier Wealth Management	new	-	535,553	535,553	0.22%
2023-03-28	SEIZERT CAPITAL PARTNERS, LLC	added	8.58	26,780	17,398,800	0.92%
2023-03-28	Werba Rubin Papier Wealth Management	new	-	475,913	475,913	0.20%
2023-03-28	Prostatis Group LLC	sold off	-100	-812,834	-	-%
2023-03-27	Ratio Wealth Group	added	1.5	-16,179	239,580	0.07%

Latest Funds Activity

Are funds buying GOOG calls or puts?

Calls

Puts

Are funds bullish or bearish(Calls - Puts)?

Net Call Options

No. of funds that own GOOG

No. of Funds

Alphabet News

Schedule 13G FIlings of Alphabet

Date Filed	Name of Filer	Percent of Class	No. of Shares	Form Type
Feb 14, 2023	page lawrence	6.12%	389,051,160	SC 13G/A
Feb 14, 2023	schmidt eric e	1.13%	67,895,332	SC 13G/A
Feb 13, 2023	sergey brin	5.82%	368,712,520	SC 13G/A
Feb 09, 2023	vanguard group inc	6.94%	422,660,991	SC 13G/A
Feb 09, 2023	vanguard group inc	8.07%	482,277,696	SC 13G/A
Feb 01, 2023	blackrock inc.	7.0%	416,003,093	SC 13G/A
Mar 11, 2022	blackrock inc.	6.1%	19,224,377	SC 13G/A
Feb 14, 2022	schmidt eric e	1.16%	3,496,743	SC 13G/A
Feb 11, 2022	page lawrence	6.12%	19,619,224	SC 13G/A
Feb 11, 2022	sergey brin	5.9%	18,693,632	SC 13G/A

GOOG Fair Value

Alphabet fair value in different scenarios

The table shows the Fair Value estimates for Alphabet for various scenarios. Disclaimer: These are just estimations from a model. None of the models are good at predicting the future. Please dont buy or sell stocks based on these outputs.

Fair Value	Very Pessimistic	Pessimistic	Base Case	Optimistic	Very Optimistic
Very Low Inflation	138.79 33.45%	187.35 80.14%	270.71 160.30%	360.60 246.73%	422.60 306.35%
Current Inflation	125.98 21.13%	167.28 60.85%	236.68 127.58%	311.21 199.24%	362.32 248.38%
Very High Inflation	110.36 6.12%	143.29 37.78%	197.02 89.44%	254.49 144.70%	293.63 182.34%

Historical Alphabet Fair Value Estimates

Very Pessimistic Case

Pessimistic Case

Fair Value

Optimistic Case

Very Optimistic Case

Closing Stock Price

Recent SEC filings of Alphabet

View All Filings

Date Filed	Form Type	Document
Mar 31, 2023	4	Insider Trading
Mar 28, 2023	4	Insider Trading
Mar 28, 2023	4	Insider Trading
Mar 28, 2023	4	Insider Trading
Mar 28, 2023	4	Insider Trading
Mar 28, 2023	4	Insider Trading
Mar 28, 2023	4	Insider Trading
Mar 16, 2023	4	Insider Trading
Mar 15, 2023	4	Insider Trading
Mar 10, 2023	4	Insider Trading

Latest Insider Trading transactions for GOOG

Filter Transactions

Datesorted ascending	Name	Buy/Sell	$ Value	Avg. Price	# Shares	Title
2023-03-25	WALKER JOHN KENT	sold	-	-	-29,007	president, global affairs, clo
2023-03-25	WALKER JOHN KENT	sold (taxes)	-2,958,330	106	-27,893	president, global affairs, clo
2023-03-25	RAGHAVAN PRABHAKAR	acquired	-	-	32,380	senior vice president
2023-03-25	Pichai Sundar	acquired	-	-	37,503	chief executive officer
2023-03-25	Pichai Sundar	sold	-	-	-37,503	chief executive officer
2023-03-25	Schindler Philipp	sold (taxes)	-3,854,430	106	-36,342	svp, chief business officer
2023-03-25	Schindler Philipp	sold	-	-	-37,598	svp, chief business officer
2023-03-25	RAGHAVAN PRABHAKAR	sold (taxes)	-3,332,410	106	-31,420	senior vice president
2023-03-25	Porat Ruth	sold	-	-	-29,007	svp, cfo
2023-03-25	O'Toole Amie Thuener	sold (taxes)	-97,681	106	-921	vp, chief accounting officer

About Alphabet

GOOG Income Statement

2022-09-30

CONSOLIDATED STATEMENTS OF INCOME - USD ($) $ in Millions	3 Months Ended		9 Months Ended
CONSOLIDATED STATEMENTS OF INCOME - USD ($) $ in Millions	Sep. 30, 2022	Sep. 30, 2021	Sep. 30, 2022	Sep. 30, 2021
Income Statement [Abstract]
Revenues	$ 69,092	$ 65,118	$ 206,788	$ 182,312
Costs and expenses:
Cost of revenues	31,158	27,621	90,861	77,951
Research and development	10,273	7,694	29,233	22,854
Sales and marketing	6,929	5,516	19,384	15,308
General and administrative	3,597	3,256	10,628	9,370
Total costs and expenses	51,957	44,087	150,106	125,483
Income from operations	17,135	21,031	56,682	56,829
Other income (expense), net	(902)	2,033	(2,501)	9,503
Income before income taxes	16,233	23,064	54,181	66,332
Provision for income taxes	2,323	4,128	7,833	10,941
Net income	$ 13,910	$ 18,936	$ 46,348	$ 55,391
Basic net income per share of Class A, Class B, and Class C stock (in dollars per share)	$ 1.07	$ 1.42	$ 3.53	$ 4.14
Diluted net income per share of Class A, Class B, and Class C stock (in dollars per share)	$ 1.06	$ 1.40	$ 3.50	$ 4.08

GOOG Balance Sheet

2022-09-30

CONSOLIDATED BALANCE SHEETS - USD ($) $ in Millions	Sep. 30, 2022	Dec. 31, 2021
Current assets:
Cash and cash equivalents	$ 21,984	$ 20,945
Marketable securities	94,275	118,704
Total cash, cash equivalents, and marketable securities	116,259	139,649
Accounts receivable, net	34,697	39,304
Income taxes receivable, net	1,479	966
Inventory	3,156	1,170
Other current assets	10,518	7,054
Total current assets	166,109	188,143
Non-marketable securities	30,419	29,549
Deferred income taxes	2,991	1,284
Property and equipment, net	108,363	97,599
Operating lease assets	13,677	12,959
Intangible assets, net	2,192	1,417
Goodwill	28,834	22,956
Other non-current assets	5,670	5,361
Total assets	358,255	359,268
Current liabilities:
Accounts payable	6,303	6,037
Accrued compensation and benefits	12,366	13,889
Accrued expenses and other current liabilities	35,038	31,236
Accrued revenue share	7,662	8,996
Deferred revenue	3,585	3,288
Income taxes payable, net	1,025	808
Total current liabilities	65,979	64,254
Long-term debt	14,653	14,817
Deferred revenue, non-current	594	535
Income taxes payable, non-current	8,572	9,176
Deferred income taxes	476	5,257
Operating lease liabilities	11,984	11,389
Other long-term liabilities	2,371	2,205
Total liabilities	104,629	107,633
Contingencies (Note 9)
Stockholders’ equity:
Preferred stock, $0.001 par value per share, 100 shares authorized; no shares issued and outstanding	0	0
Class A, Class B, and Class C stock and additional paid-in capital, $0.001 par value per share: 300,000 shares authorized (Class A 180,000, Class B 60,000, Class C 60,000); 13,242 (Class A 6,015, Class B 893, Class C 6,334) and 12,971 (Class A 5,978, Class B 884, Class C 6,109) shares issued and outstanding	66,258	61,774
Accumulated other comprehensive income (loss)	(8,852)	(1,623)
Retained earnings	196,220	191,484
Total stockholders’ equity	253,626	251,635
Total liabilities and stockholders’ equity	$ 358,255	$ 359,268