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

Avangrid Inc.

Sector: Utilities   

Industry: Utilities - Regulated Electric

35.31
 
USD
  
-0.12
  
(-0.34%)
Optionable: Yes  Market Cap: 13,685 M  90-day average vol: 850,231

Previous close: 35.43  Open: 35.35  Bid: 35.22  Ask: 37.0
52 week range    
27.46   
   39.13
Last updated: Tuesday 18th June 2024

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

AGR Balance Sheet

Annual
Invalid dateDec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
Accounts payable93 M1,314 M1,160 M1,190 M1,425 M1,503 M1,647 M2,046 M
Accounts receivable974 M1,119 M1,040 M1,142 M1,082 M1,187 M1,269 M1,737 M
Accrued expenses210 M1,560 M1,440 M1,447 M1,689 M1,782 M1,929 M2,343 M
Accumulated depreciation & depletion-6,372 M-6,986 M-7,497 M-8,359 M-9,058 M-9,799 M-10,589 M-11,542 M
Additional paid in capital13,653 M13,653 M13,653 M13,657 M13,660 M13,665 M17,679 M17,694 M
Cash and equivalents125 M91 M41 M36 M178 M1,463 M1,474 M69 M
CashCashEquivalentsAndShortTermInvestments125 M91 M41 M36 M178 M1,463 M1,474 M69 M
CashEquivalents125 M91 M41 M36 M178 M1,463 M1,474 M
CommercialPaper150 M507 M589 M562 M309 M397 M
Common par3 M3 M3 M3 M3 M3 M3 M3 M
Common stock equity15,053 M15,195 M15,077 M15,104 M15,190 M15,209 M19,076 M19,380 M
CommonStock3 M3 M3 M3 M3 M3 M3 M3 M
CommonUtilityPlant25,745 M
Construction in progress1,338 M1,471 M1,425 M1,610 M2,158 M2,408 M3,286 M4,083 M
Cost in excess3,115 M3,124 M3,127 M3,127 M3,119 M3,119 M3,119 M3,119 M
CurrentAccruedExpenses61 M60 M57 M62 M72 M70 M69 M66 M
CurrentCapitalLeaseObligation8 M12 M8 M12 M13 M
CurrentDeferredAssets148 M220 M6 M
CurrentDeferredRevenue1,553 M1,483 M1,446 M
CurrentDeferredTaxesAssets148 M220 M2,490 M6 M
CurrentDeferredTaxesLiabilities4,057 M4,335 M4,517 M4,660 M4,930 M
CurrentProvisions161 M196 M217 M190 M210 M253 M273 M
DeferredCosts307 M246 M99 M109 M110 M93 M139 M268 M
DerivativeProductLiabilities94 M78 M92 M97 M85 M79 M160 M164 M
DividendsPayable134 M134 M136 M136 M136 M170 M170 M
EmployeeBenefits1,202 M1,106 M1,049 M1,102 M1,100 M1,007 M684 M491 M
FinancialAssets89 M73 M63 M63 M84 M79 M59 M140 M
Float term debt4,530 M4,510 M5,196 M5,442 M6,781 M7,632 M8,071 M8,376 M
GoodwillAndOtherIntangibleAssets3,671 M3,662 M3,455 M3,450 M3,433 M3,424 M3,412 M3,400 M
Gross fixed assets (Plant Property & Equipment)27,083 M28,534 M30,166 M31,900 M34,324 M36,703 M39,603 M42,695 M
IncomeTaxPayable44 M52 M89 M59 M56 M73 M43 M
Intangibles556 M538 M328 M323 M314 M305 M293 M281 M
InterestPayable61 M60 M57 M62 M72 M70 M69 M66 M
Inventories98 M132 M115 M126 M141 M169 M204 M235 M
Invested capital24,113 M24,215 M25,469 M25,914 M28,687 M30,319 M35,069 M35,971 M
Leases70 M153 M148 M
LineOfCredit160 M250 M
LongTermCapitalLeaseObligation74 M65 M154 M149 M161 M
LongTermDebtAndCapitalLeaseObligation4,530 M4,510 M5,196 M5,442 M6,781 M7,632 M8,071 M8,376 M
LongTermProvisions559 M554 M556 M528 M502 M551 M552 M
Minority interest13 M13 M19 M299 M349 M617 M885 M962 M
Net fixed assets (net PP&E)20,711 M21,548 M22,669 M23,541 M25,266 M26,904 M29,014 M31,153 M
NetUtilityPlant25,745 M
Non-current deferred income taxes3,317 M3,455 M1,465 M1,530 M1,837 M1,919 M2,016 M2,234 M
NonCurrentDeferredAssets307 M246 M99 M109 M110 M93 M139 M268 M
NonCurrentDeferredLiabilities4,870 M4,938 M2,911 M2,915 M3,111 M3,123 M3,146 M3,296 M
NonCurrentDeferredRevenue1,553 M1,483 M1,446 M1,385 M1,274 M1,204 M1,130 M1,062 M
NonCurrentDeferredTaxesAssets2,617 M2,490 M
NonCurrentPensionAndOtherPostretirementBenefitPlans1,202 M1,106 M1,049 M1,102 M1,100 M1,007 M684 M491 M
Notes payable484 M151 M757 M587 M620 M531 M978 M
NotesReceivable453 M1,908 M3 M
Number of employees7300.07300.07300.07300.07300.07300.07300.07300.0
Other current assets219 M285 M664 M299 M294 M310 M400 M447 M
Other equity adjustments-52 M-86 M-46 M-72 M-95 M-111 M-273 M
Other fixed assets25,745 M21,548 M22,669 M23,541 M25,266 M26,904 M29,014 M31,153 M
Other non-current assets3,318 M3,332 M2,809 M2,802 M2,878 M2,903 M2,621 M2,734 M
Other non-current liabilities2,542 M2,198 M3,697 M3,722 M3,661 M6,585 M3,602 M3,486 M
Other receivable602 M25 M10 M6 M10 M12 M11 M5 M
OtherCurrentLiabilities336 M577 M537 M532 M578 M642 M793 M949 M
OtherDeferredCosts307 M246 M99 M109 M110 M93 M139 M268 M
OtherInventories98 M132 M115 M126 M141 M169 M204 M235 M
OtherPayable12 M1,096 M1,071 M1,132 M1,361 M1,453 M1,586 M
Payables149 M1,500 M1,383 M1,385 M1,617 M1,712 M1,860 M2,277 M
Prepaid expenses16 M255 M273 M229 M199 M525 M245 M386 M
RecievablesAdjustmentsAllowances-62 M-64 M-64 M-62 M-69 M-108 M-151 M-155 M
Restricted cash43 M184 M1,467 M1,477 M72 M
Retained earnings1,449 M1,544 M1,429 M1,456 M1,539 M1,555 M1,441 M1,730 M
Short term debt690 M500 M940 M981 M1,290 M620 M531 M978 M
Total assets30,743 M31,309 M31,671 M32,249 M34,394 M37,823 M39,504 M41,123 M
Total current assets2,474 M2,006 M2,161 M1,860 M1,915 M3,684 M3,638 M2,942 M
Total current liabilities2,035 M2,712 M2,939 M3,012 M3,589 M3,069 M3,329 M4,416 M
Total equity15,053 M15,195 M15,077 M15,104 M15,190 M15,209 M19,076 M19,380 M
Total liabilities15,677 M16,101 M16,575 M16,846 M18,855 M21,997 M19,543 M20,781 M
Total non-current assets42,574 M29,303 M29,510 M30,389 M32,479 M34,139 M35,866 M38,181 M
Total non-current liabilities13,642 M13,475 M13,461 M13,760 M15,243 M18,928 M16,214 M
TotalDeferredCreditsAndOtherNonCurrentLiabilities13,238 M13,389 M13,636 M13,834 M15,266 M18,928 M16,214 M16,365 M
TotalEquityGrossMinority15,066 M15,208 M15,096 M15,403 M15,539 M15,826 M19,961 M20,342 M
TotalEquityGrossMinorityInterest15,066 M15,208 M15,096 M15,403 M15,539 M15,826 M19,961 M20,342 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest30,743 M31,309 M31,671 M32,249 M34,394 M37,823 M39,504 M41,123 M
TotalNonCurrentLiabilitiesNetMinorityInteres13,642 M13,475 M13,461 M13,760 M15,243 M18,928 M16,214 M
TotalTaxPayable44 M52 M89 M59 M56 M73 M43 M61 M
Treasury stock626473.0-5 M-8 M-12 M-12 M-14 M-47 M-47 M
Working capital439 M-706 M-778 M-1,152 M-1,674 M615 M309 M-1,474 M
debtc690 M500 M940 M989 M1,302 M628 M543 M991 M
ltinv14,478 M442 M415 M424 M708 M736 M621 M486 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