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

Square Inc. Class A

Sector: Technology   

Industry: Software - Application

73.53
 
USD
  
4.06
  
(5.84%)
Optionable: Yes  Market Cap: 44,946 M  90-day average vol: 10,108,618

Previous close: 69.47  Open: 70.24  Bid: 73.16  Ask: 73.35
52 week range    
38.85   
   87.52
Peers   
OCFT / 
NVEI-CA / 
NTPY / 
Last updated: Tuesday 7th May 2024
45
MarketXLS Rank
40
Value
53
Technical
44
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

SQ Balance Sheet

Annual
Invalid dateDec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
"""debtc"""27 M517 M562 M1,005 M
Accounts payable444 M734 M36 M42 M47 M337 M558 M
Accounts receivable6 M9 M22 M34 M42 M1,261 M4,428 M
Accrued expenses504 M813 M298 M298 M361 M4,825 M6,859 M
Accumulated depreciation & depletion-73 M-101 M-125 M-179 M-228 M-259 M-368 M
Additional paid in capital1,357 M1,630 M2,012 M2,224 M2,955 M3,317 M18,315 M
Cash and equivalents452 M696 M583 M1,047 M3,158 M4,444 M4,544 M
CashCashEquivalentsAndShortTermInvestments512 M866 M1,124 M1,540 M3,853 M5,313 M5,626 M
CashEquivalents474 M725 M617 M1,047 M3,158 M19 M
Common stock equity576 M786 M1,121 M1,715 M2,682 M3,273 M17,223 M
CommonStock576 M786 M1,121 M-1,715 M2,682 M409 M-13,828 M
Cost in excess57 M58 M262 M266 M317 M519 M11,967 M
CurrentAccruedExpenses40 M52 M298 M298 M361 M508 M752 M
CurrentCapitalLeaseObligation17 M19 M28 M27 M53 M64 M67 M
CurrentDeferredRevenue5 M6 M31 M38 M45 M48 M142 M
CurrentDeferredTaxesAssets306000.0519000.08 M8 M207 M418 M571 M
CurrentDeferredTaxesLiabilities-476000.0-644000.0-8 M-7 M-199 M-418 M-689 M
Deferred revenues48 M142 M
DeferredFinancingCosts1 M3 M
Float term debt359 M900 M1,048 M2,977 M4,559 M4,110 M
GoodwillAndOtherIntangibleAssets76 M73 M339 M335 M454 M776 M13,981 M
Gross fixed assets (Plant Property & Equipment)162 M193 M267 M441 M919 M991 M1,070 M
IncomeTaxPayable4 M6 M10 M
Intangibles19 M14 M77 M69 M138 M257 M2,014 M
InterestPayable45 M75 M33 M36 M
Inventories14 M17 M29 M48 M61 M77 M98 M
Invested capital576 M1,503 M2,920 M3,702 M8,245 M12,786 M27,554 M
Leases208 M229 M
LineOfCredit498 M478 M
LoansReceivable42 M73 M90 M165 M463 M609 M598 M
LongTermCapitalLeaseObligation1 M4 M2 M109 M390 M395 M357 M
LongTermDebtAndCapitalLeaseObligation359 M900 M1,048 M2,977 M4,954 M4,467 M
LongTermProvisions149 M
Machinery furniture & equipment333 M468 M
Minority interest41 M28 M
Net fixed assets (net PP&E)88 M91 M142 M262 M690 M732 M702 M
Non-current deferred income taxes476000.0644000.04 M-73 M15 M132 M
NonCurrentDeferredAssets44 M103 M334 M676 M2,038 M2,831 M3,180 M
NonCurrentDeferredLiabilities15 M132 M
NonCurrentDeferredRevenue23 M20 M23 M6 M7 M
NonCurrentDeferredTaxesAssets255 M410 M727 M868 M1,445 M2,306 M2,671 M
NonCurrentPrepaidAssets2 M
NotesReceivable91 M
Number of employees12428.012428.012428.012428.012428.012428.012428.0
Other current assets382 M707 M564 M839 M1,408 M118 M614 M
Other equity adjustments-2 M-1 M-6 M2 M23 M-16 M-523 M
Other fixed assets88 M91 M142 M262 M690 M449 M373 M
Other non-current assets18 M41 M74 M196 M499 M140 M173 M
Other non-current liabilities58 M70 M93 M94 M85 M223 M1,079 M
Other receivable42 M73 M90 M165 M463 M229 M299 M
OtherCurrentBorrowings455000.0460 M
OtherCurrentLiabilities74 M160 M54 M96 M239 M255 M428 M
OtherEquityAdjustments-523 M
OtherInventories14 M17 M29 M48 M61 M77 M98 M
OtherPayable20 M27 M112 M20 M79 M3,980 M5,549 M
Payables464 M761 M749 M4,316 M6,107 M
Preferred securities of subsidiary trust100 M100 M100 M100 M100 M100 M
PreferredStock100 M100 M100 M100 M100 M100 M
Prepaid expenses7 M14 M22 M23 M34 M63 M141 M
Restricted cash22 M29 M34 M39 M4,793 M19 M640 M
Retained earnings-781 M-844 M-892 M-509 M-274 M-28 M-569 M
Short term debt464 M498 M938 M
Total assets1,211 M2,187 M3,281 M4,551 M9,870 M13,926 M31,364 M
Total current assets958 M1,675 M1,778 M2,544 M5,724 M10,521 M15,623 M
Total current liabilities577 M973 M352 M421 M1,117 M5,435 M8,435 M
Total equity576 M786 M1,121 M1,715 M2,682 M3,273 M17,223 M
Total liabilities635 M1,401 M1,494 M1,563 M4,179 M10,612 M14,113 M
Total non-current assets254 M512 M1,503 M2,008 M4,146 M3,405 M15,741 M
Total non-current liabilities58 M428 M1,142 M1,142 M3,062 M5,177 M5,678 M
TotalEquityGrossMinority576 M786 M1,121 M1,715 M2,682 M3,314 M17,251 M
TotalEquityGrossMinorityInterest576 M786 M1,121 M1,715 M2,682 M3,314 M17,251 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest1,211 M2,187 M2,614 M3,278 M6,860 M13,926 M31,364 M
TotalNonCurrentLiabilitiesNetMinorityInteres58 M428 M1,142 M1,142 M3,062 M5,177 M5,678 M
UnearnedIncome149 M
Working capital380 M702 M1,426 M2,123 M4,607 M6,234 M7,686 M
ltinv27 M204 M465 M537 M464 M1,757 M885 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