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

SQ Stock Annual Balance Sheet. Download in Excel

Square Inc. Class A logo

Square Inc. Class A

Sector: Technology   

Industry: Software - Application

91.48
 
USD
  
0.40
  
(0.44%)
Previous close: 91.08  Open: 90.5  Bid: 91.27  Ask: 91.45
52 week range    
55.00   
   99.26
Mkt Cap: 56,453 M  Avg Vol (90 Days): 8,403,852
Peers   
OCFT / 
NVEI-CA / 
NTPY / 
Last updated: Friday 27th December 2024

Stock Rankings

49
MarketXLS Rank
40
Value
61
Technical
47
Quality
How are these ranks calculated?
Search for a stock

Financials

SQ Balance Sheet

Annual
Invalid dateDec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Accounts payable444 M734 M36 M42 M47 M82 M96 M143 M
Accounts receivable6 M9 M22 M34 M42 M90 M141 M135 M
Accrued expenses504 M813 M298 M298 M361 M703 M1,074 M1,326 M
Accumulated depreciation & depletion-73 M-101 M-125 M-179 M-228 M-259 M-368 M-323 M
Additional paid in capital1,357 M1,630 M2,012 M2,224 M2,955 M3,317 M18,315 M19,602 M
Cash and equivalents452 M696 M583 M1,047 M3,158 M4,444 M4,544 M4,996 M
CashCashEquivalentsAndShortTermInvestments512 M866 M1,124 M1,540 M3,853 M5,313 M5,626 M5,848 M
CashEquivalents474 M725 M617 M1,047 M3,158 M
Common stock equity576 M786 M1,121 M1,715 M2,682 M3,273 M17,223 M18,695 M
CommonStock576 M786 M1,121 M-1,715 M2,682 M409 M-13,828 M-7 M
Cost in excess57 M58 M262 M266 M317 M519 M11,967 M11,920 M
CurrentAccruedExpenses40 M52 M298 M298 M361 M703 M1,074 M1,326 M
CurrentCapitalLeaseObligation17 M19 M28 M27 M53 M64 M67 M54 M
CurrentDeferredRevenue5 M6 M31 M38 M45 M48 M
CurrentDeferredTaxesAssets306000.0519000.08 M8 M207 M418 M571 M680 M
CurrentDeferredTaxesLiabilities-476000.0-644000.0-8 M-7 M-199 M-418 M-689 M-706 M
DeferredFinancingCosts1 M3 M
FinancialAssets573 M251 M
Float term debt359 M900 M1,048 M2,977 M4,954 M5,344 M5,265 M
GoodwillAndOtherIntangibleAssets76 M73 M339 M335 M454 M776 M13,981 M13,681 M
Gross fixed assets (Plant Property & Equipment)162 M193 M267 M441 M919 M991 M1,070 M864 M
IncomeTaxPayable4 M6 M10 M
Intangibles19 M14 M77 M69 M138 M257 M2,014 M1,762 M
InterestPayable45 M75 M33 M36 M-47 M
Inventories14 M17 M29 M48 M61 M
Invested capital576 M1,503 M2,920 M3,702 M8,245 M12,786 M27,554 M28,935 M
LoansReceivable42 M73 M90 M165 M463 M518 M474 M775 M
LongTermCapitalLeaseObligation1 M4 M2 M109 M390 M395 M357 M290 M
LongTermDebtAndCapitalLeaseObligation359 M900 M1,048 M2,977 M4,954 M5,344 M5,265 M
LongTermProvisions149 M
Minority interest41 M28 M-2 M
Net fixed assets (net PP&E)88 M91 M142 M262 M690 M732 M702 M541 M
Non-current deferred income taxes476000.0644000.04 M-73 M15 M132 M36 M
NonCurrentDeferredAssets44 M103 M334 M676 M2,038 M2,831 M3,180 M3,170 M
NonCurrentDeferredLiabilities15 M132 M36 M
NonCurrentDeferredRevenue23 M20 M23 M6 M7 M
NonCurrentDeferredTaxesAssets255 M410 M727 M868 M1,445 M2,306 M2,671 M2,681 M
NonCurrentPrepaidAssets2 M
NotesReceivable91 M
Other current assets382 M707 M564 M839 M1,408 M1,859 M4,044 M5,580 M
Other equity adjustments-2 M-1 M-6 M2 M23 M
Other fixed assets88 M91 M142 M262 M690 M732 M702 M541 M
Other non-current assets18 M41 M74 M196 M499 M371 M484 M739 M
Other non-current liabilities58 M70 M93 M94 M85 M208 M202 M155 M
Other receivable42 M73 M90 M165 M463 M
OtherCurrentLiabilities74 M160 M54 M96 M239 M255 M463 M8 M
OtherInventories14 M17 M29 M48 M61 M77 M98 M110 M
OtherPayable20 M27 M112 M20 M79 M
Payables464 M761 M749 M
Preferred securities of subsidiary trust100 M100 M100 M100 M100 M
PreferredStock100 M100 M100 M100 M100 M
Prepaid expenses7 M14 M22 M23 M34 M63 M141 M398 M
Restricted cash22 M29 M34 M39 M4,793 M19 M640 M770 M
Retained earnings-781 M-844 M-892 M-509 M-274 M-44 M-1,092 M-907 M
Short term debt464 M498 M922 M753 M
Total assets1,211 M2,187 M3,281 M4,551 M9,870 M15,026 M31,364 M34,070 M
Total current assets958 M1,675 M1,778 M2,544 M5,724 M11,622 M15,623 M18,857 M
Total current liabilities577 M973 M352 M421 M1,117 M6,536 M8,435 M9,922 M
Total equity576 M786 M1,121 M1,715 M2,682 M3,273 M17,223 M18,695 M
Total liabilities635 M1,401 M1,494 M1,563 M4,179 M11,713 M14,113 M15,377 M
Total non-current assets254 M512 M1,503 M2,008 M4,146 M6,236 M18,921 M18,383 M
Total non-current liabilities58 M428 M1,142 M1,142 M3,062 M5,177 M5,678 M5,455 M
TotalEquityGrossMinority576 M786 M1,121 M1,715 M2,682 M3,314 M17,251 M18,693 M
TotalEquityGrossMinorityInterest576 M786 M1,121 M1,715 M2,682 M3,314 M17,251 M18,693 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest1,211 M2,187 M2,614 M4,551 M9,870 M15,026 M31,364 M34,070 M
TotalNonCurrentLiabilitiesNetMinorityInteres58 M428 M1,142 M1,142 M3,062 M5,177 M5,678 M5,455 M
UnearnedIncome149 M
Working capital380 M702 M1,426 M2,123 M4,607 M5,086 M7,189 M8,936 M
debtc27 M517 M498 M922 M753 M
ltinv27 M204 M465 M537 M464 M1,526 M573 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