

_edited.png)
RISK CONCERN
Investment Strategy, Risk Analysis, and Insights by Chartered Professionals
AWK
Primary Facts
Utilities�Regulated Water
Name:
-
Sector:
- 290000.00K
Industry:
148.12
CEO:
Ms. Susan Story
Total Employees:
Large Cap
Our Technological Advancement Rating
Our Rating:
10.41021686
2.638621236
American Water Works Company, Inc. (XNYS:AWK) In-Depth Stock/Fundamental/Options Analysis Today
Primary Targets/Price Insights
Previous Close ($) :
AMERICAN WATER WORKS COMPANY, INC. (XNYS:AWK)
One Month Price Target:
Six Month Price Target :
$148.49
Likely Price in One Year's Time:
Ticker:
$150.34
Likely Trading Range Today Under (Normal Volatility)
$148.69
Price Upper limit ($) :
$152.56
Price Lower limit ($) :
Crash Risk Prep/Key Price Levels (High Volatility/Risk)
Price, as per data analysis, isn't likely to fall below:
Today:
P268
This week:
$142.13
This month :
$134.72
Other Primary facts
Market Cap:
181.79M
Market Cap Classification:
26.98B
Number of Shares
IPO Date:
A+
Best/Worst Daily Performance (Last 3+ Years)
Highest Daily Appreciation:
-12.53%
$121.32
Worst Daily Decline:
Our Options Trading Entry Points
Iron Condor entry points for options expiring in 1 week's time
Low risk (<2%) entry points
Buy Call:
Sell Call:
Buy Put:
Sell Put:
$163.12
16.57%
$133.12
$175.92
Medium risk (<10%) entry points
Buy Call
Sell Call
$156.22
Buy Put:
Sell Put:
$120.32
$140.02
$158.95
These entry points can be used for other strategies, such as butterflies, straddles, etc.
Risk-Adjusted returns (Sharpe Ratio) of
Utilities�Regulated Water
Sharpe Ratio:
AWK, is amongst the top 60% highest yielding stocks in terms of daily returns
Comparison:
1.67%
0.21828192
Sharpe ratio is 21.83% higher than the industry
Average Returns/Yield of
Utilities�Regulated Water
Daily returns:
1
Weekly returns:
0.05%
Monthly returns:
0.25%
Yearly returns:
11.86%
Comparison of returns:
0.065492094
Classification:
Average annual returns/yield (last 3 years) is 6.55% above industry average
Results of T-Test of Returns:
AWK is a riskier investment compared to Nasdaq (IXIC)
Statistical test of Returns:
0.43

Volatility (measured by Standard Deviation)
Daily Volatility:
& is -10.77% lower than the market/S&P 500 average
Weekly Volatility:
1.99%
Monthly Volatility:
4.46%
Yearly Volatility:
8.92%
Volitlilty of last five days (Measured by Standard Deviation)
Average Volatility of this Week:
38.87%
-7.59%
Value at Risk Analysis (VaR)
Daily VaR:
Volatility in last five trading days has been -7.59% below long-term volatility
Weekly VaR:
-4.05%
Monthly VaR:
-9.05%
How Much Can the price of
Utilities�Regulated Water
Decline in a Recession?
Likely price decline in a recession:
Base case (decline):
Risk of crash in next 6/12 months: High (50-70%)
Worst case (decline):
$125.26
This translates to price declining to:
-15%
This translates to price declining to:
-62.68%
Severe Crash Probability
-18.09%
What is Value at Risk (VaR)?

Risk Fundamentals
9.41%
AWK is a 27.71% riskier investment compared to the market/S&P 500 & is 9.41% riskier than Nasdaq (IXIC)
AWK is a 27.71% riskier investment compared to the market/S&P 500
Beta Examination of
Utilities�Regulated Water
0.447
Expected beta in 1 year's time:
0.689
Expected beta in 3 year's time:
0.582
Unlevered (debt free) Beta:
Beta in relation to market/S&P 500--0.45
Beta in relation to Nasdaq (XNAS):
Returns are, approximately, symmetrical
Beta in relation to all global stocks::
Beta is -18.08% below industry average
Beta Comparison & Analysis
Beta of competitors/peers::
0.215
-0.198
Average Industry Beta:
Beta is -19.76% lower than peers
-0.180846672
Sustainable Growth Rate Analysis
Sustainable growth rate for this stock/firm:
WACC is -28.30% below industry mean WACC
60.08%
Alpha provided | Alpha Analysis
Alpha provided:
0.823
0.331
3.596
Analysis of Cost of Capital of
Utilities�Regulated Water
Equity cost of capital:
Alpha is 360% higher than market/& is unsustainably high
-0.098
Unlevered (without debt) cost of capital:
Equity cost of capital is -9.81% below industry mean WACC
Before-tax cost of debt:
3.00%
After-tax cost of debt:
1.88%
Overall debt rating:
1.48%
Weighted average cost of capital (WACC):
1.88%
-28.30%
Key Per-Share Metrics & Analysis
Revenue per share:
Present value of the expected future dividends only: $74.98
Revenue growth rate per share of (3Y):
Price to sales ratio is -22.34% below the industry mean
-34.47%
EPS:
One Billion Two Hundred Eighty-Six Million Eight Hundred Eleven Thousand Two Hundred Forty Dollars
Expected Annual growth rate of EPS (3Y):
-
116.30%
Free cash flow (FCF) per share:
Price to book ratio is -0.38% below the industry mean
-
0.576191721
Debt per share
Debt repayment rate in last quarter: 0.05%
EBITDA per share
Each employee generates 34% more EBITDA than industry average revenue per employee
Valuation Analysis Today of
Utilities�Regulated Water
P/E Ratio:
Sustainable growth rate is 60.08% above industry average
P/E Ratio of Competitors/Peers:
20.75
-0.258908423
198.26136
-0.252905357
-
Share value as per dividend discount (DDM) model: $120.34
P/S (Price to Sales ratio):
$21.37
-0.223426239
P/B (Price to book value ratio):
Price to sales ratio is -22.34% below the industry mean
-
-
Net income growth rate (3Y):
Annual revenue growth rate is -34.47% below industry average
128.27%
Dividend Analysis
Net income growth rate is 128.27% higher than the average industry net income growth rate
Dividend payout rate: 8.46%
$0.66
Previous Dividend: $0.66
Previous adjusted dividend: $0.66
Previous Dividend: $2.46
Expected next dividend best case: $0.69
Expected next dividend worst case: $0.62
Average dividend payment (long-term): $0.57
Average dividend increase/decrease (growth rate) % per period: 2.83%
Expected next dividend payment date: 30/08/2022
Expected next dividend record date: 08/08/2022
Expected next dividend declaration date: 26/07/2022
Previous dividend payment date: 06/01/2022
Previous dividend record date: 05/10/2022
Dividend History:
Previous dividend declaration date: 27/04/2022
2022-02-07--$0.60
2021-08-09--$0.60
2022-05-09--$0.66
2021-11-09--$0.60
2021-05-10--$0.60
-0.638654802
In-depth Debt & Leverage Analysis
Debt to equity ratio:
143.81%
Net debt to equity ratio:
The remaining useful life of property plant & equipment is: 9.0 years
Debt to assets ratio:
41.75%
Net debt to assets ratio:
139.75%
-44.72%
Ability to repay debt:
Interest coverage ratio:
Debt-to-asset ratio is -44.72% below industry average
3.81
Looking forward:
Debt growth rate:
1.7x
-
0.05%
Analysis of Key Statistics
Correlation of price movement with the market:
20.72542825
Statistical significance of correlation:
-0.29%
Average Correlation of the industry with the market:
0.621
10.85%
R Squared (percentage of price movement explained by movement of the market):
0.621
Correlation of price movement with Nasdaq (^IXIC):
0.385
Covariance of price movement with the market:
0.002
Kurtosis
0.002
12.500
Skewness of returns:
Returns have severe fat-tails (leptokurtic), i.e., returns considerably higher or lower than the mean returns are considerably more likely, compared to assets with normally distributed returns
0.221
Fundamental Analysis & Dupont Analysis of
Utilities�Regulated Water
Gross Profit Margin Ratio:
2.16B
Operating Profit Margin Ratio:
Net profit margin is 33.73% higher than the industry
25.94%
Net Profit Margin Ratio:
2.16B
Effective Tax Rate:
-
0.982259616
Dupont Method
Net Profit Margin
Return on Equity Ratio (ROE):
×
ROA
=
×
Return on assets (ROA) is 48.80% higher than the industry
64.29%
Financial Leverage
Asset Turnover Ratio (ROA):
Operating profit margin is 25.94% higher than the industry
48.80%
Financial Leverage:
Interest coverage ratio is 380.75% more than industry average
Current Ratio:
Return on equity (ROE) is 64.29% higher than the industry
-0.248223796
Cash Conversion Cycle (days):
$57.35
-1.376741784
Current ratio is -24.82% below industry average
Stock based compensation to net income ratio:
Equity growth rate per share is 57.62% higher than the industry
In-depth Efficiency Analysis
Revenue generated per employee:
Cash conversion cycle is -137.67% below industry average
0.122553067
EBITDA generated per employee:
Each employee generates 12% more revenue than industry average revenue per employee
0.339384321
Profit generated per employee:
$13.85
31%
Free cash flow (FCF) generated per employee:
Each employee generates 31% more net income/profit than industry average revenue per employee
4.481846334
Assets/Capital per employee
Each employee generates 448% more free cash flow than industry average revenue per employee
4.481846334
Research & Development (R&D) Analysis
-
-
Competitors/Peer firms of
Utilities�Regulated Water
$267.12
Eversource Energy (XNYS:ES)
WEC ENERGY GROUP, INC. (XNYS:WEC)
CONSOLIDATED EDISON, INC. (XNYS:ED)
PG&E CORPORATION (XNYS:PCG)
EDISON INTERNATIONAL (XNYS:EIX)
FIRSTENERGY CORP. (XNYS:FE)
DTE ENERGY COMPANY (XNYS:DTE)
AMEREN CORPORATION (XNYS:AEE)
Current Analyst Ratings
$7.08
Strong buy�13%
Buy�13%
Hold�38%
Sell�0%
Strong sell�0%
Income Statement
Period:
3/31/2022
Date:
Value
Revenue:
TTM
Cost of Revenue:
Gross Profit:
R&D Expense
General & Admin Expenses:
Selling, General & Admin Expenses
Sales and Marketing Expenses
Other Expenses :
Operating Expenses :
Cost & Expenses :
Interest Income:
Interest Expenses:
Depreciation & Amortization:
EBITDA:
Operating Income:
Other Income Expenses:
Income Before Tax:
Income Tax Expense:
Net Income:
Balance Sheet
Date:
Calendar Year:
Period:
Cash & Cash Equivalents:
Short Term Investments:
Cash & Short Term Investments:
Net Receivables:
Inventory:
Other Current Assets:
Total Current Assets:
PP&E:
Goodwill:
Intangible Assets:
Long Term Investments:
Tax Assets:
Other Non-Current Assets:
Total Non-Current Assets:
Other Assets:
Total Assets:
Accounts Payable:
Short Term Debt:
Tax Payables:
Deferred Revenue:
Other Current Liabilities:
Total Current Liabilities:
Long Term Debt:
Other Non-Current Liabilities:
Total Non Current Liabilities:
Other Liabilities:
Total Liabilities:
Common Stock:
Retained Earnings:
Accumulated Other Comprehensive Loss:
Other Total Stockholders' Equity:
Total Stockholders' Equity:
Total Liabilities and Stockholders' Equity:
Total Investments:
Total Debt:
Net Debt:
3.88B
1.72B
222%
-
-
-
-
949.00M
2.67B
17.00M
203.00M
637.00M
262%
390.00M
465.00M
173%
390.00M
Statement of Cash Flow
Date:
Period:
158.00M
Differed Income Tax :
158.00M
Stock Based Compensation :
- 61000.00K
Change in Working Capital :
-
Accounts Receivables:
- 71000.00K
Other Working Capital:
-
Other Non-Cash Items:
45.00M
Net Cash Provided by Operating Activities:
- 30000.00K
Investments in PP&E:
154.00M
Net Acquisitions:
- 20000.00K
Purchases of Investments:
- 5000.00K
Sales/Maturities of Investments:
Other Investing Activities:
Net Cash Used for Investing Activities:
Debt Repayment:
Common Stock Issued:
Common Stock Repurchased:
Dividend Paid:
Other Financing Activities:
Net Cash Used Provided by Financing Activities:
Effect of FOREX on Changes in Cash:
Net Changes in Cash:
Cash at End of Period:
Cash at Beginning of Period:
Operating Cash Flow:
Capital Expenditure:
Free Cash Flow (FCF):
Value
3/31/2022
2022
Q1
75.00M
-
75.00M
520.00M
71.00M
187.00M
853.00M
21.49B
1.14B
-
-
-
2.21B
24.84B
-
25.69B
175.00M
378.00M
285.00M
-
1.10B
1.65B
10.43B
3.78B
16.59B
-
18.23B
2.00M
1.08B
- 44000.0K
Value
949.00M
-
7.46B
25.69B
-
10.80B
-
-
184.00M
159.00M
- 5000.00K
-
-
- 109000.00K
- 239000.00K
- 353000.00K
-
- 40000.00K
96.00M
136.00M
154.00M
- 444000.00K
Our Proprietary Portfolio Rating
Our Rating:
249.3125097



Price Forecast/Expected Price in Next 5 Years of
Utilities�Regulated Water
2023
2024
2025
2026
2027
237.325669
$153.32
$244.45
$251.78
$259.34