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

JHG Balance Sheet

Annual
Invalid dateDec-17Dec-18Dec-19Dec-20Dec-21Dec-22
Accounts payable271 M233 M
Accrued expenses692 M579 M582 M603 M271 M233 M
Accumulated depreciation & depletion-49 M-63 M-72 M-123 M-94 M-90 M
Additional paid in capital3,843 M3,825 M3,829 M3,815 M3,772 M3,707 M
Common par301 M295 M281 M271 M254 M249 M
Common stock equity4,837 M4,839 M4,887 M4,694 M4,624 M4,360 M
CommonStock301 M295 M281 M271 M254 M249 M
Cost in excess1,534 M1,478 M1,504 M1,384 M1,342 M1,253 M
CurrentAccruedExpenses399 M345 M336 M371 M
CurrentCapitalLeaseObligation36 M33 M25 M27 M28 M24 M
CurrentDeferredTaxesAssets74 M81 M118 M116 M118 M108 M
CurrentDeferredTaxesLiabilities795 M784 M790 M677 M-729 M-681 M
DividendsPayable270 M1.01.0-256 M-259 M
EmployeeBenefits5 M4 M4 M5 M5 M3 M
Float term debt322 M319 M316 M313 M310 M308 M
GoodwillAndOtherIntangibleAssets4,739 M4,601 M4,593 M4,070 M3,884 M3,668 M
Gross fixed assets (Plant Property & Equipment)120 M132 M157 M201 M158 M142 M
IncomeTaxPayable34 M28 M13 M20 M18 M15 M
Intangibles3,205 M3,123 M3,089 M2,686 M2,543 M2,415 M
Invested capital5,252 M5,254 M5,203 M5,008 M5,244 M4,975 M
Leases2 M2 M
LongTermCapitalLeaseObligation154 M145 M133 M96 M
LongTermDebtAndCapitalLeaseObligation322 M319 M316 M313 M310 M308 M
LongTermProvisions23 M55 M59 M54 M46 M47 M
Minority interest229 M158 M698 M103 M179 M237 M
Net fixed assets (net PP&E)71 M70 M85 M78 M63 M52 M
Non-current deferred income taxes753 M730 M729 M627 M619 M575 M
NonCurrentAccruedExpenses14 M11 M15 M16 M20 M23 M
NonCurrentDeferredLiabilities753 M730 M729 M627 M619 M575 M
NonCurrentDeferredRevenue39 M11 M
NonCurrentDeferredTaxesAssets131 M137 M174 M181 M202 M176 M
NonCurrentPensionAndOtherPostretirementBenefitPlans5 M4 M4 M5 M5 M3 M
Number of employees2235.02235.02235.02235.02235.02235.0
Other current assets76 M69 M116 M111 M150 M120 M
Other equity adjustments-302 M-423 M-367 M-324 M
Other fixed assets63 M52 M
Other non-current assets22 M307 M403 M158 M181 M206 M
Other non-current liabilities100 M223 M159 M266 M134 M99 M
Other receivable660 M454 M467 M488 M436 M319 M
OtherCurrentLiabilities235 M32 M131 M43 M512 M374 M
OtherPayable293 M233 M246 M232 M
Payables293 M233 M246 M232 M271 M233 M
Prepaid expenses24 M23 M27 M35 M38 M42 M
Retained earnings1,151 M1,315 M1,284 M1,062 M653 M413 M
Short term debt57 M
TaxesReceivable4 M4 M10 M2 M11 M31 M
Total assets7,273 M6,912 M7,622 M6,665 M6,702 M6,238 M
Total current assets2,243 M2,019 M2,581 M2,194 M2,409 M2,215 M
Total current liabilities1,005 M728 M770 M725 M786 M611 M
Total equity4,837 M4,839 M4,887 M4,694 M4,624 M4,360 M
Total liabilities2,207 M1,915 M2,038 M1,868 M1,900 M1,641 M
Total non-current assets5,030 M5,185 M5,294 M4,497 M4,293 M4,023 M
Total non-current liabilities1,202 M1,330 M1,268 M1,265 M1,115 M1,031 M
TotalEquityGrossMinority4,876 M4,861 M4,906 M4,712 M4,639 M4,363 M
TotalEquityGrossMinorityInterest4,876 M4,861 M4,906 M4,712 M4,639 M4,363 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest7,273 M6,912 M7,622 M6,665 M6,702 M6,238 M
TotalNonCurrentLiabilitiesNetMinorityInteres1,202 M1,330 M1,268 M1,265 M1,115 M1,031 M
Treasury stock-156 M-171 M-139 M-107 M-55 M-8 M
UnearnedIncome199 M207 M214 M191 M165 M98 M
Working capital1,238 M1,291 M1,811 M1,469 M1,624 M1,604 M
debtc57 M
ltinv700 M575 M1,178 M483 M702 M596 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