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

AY Stock Annual Balance Sheet. Download in Excel

Atlantica Yield plc logo

Atlantica Yield plc

Sector: Utilities   

Industry: Utilities - Regulated Electric

22.14
 
USD
  
-0.01
  
(-0.05%)
Previous close: 22.15  Open: 22.14  Bid: 22.1  Ask: 22.14
52 week range    
16.82   
   23.47
Mkt Cap: 2,568 M  Avg Vol (90 Days): 988,828
Peers   
ORA / 
PIF-CA / 
PNM / 
Last updated: Friday 22nd November 2024

Stock Rankings

61
MarketXLS Rank
80
Value
61
Technical
44
Quality
How are these ranks calculated?
Ad slot not ready
Search for a stock

Financials

AY Balance Sheet

Annual
Invalid dateDec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Accounts payable155 M192 M128 M93 M114 M140 M77 M
Accounts receivable244 M236 M318 M332 M307 M200 M213 M
Accrued expenses185 M206 M162 M147 M148 M176 M169 M
Additional paid in capital1,012 M1,012 M872 M987 M737 M
Cash and equivalents56 M53 M140 M117 M295 M260 M448 M
CashCashEquivalentsAndShortTermInvestments56 M53 M140 M117 M295 M260 M448 M
CashEquivalents263 M296 M339 M280 M208 M
Common par12 M
Common stock equity-396 M-354 M1,589 M1,617 M1,665 M1,750 M1,423 M
CommonStock12 M
CurrentAccruedExpenses12 M
CurrentCapitalLeaseObligation97 M93 M95 M
CurrentDeferredAssets148 M152 M172 M150 M
CurrentDeferredTaxesAssets148 M152 M172 M150 M
CurrentDeferredTaxesLiabilities187 M211 M830 M808 M733 M
Deferred revenues187 M211 M249 M
DerivativeProductLiabilities30 M
FinancialAssets264 M305 M222 M201 M218 M90 M57 M
Float term debt4,983 M
Gross fixed assets (Plant Property & Equipment)7,204 M
InterestPayable3,129 M2,743 M2,472 M2,310 M1,822 M
Inventories18 M19 M20 M24 M30 M35 M30 M
Invested capital-396 M-354 M1,589 M1,617 M1,665 M1,750 M6,406 M
LimitedPartnershipCapital2,163 M2,030 M1,901 M
LongTermCapitalLeaseObligation92 M88 M89 M63 M
LongTermDebtAndCapitalLeaseObligation4,983 M
Minority interest137 M139 M206 M213 M206 M189 M165 M
Net fixed assets (net PP&E)7,204 M
Non-current deferred income taxes249 M261 M309 M296 M271 M
NonCurrentAccruedExpenses141 M34 M17 M92 M
NonCurrentDeferredAssets165 M136 M148 M161 M
NonCurrentDeferredLiabilities330 M279 M548 M589 M532 M313 M271 M
NonCurrentDeferredTaxesAssets165 M136 M729 M699 M586 M161 M
Notes payable55 M
Other current assets196 M218 M
Other equity adjustments81 M95 M963 M978 M1,191 M1,161 M1,166 M
Other fixed assets7,204 M
Other non-current assets9,084 M8,549 M8,161 M8,155 M8,022 M7,483 M
Other non-current liabilities-18 M-58 M-91 M-100 M-133 M-150 M1,234 M
Other receivable40 M55 M51 M51 M46 M23 M
OtherCurrentBorrowings367 M
OtherCurrentLiabilities325 M533 M821 M347 M688 M343 M17 M
OtherEquityInterest-139 M
OtherPayable108 M109 M52 M54 M84 M35 M
Payables185 M206 M162 M147 M148 M176 M157 M
Prepaid expenses6 M6 M5 M12 M12 M13 M
Retained earnings-477 M-449 M-385 M-373 M-399 M-398 M-352 M
Short term debt421 M
TaxesReceivable37 M
Total assets10,492 M9,919 M9,660 M9,938 M9,752 M9,101 M8,714 M
Total current assets1,142 M1,128 M1,119 M1,424 M1,167 M1,032 M982 M
Total current liabilities500 M739 M973 M483 M824 M519 M608 M
Total equity-396 M-354 M1,589 M1,617 M1,665 M1,750 M1,423 M
Total liabilities8,589 M8,105 M7,864 M8,108 M7,881 M7,162 M7,126 M
Total non-current assets9,350 M8,791 M8,541 M8,514 M8,585 M8,069 M7,732 M
Total non-current liabilities8,096 M7,424 M6,972 M7,714 M7,179 M6,793 M6,518 M
TotalDeferredCreditsAndOtherNonCurrentLiabilities453 M255 M457 M489 M399 M164 M1,535 M
TotalEquityGrossMinority1,895 M1,756 M1,715 M1,741 M1,749 M1,789 M1,589 M
TotalEquityGrossMinorityInterest1,895 M1,756 M1,715 M1,741 M1,749 M1,789 M1,589 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest10,492 M9,919 M9,660 M9,938 M9,752 M9,101 M8,714 M
TotalNonCurrentLiabilitiesNetMinorityInteres8,096 M7,424 M6,972 M7,714 M7,179 M6,793 M6,518 M
TotalPartnershipCapital2,163 M2,030 M1,901 M
TotalTaxPayable30 M14 M34 M55 M34 M36 M45 M
UnrealizedGainLoss81 M95 M963 M978 M1,191 M1,161 M1,166 M
Working capital642 M389 M146 M941 M343 M513 M374 M
debtc421 M
ltinv230 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