Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Johnson Controls International plc logo

Johnson Controls International plc

Sector: Industrials   

Industry: Engineering & Construction

63.77
 
USD
  
0.08
  
(0.13%)
Optionable: Yes  Market Cap: 43,771 M  90-day average vol: 5,507,347

Previous close: 63.69  Open: 64.13  Bid: 63.03  Ask: 63.77
52 week range    
47.90   
   70.43
Peers   
LEA / 
HON / 
BWA / 
MGA / 
ALV / 
GNTX / 
VC / 
EMR / 
THRM / 
Last updated: Friday 19th April 2024
56
MarketXLS Rank
75
Value
53
Technical
42
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

JCI Balance Sheet

Annual
Sep-14Sep-15Sep-16Sep-17Sep-18Sep-19Sep-20Sep-21Sep-22Sep-23
"""debtc"""20 M865 M1,706 M1,608 M1,307 M511 M293 M234 M1,534 M1,030 M
Accounts payable825 M5,174 M4,000 M4,271 M3,407 M3,582 M3,120 M3,746 M4,368 M4,268 M
Accounts receivable1,734 M5,751 M6,394 M6,666 M5,622 M5,770 M5,294 M5,613 M5,727 M6,006 M
Accrued expenses825 M6,264 M4,000 M4,271 M3,407 M3,582 M3,120 M3,746 M4,368 M4,268 M
Accumulated depreciation & depletion-2,750 M-2,553 M-3,417 M-4,092 M-2,163 M-2,496 M-2,871 M-3,287 M-3,407 M-3,985 M
Additional paid in capital3,306 M3,740 M16,105 M16,390 M16,549 M16,812 M16,865 M17,116 M17,224 M17,349 M
Building & improvements2,107 M2,445 M1,213 M1,499 M1,351 M1,313 M1,320 M1,337 M
Cash and equivalents892 M597 M579 M321 M185 M2,805 M1,951 M1,336 M2,031 M835 M
CashCashEquivalentsAndShortTermInvestments892 M597 M579 M321 M185 M2,805 M1,951 M1,336 M2,031 M835 M
CashEquivalents597 M400 M392 M377 M366 M368 M
Common par208 M7 M9 M9 M10 M8 M8 M7 M7 M7 M
Common stock equity4,439 M10,335 M24,118 M20,447 M21,164 M19,766 M17,447 M17,562 M16,268 M16,545 M
CommonStock4,647 M7 M9 M9 M10 M8 M8 M7 M7 M7 M
Construction in progress990 M1,252 M704 M465 M327 M500 M514 M540 M
Cost in excess4,122 M6,824 M21,024 M19,688 M18,381 M18,178 M17,932 M18,335 M17,350 M17,936 M
CurrentAccruedExpenses1,090 M1,763 M1,071 M1,146 M953 M838 M
CurrentCapitalLeaseObligation185 M183 M24 M19 M348 M352 M319 M280 M318 M
CurrentDeferredAssets304 M62 M
CurrentDeferredRevenue400 M382 M1,228 M1,279 M1,326 M1,407 M1,435 M1,637 M1,804 M1,996 M
CurrentDeferredTaxesAssets304 M62 M2,849 M2,770 M1,991 M1,404 M2,245 M1,768 M1,832 M2,134 M
CurrentDeferredTaxesLiabilities2,403 M2,327 M1,924 M2,143 M1,453 M1,440 M1,768 M-1,456 M-1,381 M1,088 M
CurrentProvisions346 M15 M10 M10 M52 M61 M48 M66 M31 M
Deferred revenues400 M382 M1,228 M1,279 M1,326 M1,407 M1,435 M1,637 M1,804 M1,996 M
DeferredFinancingCosts34 M32 M33 M35 M
DefinedPensionBenefit1,922 M1,805 M
DividendsPayable-316 M257 M-752 M-938 M-968 M-887 M-780 M-771 M
EmployeeBenefits767 M1,550 M947 M616 M1,044 M1,140 M628 M358 M278 M
Finished goods381 M378 M1,533 M1,723 M1,058 M1,050 M1,002 M1,122 M1,422 M1,347 M
Float term debt1,443 M5,745 M11,053 M11,964 M9,623 M6,708 M7,526 M7,506 M7,426 M7,818 M
GoodwillAndOtherIntangibleAssets4,834 M8,340 M28,564 M26,429 M24,568 M23,810 M23,288 M23,884 M22,505 M22,824 M
Gross fixed assets (Plant Property & Equipment)4,012 M3,742 M9,049 M10,213 M5,463 M5,844 M5,930 M6,515 M6,538 M7,121 M
IncomeTaxPayable1,505 M625 M336 M159 M243 M201 M143 M249 M
Intangibles712 M1,516 M7,540 M6,741 M6,187 M5,632 M5,356 M5,549 M5,155 M4,888 M
InterestPayable-97 M102 M293 M466 M409 M335 M240 M219 M225 M
Inventories625 M2,377 M2,888 M3,209 M1,819 M1,814 M1,773 M2,057 M2,665 M2,776 M
Invested capital7,325 M6,645 M46,224 M44,375 M40,410 M33,182 M32,499 M32,574 M31,120 M32,181 M
Land & improvements367 M373 M258 M250 M241 M231 M197 M194 M
LongTermCapitalLeaseObligation1,291 M1,055 M987 M1,583 M
LongTermDebtAndCapitalLeaseObligation1,443 M5,745 M11,053 M11,964 M9,623 M6,708 M7,526 M7,506 M7,426 M7,818 M
LongTermProvisions487 M548 M573 M550 M507 M483 M458 M438 M422 M
Machinery furniture & equipment5,137 M5,572 M2,715 M2,969 M3,332 M3,669 M3,745 M4,227 M
Minority interest36 M375 M1,206 M1,131 M1,294 M1,063 M1,086 M1,191 M1,134 M1,149 M
Net fixed assets (net PP&E)1,262 M5,870 M5,632 M6,121 M3,300 M3,348 M3,059 M3,228 M3,131 M3,136 M
Non-current deferred income taxes92 M78 M-1,542 M-1,733 M-727 M588 M385 M
NonCurrentDeferredLiabilities335 M303 M
NonCurrentDeferredRevenue335 M303 M
NonCurrentDeferredTaxesAssets3,047 M3,172 M6,249 M6,608 M7,079 M6,472 M7,763 M7,621 M7,805 M8,512 M
NonCurrentPensionAndOtherPostretirementBenefitPlans417 M767 M1,550 M947 M616 M1,044 M1,140 M628 M358 M278 M
Number of employees85300.085300.085300.085300.085300.085300.085300.085300.085300.085300.0
Other current assets180 M1,744 M7,248 M2,096 M4,197 M2,004 M1,035 M992 M1,262 M1,120 M
Other equity adjustments-1,057 M-795 M-776 M
Other fixed assets1,262 M5,632 M6,121 M3,300 M3,348 M3,059 M3,228 M3,131 M3,136 M
Other non-current assets927 M2,800 M10,884 M5,851 M8,258 M1,883 M3,501 M3,714 M3,874 M4,489 M
Other non-current liabilities1,871 M1,954 M5,033 M5,368 M4,643 M4,636 M5,368 M5,905 M5,733 M5,368 M
Other receivable21 M841 M908 M23,400 M23,968 M22,317 M23,668 M25,299 M26,793 M
OtherCurrentBorrowings20 M52 M1,078 M1,214 M1,306 M10 M31 M8 M669 M385 M
OtherCurrentLiabilities2,232 M3,275 M5,121 M4,624 M3,419 M3,526 M3,400 M3,481 M3,533 M3,790 M
OtherInventories625 M2,888 M3,209 M1,819 M1,814 M1,773 M2,057 M2,665 M2,776 M
OtherPayable-66 M583 M353 M6 M21 M25 M77 M725 M269 M726 M
Payables825 M5,174 M4,000 M4,271 M3,407 M3,582 M3,120 M3,746 M4,368 M4,268 M
Preferred securities of subsidiary trust100 M
PreferredStock100 M
Prepaid expenses1,051 M776 M
Raw materials159 M165 M852 M919 M606 M588 M629 M769 M1,040 M1,203 M
RecievablesAdjustmentsAllowances-67 M-71 M-173 M-182 M-169 M-173 M-173 M-110 M-66 M-90 M
Restricted cash400 M392 M377 M366 M368 M378 M300 M301 M
Retained earnings3,648 M10,797 M8,024 M4,758 M5,658 M4,032 M1,693 M1,591 M240 M429 M
SecuritySoldNotYetRepurchased1,833 M417 M-501 M651 M300 M5,983 M2,204 M
Short term debt20 M865 M1,706 M1,608 M1,307 M511 M293 M234 M1,534 M1,030 M
TaxesReceivable257 M1,069 M252 M120 M253 M65 M
Total assets11,809 M29,622 M63,179 M51,884 M48,797 M42,114 M40,815 M41,890 M42,158 M42,242 M
Total current assets4,786 M10,469 M17,109 M12,292 M11,823 M12,220 M10,053 M9,998 M11,685 M10,737 M
Total current liabilities3,477 M10,404 M12,055 M11,782 M9,459 M9,026 M8,248 M9,098 M11,239 M11,084 M
Total equity4,439 M10,335 M24,118 M20,447 M21,164 M19,766 M17,447 M17,562 M16,268 M16,545 M
Total liabilities7,126 M18,912 M37,855 M30,306 M26,339 M21,458 M22,282 M23,137 M24,756 M24,548 M
Total non-current assets7,023 M19,153 M46,070 M39,592 M36,974 M29,894 M30,762 M31,892 M30,473 M31,505 M
Total non-current liabilities3,649 M8,508 M25,800 M18,524 M16,880 M12,432 M14,034 M14,039 M13,517 M13,464 M
TotalEquityGrossMinority4,475 M10,710 M25,324 M21,578 M22,458 M20,829 M18,533 M18,753 M17,402 M17,694 M
TotalEquityGrossMinorityInterest4,475 M10,710 M25,324 M21,578 M22,458 M20,829 M18,533 M18,753 M17,402 M17,694 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest11,601 M29,622 M63,179 M51,884 M48,797 M42,287 M40,815 M41,890 M42,158 M42,242 M
TotalNonCurrentLiabilitiesNetMinorityInteres3,649 M8,508 M25,800 M18,524 M16,880 M12,432 M14,034 M14,039 M13,517 M13,464 M
Treasury stock-2,515 M-3,152 M-20 M-710 M-1,053 M-1,086 M-1,119 M-1,152 M-1,203 M-1,240 M
Work in progress85 M84 M503 M567 M155 M176 M142 M166 M203 M226 M
Working capital1,309 M65 M5,054 M510 M2,364 M3,194 M1,805 M900 M446 M-347 M
ltinv2,143 M990 M1,191 M848 M853 M914 M1,066 M963 M1,056 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