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

Sector:    

Industry: 

 
USD
  
  
()
Optionable:   Market Cap:   90-day average vol:

Previous close:   Open:   Bid:   Ask:
52 week range    
   
   

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

Valuation

Returns

Risk

Ranks

Dividends

Analyst Estimates

Financial Health

Technicals

Growth

Profitability

Peers

StockDividendMarket Cap (B)PEPrice ($)
Financials

YELP Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
AllowancesForConstruction62 M
Amortization of intangibles-5 M-8 M-12 M-111 M-19 M105 M109 M105 M102 M104 M
Basic EPS from continuing operations0.55-0.270.530.511.43
Basic EPS total0.51-0.44-0.061.870.660.55-0.270.530.511.43
Basic weighted shares outstanding72 M75 M77 M82 M84 M75 M73 M74 M71 M69 M
Cost of sales-24 M-51 M-60 M-71 M-58 M62 M57 M78 M-200 M-218 M
Depreciation18 M30 M35 M41 M43 M49 M51 M56 M45 M42 M
Depreciation unreconciled18 M30 M35 M41 M43 M49 M51 M56 M45 M42 M
DepreciationAndAmortization18 M30 M35 M41 M43 M49 M51 M56 M45 M42 M
Diluted EPS total0.48-0.44-0.061.760.620.52-0.270.50.51.35
Diluted normalized net income/share0.52-0.270.50.51.35
Diluted weighted shares outstanding77 M75 M77 M87 M89 M78 M73 M79 M73 M74 M
GainOnSaleOfPPE4 M
GainOnSaleOfSecurity164 M
GeneralAndAdministrativeExpense58 M81 M97 M110 M121 M199 M188 M136 M164 M212 M
Gross operating profit353 M499 M514 M605 M673 M952 M816 M954 M1,393 M1,555 M
ImpairmentOfCapitalAssets-14 M-15 M-19 M-20 M-27 M34 M31 M30 M
Income before tax11 M-21 M-3 M184 M40 M50 M-35 M34 M67 M105 M
Income restructuring and M&A3 M288000.04 M32000.0
Income taxes-25 M12 M1 M31 M-15 M9 M-16 M-6 M30 M6 M
Interest income221000.0386000.02 M5 M14 M13 M2 M
InterestExpenseOperating78 M
MiscOtherSpecialCharges-33000.0451000.0145000.03 M3 M14 M4 M2 M8 M26 M
Net income from total operations36 M-33 M-5 M153 M55 M41 M-19 M40 M36 M99 M
NetIncomeCommonStockholders36 M-33 M-5 M153 M55 M502 M446 M593 M36 M99 M
NetIncomeContinuousOperations36 M-33 M-5 M153 M55 M41 M-19 M40 M36 M99 M
NetNonOperatingInterestIncomeExpense221000.0386000.02 M5 M14 M13 M2 M-116000.06 M20 M
Normalized income159 M
Operating income11 M-21 M-2 M16 M26 M36 M-39 M32 M58 M79 M
Operating income before depreciation (EBITDA)29 M10 M32 M226 M83 M99 M15 M104 M163 M199 M
OperatingExpense342 M520 M516 M588 M647 M748 M675 M646 M724 M811 M
Other income net33000.0-451000.0-14 M-164 M-28 M-14 M-4 M-2 M-8 M-26 M
Other special charges106 M
OtherGandA58 M81 M97 M110 M121 M199 M188 M136 M164 M212 M
OtherImpairmentOfCapitalAssets2 M2 M3 M2 M2 M
OtherOperatingExpenses-1 M-2 M-4 M-21 M-11 M-10 M-8 M-11 M-7 M-7 M
OtherWriteOff-14 M-19 M-24 M24 M28 M19 M23 M36 M
PromotionAndAdvertising-8 M-31 M-47 M-50 M-38 M21 M22 M56 M71 M66 M
RentAndLandingFees58 M81 M97 M110 M121 M
Research & development expense65 M108 M-133 M-171 M-206 M226 M230 M265 M295 M321 M
ResearchExpense65 M108 M139 M226 M230 M265 M295 M321 M
RestructringAndMnAIncome3 M288000.04 M32000.0
Revenue per share-5 M-8 M-12 M-121 M-30 M117 M125 M120 M102 M104 M
SalariesAndWages-42 M-61 M-86 M-100 M-114 M-32 M-32 M-36 M-34 M-34 M
Selling Gen & administrative expense259 M383 M480 M547 M604 M699 M625 M590 M679 M769 M
SellingAndMarketingExpense201 M302 M383 M437 M483 M500 M437 M454 M515 M557 M
SellingExpense201 M302 M383 M437 M483 M
Special income/charges14 M15 M-3 M-288000.027 M-34 M-4 M-78 M-30 M
Total Income available for interest expense (EBIT)11 M-21 M-3 M184 M40 M50 M-35 M34 M67 M105 M
Total common shares outstanding74 M76 M80 M83 M82 M72 M75 M71 M70 M68 M
Total net income36 M-33 M-5 M153 M55 M41 M-19 M40 M36 M99 M
Total ordinary shares67 M67 M67 M67 M67 M67 M67 M67 M67 M67 M
Total revenues378 M550 M713 M851 M943 M1,014 M873 M1,032 M1,194 M1,337 M
TotalExpenses318 M469 M455 M518 M589 M811 M732 M724 M524 M593 M
TotalRevenue378 M550 M713 M851 M943 M1,014 M873 M1,032 M1,194 M1,337 M
WriteOff78 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