Last Price$103.8(2.7%)
Market Cap$36.3B
LTM Quick ratio
0.8x
5Y avg
0.6x
Regulated Electric industry
median
0.3x
Stock quality & Intrinsic value
5/10
0.1% undervalued
Consolidated Edison, Inc. Quick ratio
Annual
Quarterly
LTM
Industry median
Company stand-alone
Crunching data... Almost there!
| Dec'05 | Dec'06 | Dec'07 | Dec'08 | Dec'09 | Dec'10 | Dec'11 | Dec'12 | Dec'13 | Dec'14 | Dec'15 | Dec'16 | Dec'17 | Dec'18 | Dec'19 | Dec'20 | Dec'21 | Dec'22 | Dec'23 | Dec'24 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Quick ratio | 0.4x | 0.7x | 0.4x | 0.5x | 0.8x | 1.0x | 0.9x | 0.6x | 0.6x | 0.7x | 0.6x | 0.7x | 0.6x | 0.5x | 0.5x | 0.5x | 0.8x | 0.4x | 0.8x | 0.1x |
Overvalued or undervalued?
Check the intrinsic value for ED
and see if it's the right time to invest.
Consolidated Edison, Inc. (ED) Quick ratio comparison analysis
General
LTM Quick ratio
OTHER METRICS
Company name
Revenue growth
EPS growth
Net Income margin
Consolidated Edison, Inc.ED
0.8x
4.0%
(27.3%)
11.9%
Median Peer Set
0.3x
0.2%
5.9%
14.7%
PG&E CorporationPCG
0.8x
(0.0%)
9.2%
10.3%
National Grid plcNGG
0.6x
(4.5%)
(71.6%)
11.5%
Exelon CorporationEXC
0.4x
6.0%
4.7%
10.7%
Xcel Energy Inc.XEL
0.3x
(5.4%)
7.2%
14.4%
The Southern CompanySO
0.3x
5.8%
10.4%
16.5%
Public Service Enterprise Group IncorporatedPEG
0.3x
(8.4%)
(30.9%)
17.2%
Dominion Energy, Inc.D
0.3x
0.5%
(99.9%)
0.0%
NextEra Energy, Inc.NEE
0.2x
(39.5%)
(38.8%)
26.7%
American Electric Power Company, Inc.AEP
0.2x
3.9%
31.5%
15.0%
Duke Energy CorporationDUK
0.1x
4.5%
69.6%
14.9%
ED key stats
USD
Millions
Billions
Annual
Quarterly
Trailing
Key stats
Income statement
Balance sheet
Cash Flow Statement
Valuation
Ratios
Per share
Per employee
Dividends & Yields
| Dec'05 | Dec'06 | Dec'07 | Dec'08 | Dec'09 | Dec'10 | Dec'11 | Dec'12 | Dec'13 | Dec'14 | Dec'15 | Dec'16 | Dec'17 | Dec'18 | Dec'19 | Dec'20 | Dec'21 | Dec'22 | Dec'23 | Dec'24 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
% growth | 11,690.0 19.8% | 12,137.0 3.8% | 13,120.0 8.1% | 13,583.0 3.5% | 13,032.0 (4.1%) | 13,325.0 2.2% | 12,938.0 (2.9%) | 12,188.0 (5.8%) | 12,354.0 1.4% | 12,919.0 4.6% | 12,554.0 (2.8%) | 12,075.0 (3.8%) | 12,033.0 (0.3%) | 12,337.0 2.5% | 12,574.0 1.9% | 12,246.0 (2.6%) | 13,676.0 11.7% | 15,670.0 14.6% | 14,663.0 (6.4%) | 15,256.0 4.0% |
| Cost of Goods Sold (COGS) | 6,714.0 | 6,695.0 | 7,225.0 | 7,584.0 | 6,242.0 | 5,732.0 | 5,001.0 | 7,069.0 | 7,191.0 | 7,807.0 | 7,060.0 | 6,357.0 | 5,928.0 | 6,100.0 | 5,808.0 | 5,097.0 | 6,008.0 | 7,985.0 | 7,258.0 | 2,739.0 |
% margin | 4,976.0 42.6% | 5,442.0 44.8% | 5,895.0 44.9% | 5,999.0 44.2% | 6,790.0 52.1% | 7,593.0 57.0% | 7,937.0 61.3% | 5,119.0 42.0% | 5,163.0 41.8% | 5,112.0 39.6% | 5,494.0 43.8% | 5,718.0 47.4% | 6,105.0 50.7% | 6,237.0 50.6% | 6,766.0 53.8% | 7,149.0 58.4% | 7,668.0 56.1% | 7,685.0 49.0% | 7,405.0 50.5% | 12,517.0 82.0% |
| Operating Expenses | 3,454.0 | 3,775.0 | 4,048.0 | 4,340.0 | 4,891.0 | 5,473.0 | 5,698.0 | 2,780.0 | 2,919.0 | 2,948.0 | 3,067.0 | 3,247.0 | 3,496.0 | 3,704.0 | 4,090.0 | 4,495.0 | 4,842.0 | 5,061.0 | 4,209.0 | 12,524.0 |
| Research & Development Expenses (R&D) | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 21.0 | 18.0 | 22.0 | 23.0 | 24.0 | 24.0 | 24.0 | 24.0 | 24.0 | 25.0 | 27.0 | 0.0 | 0.0 |
| Selling, General & Administrative Expenses (SG&A) | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 205.0 | 3,139.0 | 3,152.0 | 3,175.0 | 2,814.0 | 3,254.0 | 3,905.0 | 745.0 | 0.0 |
% margin | 1,522.0 13.0% | 1,667.0 13.7% | 1,847.0 14.1% | 1,659.0 12.2% | 1,899.0 14.6% | 2,120.0 15.9% | 2,239.0 17.3% | 2,339.0 19.2% | 2,244.0 18.2% | 2,209.0 17.1% | 2,427.0 19.3% | 2,575.0 21.3% | 2,610.0 21.7% | 2,664.0 21.6% | 2,676.0 21.3% | 2,654.0 21.7% | 2,826.0 20.7% | 2,624.0 16.7% | 3,196.0 21.8% | 2,670.0 17.5% |
| Interest Income | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 14.0 | 99.0 | 0.0 | 0.0 |
| Interest Expense | 0.0 | 0.0 | 0.0 | 544.0 | 611.0 | 609.0 | 594.0 | 604.0 | 719.0 | 591.0 | 653.0 | 696.0 | 729.0 | 819.0 | 991.0 | 1,019.0 | 919.0 | 951.0 | 1,023.0 | 1,187.0 |
| Pre-tax Income | 1,073.0 | 1,128.0 | 1,362.0 | 1,446.0 | 1,319.0 | 1,551.0 | 1,662.0 | 1,741.0 | 1,538.0 | 1,660.0 | 1,798.0 | 1,943.0 | 1,997.0 | 1,783.0 | 1,736.0 | 1,234.0 | 1,383.0 | 2,098.0 | 3,003.0 | 2,138.0 |
% effective tax rate | 341.0 31.8% | 390.0 34.6% | 437.0 32.1% | 524.0 36.2% | 440.0 33.4% | 548.0 35.3% | 600.0 36.1% | 600.0 34.5% | 476.0 30.9% | 568.0 34.2% | 605.0 33.6% | 698.0 35.9% | 472.0 23.6% | 401.0 22.5% | 296.0 17.1% | 90.0 7.3% | 190.0 13.7% | 498.0 23.7% | 487.0 16.2% | 318.0 14.9% |
% margin | 719.0 6.2% | 737.0 6.1% | 929.0 7.1% | 1,196.0 8.8% | 879.0 6.7% | 1,003.0 7.5% | 1,062.0 8.2% | 1,141.0 9.4% | 1,062.0 8.6% | 1,092.0 8.5% | 1,193.0 9.5% | 1,245.0 10.3% | 1,525.0 12.7% | 1,382.0 11.2% | 1,343.0 10.7% | 1,101.0 9.0% | 1,346.0 9.8% | 1,660.0 10.6% | 2,519.0 17.2% | 1,820.0 11.9% |
| EPS | 2.95 | 2.96 | 3.49 | 4.38 | 3.16 | 3.49 | 3.59 | 3.88 | 3.62 | 3.73 | 4.07 | 4.15 | 4.97 | 4.43 | 4.09 | 3.29 | 3.86 | 4.68 | 7.24 | 5.26 |
| Diluted EPS | 2.94 | 2.95 | 3.47 | 4.37 | 3.14 | 3.47 | 3.57 | 3.86 | 3.61 | 3.71 | 4.05 | 4.12 | 4.94 | 4.42 | 4.08 | 3.28 | 3.85 | 4.67 | 7.21 | 5.24 |
% margin | 2,089.0 17.9% | 2,272.0 18.7% | 2,479.0 18.9% | 2,718.0 20.0% | 2,721.0 20.9% | 3,000.0 22.5% | 3,140.0 24.3% | 3,300.0 27.1% | 3,268.0 26.5% | 3,235.0 25.0% | 3,557.0 28.3% | 3,687.0 30.5% | 3,951.0 32.8% | 3,801.0 30.8% | 4,279.0 34.0% | 4,371.0 35.7% | 4,720.0 34.5% | 5,034.0 32.1% | 6,062.0 41.3% | 5,480.0 35.9% |
Discover more Stock Ideas
Undervalued stocks right now
Discover the top 20 best undervalued stocks to buy for Mar 2025, listed on the Nasdaq or NYSE.
3M Return 32.1%
S&P Outperformance 19.1%
Next 3M Predicted Return 20.3%
Undervalued growth stocks
Discover the top 20 best undervalued large-cap growth stocks to buy for Mar 2025, listed on the Nasdaq or NYSE.
3M Return 35.3%
S&P Outperformance 22.3%
Next 3M Predicted Return 26.8%
Undervalued dividend stocks
Discover the top 20 best undervalued high-yield dividend stock that offers both growth potential and attractive dividend returns for Mar 2025.
3M Return 28.4%
S&P Outperformance 15.4%
Next 3M Predicted Return 16.9%
FAQ
1) What is Consolidated Edison, Inc.'s Quick ratio?
As of today, Microsoft Corp's last 12-month Quick ratio is 0.8x, based on the financial report for Dec 31, 2024 (Q4’2024). The average annual Quick ratio for Consolidated Edison, Inc. have been 0.7x over the past three years, and 0.7x over the past five years.
2) Is Consolidated Edison, Inc.'s Quick ratio Good?
As of today, Consolidated Edison, Inc.'s Quick ratio is 0.8x, which is higher than industry median of 0.3x. It indicates that Consolidated Edison, Inc.'s Quick ratio is Good.