Fundamental Analysis of Consolidated Edison Inc - Growth / Value Index
ED - Valuation Highlights
Valuation Analysis
Undervalued - Price to Intrinsic Value of 0.154
Book Value in last 3 years is trending up
Valuation Key Ratios
| Ratio | TTM | Latest FY | Yoy Change | MRQ |
|---|---|---|---|---|
| Price to Earning | 18.14 | 13.91 | -31.05 % | |
| Price to Book | 2.91 | 1.56 | -2.61 % | 1.52 |
| Price to Sales | 2.25 | 2.17 | 1.36 % | |
| Enterprise Value to EBITDA Multiple | 8.99 | 10.32 | -5.05 % |
ED - Profitability Highlights
Profitability Analysis
Tremendous increasing trend in Net Profit for last 3 year
Company Earning excess return
Piotroski F Score - Stable Value of 5.0
Reasonable Dividend Yield of 3.43 %
EBITDA is continuously increasing for last 3 Years
Steady Growth in EPS for last four quarters
Good Return on Equity of 18.83% is achieved by the company
Good Net Margin of 12.42% is achieved by the company
Low Earning Yield of 5.37 %
In the last three years, the company has given poor Returns on Assets
Profitability Key Ratios
| Ratio | TTM | Latest FY | Yoy Change | MRQ |
|---|---|---|---|---|
| Return On Equity | 18.83 | 11.23 | 39.89 % | 3.33 |
| Return On Asset | 4.42 | 3.58 | 48.97 % | 1.08 |
| Net Profit Margin | 12.42 | 15.57 | 47.01 % | 16.82 |
| Operating Profit Margin | 16.97 | 15.93 | -4.88 % | 23.62 |
| EBITDA Margin | 42.90 | 35.85 | 8.76 % | 40.49 |
Highlights
| Market Cap | 32698.70 M |
| Enterprise Value | 56090.70 M |
| Price/Book TTM | 2.91 |
| Outstanding Share | 345835 K |
| Float/ Outstanding Share | 99.83% |
| Dividend Yield | 3.59 % |
Share Holding
Guru Numbers
| Price/Graham No | 1.12 |
| Peter Lynch Ratio | 2.48 |
| Piotroski F Score | 5.00 |
| Altman Z Score | 1.12 |
| Sloan Ratio | -0.0019 |
| Peter Lynch Fair Value | 32.50 |
ED - Growth Highlights
Growth Analysis
YoY Net Margin Jump by 47.01%
Tsr Growth Index - Very Poor Score of 15.14
Growth Key Fields
| Field | TTM | YoY Growth | QoQ Growth |
|---|---|---|---|
| Revenue | 14540.00 M | 2.68 % | 24.27 % |
| Gross Profit | 9599.00 M | 3.23 % | 37.40 % |
| EBITDA | 6237.00 M | 5.85 % | 50.56 % |
| Net Profit | 1806.00 M | 43.07 % | 115.57 % |
| EPS | 5.21 | 45.04 % | NA |
ED - Stability Highlights
Stability Analysis
Altman Z Score of 1.13 suggest high risk
Company is unable to generate enough free cash to support the business.
Stability Key Ratios
| Ratio | Latest FY | Yoy Change | MRQ |
|---|---|---|---|
| Debt to Equity Ratio | 1.16 | 0.396 % | 1.14 |
| Cash Ratio | 0.184 | 62.70 % | |
| Quick Ratio | 0.939 | -14.70 % | 0.917 |
| Shareholders Equity | 31.90 | 6.49 % | |
| Debt to EBITDA | 4.50 | -2.99 % |
Historical Valuation Ratios of Consolidated Edison Inc
Historical Valuation Ratios
Loading ...
Historical Profitability Ratios of Consolidated Edison Inc
Historical Profitability Ratios
Loading ...
Historical Efficiency Ratios of Consolidated Edison Inc
Historical Efficiency Ratios
Loading ...
Historical Solvency Ratios of Consolidated Edison Inc
Historical Solvency Ratios
Loading ...
Note : All Data Generated at the End of Trading Hours (EOD Data)