Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

GOOGL Stock Forecast, Price Targets, Chart, Dividends & Analysis

Alphabet Inc. logo

Alphabet Inc.

Sector: Technology   

Industry: Internet Content & Information

188.51
 
USD
  
0.11
  
(0.06%)
Previous close: 188.4  Open: 191.625  Bid: 188.73  Ask: 188.86
52 week range    
130.67   
   201.42
Mkt Cap: 2,392,136 M  Avg Vol (90 Days): 26,733,944
Peers   
MSFT / 
AAPL / 
EBAY / 
FB / 
YNDX / 
BIDU / 
AKAM / 
BCOR / 
AMZN / 
Last updated: Friday 20th December 2024

Stock Rankings

64
MarketXLS Rank
60
Value
69
Technical
65
Quality
How are these ranks calculated?
Search for a stock

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

AAPL

0.0043,832 B41.29249.79

ADBE

200 B38.98437.39

AKAM

15 B28.7994.58

AMZN

2,431 B49.92223.29

BCOR

27.19

BIDU

EBAY

0.01731 B1663.95

FB

MSFT

0.00743,379 B37.26437.03

YNDX

36618.94
Financials

GOOGL Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
AccruedPreferredStockDividends522 M
Amortization of intangibles-43 M15,869 M16,468 M45,583 M17,888 M20,624 M21,175 M22,956 M28,960 M29,198 M
Basic EPS from continuing operations1.032.392.830.912.212.482.965.694.595.84
Basic EPS total1.072.392.830.912.212.482.965.694.595.84
Basic weighted shares outstanding13,519 M6,849 M6,878 M13,861 M13,901 M13,851 M13,616 M13,353 M13,066 M12,636 M
BasicDiscontinuousOperations0.04
Cost of sales25,691 M28,164 M35,138 M45,583 M59,549 M71,896 M84,732 M110,939 M126,203 M133,332 M
Depreciation13,475 M11,946 M
Depreciation unreconciled45,583 M71,896 M
DepreciationAndAmortization45,583 M71,896 M13,475 M11,946 M
DevelopmentExpense59,549 M
Diluted EPS total1.052.362.790.92.192.462.935.614.565.8
Diluted normalized net income/share1.012.362.790.92.192.462.935.614.565.8
Diluted weighted shares outstanding13,741 M6,930 M6,994 M14,069 M14,067 M13,972 M13,741 M13,553 M13,152 M12,723 M
DilutedDiscontinuousOperations0.04
Earnings from equity interest-227 M-202 M-156 M
EarningsFromEquityInterestNetOfTax-227 M-202 M-156 M
GainOnSaleOfPPE-138 M455 M176 M149 M1,960 M236 M
GainOnSaleOfSecurity238 M357 M272 M185 M5,460 M2,649 M5,592 M12,380 M103 M690 M
GeneralAndAdministrativeExpense5,851 M6,136 M6,985 M6,872 M6,923 M9,551 M11,052 M13,510 M15,724 M16,425 M
Gross operating profit40,310 M46,825 M55,134 M65,272 M77,270 M89,961 M97,795 M146,698 M156,633 M174,062 M
ImpairmentOfCapitalAssets71,896 M
Income before tax17,259 M19,651 M24,150 M27,193 M34,913 M39,625 M48,082 M90,734 M71,328 M85,717 M
Income restructuring and M&A84,732 M3,933 M
Income taxes3,639 M3,303 M4,672 M14,531 M4,177 M5,282 M7,813 M14,701 M11,356 M11,922 M
Interest income746 M999 M1,220 M1,312 M1,878 M2,427 M1,865 M1,499 M2,174 M3,865 M
InterestExpenseNonOperating101 M104 M124 M109 M114 M100 M135 M346 M357 M308 M
MarketingExpense3,004 M28,164 M3,900 M5,100 M6,400 M6,800 M5,400 M7,900 M9,200 M8,700 M
MinorityInterests722 M659 M160 M2,795 M310 M35 M
MiscOtherSpecialCharges763 M291 M434 M1,047 M7,389 M5,394 M6,858 M12,020 M-3,514 M1,424 M
Net income from total operations14,136 M16,348 M19,478 M12,662 M30,736 M34,343 M40,269 M76,033 M59,972 M73,795 M
NetIncomeCommonStockholders14,136 M15,826 M19,478 M12,662 M30,736 M34,343 M40,269 M76,033 M59,972 M73,795 M
NetIncomeContinuousOperations14,136 M16,348 M19,478 M12,662 M30,736 M34,343 M40,269 M76,033 M59,972 M73,795 M
NetIncomeDiscontinuousOperations516 M
NetNonOperatingInterestIncomeExpense645 M895 M1,096 M1,155 M1,672 M2,160 M1,512 M990 M-1,817 M-3,557 M
NonRecurringOperationExpense28,164 M
Normalized income71,413 M
Operating income16,496 M19,360 M23,716 M26,146 M27,524 M34,231 M41,224 M78,714 M74,842 M84,293 M
Operating income before depreciation (EBITDA)27,318 M24,818 M30,418 M34,217 M44,062 M51,506 M61,914 M103,521 M85,160 M97,971 M
OperatingExpense23,814 M55,629 M31,418 M84,709 M109,295 M55,730 M56,571 M67,984 M81,791 M81,791 M
Other income net-763 M-291 M-434 M-1,047 M-7,389 M-5,394 M-6,858 M98,919 M-5,331 M-2,133 M
OtherGainLossFromDispositionOfDiscontinuedOperations516 M
OtherGandA5,851 M6,136 M6,985 M6,872 M6,923 M9,551 M11,052 M13,510 M15,724 M16,425 M
OtherImpairmentOfCapitalAssets281 M110,939 M
OtherOperatingExpenses-771 M-852 M-680 M2,736 M5,071 M1,697 M-690 M-1,384 M-2,221 M-2,346 M
OtherunderPreferredStockDividend522 M
PreferredStockDividends522 M
PromotionAndAdvertising126,203 M
RentAndLandingFees570 M734 M897 M1,100 M1,300 M
Research & development expense9,832 M12,282 M13,948 M16,625 M80,968 M26,018 M27,573 M31,562 M39,500 M45,427 M
ResearchExpense9,832 M12,282 M13,948 M16,625 M21,419 M26,018 M27,573 M31,562 M39,500 M45,427 M
RestructringAndMnAIncome84,732 M3,933 M
Revenue per share-43 M15,869 M16,468 M45,583 M17,888 M20,624 M21,175 M22,956 M28,960 M29,198 M
SalariesAndWages-1,500 M-1,600 M-1,500 M-1,800 M-2,700 M-3,100 M-3,900 M-4,500 M
SecuritiesAmortization126,203 M
Selling Gen & administrative expense13,982 M43,347 M17,470 M19,765 M23,256 M28,015 M28,998 M36,422 M42,291 M44,342 M
SellingAndMarketingExpense8,131 M37,211 M10,485 M12,893 M16,333 M18,464 M17,946 M22,912 M26,567 M27,917 M
SellingExpense25,691 M
Special income/charges-28,164 M-71,896 M-84,732 M-3,933 M
Total Income available for interest expense (EBIT)17,360 M19,755 M24,274 M27,302 M35,027 M39,725 M48,217 M91,080 M71,685 M86,025 M
Total common shares outstanding13,612 M13,766 M13,828 M13,906 M13,904 M13,746 M13,483 M13,219 M12,807 M12,433 M
Total net income14,136 M16,348 M19,478 M12,662 M30,736 M34,343 M40,269 M76,033 M59,972 M73,795 M
Total ordinary shares5,843 M5,843 M5,843 M5,843 M5,843 M5,843 M5,843 M5,843 M5,843 M5,843 M
Total revenues66,001 M74,989 M90,272 M110,855 M136,819 M161,857 M182,527 M257,637 M282,836 M307,394 M
TotalExpenses49,505 M83,793 M66,556 M130,292 M168,844 M127,626 M141,303 M178,923 M207,994 M223,101 M
TotalRevenue66,001 M74,989 M90,272 M110,855 M136,819 M161,857 M182,527 M257,637 M282,836 M307,394 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University