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 Cash Flow

Annual
Sep-14Sep-15Sep-16Sep-17Sep-18Sep-19Sep-20Sep-21Sep-22Sep-23
(Increase) Decrease in inventories-14 M-99 M1000000.0-398 M-103 M-72 M45 M-219 M-773 M-81 M
(Increase) Decrease in other current assets-113 M148 M-480 M26 M-99 M-52 M
(Increase) Decrease in other current liabilities-23 M-6 M141 M89 M1000000.0-121 M-29 M-44 M-7 M59 M
(Increase) Decrease in other working capital-20 M-58 M148 M-480 M-171 M-99 M-52 M-164 M-362 M-216 M
(Increase) Decrease in payables-245 M474 M2,478 M-1,909 M1,195 M-1,166 M314 M1,141 M830 M-299 M
(Increase) Decrease in receivables-96 M-297 M-344 M-520 M-475 M-312 M534 M-143 M-427 M-168 M
Acquisitions-65 M-60 M349 M-81 M-21 M-25 M-209 M-725 M-269 M-726 M
AssetImpairmentCharge2 M183 M221 M78 M36 M235 M582 M98 M555 M827 M
CapitalExpenditureReported288 M1,135 M1,249 M1,343 M645 M586 M443 M552 M592 M539 M
Cash at beginning of period563 M553 M579 M332 M200 M2,821 M1,960 M1,342 M2,066 M
Cash at end of period-980 M1,401 M-24 M1,990 M1,549 M4,110 M2,755 M1,960 M2,031 M835 M
Cash flow1,870 M3,275 M1,163 M1,841 M2,869 M3,032 M3,274 M2,318 M1,799 M2,037 M
Cash from disc. financing activities-1,872 M40 M14 M15 M
Cash from disc. investing activities1,789 M-37 M
CashFlowFromContinuingInvestingActivities-221 M432 M-891 M-1,212 M1,568 M-529 M-390 M-1,090 M-693 M-1,184 M
CashFlowFromDiscontinuedOperation1,872 M
CashFromDiscontinuedOperatingActivities-958 M4 M84 M9 M621 M12,035 M-373 M-64 M-4 M
ChangeInAccountPayable-273 M348 M398 M236 M340 M56 M-717 M813 M1,270 M-222 M
ChangeInIncomeTaxPayable28 M126 M2,080 M-2,145 M855 M-1,222 M1,031 M328 M-440 M-77 M
ChangeInPayablesAndAccruedExpense-245 M474 M2,478 M-1,909 M1,195 M-1,166 M314 M1,141 M830 M-299 M
ChangeInTaxPayable28 M126 M2,080 M-2,145 M855 M-1,222 M1,031 M328 M-440 M-77 M
ChangeInWorkingCapital-398 M-41 M2,424 M-3,218 M447 M-1,770 M812 M571 M-739 M-705 M
ChangesInAccountReceivables-297 M-344 M-520 M-475 M-312 M534 M-143 M-427 M-168 M
CommonStockDividendPaid-311 M-725 M-1,221 M-790 M-997 M-1,052 M-904 M-904 M-1,037 M-1,129 M
CommonStockPayments-1,833 M-1,362 M-501 M-651 M-300 M-5,983 M-2,204 M-1,307 M-1,441 M-625 M
Current deferred income taxes-106 M327 M-1,241 M1,125 M-739 M612 M-537 M36 M-141 M-676 M
Deferred income taxes-106 M327 M-1,241 M1,125 M-739 M612 M-537 M36 M-141 M-676 M
Depreciation358 M860 M953 M1,188 M824 M825 M822 M845 M830 M848 M
Depreciation unreconciled358 M860 M953 M1,188 M824 M825 M822 M845 M830 M848 M
DepreciationAndAmortization358 M860 M953 M1,188 M824 M825 M822 M845 M830 M848 M
EarningsLossesFromEquityInvestments-144 M-250 M-181 M-128 M-34 M-36 M-117 M30 M-98 M
Effect of exchange rate changes-20 M-106 M-120 M115 M116 M-53 M-5 M
FinancingCashFlow-4,003 M862 M-933 M773 M-3,735 M-10,508 M-2,692 M-2,131 M-516 M-2,174 M
Free cash flow634 M-556 M30 M540 M2,893 M14,508 M2,585 M2,123 M1,525 M1,714 M
GainLossOnInvestmentSecurities-215 M
GainLossOnSaleOfBusiness-2 M-1,340 M-26 M-9 M-114 M
IncomeTaxPaidSupplementalData102 M
InterestPaidSupplementalData100 M
Issuance of debt-1000000.0-68 M556 M145 M96 M-1,296 M-33 M-17 M379 M-51 M
IssuanceOfDebt-1000000.040 M758 M713 M-2,472 M-3,629 M385 M-28 M1,966 M-433 M
Net cash from financing activities-2,131 M-1,783 M-933 M773 M-3,749 M-10,523 M-2,692 M-2,131 M-516 M-2,174 M
Net cash from investing activities1,568 M-862 M-891 M-1,212 M1,568 M-529 M-390 M-1,090 M-693 M-1,184 M
Net cash from operating activities912 M542 M1,247 M1,850 M3,490 M15,067 M2,901 M2,551 M1,990 M2,221 M
Net change in cash & cash equivalents-1,543 M188 M-577 M1,411 M1,217 M3,910 M-66 M-618 M724 M-1,147 M
Net income from continuing operations1,839 M3,354 M-1,388 M3,629 M2,698 M2,578 M1,590 M1,513 M1,532 M1,849 M
NetBusinessPurchaseAndSale186 M1,586 M381 M139 M2,181 M-9 M-74 M-706 M-269 M-726 M
NetCommonStockIssuance-1,833 M-1,362 M-501 M-651 M-300 M-5,983 M-2,204 M-1,307 M-1,441 M-625 M
NetInvestmentPropertiesPurchaseAndSale-129 M-56 M-55 M-41 M-16 M39 M44 M41 M49 M
NetInvestmentPurchaseAndSale-129 M-56 M-55 M-41 M-16 M39 M44 M41 M49 M
NetIssuancePaymentsOfDebt-1000000.040 M758 M713 M-2,472 M-3,629 M385 M-28 M1,966 M-433 M
NetLongTermDebtIssuance108 M202 M568 M-2,568 M-2,333 M418 M-11 M1,587 M-382 M
NetPPEPurchaseAndSale-278 M-1,098 M-1,217 M-1,310 M-597 M-559 M-316 M-428 M-465 M-507 M
Operating (gains) losses-217 M-1,497 M47 M-1,096 M-468 M428 M21 M-736 M-282 M-94 M
Other financing charges net-77 M-11 M6 M1,362 M-42 M-30 M-32 M-70 M-21 M-29 M
Other investing changes net-26 M-12 M-7 M5 M14 M44 M41 M49 M
Other non-cash items394 M272 M368 M213 M107 M359 M566 M89 M599 M815 M
Payment of cash dividends311 M725 M1,221 M790 M997 M1,052 M904 M904 M1,037 M1,129 M
PensionAndEmployeeBenefitExpense-13 M323 M-915 M-226 M462 M57 M-619 M-312 M4 M
ProceedsFromStockOptionExercised91 M275 M70 M157 M66 M171 M75 M178 M17 M42 M
Purchase of Float term investments-386 M-44 M-48 M-41 M-1000000.025 M8 M
Purchase of property plant & equipment-278 M-1,098 M-1,217 M-1,310 M-597 M-559 M-316 M-428 M-465 M-507 M
Purchase of short term investments299 M1,501 M1,865 M1,136 M1,804 M496 M1,771 M1,173 M
PurchaseOfInvestment-386 M-44 M-48 M-41 M-16 M39 M43 M
PurchaseOfLongTermInvestments-15 M14 M35 M
PurchaseOfPPE-288 M-1,135 M-1,249 M-1,343 M-645 M-586 M-443 M-552 M-592 M-539 M
Repayment of debt-191 M-1,299 M-1,297 M-3,704 M-2,333 M-1,386 M-507 M-184 M-1,555 M
RepaymentOfDebt-831 M-259 M-1,299 M-1,297 M-3,704 M-2,333 M-1,386 M-507 M-184 M-1,555 M
Repurchase of capital stock-1,833 M-1,362 M-501 M-651 M-300 M-5,983 M-2,204 M-1,307 M-1,441 M-625 M
Sale of short term investments283 M288 M
SaleOfBusiness251 M1,646 M32 M220 M2,202 M16 M135 M19 M16 M
SaleOfInvestment283 M288 M
SaleOfPPE10 M37 M32 M33 M48 M27 M127 M124 M127 M32 M
ShortTermDebtIssuance830 M364 M556 M145 M96 M-1,296 M-33 M-17 M379 M-51 M
ShortTermDebtPayments-831 M-68 M556 M145 M107 M
StockBasedCompensation72 M90 M142 M147 M106 M95 M74 M76 M102 M111 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