Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Atlantica Yield plc logo

Atlantica Yield plc

Sector: Utilities   

Industry: Utilities - Regulated Electric

Optionable: Yes  Market Cap: 2,640 M  90-day average vol: 1,308,976

Previous close: 22.75  Open: 22.57  Bid: 22.85  Ask: 23.37
52 week range    
ORA / 
PNM / 
Last updated: Thursday 23rd May 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


AY Income Statement

Invalid dateDec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Basic EPS from continuing operations-1.120.420.610.12-0.27-0.050.37
Basic EPS total-1.120.420.610.12-0.27-0.050.37
Basic weighted shares outstanding100 M100 M101 M102 M111 M115 M116 M
Cost of sales17 M-11 M-10 M-8 M-20 M
Depreciation-311 M-363 M-311 M-409 M-474 M418 M
Depreciation unreconciled311 M363 M311 M409 M439 M474 M418 M
DepreciationAndAmortization311 M363 M311 M409 M439 M474 M418 M
Diluted EPS total0.610.12-0.26-0.050.36
Diluted normalized net income/share0.610.12-0.26-0.050.36
Diluted weighted shares outstanding314 M1,111 M771 M3,335 M1,421 M6,691 M120 M
Dividends paid per share1.78
Earnings from equity interest5 M5 M7 M510000.012 M22 M13 M
EarningsFromEquityInterestNetOfTax5 M5 M7 M510000.012 M22 M13 M
ExciseTaxes277 M
GainOnSaleOfSecurity27 M
GeneralAndAdministrativeExpense-20 M-26 M-26 M-28 M-59 M41 M
Gross operating profit991 M1,044 M1,011 M737 M1,212 M1,102 M1,100 M
ImpairmentOfCapitalAssets-6 M
Income before tax15 M98 M106 M42 M25 M-12 M37 M
Income taxes120 M43 M31 M25 M36 M-10 M790000.0
InsuranceAndClaims-24 M-24 M-24 M-38 M-46 M41 M
Interest income1 M36 M4 M7 M3 M6 M25 M
InterestExpenseNonOperating-292 M367 M
InterestIncomeOperating42 M
MarketingExpense277 M
MinorityInterests-7 M-14 M-12 M5 M19 M3 M7 M
MiscOtherSpecialCharges81 M133 M94 M100 M75 M81 M59 M
Net income from total operations352 M467 M470 M400 M370 M335 M43 M
NetIncomeCommonStockholders352 M467 M470 M400 M370 M335 M43 M
NetIncomeContinuousOperations352 M467 M470 M400 M370 M335 M36 M
NetNonOperatingInterestIncomeExpense19 M28 M3 M48 M19 M12 M-342 M
NetOperatingInterestIncomeExpense42 M
NonRecurringOperationExpense311 M
Operating income662 M666 M407 M274 M694 M197 M241 M
Operating income before depreciation (EBITDA)326 M461 M416 M450 M465 M170 M
OperatingExpense330 M378 M605 M463 M518 M905 M859 M
OperationAndMaintenance17 M11 M
Other income net198 M-138 M-101 M-100 M-87 M-102 M-99 M
OtherGandA-20 M-26 M-26 M-28 M-59 M41 M
OtherOperatingExpenses-15 M-22 M-8 M-10 M-16 M296 M
OtherTaxes-52 M-37 M-35 M-40 M-20 M
OtherWriteOff284 M
SalariesAndWages19 M15 M32 M54 M79 M80 M104 M
SecuritiesAmortization262 M351 M
Selling Gen & administrative expense-20 M-26 M-26 M277 M-59 M41 M
SellingAndMarketingExpense262 M277 M
Special income/charges311 M-6 M414 M
Total Income available for interest expense (EBIT)15 M98 M106 M42 M25 M-304 M
Total common shares outstanding100 M100 M102 M107 M112 M116 M
Total net income352 M467 M470 M400 M370 M335 M43 M
Total ordinary shares116 M116 M116 M116 M116 M116 M116 M
Total revenues1,008 M1,044 M1,011 M1,013 M1,212 M1,102 M1,100 M
TotalExpenses347 M367 M595 M732 M518 M885 M859 M
TotalRevenue1,008 M1,044 M1,011 M1,013 M1,212 M1,102 M1,100 M
WriteDown414 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


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.


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