Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Verizon Communications Inc. logo

Verizon Communications Inc.

Sector: Communication Services   

Industry: Telecom Services

40.13
 
USD
  
0.35
  
(0.88%)
Optionable: Yes  Market Cap: 167,204 M  90-day average vol: 18,835,562

Previous close: 39.78  Open: 39.85  Bid: 40.09  Ask: 40.14
52 week range    
30.14   
   43.42
Peers   
T / 
TMUS / 
SHEN / 
DTEGY / 
TDS / 
VOD / 
SPOK / 
USM / 
GOOGL / 
Last updated: Friday 19th April 2024
62
MarketXLS Rank
80
Value
53
Technical
55
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

VZ Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
"""debtc"""2,735 M6,489 M2,645 M3,453 M10,121 M14,038 M9,374 M11,302 M14,097 M17,239 M
Accounts payable16,680 M19,362 M19,593 M21,232 M22,501 M21,806 M20,658 M24,833 M23,977 M23,453 M
Accounts receivable13,993 M13,457 M17,513 M23,493 M25,102 M26,162 M25,169 M23,846 M26,158 M27,119 M
Accrued expenses16,680 M19,362 M19,593 M21,232 M22,501 M21,806 M20,658 M24,833 M23,977 M23,453 M
Accumulated depreciation & depletion-140,561 M-136,622 M-147,464 M-157,930 M-163,549 M-173,819 M-184,904 M-190,201 M-200,255 M-211,798 M
Additional paid in capital11,155 M11,196 M11,182 M11,101 M13,437 M13,419 M13,404 M13,861 M13,420 M13,631 M
Building & improvements25,209 M25,587 M27,117 M
Cash and equivalents10,598 M4,470 M2,880 M2,079 M2,745 M2,594 M22,171 M2,921 M2,605 M2,065 M
CashCashEquivalentsAndShortTermInvestments11,153 M4,820 M2,880 M2,079 M2,745 M2,594 M22,171 M2,921 M2,605 M2,065 M
CashEquivalents10,598 M4,470 M2,880 M2,079 M2,745 M2,594 M22,171 M2,921 M
Common par424 M424 M424 M424 M429 M429 M429 M429 M429 M429 M
Common stock equity11,874 M16,000 M22,075 M42,680 M52,792 M61,173 M67,507 M81,790 M90,351 M91,774 M
CommonStock424 M424 M424 M424 M429 M429 M429 M429 M429 M429 M
Construction in progress4,580 M4,907 M
Cost in excess24,639 M25,331 M27,205 M29,172 M24,614 M24,389 M24,773 M28,603 M28,671 M22,843 M
CurrentCapitalLeaseObligation516 M957 M950 M1,020 M2,931 M3,261 M3,485 M3,859 M4,134 M4,266 M
CurrentDeferredRevenue3,125 M2,969 M2,914 M4,050 M4,207 M4,651 M4,843 M6,053 M6,583 M6,955 M
CurrentDeferredTaxesAssets16,011 M15,409 M13,930 M8,995 M7,888 M11,395 M11,979 M12,352 M11,467 M11,682 M
CurrentDeferredTaxesLiabilities57,460 M60,795 M59,894 M40,196 M41,614 M46,014 M47,602 M52,869 M54,735 M57,315 M
DeferredFinancingCosts-465 M-469 M-534 M-541 M-492 M-604 M-688 M-671 M-616 M
DefinedPensionBenefit25,300 M22,000 M21,100 M21,500 M19,500 M21,200 M22,200 M20,100 M15,300 M15,100 M
DividendsPayable2,307 M2,323 M2,375 M2,429 M2,512 M2,566 M2,618 M2,709 M2,764 M2,821 M
EmployeeBenefits33,280 M29,957 M26,166 M22,112 M18,599 M17,952 M18,657 M15,410 M12,974 M13,189 M
Float term debt110,536 M103,240 M105,433 M113,642 M125,076 M119,105 M141,173 M143,425 M162,234 M157,703 M
GoodwillAndOtherIntangibleAssets105,708 M119,498 M122,775 M127,836 M128,519 M128,946 M130,283 M187,899 M189,928 M189,567 M
Gross fixed assets (Plant Property & Equipment)230,508 M220,163 M232,215 M246,498 M276,076 M288,428 M302,268 M317,780 M333,819 M344,834 M
IncomeTaxPayable1,457 M2,054 M1,516 M1,483 M1,483 M1,771 M1,432 M1,624 M1,876 M2,612 M
Intangibles81,069 M94,167 M95,570 M98,664 M103,905 M104,557 M105,510 M159,296 M161,257 M166,724 M
InterestPayable-4,915 M-4,920 M-4,376 M-4,733 M-4,833 M-4,730 M-4,247 M-3,485 M-3,613 M-5,524 M
Inventories1,153 M1,252 M1,202 M1,034 M1,336 M1,422 M1,796 M3,055 M2,388 M2,057 M
Invested capital232,946 M222,480 M232,941 M269,964 M283,741 M280,990 M331,853 M368,215 M393,261 M387,178 M
Land & improvements763 M709 M7,627 M
Leases6,374 M7,104 M1,277 M1,463 M1,756 M939 M1,127 M1,046 M1,138 M1,459 M
LineOfCredit100 M100 M400 M8,900 M9,400 M9,390 M10,392 M9,418 M10,436 M9,457 M
LoansReceivable1,090 M
LongTermCapitalLeaseObligation113,271 M110,194 M108,078 M117,095 M19,203 M18,393 M18,000 M23,203 M21,558 M20,002 M
LongTermDebtAndCapitalLeaseObligation111,000 M103,000 M105,000 M114,000 M86,670 M101,000 M123,000 M166,628 M162,234 M157,703 M
Machinery furniture & equipment129,619 M129,201 M136,737 M
Minority interest1,378 M1,414 M1,508 M1,591 M1,565 M1,440 M1,430 M1,410 M1,319 M1,369 M
Net fixed assets (net PP&E)89,947 M83,541 M84,751 M88,568 M112,527 M114,609 M117,364 M127,579 M133,564 M133,036 M
NetOtherUnrealizedGainLoss261 M-126 M706 M
Non-current deferred income taxes41,563 M45,484 M45,964 M31,232 M33,795 M34,703 M35,711 M40,685 M43,441 M45,781 M
NonCurrentDeferredLiabilities41,563 M45,484 M45,964 M31,232 M33,795 M34,703 M35,711 M40,685 M43,441 M45,781 M
NonCurrentDeferredRevenue1,176 M1,651 M1,947 M
NonCurrentDeferredTaxesAssets17,852 M18,823 M16,403 M12,288 M10,629 M13,655 M14,162 M13,926 M12,814 M13,023 M
NonCurrentNoteReceivables7,403 M11,898 M14,124 M
NonCurrentPensionAndOtherPostretirementBenefitPlans33,280 M29,957 M26,166 M22,112 M18,599 M17,952 M18,657 M15,410 M12,974 M13,189 M
NonCurrentPrepaidAssets921 M2,772 M
Notes payable319 M158 M168 M900 M
NotesReceivable3,833 M3,720 M11,797 M17,770 M19,313 M19,493 M17,959 M21,303 M26,188 M29,206 M
Number of employees117100.0117100.0117100.0117100.0117100.0117100.0117100.0117100.0117100.0117100.0
Other current assets552 M792 M882 M2,355 M3,895 M4,489 M4,542 M4,691 M5,104 M5,395 M
Other equity adjustments1,111 M550 M2,673 M2,659 M2,370 M998 M-71 M-927 M
Other fixed assets230,508 M220,163 M232,215 M246,498 M276,076 M288,428 M302,268 M317,780 M333,819 M344,834 M
Other non-current assets5,739 M17,985 M9,149 M9,787 M11,717 M10,141 M10,879 M13,329 M17,260 M19,885 M
Other non-current liabilities5,998 M11,641 M12,694 M12,849 M13,922 M12,486 M12,343 M13,513 M18,397 M17,216 M
Other receivable3,678 M3,578 M11,286 M16,949 M18,767 M19,039 M17,506 M20,945 M25,709 M28,448 M
OtherCurrentBorrowings2,735 M6,489 M2,645 M3,453 M7,190 M10,777 M320 M7,443 M150 M
OtherCurrentLiabilities8,572 M9,629 M8,102 M8,352 M8,592 M9,024 M9,628 M11,025 M12,890 M12,531 M
OtherInventories1,153 M1,252 M1,202 M1,034 M1,336 M1,422 M1,796 M3,055 M2,388 M2,057 M
OtherPayable58,886 M9,942 M534 M21,232 M1,429 M898 M3,896 M47,596 M3,653 M5,796 M
Payables16,680 M19,362 M19,593 M21,232 M22,501 M21,806 M20,658 M24,833 M23,977 M23,453 M
Preferred securities of subsidiary trust250 M
PreferredStock250 M
Prepaid expenses2,648 M2,034 M3,918 M3,307 M5,453 M8,028 M6,710 M6,906 M8,358 M7,607 M
RecievablesAdjustmentsAllowances-739 M-882 M-845 M-939 M-765 M-733 M-1,252 M-759 M-881 M-1,151 M
Restricted cash2,888 M3,916 M3,917 M23,498 M4,161 M4,111 M3,497 M
Retained earnings3,558 M11,796 M17,732 M38,294 M45,912 M54,145 M60,393 M71,993 M80,515 M81,535 M
SecuritySoldNotYetRepurchased5,134 M
Short term debt2,735 M6,489 M2,645 M3,453 M7,190 M10,777 M5,889 M7,443 M9,963 M12,973 M
Total assets232,616 M244,175 M244,180 M257,143 M288,070 M291,727 M316,481 M368,388 M379,680 M380,255 M
Total current assets29,499 M22,355 M26,395 M29,913 M34,636 M37,473 M54,594 M36,728 M37,857 M36,814 M
Total current liabilities27,987 M35,480 M30,340 M33,037 M41,214 M44,868 M39,660 M47,160 M50,171 M53,223 M
Total equity11,874 M16,000 M22,075 M42,680 M52,792 M61,173 M67,507 M81,790 M90,351 M91,774 M
Total liabilities219,364 M226,761 M220,597 M212,872 M210,000 M229,114 M247,544 M283,934 M288,010 M287,112 M
Total non-current assets203,117 M221,820 M217,785 M227,230 M253,434 M254,254 M261,887 M329,868 M341,823 M343,441 M
Total non-current liabilities191,377 M191,281 M190,257 M179,835 M191,392 M184,246 M207,884 M236,236 M237,046 M233,233 M
TotalEquityGrossMinority13,252 M17,414 M23,583 M44,271 M54,357 M62,613 M68,937 M82,662 M92,463 M93,799 M
TotalEquityGrossMinorityInterest13,252 M17,414 M23,583 M44,271 M54,357 M62,613 M68,937 M82,662 M92,463 M93,799 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest232,616 M244,175 M244,180 M257,143 M210,000 M291,727 M316,481 M368,388 M379,680 M380,255 M
TotalNonCurrentLiabilitiesNetMinorityInteres191,377 M191,281 M190,257 M179,835 M191,392 M184,246 M207,884 M236,236 M237,046 M233,233 M
Treasury stock-3,263 M-7,416 M-7,263 M-7,139 M-6,986 M-6,820 M-6,719 M-4,104 M-4,013 M-3,821 M
UnearnedPremiums-2,954 M-5,824 M-5,716 M-7,133 M-6,298 M-4,480 M-6,057 M-4,922 M-4,039 M-3,812 M
Working capital1,512 M-13,125 M-3,945 M-3,124 M-6,578 M-7,395 M14,934 M-10,432 M-12,314 M-16,409 M
ltinv802 M796 M1,110 M1,039 M671 M558 M589 M1,061 M1,071 M953 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