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

40.44
 
USD
  
0.20
  
(0.50%)
Optionable: Yes  Market Cap: 2,748 M  90-day average vol: 796,727

Previous close: 40.24  Open: 40.41  Bid: 37.1  Ask: 42.0
52 week range    
26.53   
   48.99
Peers   
ANGI / 
GOOGL / 
FB / 
MSFT / 
Last updated: Thursday 2nd May 2024
51
MarketXLS Rank
40
Value
46
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

Financials

YELP Balance Sheet

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
"""debtc"""58 M51 M40 M40 M
Accounts payable3 M1 M3 M20 M9 M7 M72 M88 M120 M138 M
Accounts receivable21 M36 M53 M69 M76 M87 M107 M88 M107 M132 M
Accrued expenses22 M31 M47 M57 M83 M61 M72 M88 M120 M138 M
Accumulated depreciation & depletion-18 M-31 M-50 M-76 M-106 M-143 M-185 M-230 M-245 M-282 M
Additional paid in capital554 M628 M774 M893 M1,038 M1,139 M1,260 M1,398 M1,523 M1,650 M
Cash and equivalents390 M247 M172 M272 M548 M333 M170 M596 M480 M306 M
CashCashEquivalentsAndShortTermInvestments390 M366 M371 M480 M821 M756 M412 M596 M480 M401 M
CashEquivalents390 M247 M172 M272 M548 M333 M127 M510 M390 M250 M
Common stock equity486 M588 M694 M807 M1,109 M1,076 M755 M855 M751 M710 M
CommonStock500 M500 M500 M200 M200 M200 M755 M855 M751 M710 M
Cost in excess60 M67 M172 M171 M108 M106 M105 M109 M105 M102 M
CurrentAccruedExpenses19 M30 M43 M37 M74 M55 M
CurrentCapitalLeaseObligation15 M26 M35 M42 M49 M57 M58 M51 M40 M40 M
CurrentDeferredRevenue3 M3 M3 M3 M3 M4 M4 M4 M4 M5 M
CurrentDeferredTaxesAssets8 M38 M32 M32 M24 M45 M92 M92 M94 M142 M
CurrentDeferredTaxesLiabilities528000.027 M3 M2 M2 M17 M-71 M-61 M-54 M97 M
Deferred revenues3 M3 M3 M3 M3 M4 M4 M4 M4 M5 M
Deposits29 M29 M
Float term debt5 M8 M12 M18 M175 M149 M128 M87 M
GoodwillAndOtherIntangibleAssets65 M73 M211 M203 M125 M119 M115 M123 M116 M111 M
Gross fixed assets (Plant Property & Equipment)48 M94 M131 M169 M210 M257 M494 M500 M470 M457 M
IncomeTaxPayable2 M1 M2 M5 M33 M3 M4 M975000.0
Intangibles5 M6 M39 M33 M17 M13 M10 M14 M11 M9 M
Invested capital491 M596 M706 M807 M1,109 M1,076 M930 M1,003 M879 M797 M
LongTermCapitalLeaseObligation175 M149 M128 M87 M
LongTermDebtAndCapitalLeaseObligation5 M8 M12 M18 M175 M149 M128 M87 M
LongTermProvisions21 M25 M32 M15 M25 M
Net fixed assets (net PP&E)31 M63 M80 M92 M104 M115 M309 M270 M225 M175 M
Non-current deferred income taxes7 M11 M29 M30 M13 M17 M-16 M-16 M-15 M-14 M
NonCurrentDeferredTaxesAssets39 M42 M53 M124 M53 M63 M115 M121 M127 M176 M
NonCurrentPensionAndOtherPostretirementBenefitPlans907000.0817000.01 M
Number of employees4400.04400.04400.04400.04400.04400.04400.04400.04400.04400.0
Other current assets306000.016 M5 M10 M18 M33 M41 M48 M53 M60 M
Other equity adjustments3 M-6 M-14 M-16 M-8 M-11 M
Other fixed assets309 M270 M225 M175 M
Other non-current assets3 M18 M20 M28 M59 M82 M60 M50 M65 M134 M
Other non-current liabilities835000.0706000.0725000.04 M4 M7 M8 M7 M36 M
Other receivable851 M943 M1,014 M873 M1,032 M1,194 M
OtherCurrentLiabilities2 M6 M300000.0500000.035 M41 M58 M50 M67 M
OtherPayable2 M14 M73 M61 M385000.026 M26 M
Payables3 M1 M3 M20 M9 M61 M72 M88 M120 M138 M
Preferred securities of subsidiary trust10 M10 M10 M10 M10 M10 M
PreferredStock10 M10 M10 M10 M10 M10 M
Prepaid expenses6 M19 M20 M13 M16 M17 M14 M28 M58 M63 M
RecievablesAdjustmentsAllowances-810000.0-2 M-3 M-5 M-9 M-9 M-8 M-12 M-7 M-9 M
Restricted cash192 M597 M481 M307 M
Retained earnings-70 M-34 M-67 M-70 M79 M-53 M-505 M-541 M-771 M-939 M
SecuritySoldNotYetRepurchased13 M187 M481 M24 M263 M200 M
Total assets516 M630 M755 M885 M1,226 M1,176 M1,071 M1,155 M1,051 M1,016 M
Total current assets417 M421 M443 M561 M913 M860 M533 M713 M645 M596 M
Total current liabilities25 M34 M50 M60 M86 M65 M134 M143 M164 M183 M
Total equity486 M588 M694 M807 M1,109 M1,076 M755 M855 M751 M710 M
Total liabilities29 M42 M62 M78 M117 M100 M316 M300 M299 M306 M
Total non-current assets99 M192 M312 M324 M313 M315 M537 M442 M406 M420 M
Total non-current liabilities5 M8 M12 M18 M31 M35 M182 M157 M135 M123 M
TotalEquityGrossMinority486 M588 M694 M807 M1,109 M1,076 M755 M855 M751 M710 M
TotalEquityGrossMinorityInterest486 M588 M694 M807 M1,109 M1,076 M755 M855 M751 M710 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest516 M630 M755 M885 M1,226 M1,176 M1,071 M1,155 M1,051 M1,016 M
TotalNonCurrentLiabilitiesNetMinorityInteres5 M8 M12 M18 M31 M35 M182 M157 M135 M123 M
Treasury stock-46000.0187 M-481 M-3 M-263 M-200 M
Working capital392 M387 M394 M501 M827 M795 M399 M570 M481 M413 M
ltinv39 M8 M25 M53 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