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

QRTEA Stock Annual Balance Sheet. Download in Excel

Qurate Retail Inc. Series A Common Stock logo

Qurate Retail Inc. Series A Common Stock

Sector: Consumer Cyclical   

Industry: Specialty Retail

0.37
 
USD
  
0.01
  
(2.08%)
Previous close: 0.3605  Open: 0.36  Bid: 0.3575  Ask: 0.3703
52 week range    
0.35   
   1.80
Mkt Cap: 145 M  Avg Vol (90 Days): 2,772,514
Peers   
PKB-CA / 
POSH / 
PDD / 
Last updated: Friday 22nd November 2024

Stock Rankings

35
MarketXLS Rank
60
Value
15
Technical
31
Quality
How are these ranks calculated?
Ad slot not ready
Search for a stock

Financials

QRTEA Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Accounts payable735 M762 M790 M1,151 M1,204 M1,091 M1,305 M1,429 M976 M895 M
Accrued expenses1,478 M1,546 M1,496 M2,276 M2,386 M2,264 M2,723 M2,665 M2,109 M1,878 M
Accumulated depreciation & depletion-937 M-984 M-1,032 M-1,223 M-1,363 M-1,455 M-1,689 M-1,571 M-1,091 M-963 M
Additional paid in capital4 M370 M1,043 M53 M99 M
Building & improvements935 M947 M
Cash and equivalents2,306 M2,449 M825 M903 M653 M673 M806 M587 M1,275 M1,121 M
CashCashEquivalentsAndShortTermInvestments3,195 M3,359 M825 M3,266 M653 M673 M806 M587 M1,275 M1,121 M
CashEquivalents2,306 M2,449 M825 M655 M7 M8 M8 M587 M
Common par5 M5 M5 M5 M4 M4 M4 M4 M4 M4 M
Common stock equity5,673 M6,787 M6,772 M9,984 M5,624 M4,840 M3,598 M2,850 M412 M385 M
CommonStock5 M5 M5 M5 M4 M4 M4 M4 M4 M4 M
Cost in excess5,404 M6,112 M6,052 M7,082 M7,017 M6,576 M6,638 M6,339 M3,501 M3,164 M
CurrentAccruedExpenses743 M784 M706 M1,125 M1,182 M1,173 M1,418 M1,236 M1,133 M983 M
CurrentCapitalLeaseObligation33 M41 M42 M78 M72 M181 M168 M157 M76 M39 M
CurrentDeferredTaxesAssets442 M534 M511 M353 M349 M603 M499 M445 M473 M505 M
CurrentDeferredTaxesLiabilities3,263 M3,217 M3,636 M2,500 M1,925 M2,284 M1,826 M1,762 M1,882 M2,004 M
Deferred revenues972 M
Float term debt7,062 M7,481 M7,166 M7,553 M5,963 M5,855 M5,186 M5,977 M6,043 M5,313 M
GoodwillAndOtherIntangibleAssets9,078 M11,132 M10,359 M12,259 M11,970 M10,699 M10,585 M10,122 M6,831 M6,388 M
Gross fixed assets (Plant Property & Equipment)2,030 M2,124 M2,163 M2,564 M2,685 M4,157 M4,289 M3,982 M2,816 M2,622 M
Intangibles3,674 M5,020 M4,307 M5,177 M4,953 M4,123 M3,947 M3,783 M3,330 M3,224 M
InterestPayable387 M360 M363 M355 M381 M-374 M-408 M-468 M-456 M-451 M
Inventories1,049 M1,000 M968 M1,411 M1,474 M1,413 M1,301 M1,623 M1,346 M1,044 M
InventoriesAdjustmentsAllowances-86 M-87 M-76 M-93 M-151 M-152 M-181 M-135 M-154 M-121 M
Invested capital16,484 M18,079 M18,436 M20,168 M11,587 M16,550 M13,970 M14,501 M11,980 M10,396 M
Land & improvements205 M197 M
LongTermCapitalLeaseObligation413 M383 M303 M518 M615 M
LongTermDebtAndCapitalLeaseObligation7,062 M7,481 M7,166 M7,553 M5,963 M5,855 M5,186 M5,977 M6,043 M5,313 M
LongTermProvisions95 M84 M109 M73 M123 M130 M92 M55 M82 M59 M
Machinery furniture & equipment847 M909 M
Minority interest107 M88 M89 M99 M120 M132 M135 M136 M113 M104 M
Net fixed assets (net PP&E)1,093 M1,140 M1,131 M1,341 M1,322 M2,702 M2,600 M2,411 M1,725 M1,659 M
NetOtherUnrealizedGainLoss110 M9 M410 M1000000.0-1000000.0224 M10 M
Non-current deferred income taxes2,821 M3,217 M3,636 M2,500 M1,925 M1,716 M1,359 M1,350 M1,440 M1,531 M
NonCurrentDeferredLiabilities2,821 M3,217 M3,636 M2,500 M1,925 M1,716 M1,359 M1,350 M1,440 M1,531 M
NonCurrentDeferredTaxesAssets496 M582 M575 M518 M503 M808 M763 M709 M737 M769 M
Other current assets72 M73 M68 M125 M224 M434 M473 M235 M260 M209 M
Other equity adjustments-94 M-215 M-266 M-133 M-55 M-55 M72 M-79 M
Other fixed assets4,157 M4,289 M3,982 M2,816 M2,622 M
Other non-current assets22 M966 M32 M3,994 M267 M881 M894 M575 M310 M151 M
Other non-current liabilities168 M222 M158 M242 M258 M761 M2,017 M1,665 M1,464 M1,418 M
Other receivable1,232 M1,443 M1,308 M1,726 M1,835 M1,854 M1,640 M1,679 M1,394 M1,308 M
OtherCurrentBorrowings946 M1,226 M876 M996 M1,410 M1,557 M1,750 M1,315 M828 M642 M
OtherCurrentLiabilities343 M328 M162 M169 M155 M180 M231 M244 M162 M97 M
OtherInventories1,413 M1,301 M1,623 M1,346 M1,044 M
OtherPayable864 M1,370 M264 M-22 M
Payables735 M762 M790 M1,151 M1,204 M1,091 M1,305 M1,429 M976 M895 M
Preferred securities of subsidiary trust50 M50 M50 M
PreferredStock50 M50 M50 M
RecievablesAdjustmentsAllowances-92 M-87 M-99 M-92 M-117 M-129 M-132 M-107 M-111 M-102 M
Restricted cash681 M814 M596 M1,285 M1,136 M
Retained earnings5,757 M6,626 M7,032 M9,068 M5,675 M4,836 M3,594 M2,846 M355 M282 M
SecuritySoldNotYetRepurchased785 M785 M799 M765 M
Short term debt946 M1,226 M876 M996 M1,410 M1,557 M1,750 M1,315 M828 M642 M
Total assets18,641 M21,180 M20,355 M24,122 M17,841 M18,656 M18,299 M17,232 M12,571 M11,368 M
Total current assets5,548 M5,875 M3,169 M4,165 M4,186 M4,374 M4,220 M4,124 M4,275 M3,682 M
Total current liabilities3,739 M3,100 M2,534 M3,441 M3,951 M4,001 M4,704 M4,224 M3,099 M2,617 M
Total equity5,673 M6,787 M6,772 M9,984 M5,624 M4,840 M3,598 M2,850 M412 M385 M
Total liabilities12,861 M14,305 M13,494 M14,039 M12,097 M12,333 M13,266 M13,216 M12,046 M10,879 M
Total non-current assets13,050 M15,305 M17,186 M17,594 M13,655 M14,282 M14,079 M13,108 M8,866 M8,198 M
Total non-current liabilities10,051 M11,205 M10,960 M10,598 M8,146 M8,332 M8,562 M8,992 M8,947 M8,262 M
TotalEquityGrossMinority5,780 M6,875 M6,861 M10,083 M5,744 M4,972 M3,733 M2,986 M525 M489 M
TotalEquityGrossMinorityInterest5,780 M6,875 M6,861 M10,083 M5,744 M4,972 M3,733 M2,986 M525 M489 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest18,641 M21,180 M20,355 M24,122 M17,841 M18,656 M18,299 M17,232 M12,571 M11,368 M
TotalNonCurrentLiabilitiesNetMinorityInteres10,051 M11,205 M10,960 M10,598 M8,146 M8,332 M8,562 M8,992 M8,947 M8,262 M
UnearnedIncome96 M76 M
Working capital1,809 M2,775 M635 M724 M235 M373 M-484 M-100 M1,176 M1,065 M
debtc946 M1,226 M876 M996 M1,410 M1,557 M1,750 M1,315 M828 M642 M
ltinv2,857 M2,067 M5,664 M2,275 M135 M126 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