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

TREE Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Accounts payable1 M6 M6 M9 M15 M3 M10 M2 M2 M2 M
Accounts receivable14 M30 M41 M53 M91 M113 M90 M98 M83 M55 M
Accrued expenses27 M41 M55 M86 M108 M116 M111 M108 M77 M73 M
Accumulated depreciation & depletion-15 M-7 M-10 M-13 M-14 M-18 M-20 M-31 M-34 M-39 M
Additional paid in capital910 M1,007 M1,018 M1,088 M1,134 M1,178 M1,189 M1,243 M1,189 M1,228 M
Cash and equivalents105 M214 M95 M373 M105 M60 M170 M251 M299 M112 M
CashCashEquivalentsAndShortTermInvestments105 M214 M95 M373 M105 M60 M170 M251 M299 M112 M
CashEquivalents105 M214 M95 M373 M105 M60 M170 M251 M
Common par129000.0139000.0140000.0142000.0154000.0157000.0158000.0161000.0162000.0164000.0
Common stock equity96 M241 M231 M295 M346 M402 M365 M448 M208 M124 M
CommonStock129000.0139000.0140000.0142000.0154000.0157000.0158000.0161000.0162000.0164000.0
Cost in excess4 M4 M56 M113 M348 M420 M420 M420 M420 M382 M
CurrentAccruedExpenses26 M35 M49 M77 M93 M113 M101 M107 M75 M71 M
CurrentCapitalLeaseObligation1 M2 M1 M2 M4 M7 M5 M9 M9 M7 M
CurrentDeferredRevenue400000.0600000.0700000.0800000.0900000.0
CurrentDeferredTaxesAssets21 M15 M20 M79 M88 M96 M88 M
CurrentDeferredTaxesLiabilities5 M2 M3 M2 M82 M96 M112 M102 M-54 M-21 M
Float term debt238 M251 M264 M611 M478 M902 M601 M
GoodwillAndOtherIntangibleAssets15 M15 M128 M194 M554 M602 M549 M506 M478 M432 M
Gross fixed assets (Plant Property & Equipment)20 M16 M45 M49 M37 M75 M167 M180 M160 M146 M
Intangibles11 M11 M72 M81 M206 M182 M129 M86 M58 M51 M
InterestPayable2000.012 M20 M36 M47 M-26 M22 M
Invested capital96 M241 M231 M833 M897 M1,210 M926 M1,923 M1,250 M
LineOfCredit200000.0200000.0200000.0200000.0200000.0
LongTermCapitalLeaseObligation21 M92 M96 M88 M75 M
LongTermDebtAndCapitalLeaseObligation238 M251 M286 M704 M574 M902 M601 M
LongTermProvisions206000.0337000.0515000.0195000.0880000.02 M2 M2 M4 M2 M
Minority interest589000.0
Net fixed assets (net PP&E)5 M9 M35 M36 M23 M57 M146 M150 M126 M108 M
Non-current deferred income taxes5 M453000.01 M1 M894000.05 M5 M2 M7 M2 M
NonCurrentDeferredAssets21 M15 M20 M79 M88 M96 M88 M
NonCurrentDeferredLiabilities5 M894000.02 M7 M2 M
NonCurrentDeferredTaxesAssets40 M21 M15 M20 M79 M88 M96 M88 M193 M181 M
Number of employees1425.01425.01425.01425.01425.01425.01425.01425.01425.01425.0
Other current assets189000.0110000.023 M75000.022 M84000.09 M3 M6 M3 M
Other fixed assets126 M108 M
Other non-current assets202000.05 M5 M4 M5 M12 M21 M24 M6 M6 M
Other non-current liabilities586000.025 M13 M36 M29 M9 M351000.0308000.0267000.0
Other receivable4 M2 M2 M
OtherCurrentLiabilities12 M13 M12 M61 M29 M40 M536000.01000.03 M15 M
Payables1 M6 M6 M9 M15 M3 M10 M2 M2 M2 M
Preferred securities of subsidiary trust5 M5 M
PreferredStock5 M5 M
Prepaid expenses931000.02 M4 M12 M16 M16 M28 M25 M26 M29 M
RecievablesAdjustmentsAllowances-349000.0-606000.0-1 M-675000.0-1 M-1 M-1 M-1 M-2 M-2 M
Restricted cash124000.05000.0
Retained earnings-798 M-750 M-723 M-708 M-610 M-593 M-641 M-572 M-715 M-838 M
Short term debt125 M75 M166 M3 M3 M
Total assets140 M296 M323 M693 M896 M948 M1,189 M1,299 M1,199 M803 M
Total current assets120 M246 M141 M438 M234 M189 M296 M374 M414 M196 M
Total current liabilities39 M54 M67 M148 M262 M231 M112 M274 M83 M76 M
Total equity96 M241 M231 M295 M346 M402 M365 M448 M208 M124 M
Total liabilities44 M55 M92 M399 M550 M546 M824 M851 M991 M679 M
Total non-current assets20 M50 M183 M255 M662 M759 M893 M925 M785 M606 M
Total non-current liabilities5 M612000.025 M251 M288 M315 M712 M577 M909 M603 M
TotalEquityGrossMinority96 M241 M231 M295 M346 M402 M365 M448 M208 M124 M
TotalEquityGrossMinorityInterest96 M241 M231 M295 M346 M402 M365 M448 M208 M124 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest140 M296 M323 M693 M896 M948 M1,189 M1,299 M1,199 M803 M
TotalNonCurrentLiabilitiesNetMinorityInteres5 M612000.025 M251 M288 M315 M712 M577 M909 M603 M
Treasury stock-15 M-16 M-64 M-85 M-178 M-183 M-183 M-223 M-266 M-266 M
Working capital81 M192 M74 M291 M-28 M-41 M185 M100 M331 M121 M
debtc125 M75 M166 M3 M3 M
ltinv80 M158 M175 M60 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