Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Transocean Ltd (Switzerland) logo

Transocean Ltd (Switzerland)

Sector: Energy   

Industry: Oil & Gas Drilling

5.57
 
USD
  
0.20
  
(3.72%)
Optionable: Yes  Market Cap: 4,223 M  90-day average vol: 19,009,736

Previous close: 5.37  Open: 5.46  Bid: 5.53  Ask: 5.59
52 week range    
4.45   
   8.88
Peers   
HP / 
NE / 
NBR / 
Last updated: Sunday 5th May 2024
32
MarketXLS Rank
40
Value
7
Technical
50
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

RIG Cash Flow

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
(Increase) Decrease in other current assets-1,131 M179 M72 M54 M34 M
(Increase) Decrease in other current liabilities106 M-90 M219 M33 M-139 M43 M-73 M-108 M-20 M70 M
(Increase) Decrease in other working capital-395 M-165 M7 M234 M-344 M-341 M31 M-74 M-303 M
Acquisitions-990 M-77 M-19 M-1000000.0-42 M-10 M
Amortization of intangibles-15 M-15 M112 M187 M215 M220 M117 M52 M
AssetImpairmentCharge4,043 M1,875 M93 M1,498 M1,464 M609 M659 M37 M62 M
CapitalExpenditureReported2,165 M2,001 M1,344 M497 M184 M387 M265 M208 M717 M427 M
Cash at beginning of period3,243 M2,635 M2,339 M3,433 M2,975 M2,589 M2,349 M1,560 M1,412 M991 M
Cash at end of period2,635 M2,339 M3,052 M2,975 M2,589 M2,349 M1,560 M1,412 M991 M995 M
Cash flow2,210 M3,445 M1,911 M1,170 M558 M340 M398 M575 M448 M164 M
CashFlowFromContinuingInvestingActivities-1,672 M-1,822 M-1,274 M-485 M-797 M-268 M-257 M-233 M-757 M-423 M
CashFromDiscontinuedOperatingActivities10 M-1000000.0
ChangeInWorkingCapital-1,025 M-306 M126 M94 M129 M-301 M-414 M-77 M-94 M-233 M
CommonStockDividendPaid-5 M-29 M-30 M
Current deferred income taxes-142 M-134 M68 M89 M-16 M248 M60 M128 M46 M18 M
Deferred income taxes-142 M-134 M68 M89 M-16 M248 M60 M128 M46 M18 M
Depreciation1,139 M963 M893 M832 M818 M855 M781 M742 M735 M744 M
Depreciation unreconciled1,124 M963 M893 M832 M930 M1,042 M996 M962 M885 M847 M
DepreciationAndAmortization1,124 M963 M893 M832 M930 M1,042 M996 M962 M885 M847 M
FinancingCashFlow-1,156 M-1,919 M76 M-1,143 M-147 M-312 M-930 M-490 M-112 M263 M
Free cash flow270 M1,498 M597 M1,023 M417 M23 M157 M376 M-262 M-253 M
GainLossOnSaleOfPPE26 M35 M-4 M1,603 M12 M84 M62 M10 M183 M
Issuance of capital stock158 M263 M
IssuanceOfCapitalStock158 M263 M
IssuanceOfDebt-539 M-1,506 M106 M-1,140 M-51 M-269 M-894 M-606 M-379 M266 M
Net cash from financing activities-1,156 M-1,919 M76 M-1,143 M-147 M-312 M-930 M-490 M-112 M263 M
Net cash from investing activities-1,672 M-1,822 M-1,274 M-485 M-797 M-268 M-257 M-233 M-757 M-423 M
Net cash from operating activities2,220 M3,445 M1,911 M1,170 M558 M340 M398 M575 M448 M164 M
Net change in cash & cash equivalents-608 M-296 M713 M-458 M-386 M-240 M-789 M-148 M-421 M4 M
Net income from continuing operations-1,966 M897 M827 M-3,097 M-2,003 M-1,257 M-568 M-591 M-621 M-954 M
NetBusinessPurchaseAndSale35 M3 M-990 M-77 M-19 M-1000000.0-42 M-3 M
NetCommonStockIssuance158 M263 M
NetInvestmentPropertiesPurchaseAndSale243 M125 M40 M-338 M334 M126 M3 M-33 M-5 M-3 M
NetInvestmentPurchaseAndSale243 M125 M40 M-338 M334 M126 M3 M-33 M-5 M-3 M
NetIssuancePaymentsOfDebt-539 M-1,506 M106 M-1,140 M-51 M-269 M-894 M-606 M-379 M266 M
NetLongTermDebtIssuance-539 M-1,506 M-2,295 M-2,284 M-2,105 M-1,325 M-1,637 M-606 M-554 M-1,717 M
NetPPEPurchaseAndSale-1,950 M-1,947 M-1,314 M-147 M-141 M-317 M-241 M-199 M-710 M-417 M
Operating (gains) losses26 M12 M-152 M1,658 M3 M-79 M-449 M11 M2 M214 M
Other financing charges net-612 M-384 M-3 M-96 M-43 M-36 M-42 M-8 M-3 M
Other investing changes net102 M15 M1000000.010 M3 M-2 M-33 M-5 M-3 M
Other non-cash items4,193 M2,013 M149 M1,594 M1,515 M687 M773 M142 M230 M272 M
Payment of cash dividends5 M29 M30 M
ProceedsFromIssuanceOfWarrants12 M
Purchase of Float term investments-15 M-450 M334 M123 M5 M
Purchase of property plant & equipment-1,950 M-1,947 M-1,314 M-147 M-141 M-317 M-241 M-199 M-710 M-417 M
PurchaseOfInvestment-35 M-85 M-450 M334 M123 M5 M
PurchaseOfLongTermInvestments-20 M-85 M-97 M
PurchaseOfPPE-2,165 M-2,001 M-1,344 M-497 M-184 M-387 M-265 M-208 M-717 M-427 M
Repayment of debt-539 M-1,506 M-2,295 M-2,284 M-2,105 M-1,325 M-1,637 M-606 M-554 M-1,717 M
RepaymentOfDebt-539 M-1,506 M-2,295 M-2,284 M-2,105 M-1,325 M-1,637 M-606 M-554 M-1,717 M
Revenue per share-15 M-15 M112 M187 M215 M220 M150 M103 M
Sale of Float term investments176 M110 M124 M102 M26 M
SaleOfBusiness35 M3 M7 M
SaleOfInvestment176 M110 M124 M102 M26 M
SaleOfPPE215 M54 M30 M350 M43 M70 M24 M9 M7 M10 M
StockBasedCompensation98 M64 M42 M41 M45 M37 M31 M28 M29 M40 M
UnrealizedGainLossOnInvestmentSecurities157 M127 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