Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Jones Lang LaSalle Incorporated logo

Jones Lang LaSalle Incorporated

Sector: Real Estate   

Industry: Real Estate Services

185.52
 
USD
  
1.53
  
(0.83%)
Optionable: Yes  Market Cap: 8,573 M  90-day average vol: 266,323

Previous close: 183.99  Open: 188.04  Bid:   Ask:
52 week range    
119.46   
   200.14
Peers   
JCI / 
FSV-CA / 
JOE / 
Last updated: Sunday 5th May 2024
62
MarketXLS Rank
55
Value
76
Technical
57
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

JLL Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
"""debtc"""312 M670 M387 M351 M669 M1,664 M1,224 M612 M825 M
Accounts payable1,023 M1,091 M1,246 M2,384 M2,613 M2,816 M3,204 M
Accounts receivable1,375 M1,592 M1,871 M3,003 M3,395 M3,706 M3,097 M3,739 M4,155 M4,418 M
Accrued expenses1,802 M1,911 M3,435 M3,957 M4,264 M2,384 M2,613 M2,816 M3,204 M
Accumulated depreciation & depletion-418 M-449 M-488 M-515 M-588 M-661 M-806 M-909 M-960 M-1,039 M
Additional paid in capital987 M1,013 M1,038 M1,057 M1,963 M2,023 M2,054 M2,023 M2,020 M
Cash and equivalents250 M217 M259 M268 M481 M452 M574 M594 M519 M410 M
CashCashEquivalentsAndShortTermInvestments250 M217 M259 M268 M481 M452 M574 M594 M519 M410 M
CashEquivalents250 M217 M259 M268 M481 M452 M
Common par-6 M-5 M-5 M-5 M-5 M-5 M-5 M-9 M-10 M
Common stock equity2,689 M2,790 M3,340 M3,692 M5,118 M5,521 M6,185 M6,021 M6,294 M
CommonStock100 M-6 M-5 M-5 M-5 M-5 M-5 M-5 M-9 M-10 M
Cost in excess1,908 M2,142 M2,579 M2,709 M2,698 M4,168 M4,225 M4,612 M4,528 M4,587 M
CurrentAccruedExpenses1,089 M1,065 M1,419 M1,605 M1,729 M
CurrentCapitalLeaseObligation138 M144 M158 M173 M168 M153 M166 M154 M156 M162 M
CurrentDeferredAssets246 M267 M173 M230 M258 M350 M446 M529 M518 M604 M
CurrentDeferredRevenue115 M130 M155 M190 M159 M193 M208 M217 M226 M
CurrentDeferredTaxesAssets135 M133 M351 M358 M350 M422 M513 M580 M616 M774 M
CurrentDeferredTaxesLiabilities193 M21 M191 M192 M177 M283 M337 M429 M431 M453 M
CurrentProvisions74 M51 M
Deferred revenues136 M130 M155 M190 M159 M193 M208 M217 M226 M
DividendsPayable22 M43 M
Float term debt285 M512 M273 M691 M672 M665 M1,386 M1,110 M1,149 M1,534 M
GoodwillAndOtherIntangibleAssets1,947 M2,369 M2,874 M3,014 M3,035 M4,851 M4,905 M5,499 M5,387 M5,372 M
Gross fixed assets (Plant Property & Equipment)787 M873 M989 M1,059 M1,156 M2,167 M2,178 M2,373 M2,320 M2,384 M
IncomeTaxPayable104 M88 M80 M109 M215 M231 M201 M221 M214 M370 M
Intangibles39 M227 M295 M305 M337 M683 M680 M887 M859 M785 M
InterestPayable-40 M-75 M-135 M
Invested capital285 M3,201 M3,062 M4,031 M4,363 M5,783 M7,609 M7,691 M7,542 M8,607 M
LineOfCredit22 M18 M18 M9 M9 M800000.0700000.0700000.0400000.0400000.0
LoansReceivable527 M1,529 M822 M463 M677 M
LongTermCapitalLeaseObligation751 M684 M714 M776 M755 M
LongTermDebtAndCapitalLeaseObligation512 M273 M691 M672 M1,416 M1,386 M1,110 M1,149 M1,534 M
LongTermProvisions43 M905 M-15 M-16 M513 M-9 M138 M1,214 M611 M
Minority interest13 M41 M32 M42 M43 M95 M97 M236 M129 M116 M
Net fixed assets (net PP&E)368 M423 M501 M544 M568 M1,506 M1,371 M1,463 M1,359 M1,345 M
NetOtherUnrealizedGainLoss7 M21 M17 M28 M14 M35 M-1000000.0201 M61 M-198 M
Non-current deferred income taxes6 M33 M22 M63 M33 M106 M120 M180 M194 M45 M
NonCurrentAccountsReceivable86 M135 M176 M165 M199 M250 M231 M316 M331 M364 M
NonCurrentAccruedExpenses13 M
NonCurrentDeferredAssets91 M87 M181 M229 M210 M245 M297 M331 M380 M497 M
NonCurrentDeferredLiabilities189 M223 M322 M311 M480 M570 M705 M686 M625 M
NonCurrentDeferredTaxesAssets91 M87 M181 M229 M210 M245 M297 M331 M380 M497 M
NotesReceivable181 M267 M327 M385 M363 M473 M470 M389 M470 M446 M
Number of employees98200.098200.098200.098200.098200.098200.098200.098200.098200.098200.0
Other current assets28 M99 M161 M220 M247 M424 M460 M562 M695 M698 M
Other equity adjustments-200 M-336 M-551 M-341 M-456 M-428 M
Other fixed assets1,371 M1,463 M1,359 M1,345 M
Other non-current assets57 M76 M69 M156 M193 M197 M182 M234 M176 M209 M
Other non-current liabilities119 M263 M396 M561 M563 M560 M686 M644 M483 M588 M
Other receivable83 M265 M601 M318 M331 M587 M460 M601 M593 M594 M
OtherCurrentBorrowings20 M312 M670 M387 M351 M516 M1,498 M796 M455 M663 M
OtherCurrentLiabilities8 M201 M227 M337 M264 M398 M1,825 M2,441 M2,268 M2,044 M
OtherEquityInterest63 M
OtherPayable157 M713 M846 M993 M1,261 M1,289 M-500000.06 M14 M
Payables713 M846 M2,016 M2,352 M2,535 M2,384 M2,613 M2,816 M3,204 M
Prepaid expenses65 M78 M82 M389 M322 M378 M517 M501 M604 M567 M
Properties3,400 M4,000 M4,400 M4,600 M4,600 M5,100 M
RecievablesAdjustmentsAllowances-18 M-68 M-66 M-68 M-67 M-71 M
Retained earnings8.02,044 M2,333 M2,649 M3,096 M3,588 M3,599 M4,542 M4,942 M5,204 M
Short term debt312 M670 M387 M351 M516 M1,498 M1,070 M455 M663 M
TaxesReceivable59 M90 M121 M145 M156 M235 M222 M187 M215 M216 M
Total assets5,075 M6,187 M7,629 M9,254 M10,026 M13,673 M14,317 M15,505 M15,594 M16,065 M
Total current assets2,118 M2,651 M3,300 M4,541 M5,206 M5,869 M6,454 M6,388 M6,570 M6,857 M
Total current liabilities2,505 M2,966 M4,314 M4,762 M5,490 M6,128 M6,487 M5,912 M6,446 M
Total equity2,689 M2,790 M3,340 M3,692 M5,118 M5,521 M6,185 M6,021 M6,294 M
Total liabilities2,653 M3,458 M4,808 M5,872 M6,291 M8,459 M8,699 M9,084 M9,444 M9,655 M
Total non-current assets2,846 M3,402 M4,157 M4,484 M4,561 M7,454 M7,417 M8,589 M8,506 M8,604 M
Total non-current liabilities1,007 M1,796 M1,559 M1,529 M2,969 M2,633 M2,597 M3,532 M3,357 M
TotalEquityGrossMinority2,718 M2,815 M3,378 M3,735 M5,205 M5,610 M6,413 M6,143 M6,410 M
TotalEquityGrossMinorityInterest2,718 M2,815 M3,378 M3,735 M5,205 M5,610 M6,413 M6,143 M6,410 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest6,187 M7,629 M9,254 M10,026 M13,673 M14,317 M15,505 M15,594 M16,065 M
TotalNonCurrentLiabilitiesNetMinorityInteres1,007 M1,796 M1,559 M1,529 M2,969 M2,633 M2,597 M3,532 M3,357 M
Treasury stock-96 M-406 M-935 M-920 M
Working capital2,118 M146 M333 M227 M444 M378 M326 M-99 M658 M411 M
ltinv297 M312 M355 M376 M357 M404 M431 M746 M874 M817 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