Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Pinnacle West Capital Corporation logo

Pinnacle West Capital Corporation

Sector: Utilities   

Industry: Utilities - Regulated Electric

74.03
 
USD
  
2.04
  
(2.83%)
Optionable: Yes  Market Cap: 8,166 M  90-day average vol: 1,455,907

Previous close: 71.99  Open: 72.36  Bid: 72.55  Ask: 75.55
52 week range    
65.20   
   86.03
Peers   
AVA / 
XEL / 
PNM / 
IDA / 
EIX / 
NWE / 
Last updated: Thursday 28th March 2024
67
MarketXLS Rank
80
Value
76
Technical
47
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

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

AVA

0.03813 B19.844.32

BRK.A

702 B8.5474900

EIX

0.045823 B30.961.56

IDA

0.02785 B22.3107.82

NWE

0.04273 B15.858.12

PNM

0.02884 B2045.48

XEL

0.026637 B23.568.75
Financials

PNW Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Sep-23
Basic EPS from continuing operations3.593.943.974.374.564.794.895.484.273.51
Basic EPS total3.593.943.974.374.564.794.895.484.273.51
Basic weighted shares outstanding111 M111 M111 M112 M112 M112 M113 M113 M113 M113 M
Cost of sales908 M868 M911 M993 M1,037 M942 M959 M954 M987 M250 M
Depreciation-496 M-572 M-565 M534 M582 M591 M686 M719 M818 M
Depreciation unreconciled-557 M-635 M-623 M534 M582 M591 M756 M799 M902 M
Diluted EPS total3.583.923.954.354.544.774.875.474.263.5
Diluted normalized net income/share3.583.923.954.354.544.774.875.474.263.5
Diluted weighted shares outstanding111 M112 M112 M112 M113 M113 M113 M113 M113 M114 M
Dividends paid per share2.870.03.363.43
GainOnSaleOfSecurity8 M354000.016 M2 M6 M
GeneralAndAdministrativeExpense21 M22 M17 M203 M
Gross operating profit6,073 M6,119 M6,077 M2,616 M2,655 M2,530 M2,628 M2,850 M3,337 M1,388 M
Income before tax5,525 M5,588 M5,540 M1,511 M1,715 M1,566 M1,623 M1,878 M2,177 M1,065 M
Income taxes221 M238 M236 M258 M134 M-16 M78 M110 M75 M57 M
Interest income1 M493000.0884000.03 M9 M0.012 M7 M7 M10 M
InterestExpenseNonOperating197 M192 M203 M214 M231 M
InterestExpenseOperating201 M195 M206 M220 M243 M235 M248 M254 M284 M97 M
MarketingExpense614 M
MinorityInterests23 M0.0-19 M-17 M-21 M-4 M
MiscOtherSpecialCharges-4 M-3 M-925000.0-18 M7 M32 M-1 M20 M-44 M9 M
Net income from total operations447 M469 M482 M524 M590 M585 M551 M619 M484 M398 M
NetIncomeCommonStockholders5,279 M5,331 M5,284 M1,233 M1,562 M1,562 M551 M619 M484 M398 M
NetIncomeContinuousOperations447 M469 M482 M524 M590 M585 M551 M619 M484 M398 M
NetIncomeExtraordinary-26 M-19 M-19 M-19 M-19 M-19 M-17 M
NetNonOperatingInterestIncomeExpense-197 M-192 M-203 M-214 M9 M10 M12 M7 M7 M10 M
NetOperatingInterestIncomeExpense-201 M-195 M-206 M-220 M-243 M-235 M-248 M-254 M-284 M-97 M
Normalized income2,473 M841 M
Operating income5,928 M5,978 M5,949 M1,963 M1,952 M1,769 M788 M805 M3,258 M516 M
Operating income before depreciation (EBITDA)7,413 M7,690 M7,641 M3,774 M3,908 M3,793 M2,557 M2,851 M3,278 M
OperatingExpense144 M142 M128 M653 M703 M761 M756 M87 M832 M235 M
OperationAndMaintenance908 M868 M911 M949 M1,037 M942 M959 M954 M987 M250 M
Other income net4 M3 M925000.018 M-7 M-32 M1 M-20 M44 M-9 M
OtherCostofRevenue1,180 M1,101 M1,076 M981 M1,076 M1,042 M993 M1,153 M1,629 M615 M
OtherGandA21 M22 M17 M203 M
OtherImpairmentOfCapitalAssets753 M
OtherOperatingExpenses-28 M-30 M-39 M-40 M-43 M-26 M-26 M-35 M-43 M-12 M
OtherTaxes172 M172 M166 M184 M213 M219 M225 M235 M220 M53 M
OtherWriteDown614 M
Revenue per share-53 M-58 M-58 M-72 M-68 M-66 M70 M80 M84 M
SalariesAndWages-33 M-19 M-19 M-25 M-50 M-23 M-56 M-113 M-98 M-10 M
Selling Gen & administrative expense614 M203 M
SellingAndMarketingExpense614 M
Special income/charges651 M
Total Income available for interest expense (EBIT)5,924 M5,975 M5,948 M1,945 M1,959 M1,801 M1,871 M2,132 M2,461 M1,162 M
Total common shares outstanding182 M182 M183 M183 M183 M184 M184 M184 M184 M185 M
Total net income447 M469 M482 M524 M590 M585 M551 M619 M484 M398 M
Total ordinary shares113 M113 M113 M113 M113 M113 M113 M113 M113 M113 M
Total revenues6,981 M6,988 M6,988 M3,565 M3,691 M3,471 M3,587 M3,804 M4,324 M1,638 M
TotalExpenses1,052 M1,010 M1,039 M1,646 M1,739 M1,703 M1,715 M1,041 M1,066 M485 M
TotalRevenue3,492 M3,495 M3,499 M3,558 M3,688 M3,471 M3,587 M3,804 M4,324 M1,638 M
WriteDown651 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.

We respect your privacy and will never share your email.
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