Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Sector:    

Industry: 

 
USD
  
  
()
Optionable:   Market Cap:   90-day average vol:

Previous close:   Open:   Bid:   Ask:
52 week range    
   
   

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

RTX Balance Sheet

Annual
Dec-13Dec-14Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Accounts payable6,965 M6,250 M7,483 M9,579 M11,080 M7,816 M8,639 M8,751 M9,896 M10,698 M
Accounts receivable8,743 M9,254 M9,661 M9,108 M10,838 M
Accrued expenses22,300 M18,777 M19,702 M21,895 M21,303 M16,233 M19,156 M18,913 M20,895 M25,615 M
Accumulated depreciation & depletion-9,795 M-9,477 M-10,311 M-11,178 M-11,787 M-9,755 M-11,384 M-12,665 M-13,946 M-15,644 M
Building & improvements5,633 M5,098 M5,180 M5,727 M6,486 M4,978 M7,067 M7,271 M7,519 M8,151 M
Cash and equivalents4,619 M5,229 M7,157 M8,985 M6,152 M4,937 M8,802 M7,832 M6,220 M6,587 M
CashCashEquivalentsAndShortTermInvestments4,619 M5,229 M7,157 M8,985 M6,152 M4,937 M8,802 M7,832 M6,220 M6,587 M
CashEquivalents5,229 M7,157 M8,985 M6,152 M42 M30 M
CommercialPaper200 M522 M300 M1,257 M160 M500 M
Common par14,764 M15,300 M17,285 M17,574 M22,514 M23,019 M36,930 M37,483 M37,939 M37,055 M
Common stock equity31,866 M31,213 M96,069 M100,972 M103,562 M41,774 M72,163 M73,068 M72,632 M59,798 M
CommonStock14,764 M15,300 M17,285 M17,574 M22,514 M23,019 M36,930 M37,483 M37,939 M37,055 M
Cost in excess28,168 M27,448 M27,059 M27,910 M48,112 M36,609 M54,285 M54,436 M53,840 M53,699 M
CurrentAccruedExpenses15,335 M12,527 M12,219 M12,316 M10,223 M8,417 M10,517 M10,162 M10,999 M14,917 M
CurrentCapitalLeaseObligation586 M462 M498 M683 M544 M482 M411 M356 M348 M
CurrentDeferredAssets1,964 M1,923 M
CurrentDeferredRevenue6,444 M4,217 M4,547 M5,720 M9,014 M12,889 M13,720 M14,598 M17,183 M
CurrentDeferredTaxesAssets1,964 M1,923 M5,705 M3,794 M4,677 M3,291 M5,081 M4,227 M4,980 M5,190 M
CurrentDeferredTaxesLiabilities3,338 M4,460 M5,740 M3,826 M6,744 M5,859 M9,574 M9,237 M8,559 M8,205 M
CurrentProvisions27 M
Deferred revenues5,720 M9,014 M12,889 M13,720 M14,598 M17,183 M
DefinedPensionBenefit31,900 M36,900 M34,200 M36,200 M37,000 M37,700 M70,200 M66,500 M48,800 M49,400 M
DerivativeProductLiabilities158 M60 M92 M
DividendsPayable-1,908 M2,069 M2,074 M
ESOPDebtGuarantee-126 M115 M95 M85 M76 M-64 M-49 M-38 M-28 M-15 M
EmployeeBenefits3,444 M6,681 M5,612 M3,036 M4,018 M2,487 M10,342 M7,855 M4,807 M2,385 M
Finished goods3,360 M2,975 M3,305 M3,845 M4,358 M3,477 M3,472 M3,069 M3,301 M3,704 M
Float term debt19,741 M17,784 M21,697 M24,989 M41,192 M38,794 M32,542 M32,984 M32,280 M43,767 M
GoodwillAndOtherIntangibleAssets43,689 M42,976 M42,743 M43,793 M74,536 M61,082 M94,824 M92,952 M90,663 M89,098 M
Gross fixed assets (Plant Property & Equipment)18,661 M18,069 M19,469 M21,364 M24,084 M21,329 M28,226 M29,595 M30,945 M33,030 M
IncomeTaxPayable540 M305 M382 M285 M460 M928 M
Intangibles15,521 M15,528 M15,684 M15,883 M26,424 M24,473 M40,539 M38,516 M36,823 M35,399 M
InterestPayable481 M503 M395 M909 M637 M608 M
Inventories10,330 M7,642 M8,704 M9,881 M10,083 M9,047 M9,411 M9,178 M10,617 M11,777 M
InventoriesAdjustmentsAllowances-1,025 M-721 M-877 M-1,107 M-1,270 M-1,122 M-1,800 M-2,000 M-2,200 M-2,400 M
Invested capital71,348 M49,365 M139,463 M150,950 M185,946 M118,269 M135,731 M137,379 M135,606 M145,920 M
Land & improvements434 M392 M392 M412 M425 M292 M773 M765 M744 M743 M
LineOfCredit1,500 M1,300 M2,200 M2,300 M1,000 M900 M800 M700 M
LongTermCapitalLeaseObligation1,093 M1,516 M1,657 M1,586 M1,412 M
LongTermDebtAndCapitalLeaseObligation19,741 M17,784 M21,697 M24,989 M41,192 M37,701 M31,026 M32,984 M32,280 M43,767 M
LongTermProvisions277 M-47 M26 M-92 M
Machinery furniture & equipment11,353 M11,398 M12,471 M13,476 M15,119 M12,936 M15,994 M16,729 M17,479 M18,904 M
Minority interest1,464 M1,491 M1,886 M1,942 M2,273 M2,552 M1,721 M1,631 M1,582 M1,647 M
Net fixed assets (net PP&E)8,866 M8,592 M9,158 M10,186 M12,297 M11,574 M16,842 M16,930 M16,999 M17,386 M
NetOtherUnrealizedGainLoss-6,772 M-4,483 M-1,828 M-782 M-2,026 M
NetUnrealizedGainLossForeignCurrency158 M60 M92 M-3,211 M710 M49 M-1,005 M-440 M
Non-current deferred income taxes-178 M-124 M364 M411 M123 M638 M151 M323 M220 M238 M
NonCurrentDeferredAssets1,236 M1,491 M1,809 M1,723 M1,646 M1,611 M
NonCurrentDeferredLiabilities5,069 M5,732 M
NonCurrentDeferredRevenue5,069 M5,732 M
NonCurrentDeferredTaxesAssets1,236 M1,491 M1,809 M1,723 M1,646 M-432 M-757 M-825 M-842 M-1,465 M
NonCurrentPensionAndOtherPostretirementBenefitPlans3,444 M6,681 M5,612 M3,036 M4,018 M2,487 M10,342 M7,855 M4,807 M2,385 M
NotesReceivable1,297 M1,032 M1,356 M1,397 M527 M516 M
Number of employees182000.0182000.0182000.0182000.0182000.0182000.0182000.0182000.0182000.0182000.0
Other current assets1,071 M6,241 M1,208 M1,397 M1,511 M2,565 M5,978 M4,018 M4,964 M7,076 M
Other equity adjustments-6,661 M-8,334 M-7,525 M-9,333 M-10,149 M-3,734 M
Other fixed assets8,866 M1,181 M9,158 M10,186 M12,297 M11,574 M16,842 M16,930 M16,999 M17,386 M
Other non-current assets6,205 M5,706 M6,048 M5,988 M7,206 M33,742 M3,967 M6,624 M6,156 M4,576 M
Other non-current liabilities11,279 M10,562 M11,026 M12,952 M11,845 M7,414 M9,537 M10,417 M8,449 M7,511 M
Other receivable11,458 M10,448 M11,481 M12,595 M14,271 M8,743 M9,254 M9,661 M9,108 M10,838 M
OtherCurrentBorrowings388 M126 M601 M392 M1,469 M2,293 M247 M134 M625 M189 M
OtherCurrentLiabilities1,901 M2,781 M1,608 M1,741 M2,074 M1,353 M3,006 M2,658 M2,401 M2,491 M
OtherEquityInterest710 M
OtherInventories10,330 M8,189 M8,704 M9,881 M10,083 M9,047 M9,411 M9,178 M10,617 M11,777 M
OtherPayable218 M208 M204 M142 M1,795 M2,134 M2,288 M
Payables6,965 M6,250 M7,483 M9,579 M11,080 M7,816 M8,639 M8,751 M9,896 M10,698 M
Preferred securities of subsidiary trust250001.0250001.0
PreferredSecuritiesOutsideStockEquity111 M
PreferredStock250001.0250001.0
Raw materials1,983 M1,948 M2,040 M2,038 M3,052 M2,984 M3,015 M3,024 M3,477 M3,911 M
RecievablesAdjustmentsAllowances-488 M-450 M-456 M-488 M-254 M-546 M-475 M-452 M-316 M
Restricted cash47 M32 M33 M60 M24 M
Retained earnings37,659 M44,611 M44,539 M47,717 M48,490 M51,445 M45,689 M48,350 M50,251 M49,735 M
SecuritySoldNotYetRepurchased2,803 M12,870 M
Short term debt500 M1,917 M2,204 M2,496 M4,345 M5,551 M797 M158 M1,220 M1,472 M
Total assets90,594 M91,206 M89,706 M96,920 M133,723 M139,615 M162,153 M161,404 M158,864 M161,869 M
Total current assets29,442 M31,483 M28,550 M32,858 M35,015 M29,754 M43,376 M42,050 M42,443 M48,417 M
Total current liabilities22,800 M23,475 M21,906 M24,391 M31,368 M32,151 M35,848 M35,449 M39,114 M46,761 M
Total equity31,866 M31,213 M96,069 M100,972 M103,562 M41,774 M72,163 M73,068 M72,632 M59,798 M
Total liabilities57,264 M58,502 M60,241 M65,368 M93,492 M95,289 M88,269 M86,705 M84,650 M100,424 M
Total non-current assets61,152 M59,723 M61,156 M64,062 M98,708 M109,861 M118,777 M119,354 M116,421 M113,452 M
Total non-current liabilities34,464 M35,027 M38,335 M40,977 M62,124 M63,138 M52,421 M51,256 M45,536 M53,663 M
TotalEquityGrossMinority33,330 M32,564 M97,955 M102,914 M105,835 M44,326 M73,884 M74,664 M74,178 M61,410 M
TotalEquityGrossMinorityInterest33,330 M32,564 M97,955 M102,914 M105,835 M44,326 M73,884 M74,664 M74,178 M61,410 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest90,594 M91,206 M158,196 M168,282 M199,327 M139,615 M162,153 M161,404 M158,864 M161,869 M
TotalNonCurrentLiabilitiesNetMinorityInteres34,464 M35,027 M38,335 M40,977 M62,124 M63,138 M52,421 M51,256 M45,536 M53,663 M
Treasury stock-20,431 M21,922 M34,150 M35,596 M32,482 M-32,626 M-10,407 M-12,727 M-15,530 M-26,977 M
UnearnedIncome1,156 M958 M1,398 M2,372 M3,023 M3,463 M3,144 M2,848 M2,603 M2,392 M
UnearnedPremiums106 M51 M40 M-59 M
Work in progress4,600 M2,093 M2,787 M3,366 M2,673 M2,586 M2,924 M3,085 M3,839 M4,162 M
Working capital6,642 M8,008 M6,644 M8,467 M3,647 M-2,397 M7,528 M6,601 M3,329 M1,656 M
debtc500 M1,917 M2,204 M2,496 M4,345 M5,551 M797 M158 M1,220 M1,472 M
ltinv988 M961 M987 M64 M51 M57 M881 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