— Know what they know.
Not Investment Advice

CPGX NYSE

Columbia Pipeline Group, Inc.
1W: +0.0% 1M: -0.2% 3M: +1.6%
$25.49
Last traded 2016-06-30 — delisted
NYSE · Energy · Oil & Gas Midstream

Edge Score

Quantitative competitive moat analysis scoring five pillars of durable advantage — cost leadership, brand intangibles, switching costs, network effects, and efficient scale — using industry percentile rankings on a 0–100 scale.

WEAK EDGE
50.8 / 100
NoneWeakNarrowWide
Primary source: Switching Costs  ·  ROIC: 3.0%
Cost Advantage
41
Intangibles
58
Switching Cost
72
Network Effect
25
Scale
42
The Edge Score quantifies a company's competitive moat using five pillars: Cost Advantage (20%, operating margin and SG&A efficiency vs industry peers), Intangible Assets (25%, gross margin premium, R&D intensity, brand pricing power), Switching Costs (25%, revenue stability, earnings consistency, customer retention proxied by operating leverage), Network Effects (15%, revenue growth with expanding margins, market share dominance), and Efficient Scale (15%, market concentration, ROIC sustainability). Each pillar is scored 0–100 using industry percentile rankings, then weighted into a composite. Wide ≥ 70, Narrow ≥ 55, Weak ≥ 40, None < 40. CPGX shows a Weak competitive edge (50.8/100) — limited structural advantages that may face competitive pressure. The primary source of advantage is Switching Costs. ROIC of 3.0% suggests modest returns relative to capital deployed.

InsiderStreet Scorecard

Proprietary multi-factor scorecard rating companies across seven fundamental dimensions — profitability, balance sheet strength, earnings quality, growth, value, momentum, and safety — each scored 0–100.

★ ★ ★ ★ ★ 48 Grade A
Profitability
56
Balance Sheet
41
Earnings Quality
81
Growth
75
Value
35
Momentum
100
Safety
30
Cash Flow
35
The InsiderStreet Scorecard rates companies across eight dimensions: Profitability (margins, ROA, ROE), Balance Sheet (leverage, liquidity, coverage), Earnings Quality (accruals, cash conversion), Growth (revenue and earnings trajectory), Value (P/E, P/B, earnings yield, Graham criteria), Momentum (revenue and earnings acceleration), Safety (Altman Z-Score risk adjustment), and Cash Flow (operating cash flow quality, FCF conversion, cash coverage). The overall score blends 35% quality, 35% value, and 30% momentum, with a penalty for distress-zone Altman scores. CPGX scores highest in Momentum (100/100) and lowest in Safety (30/100). An overall grade of A places CPGX among the highest-quality companies in its peer group.

Risk & Quality Signals

Academic financial models used by institutional investors to assess bankruptcy risk, earnings manipulation, financial strength, and credit quality.

Altman Z-Score
1.44
Distress Zone
Piotroski F-Score
6/9
✓ ✓ ✓ ✓ ✓ ✗ ✗ ✗ ✓
Beneish M-Score
-2.35
Unlikely Manipulator
Ohlson O-Score
-7.42
Bankruptcy prob: 0.1%
Low Risk
Credit Rating
BB-
Score: 38.8/100
Trend: Deteriorating
Earnings Quality
100/100
OCF/NI: 3.08x
Accruals: -2.4%
The Altman Z-Score (1968) combines five ratios — working capital, retained earnings, EBIT, market value of equity, and sales, all relative to total assets or liabilities — into a single bankruptcy predictor. CPGX scores 1.44, placing it in the Distress Zone (safe > 2.99, distress < 1.81). Historically, companies in this range face elevated bankruptcy risk. The Piotroski F-Score (2000) is a 9-point binary checklist — four profitability tests (positive ROA, positive cash flow, improving ROA, cash flow exceeding net income), three leverage tests (declining debt ratio, improving current ratio, no share dilution), and two efficiency tests (improving gross margin, improving asset turnover). Each pass scores 1 point. CPGX scores 6/9, indicating moderate financial health — some areas of strength offset by weaknesses in others. The Beneish M-Score (1999) is an 8-variable model that detects earnings manipulation by comparing year-over-year changes in receivables, gross margins, asset quality, sales growth, depreciation, SG&A, leverage, and accruals. Scores above −1.78 statistically resemble past manipulators. CPGX's score of -2.35 falls below this threshold, suggesting earnings are unlikely to be manipulated. The Ohlson O-Score (1980) is a 9-variable logistic regression that estimates bankruptcy probability using firm size, leverage, working capital, current ratio, profitability (ROA), cash flow coverage, negative equity flag, consecutive losses flag, and earnings trajectory. The raw score is converted to a probability via logistic transformation. CPGX's implied 0.1% bankruptcy probability is well within safe territory. Our Credit Rating model scores companies on five weighted components — solvency (30%), earning power (25%), leverage (20%), liquidity (15%), and cash flow quality (10%) — then blends the absolute score with sector and industry peer rankings. For companies with large buyback programs, equity is adjusted by adding back cumulative 5-year repurchases (capped at 80% of FCF generated) to avoid penalizing shareholder-friendly capital allocation. CPGX receives an estimated rating of BB- (score: 38.8/100), with a deteriorating trend. The Earnings Quality score measures how well reported earnings are backed by real cash. It evaluates the operating cash flow to net income ratio (OCF/NI ≥ 1.0 means every dollar of earnings is cash-backed) and the accruals ratio (the gap between earnings and cash flow relative to assets — lower is better). CPGX's score of 100/100 is high — cash flows strongly support reported earnings.

Valuation

Key valuation multiples comparing the stock's market price to its earnings, revenue, book value, and cash flows. Lower multiples may indicate relative undervaluation versus peers.

P/E
106.21x
PEG
-1.92x
P/S
0.00x
P/B
2.77x
P/FCF
-11.40x
P/OCF
34.12x
EV/EBITDA
29.78x
EV/Revenue
10.70x
EV/EBIT
42.20x
EV/FCF
-13.72x
Earnings Yield
0.95%
FCF Yield
-8.77%
Shareholder Yield
0.05%
Graham Number
$7.08
Equity-based multiples (P/E, P/B, P/FCF) compare the stock price to per-share fundamentals and are affected by capital structure. Enterprise value multiples (EV/EBITDA, EV/Revenue, EV/FCF) strip out debt and cash, making them more useful for cross-company comparisons regardless of how companies are financed. The Graham Number — √(22.5 × EPS × Book Value) — is Benjamin Graham's formula for the maximum price a defensive investor should pay. At 106.2x earnings, CPGX is priced for high growth expectations. Graham's intrinsic value formula yields $7.08 per share, 260% below the current price.

DuPont Decomposition (5-Factor)

The 5-factor DuPont framework breaks Return on Equity into its component drivers — tax efficiency, interest burden, operating profitability, asset utilization, and financial leverage — to reveal what truly drives shareholder returns.

Tax Burden
0.505
NI / EBT
×
Interest Burden
0.660
EBT / EBIT
×
EBIT Margin
0.254
EBIT / Rev
×
Asset Turnover
0.134
Rev / Assets
×
Equity Multiplier
2.425
Assets / Equity
=
ROE
2.8%
The 5-factor DuPont identity decomposes ROE as: Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Equity Multiplier = ROE. This reveals whether returns are driven by operating performance, financial leverage, or tax efficiency — three very different sources of profitability. CPGX's ROE of 2.8% is driven by a balanced combination of operating margin, asset efficiency, and leverage. A tax burden ratio of 0.50 suggests the company retains less than 60% of pre-tax earnings after taxes.

Graham-Dodd Adjusted Valuation

Our adaptation of Graham's growth formula (Fair P/E = 8.5 + 2g) from The Intelligent Investor. The classic version relies on analyst growth projections, which can be unreliable. This adjusted model substitutes the company's realized 3-year EPS CAGR — a backward-looking, verifiable measure of actual earnings power — grounding the valuation in demonstrated performance rather than forecasts.

Two adjustments we make, and why. Growth is capped at 15%. Graham defined g as expected growth over the next seven to ten years, not last year's rate. Across US companies since 1994 the median realized 7-year EPS growth is 5–8% regardless of how fast a company grew beforehand, and of 4,457 company-quarters that grew faster than 200%, none sustained it. Uncapped, the formula assigned fair multiples in the hundreds to companies that had never held that rate — and scored worse than simply reading the P/E. Capped, it carries real information. The verdict has three states, not two. Tested over 377,249 stock-months, this ratio only separates outcomes at its extremes: below 0.25 beat the universe by 1.3 points a year, above 3.0 lagged by 2.7, and everything in between sat inside a one-point band. Rather than call two-thirds of the market "undervalued" on a threshold of 1.0, we say Neutral where the model cannot tell — which is most of the time.

Adj. Growth Rate
15.00%
Fair P/E
38.50x
Intrinsic Value
$9.33
Price/Value
2.73x
Margin of Safety
-173.30%
Premium
173.30%
Assessment
Neutral
Graham's classic formula uses analyst-projected growth to estimate a fair P/E (8.5 + 2g). Our adjusted version replaces that projection with CPGX's realized 15.0% 3-year EPS CAGR, capped at 15% — demonstrated performance rather than forecasts, held to a rate companies have historically sustained. CPGX trades at a 173% premium to its adjusted intrinsic value of $9.33, suggesting the market is pricing in future growth beyond what historical earnings support. The adjusted fair P/E of 38.5x compares to the current market P/E of 106.2x.

Profitability Trends

Historical profitability ratios tracking how efficiently the company converts revenue into returns for shareholders over time.

Leverage & Solvency Trends

Debt and liquidity metrics showing the company's financial leverage and ability to meet short-term and long-term obligations.

Efficiency & Working Capital Trends

Operating efficiency metrics measuring how quickly the company converts inventory to sales, collects receivables, and manages its cash conversion cycle.

Growth Trends (YoY %)

Year-over-year growth rates for key financial metrics, showing the trajectory of revenue, earnings, and cash flow generation.

Earnings Stability

R-squared of linear regression measuring how predictably revenue, earnings, and margins follow a trend over the trailing 5 years. 1.0 = perfectly predictable; lower values indicate erratic or cyclical behavior.

Monte Carlo Price Simulation

Geometric Brownian Motion with 1,000 antithetic paths over 1 year, seeded from 252 days of historical volatility. Percentile bands show the range of statistically plausible outcomes — this is a statistical model, not a forecast.

Current Price
$25.49
Median 1Y
$20.10
5th Pctile
$10.91
95th Pctile
$37.19
Ann. Volatility
35.6%
25th–75th percentile 5th–95th percentile Median path Historical
All Ratios & Metrics

Complete fundamental data with up to 20 periods of history, sparkline trends, and current values across 13 categories and 130+ financial metrics.

Profitability
Metric Trend Q4'15 Q1'16 Q2'16 Q3'16 Q4'16 Current
ROE 1.6% 3.4% 4.4% 3.1% 2.8% 2.75%
ROA 0.6% 1.3% 1.7% 1.2% 1.1% 1.13%
ROIC 1.4% 3.1% 3.9% 3.1% 3.0% 3.04%
ROCE 1.4% 3.1% 4.1% 3.7% 3.5% 3.50%
Gross Margin 1.0% 1.0% 1.0% 1.0% 1.0% 1.00%
Operating Margin 34.1% 41.6% 29.1% -16.2% 33.8% 33.84%
Net Margin 17.7% 19.8% 12.4% -16.1% 15.5% 15.46%
EBITDA Margin 45.5% 51.0% 43.2% 1.9% 44.9% 44.89%
FCF Margin -75.1% -67.5% -65.0% -81.5% -78.0% -78.00%
OCF Margin 22.2% 34.6% 33.6% 24.4% 26.1% 26.06%
ROIC Economic snapshot only 2.95%
Cash ROA snapshot only 3.42%
Cash ROIC snapshot only 5.19%
CROIC snapshot only -15.53%
NOPAT Margin snapshot only 15.26%
Pretax Margin snapshot only 16.75%
R&D / Revenue snapshot only 0.00%
SGA / Revenue snapshot only 81.67%
SBC / Revenue snapshot only 0.00%
Valuation
Metric Trend Q4'15 Q1'16 Q2'16 Q3'16 Q4'16 Current
P/E Ratio 103.82 74.17 58.59 100.74 105.22 106.208
P/S Ratio 18.39 13.92 9.87 9.01 8.89 0.000
P/B Ratio 1.62 2.50 2.55 3.13 2.77 2.770
P/FCF -24.50 -20.64 -15.18 -11.06 -11.40 -11.402
P/OCF 83.00 40.29 29.37 36.98 34.12 34.119
EV/EBITDA 51.27 34.68 25.87 30.71 29.78 29.784
EV/Revenue 23.31 16.74 12.09 11.05 10.70 10.705
EV/EBIT 61.83 41.18 31.73 42.42 42.20 42.196
EV/FCF -31.04 -24.81 -18.60 -13.55 -13.72 -13.725
Earnings Yield 1.0% 1.3% 1.7% 1.0% 1.0% 0.95%
FCF Yield -4.1% -4.8% -6.6% -9.0% -8.8% -8.77%
Price/Tangible Book snapshot only 4.994
EV/OCF snapshot only 41.071
EV/Gross Profit snapshot only 10.705
Acquirers Multiple snapshot only 46.580
Shareholder Yield snapshot only 0.05%
Graham Number snapshot only $7.08
Leverage & Solvency
Metric Trend Q4'15 Q1'16 Q2'16 Q3'16 Q4'16 Current
Current Ratio 2.68 1.84 1.10 0.54 0.89 0.889
Quick Ratio 2.61 1.78 1.06 0.51 0.84 0.840
Debt/Equity 0.68 0.68 0.68 0.76 0.62 0.615
Net Debt/Equity 0.43 0.51 0.57 0.71 0.56 0.564
Debt/Assets 0.27 0.27 0.27 0.29 0.26 0.259
Debt/EBITDA 16.97 7.86 5.63 6.07 5.49 5.493
Net Debt/EBITDA 10.81 5.83 4.76 5.65 5.04 5.041
Interest Coverage 5.33 5.37 4.63 3.04 2.94 2.944
Equity Multiplier 2.48 2.51 2.53 2.62 2.38 2.375
Cash Ratio snapshot only 0.421
Debt Service Coverage snapshot only 4.170
Cash to Debt snapshot only 0.082
FCF to Debt snapshot only -0.395
Defensive Interval snapshot only 135.4 days
Efficiency & Turnover
Metric Trend Q4'15 Q1'16 Q2'16 Q3'16 Q4'16 Current
Asset Turnover 0.04 0.07 0.10 0.13 0.13 0.134
Inventory Turnover 0.00 0.00 0.00 0.00 0.00 0.000
Receivables Turnover 2.35 4.47 6.33 8.55 7.97 7.975
Payables Turnover 0.00 0.00 0.00 0.00 0.00 —
DSO 155 82 58 43 46 45.8 days
DIO — — — — — —
DPO — — — — — —
Cash Conversion Cycle — — — — — —
Fixed Asset Turnover snapshot only 0.188
Cash Velocity snapshot only 6.153
Capital Intensity snapshot only 7.625
Growth (YoY)
Metric Trend Q4'15 Q1'16 Q2'16 Q3'16 Q4'16 Current
Revenue — — — — 2.9% 2.86%
Net Income — — — — 84.2% 84.23%
EPS — — — — 25.7% 25.75%
FCF — — — — -3.0% -3.01%
EBITDA — — — — 2.1% 2.05%
Op. Income — — — — 1.6% 1.60%
OCF Growth snapshot only 3.54%
Asset Growth snapshot only 4.79%
Equity Growth snapshot only 9.36%
Debt Growth snapshot only -1.18%
Shares Change snapshot only 46.50%
Growth Quality
Metric Trend Q4'15 Q1'16 Q2'16 Q3'16 Q4'16 Current
Revenue Stability — — — — — —
Earnings Stability — — — — — —
Margin Stability — — — — — —
Rev. Growth Consistency 0.00 0.00 0.00 0.00 0.50 0.500
Earn. Growth Consistency 0.00 0.00 0.00 0.00 0.50 0.500
FCF Positive Streak 0 0 0 0 0 0
Earnings Persistence — — — — — —
Earnings Smoothness — — — — 0.41 0.407
ROE Trend — — — — — —
Gross Margin Trend — — — — — —
FCF Margin Trend — — — — — —
Sustainable Growth Rate 1.6% 3.4% 4.4% 3.1% 2.8% 2.75%
Internal Growth Rate 0.6% 1.4% 1.7% 1.2% 1.1% 1.15%
Cash Flow Quality
Metric Trend Q4'15 Q1'16 Q2'16 Q3'16 Q4'16 Current
OCF/Net Income 1.25 1.84 1.99 2.72 3.08 3.084
FCF/OCF -3.39 -1.95 -1.94 -3.34 -2.99 -2.993
FCF/Net Income snapshot only -9.229
OCF/EBITDA snapshot only 0.725
CapEx/Revenue 97.2% 1.0% 98.6% 1.1% 1.0% 1.04%
CapEx/Depreciation snapshot only 7.858
Accruals Ratio -0.00 -0.01 -0.02 -0.02 -0.02 -0.024
Sloan Accruals snapshot only -0.099
Cash Flow Adequacy snapshot only 0.250
Earnings Quality Score snapshot only 1.000
Dividends & Buybacks
Metric Trend Q4'15 Q1'16 Q2'16 Q3'16 Q4'16 Current
Dividend Yield 0.0% 0.0% 0.0% 0.0% 0.0% 0.00%
Dividend/Share $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Payout Ratio 0.0% 0.0% 0.0% 0.0% 0.0% 0.00%
FCF Payout Ratio — — — — — —
Total Payout Ratio 13.7% 6.4% 5.0% 7.2% 5.3% 5.31%
Div. Increase Streak — — — — — —
Chowder Number — — — — — —
Buyback Yield 13.2% 8.7% 8.5% 7.1% 0.1% 0.05%
Net Buyback Yield -8.0% -5.2% -5.1% -4.2% -4.0% -4.02%
Total Shareholder Return -8.0% -5.2% -5.1% -4.2% -4.0% -4.02%
DuPont Factors
Metric Trend Q4'15 Q1'16 Q2'16 Q3'16 Q4'16 Current
Tax Burden (NI/EBT) 0.58 0.57 0.56 0.51 0.50 0.505
Interest Burden (EBT/EBIT) 0.81 0.81 0.78 0.67 0.66 0.660
EBIT Margin 0.38 0.41 0.38 0.26 0.25 0.254
Asset Turnover 0.04 0.07 0.10 0.13 0.13 0.134
Equity Multiplier 2.48 2.51 2.53 2.62 2.42 2.425
Per Share
Metric Trend Q4'15 Q1'16 Q2'16 Q3'16 Q4'16 Current
EPS (Diluted TTM) $0.19 $0.34 $0.44 $0.25 $0.24 $0.24
Book Value/Share $12.33 $10.04 $10.00 $8.15 $9.20 $9.20
Tangible Book/Share $6.32 $5.11 $5.07 $4.06 $5.10 $5.10
Revenue/Share $1.09 $1.80 $2.58 $2.83 $2.87 $2.87
FCF/Share $-0.82 $-1.22 $-1.68 $-2.31 $-2.24 $-2.24
OCF/Share $0.24 $0.62 $0.87 $0.69 $0.75 $0.75
Cash/Share $3.04 $1.76 $1.05 $0.43 $0.47 $0.47
EBITDA/Share $0.49 $0.87 $1.21 $1.02 $1.03 $1.03
Debt/Share $8.39 $6.84 $6.80 $6.18 $5.66 $5.66
Net Debt/Share $5.35 $5.08 $5.74 $5.75 $5.19 $5.19
Academic Models
Metric Trend Q4'15 Q1'16 Q2'16 Q3'16 Q4'16 Current
Altman Z-Score — — — — — 1.436
Altman Z-Prime snapshot only 2.285
Piotroski F-Score 4 4 4 4 6 6
Beneish M-Score — — — — -2.35 -2.355
Ohlson O-Score snapshot only -7.417
ROIC (Greenblatt) snapshot only 4.82%
Net-Net WC snapshot only $-11.67
EVA snapshot only $-483185550.76
Credit
Metric Trend Q4'15 Q1'16 Q2'16 Q3'16 Q4'16 Current
Credit Rating snapshot only BB-
Credit Score 49.38 53.21 46.60 41.22 38.80 38.804
Credit Grade snapshot only 13
Credit Trend snapshot only -10.578
Implied Spread (bps) snapshot only 550.000
Industry Credit Rank snapshot only 46
Sector Credit Rank snapshot only 33

Sign in to InsiderStreet

You'll also get our free weekly newsletter with
smart money signals, market insights, and alpha ideas.
Unsubscribe anytime.

For informational purposes only. Not investment advice. Data sourced from SEC filings. Privacy Terms