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

Financials

ASR Balance Sheet

Annual
Invalid dateDec-17Dec-18Dec-19Dec-20Dec-21Dec-22
Accounts payable1,762 M1,871 M1,799 M1,598 M2,489 M2,815 M
Accounts receivable686 M793 M1,004 M1,358 M1,878 M2,542 M
Accrued expenses1,895 M1,908 M2,010 M1,628 M3,208 M3,694 M
Additional paid in capital39,689 M41,606 M42,825 M45,258 M53,330 M
AllowanceForLoansAndLeaseLosses173 M180 M192 M346 M302 M
Cash and equivalents106 M47 M166 M14 M134 M10 M
CashCashEquivalentsAndShortTermInvestments106 M47 M166 M14 M134 M10 M
CashEquivalents106 M47 M166 M5 M123 M5,507 M
Common stock equity26,040 M10,110 M10,220 M12,453 M37,177 M41,621 M
Cost in excess2,362 M2,362 M2,567 M2,567 M2,469 M
CurrentCapitalLeaseObligation127 M248 M20 M17 M24 M
CurrentDeferredTaxesAssets302 M304 M258 M260 M
CurrentDeferredTaxesLiabilities-3,034 M3,191 M
Float term debt7,149,177 M6,958 M6,489 M6,642 M6,598 M9,892 M
GoodwillAndOtherIntangibleAssets637 M49,586 M49,126 M52,182 M53,973 M52,658 M
Gross fixed assets (Plant Property & Equipment)473 M558 M521 M504 M185 M171 M
IncomeTaxPayable157 M230 M176 M57 M574 M
Intangibles415 M
InterestPayable340 M
Inventories50 M49 M50 M34 M57 M65 M
Invested capital7,175,217 M17,067 M16,708 M19,095 M43,775 M51,513 M
LongTermDebtAndCapitalLeaseObligation7,149,177 M6,958 M6,489 M6,642 M6,598 M9,892 M
LongTermProvisions13 M10 M17 M24 M28 M33 M
Minority interest7,648 M7,575 M7,613 M8,027 M8,594 M7,395 M
Net fixed assets (net PP&E)473 M558 M521 M504 M185 M171 M
NetUnrealizedGainLossForeignCurrency18.018.019.019.0
Non-current deferred income taxes-3,361 M
NonCurrentDeferredTaxesAssets327 M304 M218 M
Number of employees1777.01777.01777.01777.01777.01777.0
Other current assets185 M182 M161 M222 M311 M286 M
Other non-current liabilities29,250 M29,121 M30,618 M22,730 M30,959 M28,400 M
Other receivable437000.0809000.0284000.0197000.0105 M149 M
OtherCurrentBorrowings173 M176 M238 M809 M1,493 M
OtherCurrentLiabilities514 M500 M550 M8,906 M578 M1,493 M
OtherPayable429 M314 M245 M354 M307 M
Patents6,054 M6,054 M
Payables1,895 M1,908 M2,010 M1,628 M3,208 M3,694 M
Restricted cash1,421 M
Retained earnings10,145 M10,110 M10,220 M12,453 M15,865 M20,014 M
TaxesReceivable83 M346 M273 M904 M417 M444 M
Total assets56,614 M51,597 M51,323 M55,219 M65,831 M70,920 M
Total current assets5,788 M1,416 M1,653 M2,532 M11,662 M18,080 M
Total current liabilities2,409 M2,408 M2,560 M10,534 M3,786 M5,564 M
Total equity26,040 M10,110 M10,220 M12,453 M37,177 M41,621 M
Total liabilities22,926 M38,497 M39,683 M39,931 M20,061 M21,904 M
Total non-current assets1,110 M50,181 M49,670 M52,687 M54,158 M52,829 M
Total non-current liabilities7,178,440 M36,089 M37,123 M29,396 M37,586 M38,324 M
TotalEquityGrossMinority33,688 M17,685 M17,833 M20,481 M45,770 M49,016 M
TotalEquityGrossMinorityInterest33,688 M17,685 M17,833 M20,481 M45,770 M49,016 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest56,614 M56,182 M57,516 M60,411 M65,831 M70,920 M
TotalNonCurrentLiabilitiesNetMinorityInteres7,178,440 M36,089 M37,123 M29,396 M37,586 M38,324 M
TotalTaxPayable133 M37 M211 M30 M719 M879 M
Working capital3,379 M-992 M-907 M-8,002 M7,876 M12,516 M
ltinv583 M811 M804 M640 M916 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