Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
CVS Health Corporation logo

CVS Health Corporation

Sector: Healthcare   

Industry: Health Care Plans

69.39
 
USD
  
0.79
  
(1.15%)
Optionable: Yes  Market Cap: 86,871 M  90-day average vol: 10,009,466

Previous close: 68.6  Open: 69.17  Bid: 69.26  Ask: 69.38
52 week range    
64.41   
   83.25
Peers   
PETS / 
RAD / 
WBA / 
Last updated: Friday 19th April 2024
62
MarketXLS Rank
85
Value
38
Technical
65
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

CVS Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
"""debtc"""1,260 M1,197 M1,916 M4,821 M3,788 M5,377 M7,078 M5,851 M3,456 M4,713 M
Accounts payable11,951 M15,143 M17,397 M19,218 M20,290 M24,093 M26,933 M29,874 M34,261 M49,820 M
Accounts receivable9,687 M11,888 M12,164 M13,181 M17,631 M19,617 M21,742 M24,431 M27,276 M35,227 M
Accrued expenses17,767 M21,972 M24,334 M25,799 M31,001 M36,226 M41,176 M47,544 M53,006 M72,009 M
Accumulated depreciation & depletion-9,943 M-11,181 M-12,627 M-13,998 M-15,520 M-16,890 M-18,700 M-20,654 M-21,483 M-20,699 M
Additional paid in capital30,418 M30,948 M31,618 M32,079 M
Cash and equivalents2,481 M2,459 M3,371 M1,696 M4,059 M5,683 M7,854 M9,408 M12,945 M8,196 M
CashCashEquivalentsAndShortTermInvestments2,515 M2,547 M3,458 M1,807 M6,581 M8,056 M10,854 M12,525 M15,723 M11,455 M
CashEquivalents144 M
CommercialPaper200 M
Common par-14 M-14 M-14 M32,096 M45,440 M45,972 M46,513 M47,377 M48,193 M48,992 M
Common stock equity37,958 M37,196 M36,830 M37,691 M58,225 M63,864 M69,389 M75,075 M71,015 M76,461 M
CommonStock-14 M-14 M-14 M32,096 M45,440 M45,972 M46,513 M47,377 M48,193 M48,992 M
Cost in excess28,142 M38,106 M38,249 M38,451 M78,678 M79,749 M79,552 M79,121 M78,150 M91,272 M
CurrentAccruedExpenses5,816 M6,829 M6,937 M6,581 M10,711 M12,133 M14,243 M17,670 M18,745 M22,189 M
CurrentCapitalLeaseObligation2,279 M300 M2,458 M2,493 M1,803 M1,596 M1,638 M1,646 M1,678 M1,741 M
CurrentDeferredAssets985 M1,220 M
CurrentDeferredRevenue53 M67 M73 M71 M87 M71 M149 M
CurrentDeferredTaxesAssets985 M83 M144 M930 M1,754 M7,309 M7,774 M7,497 M8,121 M8,002 M
CurrentDeferredTaxesLiabilities-4,590 M-6,018 M-5,882 M-3,926 M-9,431 M-14,603 M-14,568 M-13,767 M-11,870 M12,313 M
DeferredAcquisitionCosts22 M271 M546 M895 M1,200 M1,502 M
DividendsPayable-2,049 M-2,045 M-2,615 M-2,644 M-2,644 M-2,910 M-3,138 M
Float term debt11,630 M26,267 M25,615 M22,181 M71,444 M64,699 M77,964 M70,148 M51,288 M74,672 M
GoodwillAndOtherIntangibleAssets37,916 M51,984 M51,760 M52,081 M115,202 M112,870 M110,694 M108,147 M102,904 M120,506 M
Gross fixed assets (Plant Property & Equipment)18,786 M21,036 M22,802 M24,290 M47,856 M49,794 M52,035 M52,672 M52,228 M51,134 M
Intangibles9,774 M13,878 M13,511 M13,630 M36,524 M33,121 M31,142 M29,026 M24,754 M29,234 M
InterestPayable615 M859 M1,078 M1,062 M-536 M
Inventories11,930 M14,001 M14,760 M15,296 M16,450 M17,516 M18,496 M17,760 M19,090 M18,025 M
Invested capital61,218 M89,730 M88,060 M82,053 M219,945 M212,188 M206,560 M197,194 M172,779 M209,771 M
Leases268 M528 M547 M588 M582 M1,229 M
LongTermCapitalLeaseObligation12,955 M27,694 M27,726 M306 M18,832 M18,926 M18,757 M18,177 M16,800 M16,034 M
LongTermDebtAndCapitalLeaseObligation11,630 M26,267 M25,615 M22,181 M90,276 M83,625 M77,964 M70,148 M67,276 M74,672 M
LongTermProvisions334 M8,119 M7,436 M7,007 M15,210 M16,514 M5,459 M
Minority interest5 M46 M4 M4 M318 M306 M312 M306 M300 M175 M
Net fixed assets (net PP&E)8,843 M9,855 M10,175 M10,292 M32,336 M32,904 M33,335 M32,018 M30,745 M30,435 M
NetOtherUnrealizedGainLoss143 M186 M173 M
NetUnrealizedGainLossForeignCurrency65 M165 M127 M
Non-current deferred income taxes4,036 M4,217 M4,214 M2,996 M7,677 M7,294 M6,794 M6,270 M3,880 M4,311 M
NonCurrentDeferredLiabilities4,036 M4,217 M4,214 M2,996 M7,677 M7,294 M6,794 M6,270 M3,880 M4,311 M
NonCurrentDeferredTaxesAssets1,578 M1,801 M1,668 M101 M529 M480 M568 M416 M1,260 M1,205 M
Number of employees300000.0300000.0300000.0300000.0300000.0300000.0300000.0300000.0300000.0300000.0
Other current assets866 M722 M660 M945 M8,465 M9,572 M10,158 M10,379 M6,821 M6,401 M
Other equity adjustments-217 M-358 M-305 M
Other fixed assets8,843 M9,855 M10,175 M10,292 M32,336 M32,904 M33,335 M32,018 M30,745 M30,435 M
Other non-current assets1,445 M1,440 M1,485 M1,417 M5,046 M4,600 M4,624 M4,714 M4,620 M4,660 M
Other non-current liabilities1,531 M1,542 M1,549 M1,282 M8,927 M9,041 M10,287 M1,904 M6,732 M6,211 M
Other receivable184,765 M2,259 M2,663 M2,628 M3,389 M3,449 M3,894 M
OtherCurrentBorrowings685 M1,874 M1,276 M720 M200 M
OtherCurrentLiabilities4 M23 M8,760 M9,280 M10,708 M10,691 M6,096 M5,717 M
OtherEquityInterest9 M186 M173 M21 M
OtherInventories11,930 M14,001 M14,760 M15,296 M16,450 M17,516 M18,496 M17,760 M19,090 M18,025 M
OtherPayable-1,181 M-42,226 M
Payables11,951 M15,143 M17,397 M19,218 M20,290 M24,093 M26,933 M29,874 M34,261 M49,820 M
Prepaid expenses14 M6 M
RecievablesAdjustmentsAllowances-256 M-161 M-286 M-307 M-287 M-319 M-358 M-339 M-333 M-343 M
Restricted cash1,900 M4,295 M5,954 M11,043 M12,691 M8,525 M
Retained earnings31,632 M35,148 M38,678 M43,391 M41,013 M46,127 M51,054 M55,871 M54,680 M61,307 M
Short term debt1,260 M1,197 M1,916 M4,821 M1,985 M3,781 M5,440 M4,205 M1,778 M2,972 M
Total assets74,187 M92,437 M94,462 M95,131 M196,456 M222,449 M230,715 M232,999 M228,275 M249,728 M
Total current assets25,983 M29,158 M31,042 M31,229 M49,127 M54,761 M56,369 M60,008 M68,910 M67,858 M
Total current liabilities19,027 M23,169 M26,250 M30,643 M43,549 M50,883 M62,017 M67,807 M62,558 M79,189 M
Total equity37,958 M37,196 M36,830 M37,691 M58,225 M63,864 M69,389 M75,075 M71,015 M76,461 M
Total liabilities36,224 M55,195 M57,628 M57,436 M137,913 M158,279 M161,014 M157,618 M156,960 M173,092 M
Total non-current assets48,204 M63,279 M63,420 M63,902 M179,676 M167,688 M169,465 M167,904 M159,365 M178,620 M
Total non-current liabilities17,197 M32,026 M31,378 M26,793 M114,999 M107,396 M102,052 M93,532 M94,402 M90,653 M
TotalEquityGrossMinority37,963 M37,242 M36,834 M37,695 M58,543 M64,170 M69,701 M75,381 M71,315 M76,636 M
TotalEquityGrossMinorityInterest37,963 M37,242 M36,834 M37,695 M58,543 M64,170 M69,701 M75,381 M71,315 M76,636 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest74,187 M92,437 M94,462 M95,131 M217,091 M222,449 M230,715 M232,999 M228,275 M249,728 M
TotalNonCurrentLiabilitiesNetMinorityInteres17,197 M32,026 M31,378 M26,793 M114,999 M107,396 M102,052 M93,532 M94,402 M90,653 M
Treasury stock-24,078 M-28,886 M-33,452 M-37,796 M-28,228 M-28,235 M-28,178 M-28,173 M-31,858 M-33,838 M
UnearnedIncome11,360 M12,044 M
UnearnedPremiums39 M33 M28 M302 M262 M238 M219 M200 M186 M
Working capital6,956 M5,989 M4,792 M586 M5,578 M3,878 M-5,648 M-7,799 M6,352 M-11,331 M
ltinv51 M112 M15,732 M17,314 M20,812 M23,025 M21,096 M23,019 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