NiSource
Financial ratios & Valuation

Historical Multiples (2014 – 2023)

2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 TTM Median
Valuation Ratios
Price/Earnings ratio
9.9121.6321.4965.80-178.5927.22-620.9018.5713.8815.4621.46-178.59
Price/Sales ratio
0.811.331.581.731.762.001.882.211.902.003.241.76
Price/Book Value ratio
0.851.611.751.951.571.741.531.561.471.331.991.57
Price/Cash Flow ratio
3.984.258.8611.3916.736.587.988.927.925.709.789.78
Price/Free Cash Flow ratio
-7.4064.49-10.60-8.86-7.07-47.60-13.47-17.52-14.06-15.54-17.58-47.60
Price/Earnings Growth ratio
-8.42-0.461.48-1.051.31-0.035.95-0.000.38-1.13-0.72-0.03
Dividend Yield
6.11%4.24%2.88%2.70%3.15%3.39%4.27%3.68%3.91%4.13%2.88%3.39%
Profitability Indicator Ratios
Gross Profit Margin
32.61%34.00%36.69%35.76%19.55%44.52%42.43%41.86%38.46%45.20%53.24%19.55%
Operating Profit Margin
19.50%17.19%19.10%18.68%2.43%24.74%20.85%20.55%21.63%23.53%26.57%2.43%
Pretax Profit Margin
12.99%7.30%11.35%9.09%-4.50%9.72%-0.66%14.42%16.34%14.78%17.72%-4.50%
Net Profit Margin
8.19%6.15%7.37%2.63%-0.98%7.35%-0.30%11.93%13.74%12.97%14.63%-0.98%
Effective Tax Rate
36.90%41.57%35.69%70.97%78.05%24.37%54.63%16.67%17.21%17.13%15.49%24.37%
Return on Assets
2.13%1.63%1.77%0.64%-0.23%1.69%-0.06%2.42%3.00%2.29%2.51%-0.23%
Return On Equity
8.58%7.45%8.14%2.97%-0.87%6.39%-0.24%8.41%10.61%8.63%9.56%-0.87%
Return on Capital Employed
6.03%5.39%5.63%5.42%0.70%6.81%4.94%4.70%5.73%5.01%5.14%0.70%
Liquidity Ratios
Current Ratio
N/AN/AN/AN/AN/AN/AN/AN/AN/AN/A0.46N/A
Quick Ratio
0.450.370.360.400.400.380.550.510.390.750.350.38
Cash ratio
0.000.000.000.000.020.030.050.030.000.420.030.02
Days of Sales Outstanding
51.9451.7869.2570.7381.8463.4464.3568.9272.9961.5241.0263.44
Days of Inventory outstanding
54.2367.9363.4554.9137.4853.6454.3163.9076.2360.8757.7537.48
Operating Cycle
106.17119.72132.70125.65119.33117.09118.67132.83149.22122.4098.78117.09
Days of Payables Outstanding
51.0651.5369.2272.9378.4084.1279.7689.4291.2090.6690.7178.40
Cash Conversion Cycle
55.1068.1963.4752.7240.9232.9638.9043.4058.0231.738.0632.96
Debt Ratios
Debt Ratio
0.390.390.420.450.410.420.430.400.410.440.440.41
Debt Equity Ratio
1.591.801.942.081.581.581.661.401.471.681.631.58
Long-term Debt to Capitalization
0.560.600.590.630.550.560.610.560.550.560.590.55
Total Debt to Capitalization
0.610.640.660.670.610.610.620.580.590.620.610.61
Interest Coverage Ratio
N/AN/AN/AN/AN/AN/AN/AN/AN/AN/A2.63N/A
Cash Flow to Debt Ratio
0.130.200.100.080.050.160.110.120.120.130.120.05
Company Equity Multiplier
4.024.554.594.623.793.783.833.473.523.753.693.78
Cash Flow Ratios
Operating Cash Flow / Sales Ratio
0.200.310.170.150.100.300.230.240.240.350.320.10
Free Cash Flow / Operating Cash Flow Ratio
-0.530.06-0.83-1.28-2.36-0.13-0.59-0.50-0.56-0.36-0.57-2.36
Cash Flow Coverage Ratio
0.130.200.100.080.050.160.110.120.120.130.120.05
Short Term Coverage Ratio
0.711.450.430.490.260.892.092.060.780.621.110.26
Dividend Payout Ratio
60.62%91.93%61.99%178.28%-563.04%92.56%-2652.81%68.43%54.29%64.02%62.39%-563.04%