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

Sector:    

Industry: 

 
USD
  
  
()
Optionable:   Market Cap:   90-day average vol:

Previous close:   Open:   Bid:   Ask:
52 week range    
   
   

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

Valuation

Returns

Risk

Ranks

Dividends

Analyst Estimates

Financial Health

Technicals

Growth

Profitability

Peers

StockDividendMarket Cap (B)PEPrice ($)
Financials

SJW Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Basic EPS from continuing operations2.561.862.592.891.830.822.162.042.442.69
Basic EPS total2.561.862.592.891.830.822.162.042.442.69
Basic weighted shares outstanding20 M20 M20 M21 M21 M28 M29 M30 M30 M32 M
Depreciation unreconciled38 M41 M45 M48 M55 M66 M89 M94 M104 M106 M
DepreciationAndAmortization38 M41 M45 M48 M55 M66 M89 M94 M104 M106 M
Diluted EPS total2.541.852.572.861.820.822.142.032.432.68
Diluted normalized net income/share2.541.852.572.861.820.822.142.032.432.68
Diluted weighted shares outstanding20 M21 M21 M21 M21 M29 M29 M30 M30 M32 M
Dividends paid per share0.750.190.20.381.120.30.321.361.441.52
Earnings from equity interest12 M9000.0-20000.0927000.0
EarningsFromEquityInterestNetOfTax12 M9000.0-20000.0927000.0
GainOnSaleOfPPE554000.02 M10 M7 M929000.0948000.010 M6 M
GainOnSaleOfSecurity2 M3 M-423000.0117000.0
GeneralAndAdministrativeExpense41 M47 M48 M49 M49 M66 M80 M87 M95 M99 M
Gross operating profit320 M305 M340 M389 M398 M420 M565 M574 M621 M670 M
ImpairmentOfCapitalAssets2 M
Income before tax77 M61 M86 M96 M49 M32 M70 M69 M82 M91 M
Income restructuring and M&A19 M16 M
Income taxes25 M23 M34 M35 M10 M8 M8 M8 M8 M6 M
Interest income155000.07 M
InterestExpenseNonOperating21 M22 M22 M23 M24 M32 M54 M54 M58 M66 M
MinorityInterests224000.0
MiscOtherSpecialCharges2 M1 M1 M-2 M-17000.0-1 M6 M8 M9 M8 M
Net income from total operations153 M130 M158 M193 M183 M166 M234 M60 M74 M85 M
NetIncomeCommonStockholders153 M130 M158 M193 M183 M166 M234 M235 M74 M85 M
NetIncomeContinuousOperations153 M130 M158 M193 M183 M166 M234 M60 M74 M85 M
NetIncomeExtraordinary-2 M-224000.0
NetNonOperatingInterestIncomeExpense-21 M-22 M-22 M-23 M-24 M-25 M-54 M-54 M-58 M-66 M
Normalized income46 M
Operating income194 M172 M198 M236 M236 M216 M290 M111 M131 M149 M
Operating income before depreciation (EBITDA)137 M126 M155 M170 M130 M132 M216 M220 M247 M265 M
OperatingExpense126 M133 M142 M153 M162 M204 M275 M294 M317 M322 M
Other income net-4 M-3 M-15 M-18 M431000.0138000.0-6 M-20 M-16 M-8 M
OtherCostofRevenue101 M92 M105 M134 M144 M143 M172 M22 M66 M73 M
OtherGandA41 M47 M48 M49 M49 M66 M80 M87 M95 M99 M
OtherOperatingExpenses36 M33 M37 M42 M43 M53 M76 M81 M85 M83 M
OtherTaxes11 M12 M12 M14 M15 M19 M30 M31 M33 M34 M
RestructringAndMnAIncome19 M16 M
Revenue per share-364000.0-453000.0-530000.0-616000.0-647000.0-745000.0-1 M2 M4 M1 M
SalariesAndWages-1 M-2 M-2 M-3 M-2 M-3 M-4 M4 M5 M5 M
Selling Gen & administrative expense41 M47 M48 M49 M49 M66 M80 M87 M95 M99 M
Special income/charges19 M16 M2 M
Total Income available for interest expense (EBIT)98 M83 M108 M119 M73 M64 M124 M123 M140 M157 M
Total common shares outstanding20 M20 M20 M21 M28 M28 M29 M30 M31 M32 M
Total net income153 M130 M158 M193 M183 M166 M234 M60 M74 M85 M
Total ordinary shares32 M32 M32 M32 M32 M32 M32 M32 M32 M32 M
Total revenues320 M305 M340 M389 M398 M420 M565 M574 M621 M670 M
TotalExpenses126 M133 M142 M153 M162 M204 M275 M294 M317 M322 M
TotalRevenue320 M305 M340 M389 M398 M420 M565 M574 M621 M670 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