Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Yelp Inc. logo

Yelp Inc.

Sector: Technology   

Industry: Internet Content & Information

39.41
 
USD
  
-0.15
  
(-0.38%)
Optionable: Yes  Market Cap: 2,701 M  90-day average vol: 794,117

Previous close: 39.56  Open: 39.49  Bid: 39.0  Ask: 40.62
52 week range    
26.53   
   48.99
Peers   
ANGI / 
GOOGL / 
FB / 
MSFT / 
Last updated: Friday 19th April 2024
43
MarketXLS Rank
40
Value
23
Technical
68
Quality

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

ANGI

4 B-73.98.35

FB

899 B22.4224.91

GOOGL

1,827 B26.12784.02

MARK

0 B1.50.9798

MSFT

0.00812,315 B33.1300.95
Financials

YELP Income Statement

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
AllowancesForConstruction62 M
Amortization of intangibles-3 M-5 M-8 M-12 M-111 M-19 M105 M109 M105 M102 M
Basic EPS from continuing operations0.55-0.270.530.51
Basic EPS total-0.150.51-0.44-0.061.870.660.55-0.270.530.51
Basic weighted shares outstanding66 M72 M75 M77 M82 M84 M75 M73 M74 M71 M
Cost of sales-17 M-24 M-51 M-60 M-71 M-58 M62 M57 M78 M106 M
Depreciation11 M18 M30 M35 M41 M43 M49 M51 M56 M45 M
Depreciation unreconciled11 M18 M30 M35 M41 M43 M49 M51 M56 M45 M
DepreciationAndAmortization11 M18 M30 M35 M41 M43 M49 M51 M56 M45 M
Diluted EPS total-0.150.48-0.44-0.061.760.620.52-0.270.50.5
Diluted normalized net income/share0.52-0.270.50.5
Diluted weighted shares outstanding66 M77 M75 M77 M87 M89 M78 M73 M79 M73 M
GainOnSaleOfPPE4 M
GainOnSaleOfSecurity164 M
GeneralAndAdministrativeExpense43 M58 M81 M97 M110 M121 M199 M188 M136 M164 M
Gross operating profit216 M353 M499 M514 M605 M673 M952 M816 M954 M1,088 M
ImpairmentOfCapitalAssets-5 M-14 M-15 M-19 M-20 M-27 M34 M31 M
Income before tax-9 M11 M-21 M-3 M184 M40 M50 M-35 M34 M67 M
Income restructuring and M&A675000.03 M288000.04 M32000.0
Income taxes838000.0-25 M12 M1 M31 M-15 M9 M-16 M-6 M30 M
Interest income-407000.0221000.0386000.02 M5 M14 M13 M2 M
InterestExpenseOperating78 M
MiscOtherSpecialCharges-218000.0-33000.0451000.0145000.03 M3 M14 M4 M2 M8 M
Net income from total operations-10 M36 M-33 M-5 M153 M55 M41 M-19 M40 M36 M
NetIncomeCommonStockholders-10 M36 M-33 M-5 M153 M55 M502 M446 M593 M647 M
NetIncomeContinuousOperations-10 M36 M-33 M-5 M153 M55 M41 M-19 M40 M36 M
NetNonOperatingInterestIncomeExpense-407000.0221000.0386000.02 M5 M14 M13 M2 M-116000.06 M
Normalized income159 M183 M
Operating income-8 M11 M-21 M-2 M16 M26 M36 M-39 M32 M58 M
Operating income before depreciation (EBITDA)2 M29 M10 M32 M226 M83 M99 M15 M104 M130 M
OperatingExpense225 M342 M520 M516 M588 M647 M748 M675 M646 M724 M
Other income net218000.033000.0-451000.0-14 M-164 M-28 M-14 M-4 M-2 M-8 M
OtherGandA43 M58 M81 M97 M110 M121 M199 M188 M136 M164 M
OtherImpairmentOfCapitalAssets2 M2 M3 M2 M
OtherOperatingExpenses-1 M-1 M-2 M-4 M-21 M-11 M-10 M-8 M-11 M-7 M
OtherWriteOff-14 M-19 M-24 M24 M28 M19 M23 M
PromotionAndAdvertising-1 M-8 M-31 M-47 M-50 M-38 M21 M22 M56 M71 M
RentAndLandingFees43 M58 M81 M97 M110 M121 M
Research & development expense38 M65 M108 M-133 M-171 M-206 M226 M230 M265 M295 M
ResearchExpense38 M65 M108 M139 M226 M230 M265 M295 M
RestructringAndMnAIncome675000.03 M288000.04 M32000.0
Revenue per share-3 M-5 M-8 M-12 M-121 M-30 M117 M125 M120 M121 M
SalariesAndWages-27 M-42 M-61 M-86 M-100 M-114 M-32 M-32 M-36 M-34 M
Selling Gen & administrative expense175 M259 M383 M480 M547 M604 M699 M625 M590 M679 M
SellingAndMarketingExpense132 M201 M302 M383 M437 M483 M500 M437 M454 M515 M
SellingExpense132 M201 M302 M383 M437 M483 M
Special income/charges-675000.014 M15 M-3 M-288000.027 M-34 M-4 M-78 M-106 M
Total Income available for interest expense (EBIT)-9 M11 M-21 M-3 M184 M40 M50 M-35 M34 M67 M
Total common shares outstanding71 M74 M76 M80 M83 M82 M72 M75 M71 M70 M
Total net income-10 M36 M-33 M-5 M153 M55 M41 M-19 M40 M36 M
Total ordinary shares68 M68 M68 M68 M68 M68 M68 M68 M68 M68 M
Total revenues233 M378 M550 M713 M851 M943 M1,014 M873 M1,032 M1,194 M
TotalExpenses208 M318 M469 M455 M518 M589 M811 M732 M724 M830 M
TotalRevenue233 M378 M550 M713 M851 M943 M1,014 M873 M1,032 M1,194 M
WriteOff78 M106 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