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.37
 
USD
  
0.10
  
(1.90%)
Optionable: Yes  Market Cap: 4,223 M  90-day average vol: 19,058,558

Previous close: 5.27  Open: 5.33  Bid: 5.37  Ask: 5.38
52 week range    
4.45   
   8.88
Peers   
HP / 
NE / 
NBR / 
Last updated: Friday 3rd May 2024
37
MarketXLS Rank
40
Value
23
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 Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
"""debtc"""1,032 M1,093 M724 M250 M373 M568 M505 M513 M719 M370 M
Accounts payable784 M455 M206 M201 M269 M311 M194 M228 M281 M323 M
Accounts receivable1,343 M833 M597 M
Accrued expenses915 M510 M301 M280 M339 M375 M222 M245 M300 M346 M
Accumulated depreciation & depletion-6,978 M-5,456 M-6,279 M-5,291 M-5,403 M-5,434 M-5,373 M-6,054 M-6,748 M-6,934 M
Additional paid in capital5,797 M5,736 M10,993 M11,031 M13,394 M13,424 M13,501 M13,683 M13,984 M14,544 M
Cash and equivalents2,749 M2,679 M3,518 M2,985 M2,711 M2,348 M1,154 M976 M683 M762 M
CashCashEquivalentsAndShortTermInvestments2,749 M2,679 M3,518 M3,435 M2,711 M2,348 M1,154 M976 M683 M762 M
CashEquivalents114 M340 M466 M466 M2,711 M558 M
Common par5,169 M5,193 M36 M37 M59 M59 M60 M64 M71 M81 M
Common stock equity13,671 M14,690 M15,802 M12,707 M13,107 M11,862 M11,432 M11,205 M10,791 M10,415 M
CommonStock5,169 M5,193 M36 M37 M59 M59 M60 M64 M71 M81 M
Construction in progress2,451 M3,735 M2,171 M1,392 M
CurrentCapitalLeaseObligation23 M23 M25 M30 M0.035 M37 M40 M40 M394 M
CurrentDeferredAssets161 M
CurrentDeferredRevenue219 M187 M209 M213 M87 M100 M133 M83 M124 M165 M
CurrentDeferredTaxesAssets443 M453 M377 M223 M87 M154 M365 M632 M680 M855 M
CurrentDeferredTaxesLiabilities520 M182 M120 M3 M22 M400 M-671 M-1,072 M-1,160 M-1,351 M
DefinedPensionBenefit2,280 M2,049 M1,974 M2,078 M1,882 M2,108 M2,225 M2,085 M1,505 M1,544 M
DividendsPayable272 M
Float term debt9,019 M7,397 M7,740 M7,146 M9,605 M9,361 M7,302 M6,657 M6,628 M7,043 M
GoodwillAndOtherIntangibleAssets795 M608 M393 M173 M56 M4 M
Gross fixed assets (Plant Property & Equipment)28,516 M26,265 M27,372 M22,693 M25,811 M24,281 M23,040 M23,152 M24,217 M23,875 M
IncomeTaxPayable131 M55 M95 M79 M70 M64 M28 M17 M19 M23 M
Intangibles795 M608 M393 M173 M56 M4 M
InterestPayable483 M432 M135 M127 M184 M169 M128 M121 M561 M646 M
InventoriesAdjustmentsAllowances-109 M-148 M-153 M-141 M-134 M-127 M-143 M-183 M-199 M-198 M
Invested capital23,229 M23,401 M23,542 M19,853 M22,712 M29,916 M26,036 M24,519 M24,047 M24,501 M
Leases780 M774 M776 M774 M0.0
LongTermCapitalLeaseObligation594 M568 M8,464 M7,396 M9,978 M9,261 M407 M366 M323 M276 M
LongTermDebtAndCapitalLeaseObligation9,019 M7,397 M7,740 M7,146 M9,605 M8,693 M7,302 M6,657 M6,628 M7,043 M
Minority interest322 M315 M31 M62 M7 M5 M3 M1000000.01000000.01000000.0
Net fixed assets (net PP&E)21,538 M20,809 M21,093 M17,402 M20,408 M18,847 M17,667 M17,098 M17,469 M16,941 M
Non-current deferred income taxes436 M229 M178 M44 M64 M266 M315 M447 M493 M540 M
NonCurrentAccruedExpenses383 M428 M333 M247 M476 M179 M202 M157 M129 M80 M
NonCurrentDeferredAssets360 M411 M298 M47 M66 M20 M9 M7 M13 M44 M
NonCurrentDeferredLiabilities436 M229 M178 M44 M64 M266 M315 M447 M493 M540 M
NonCurrentDeferredRevenue201 M178 M390 M422 M399 M429 M323 M265 M204 M233 M
NonCurrentDeferredTaxesAssets360 M411 M298 M47 M66 M20 M9 M7 M13 M44 M
NonCurrentPensionAndOtherPostretirementBenefitPlans514 M405 M370 M353 M355 M346 M-272 M-128 M-170 M-121 M
NotesReceivable57 M65 M44 M
Number of employees5340.05340.05340.05340.05340.05340.05340.05340.05340.05340.0
Other current assets153 M92 M121 M157 M159 M159 M163 M148 M144 M193 M
Other equity adjustments-404 M-277 M-283 M-290 M-279 M
Other fixed assets24,281 M23,040 M23,152 M24,217 M23,875 M
Other non-current assets833 M413 M400 M355 M448 M990 M995 M959 M890 M1,139 M
Other non-current liabilities1,354 M1,135 M1,153 M1,082 M1,424 M1,555 M1,366 M1,068 M965 M858 M
Other receivable2,120 M1,379 M596 M604 M654 M583 M492 M485 M512 M
OtherCapitalStock5 M
OtherCurrentBorrowings1,032 M1,093 M724 M250 M373 M568 M505 M513 M719 M370 M
OtherCurrentLiabilities1,822 M1,062 M960 M839 M746 M781 M659 M545 M539 M681 M
OtherPayable2,165 M2,001 M1,344 M497 M184 M387 M265 M208 M717 M427 M
Payables915 M510 M301 M280 M339 M375 M222 M245 M300 M346 M
Prepaid expenses818 M627 M561 M418 M474 M479 M434 M392 M388 M426 M
RecievablesAdjustmentsAllowances-14 M-1000000.0-1000000.0-2 M
Restricted cash558 M406 M436 M308 M233 M
Retained earnings3,349 M4,278 M5,056 M1,929 M-67 M-1,621 M-2,129 M-2,542 M-3,264 M-4,210 M
Short term debt1,032 M1,093 M724 M250 M373 M568 M505 M513 M719 M370 M
Total assets28,571 M26,431 M26,889 M22,410 M25,665 M24,105 M21,804 M20,681 M20,436 M20,254 M
Total current assets5,840 M4,798 M5,098 M4,606 M3,948 M3,640 M2,740 M2,444 M2,008 M2,126 M
Total current liabilities3,769 M2,665 M1,985 M1,369 M1,458 M1,724 M1,386 M1,303 M1,558 M1,397 M
Total equity13,671 M14,690 M15,802 M12,707 M13,107 M11,862 M11,432 M11,205 M10,791 M10,415 M
Total liabilities14,578 M11,426 M11,056 M9,641 M12,551 M12,238 M10,369 M9,475 M9,644 M9,838 M
Total non-current assets22,731 M21,633 M21,791 M17,804 M21,717 M20,465 M19,064 M18,237 M18,428 M18,128 M
Total non-current liabilities10,809 M8,761 M9,071 M8,272 M11,093 M10,514 M8,983 M8,172 M8,086 M8,441 M
TotalEquityGrossMinority13,982 M15,000 M15,805 M12,711 M13,114 M11,867 M11,435 M11,206 M10,792 M10,416 M
TotalEquityGrossMinorityInterest13,982 M15,000 M15,805 M12,711 M13,114 M11,867 M11,435 M11,206 M10,792 M10,416 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest28,571 M26,431 M26,889 M22,410 M25,665 M24,105 M21,804 M20,681 M20,436 M20,254 M
TotalNonCurrentLiabilitiesNetMinorityInteres10,809 M8,761 M9,071 M8,272 M11,093 M10,514 M8,983 M8,172 M8,086 M8,441 M
TotalTaxPayable131 M55 M95 M79 M70 M64 M28 M17 M19 M23 M
Treasury stock-240 M-240 M
UnearnedPremiums-10 M19 M82 M88 M0.0100 M
Working capital2,071 M2,133 M3,113 M3,237 M2,490 M1,916 M1,354 M1,141 M450 M729 M
ltinv191 M138 M91 M113 M216 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